SAP table BUT0BK (BP: Bank Details)

SAP table BUT0BK has 3 primary key fields being MANDT,PARTNER,BKVID.

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 T000 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
IBAN IBAN (International Bank Account Number) CHAR 34 0 BU_IBAN
BANK_GUID Bank GUID RAW 16 0 BU_BANK_GUID
ACCOUNT_ID Bank Account Number (New) CHAR 35 0 BU_ACCOUNT_ID
CHECK_DIGIT Bank Account Check Digit CHAR 2 0 BU_ACCOUNT_CHECK
ACCOUNT_TYPE Bank Account Type CHAR 3 0 BU_ACCOUNT_TYPE
BP_EEW_BUT0BK Dummy function in length 1 CHAR 1 0 DUMMY

BUT0BK foreign key relationships

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