SAP table A039 (Overhead Type/Business Area)

SAP table A039 has 7 primary key fields being MANDT,KAPPL,KSCHL,KOKRS,AUFZA,GSBER,DATBI.

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 T681A KAPPL
KSCHL Condition Type CHAR 4 0 T685A KSCHA
KOKRS Controlling Area CHAR 4 0 TKA01 KOKRS
AUFZA Overhead Type CHAR 1 0 AUFZA
1 Actual overhead rate
2 Planned overhead rate
3 Commitment overhead rate
GSBER Business Area CHAR 4 0 TGSB GSBER
DATBI Validity end date of the condition record DATS 8 0 KODATBI
DATAB Validity start date of the condition record DATS 8 0 KODATAB
KNUMH Number of the Condition Record CHAR 10 0 KNUMH

A039 foreign key relationships

Table Field Check Table Check Field
0 A039 GSBER TGSB Business Areas MANDT
0 A039 GSBER TGSB Business Areas GSBER
1 A039 KAPPL T681A Conditions: Applications KAPPL
0 A039 KOKRS TKA01 Controlling Areas MANDT
1 A039 KSCHL T685A Conditions: Types: Additional Price Element Data KAPPL
1 A039 KSCHL T685A Conditions: Types: Additional Price Element Data KSCHL
0 A039 MANDT T000 Clients MANDT