SAP table TFK020K (Short Account Assignments for Transfer Postings)

SAP table TFK020K has 2 primary key fields being MANDT,KUKON.

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
KUKON Short Account Assignment for Transfer Postings CHAR 4 0 KUKON_KK
BUKRS Company Code CHAR 4 0 T001 BUKRS
HKONT General ledger account CHAR 10 0 SKB1 HKONT_KK
GSBER Business Area CHAR 4 0 TGSB GSBER_KUKON_KK
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM SEGMT_KK
COKEY CO Account Assignment Key CHAR 10 0 TFKCOK COKEY_KK2
XEIPH Create Line Item in General Ledger CHAR 1 0 XEIPH_KK
XEVEN Start Workflow CHAR 1 0 XEVEN_KK
CTIME Period in Days for Calculation of Key Date NUMC 4 0 CTIME_KK
TEXT50 Text Field CHAR 50 0 TEXT50
MWSKZ Tax Code CHAR 2 0 T007A MWSKZ_CSH_KK
BEGRU Authorization Group CHAR 4 0 BEGRU_CSH_KK
AAREA Application Area CHAR 1 0 AAREA_KK
C Cash Desk
L Payment Lot
M Account Maintenance
P Payments
XGLOV General Ledger Account Can Be Overwritten CHAR 1 0 XGLOV_KK
XCLTR Transfer to Other Clarification Account CHAR 1 0 XCLTR_KK
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD

TFK020K foreign key relationships

Table Field Check Table Check Field
0 TFK020K BUKRS T001 Company Codes BUKRS
1 TFK020K COKEY TFKCOK FI-CA: CO Account Assignment Key MANDT
1 TFK020K COKEY TFKCOK FI-CA: CO Account Assignment Key COKEY
0 TFK020K GSBER TGSB Business Areas MANDT
0 TFK020K GSBER TGSB Business Areas GSBER
1 TFK020K HKONT SKB1 G/L account master (company code) MANDT
1 TFK020K HKONT SKB1 G/L account master (company code) BUKRS
0 TFK020K MWSKZ T007A Tax Keys KALSM
0 TFK020K MWSKZ T007A Tax Keys MWSKZ
1 TFK020K SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
0 TFK020K TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 TFK020K TXJCD TTXJ Check Table for Tax Jurisdiction KALSM