SAP table TFK012 (Bank clearing accounts)

SAP table TFK012 has 3 primary key fields being MANDT,BUKRS,BVRKO.

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
BUKRS Company Code CHAR 4 0 T001 BUKRS
BVRKO Bank clearing account CHAR 10 0 SKB1 BVRKO_KK
HBKID Short Key for a House Bank CHAR 5 0 T012 HBKID
HKTID ID for Account Details CHAR 5 0 T012K HKTID
GPARK Business Partner Number for Correspondence CHAR 10 0 BUT000 GPARK_KK
XBVRZS Bank clearing account for payment lot CHAR 1 0 XBVRZS_KK
XBVRRL Bank Clearing Account Valid for Returns CHAR 1 0 XBVRRL_KK
XBVRSS Bank Clearing Account Valid for Check Lot CHAR 1 0 XBVRSS_KK
XBVRCR Bank Clearing Account Valid For Card Lot CHAR 1 0 XBVRCR_KK
XBVZAU Bank Clearing Account Valid for Payment Order Lot CHAR 1 0 XBVZAU_KK
XBVROL Bank Clearing Account Valid for Online Checks CHAR 1 0 XBVROL_KK
XBVRVT Bank Clearing Account Valid for Distribution Lot CHAR 1 0 XBVRVT_KK
XBVRPDC Bank Clearing Account Valid for Postdated Check Lot CHAR 1 0 XBVRPDC_KK
DECRE Bank Clearing Account for Debit / Credit Postings CHAR 1 0 DECRE_KK
No Restriction
C For Credit Postings Only
D For Debit Postings Only

TFK012 foreign key relationships

Table Field Check Table Check Field
0 TFK012 BUKRS T001 Company Codes BUKRS
1 TFK012 BVRKO SKB1 G/L account master (company code) MANDT
1 TFK012 BVRKO SKB1 G/L account master (company code) BUKRS
0 TFK012 GPARK BUT000 BP: General data I PARTNER
1 TFK012 HBKID T012 House Banks BUKRS
0 TFK012 HKTID T012K House Bank Accounts MANDT
0 TFK012 HKTID T012K House Bank Accounts BUKRS
0 TFK012 HKTID T012K House Bank Accounts HBKID
0 TFK012 HKTID T012K House Bank Accounts HKTID