SAP table BUS_MASS_BUT0BK (SAP BP, Mass Update: Bank Details)

SAP table BUS_MASS_BUT0BK has 5 primary key fields being MANDT,PARTNER,BVALID_FROM,BVALID_TO,BMOVE_DATE.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
PARTNER Business Partner Number CHAR 10 0 BUT000 BU_PARTNER
BKVID Bank Details ID CHAR 4 0 BU_BKVID
BANKS Country/Region Key of Bank CHAR 3 0 T005 BU_BANKS
BANKL Bank Key CHAR 15 0 BU_BANKK
BANKN Bank Account Number CHAR 18 0 BU_BANKN
BKONT Bank Control Key CHAR 2 0 BU_BKONT
BKREF Reference Details for Bank Details CHAR 20 0 BU_BKREF
KOINH Account Holder Name CHAR 60 0 BU_KOINH
BKEXT Bank details ID in external system CHAR 20 0 BU_BKEXT
XEZER Indicator: Collection Authorization CHAR 1 0 BU_XEZER
ACCNAME Name of Bank Account CHAR 40 0 BU_BANKACCNAME
MOVE_BKVID ID of Target Details for Change of Bank Details (BP) CHAR 4 0 BU_MOVE_BKVID
PROTECT BP: Sensitivity Indicator CHAR 1 0 BU_PROTECTED
Not Defined
E Employee-Related Data
ALIAS_IS_USED Alias Is Used CHAR 1 0 BU_ALIAS_IS_USED
BK_VALID_FROM Validity Start of Business Partner Bank Details DEC 15 0 BU_BK_VALID_FROM
BK_VALID_TO Validity End of Business Partner Bank Details DEC 15 0 BU_BK_VALID_TO
BK_MOVE_DATE Date of Change to Bank Details (BP) DEC 15 0 BU_BK_MOVE_DATE
BP_BANK_GUID BP: Bank Account Alias GUID RAW 16 0 BU_BP_BANK_GUID
MASSOBJ_COUNT 4 Byte Signed Integer INT4 10 0 INT4
BP_EEW_BUT0BK Dummy function in length 1 CHAR 1 0 DUMMY
BVALID_FROM Valid-From Date (BUT0BK) DATS 8 0 BU_MASS_DAT_VALFROM_BUT0BK
BVALID_TO Valid-To Date (BUT0BK) DATS 8 0 BU_MASS_DAT_VALTO_BUT0BK
BMOVE_DATE Date of Change DATS 8 0 BU_MASS_MOVEDATE

BUS_MASS_BUT0BK foreign key relationships

Table Field Check Table Check Field
0 BUS_MASS_BUT0BK BANKS T005 Countries MANDT
0 BUS_MASS_BUT0BK BANKS T005 Countries LAND1
1 BUS_MASS_BUT0BK PARTNER BUT000 BP: General data I PARTNER