SAP table TBKKCASS (GL Account Assignment)

SAP table TBKKCASS has 7 primary key fields being MANDT,PSTYPE,GLVAR,GLGRP,GLACT,WAERS,EXTRAKEY.

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
PSTYPE GL: Posting Category CHAR 1 0 BKK_GLPSTK
1 CA Posting
2 CA Postprocessing
3 Interest Accrual/Deferral
4 Individual Value Adjustment
5 Payment Item in Block Table
GLVAR GL Variants CHAR 4 0 TBKKCVAR BKK_GLVAR
GLGRP General Ledger Group CHAR 4 0 TBKKCGRP BKK_GLGRP
GLACT General Ledger Transaction CHAR 6 0 TBKKCACT BKK_GLACT
WAERS Account Currency CUKY 5 0 TCURC BKK_ACUR
EXTRAKEY Additional Key Account Determination GL CHAR 6 0 BKK_GLUSER
GLACCT GL Clearing Account Transfer BCA->FI CHAR 10 0 * BKK_GLACL
C_GLACCT Offsetting Account General Ledger Transfer BCA ->FI CHAR 10 0 * BKK_CGLACC
MWSKZ Tax on sales/purchases code CHAR 2 0 * MWSKZ
TAXIT Indicator: Tax item CHAR 1 0 BKK_TAXIT
GSBER Business Area CHAR 4 0 * GSBER
VBUND Company ID CHAR 6 0 * VBUND
ZUONR Assignment number CHAR 18 0 DZUONR

TBKKCASS foreign key relationships

Table Field Check Table Check Field
0 TBKKCASS GLACT TBKKCACT General Ledger Transaction MANDT
0 TBKKCASS GLACT TBKKCACT General Ledger Transaction GLVAR
1 TBKKCASS GLGRP TBKKCGRP General Ledger Group MANDT
1 TBKKCASS GLGRP TBKKCGRP General Ledger Group GLVAR
0 TBKKCASS GLVAR TBKKCVAR GL Variants MANDT
0 TBKKCASS GLVAR TBKKCVAR GL Variants GLVAR
1 TBKKCASS WAERS TCURC Currency Codes MANDT
1 TBKKCASS WAERS TCURC Currency Codes WAERS