SAP table C001 (Cust.Grp/MaterialGrp/AcctKey)

SAP table C001 has 8 primary key fields being MANDT,KAPPL,KSCHL,KTOPL,VKORG,KTGRD,KTGRM,KVSL1.

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
KAPPL Application CHAR 2 0 T681Z KAPPL
KSCHL Condition type for account determination CHAR 4 0 T685 KSCHC
KTOPL Chart of Accounts CHAR 4 0 T004 KTOPL
VKORG Sales Organization CHAR 4 0 TVKO VKORG
KTGRD Account Assignment Group for this Customer CHAR 2 0 TVKT KTGRD
KTGRM Account Assignment Group for Material CHAR 2 0 TVKM KTGRM
KVSL1 Account Key CHAR 3 0 T687 KVSL1
SAKN1 G/L Account Number CHAR 10 0 SKA1 SAKNR
SAKN2 Number of Accruals Account CHAR 10 0 SKA1 SAKNR_ACCR

C001 foreign key relationships

Table Field Check Table Check Field
0 C001 KAPPL T681Z Conditions: Dependent Data for Application/Usage KAPPL
1 C001 KSCHL T685 Conditions: Types KAPPL
1 C001 KSCHL T685 Conditions: Types KSCHL
0 C001 KTGRD TVKT Customers: Account Assignment Groups KTGRD
1 C001 KTGRM TVKM Materials: Account Assignment Groups MANDT
1 C001 KTGRM TVKM Materials: Account Assignment Groups KTGRM
0 C001 KTOPL T004 Directory of Charts of Accounts MANDT
1 C001 KVSL1 T687 Account Determination: Account Key KAPPL
0 C001 MANDT T000 Clients MANDT
1 C001 SAKN1 SKA1 G/L Account Master (Chart of Accounts) MANDT
1 C001 SAKN1 SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 C001 SAKN1 SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 C001 SAKN2 SKA1 G/L Account Master (Chart of Accounts) MANDT
0 C001 SAKN2 SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 C001 SAKN2 SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 C001 VKORG TVKO Organizational Unit: Sales Organizations MANDT
1 C001 VKORG TVKO Organizational Unit: Sales Organizations VKORG