SAP table C496 (Condition Type/Account Key)

SAP table C496 has 6 primary key fields being MANDT,KAPPL,KSCHL,KTOPL,KSCHA,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
KSCHA Condition Type CHAR 4 0 T685A KSCHA
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

C496 foreign key relationships

Table Field Check Table Check Field
0 C496 KAPPL T681Z Conditions: Dependent Data for Application/Usage KAPPL
1 C496 KSCHA T685A Conditions: Types: Additional Price Element Data KAPPL
1 C496 KSCHA T685A Conditions: Types: Additional Price Element Data KSCHL
0 C496 KSCHL T685 Conditions: Types KAPPL
0 C496 KSCHL T685 Conditions: Types KSCHL
1 C496 KTOPL T004 Directory of Charts of Accounts MANDT
0 C496 KVSL1 T687 Account Determination: Account Key KAPPL
1 C496 MANDT T000 Clients MANDT
0 C496 SAKN1 SKA1 G/L Account Master (Chart of Accounts) MANDT
0 C496 SAKN1 SKA1 G/L Account Master (Chart of Accounts) KTOPL
0 C496 SAKN1 SKA1 G/L Account Master (Chart of Accounts) SAKNR
1 C496 SAKN2 SKA1 G/L Account Master (Chart of Accounts) MANDT
1 C496 SAKN2 SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 C496 SAKN2 SKA1 G/L Account Master (Chart of Accounts) SAKNR