SAP table TBKK01 (Bank Area Table)

SAP table TBKK01 has 2 primary key fields being MANDT,BKKRS.

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
BKKRS Bank Area CHAR 4 0 BKK_BKKRS
BANKS Country/Region Key of Bank CHAR 3 0 T005 BANKS
BANKL Bank Keys CHAR 15 0 BNKA BANKK
SPRAS Language Key LANG 1 0 T002 SPRAS
WAERS Bank Area Currency CUKY 5 0 TCURC BKK_BKCUR
CUR_OLD Currency pre EURO Conversion CUKY 5 0 TCURC BKK_CUR_OLD
CUR_DFLT Default Account Currency CUKY 5 0 TCURC BKK_CUR_DFLT
CAL_ID Factory Calendar Key CHAR 2 0 TFACD BKK_CAL
SHIFT_WDAY Shift Execution Date to Valid Working Day NUMC 1 0 BKK_SHIFTWDAY
0 No Shift
1 Next Following Working Day
3 Last Previous Working Day
CUTTIME Time Automatic Posting Cut-Off TIMS 6 0 BKK_CUTTIM
RATETYPE Exchange Rate Type CHAR 4 0 TCURV KURST_CURR
XTRACE Indicator: Trace Active CHAR 1 0 BKK_XTRACE
XEURO Indicator: Currency Conversion only at Acct. Balancing CHAR 1 0 BKK_XEURO
XRELEASE Flag: Principle of Dual Control Active CHAR 1 0 BKK_XRELSE_CHCUR
XEXTASYNC Transfer to Payment System: Synchronous/Asynchronous CHAR 1 0 BKK_X_EXTTRNS
XDIFCHKDIG Different check digit methods Exists CHAR 1 0 BKK_DIFF_CHKDIG_EXISTS
No
X YES

TBKK01 foreign key relationships

Table Field Check Table Check Field
0 TBKK01 BANKL BNKA Bank master record BANKS
1 TBKK01 BANKS T005 Countries MANDT
1 TBKK01 BANKS T005 Countries LAND1
0 TBKK01 CUR_DFLT TCURC Currency Codes MANDT
0 TBKK01 CUR_DFLT TCURC Currency Codes WAERS
1 TBKK01 CUR_OLD TCURC Currency Codes MANDT
1 TBKK01 CUR_OLD TCURC Currency Codes WAERS
0 TBKK01 RATETYPE TCURV Exchange rate types for currency translation MANDT
0 TBKK01 RATETYPE TCURV Exchange rate types for currency translation KURST
1 TBKK01 SPRAS T002 Language Keys (Component BC-I18) SPRAS
0 TBKK01 WAERS TCURC Currency Codes MANDT
0 TBKK01 WAERS TCURC Currency Codes WAERS