SAP table A367 (Country/Plant/Region/Material)

SAP table A367 has 9 primary key fields being MANDT,KAPPL,KSCHL,ALAND,WERKS,REGIO,MATNR,KFRST,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 T685 KSCHA
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
WERKS Plant CHAR 4 0 T001W WERKS_D
REGIO Region (State, Province, County) CHAR 3 0 T005S REGIO
MATNR Material Number CHAR 40 0 MARA MATNR
KFRST Release Status CHAR 1 0 KFRST
Released
A Blocked
B Released for pricing simulation
C Released for planning and pricing simulation
D In Review
E Rejected
DATBI Validity end date of the condition record DATS 8 0 KODATBI
DATAB Validity start date of the condition record DATS 8 0 KODATAB
KBSTAT Processing status for conditions CHAR 2 0 T686E KBSTAT
KNUMH Number of the Condition Record CHAR 10 0 KNUMH

A367 foreign key relationships

Table Field Check Table Check Field
0 A367 ALAND T005 Countries MANDT
0 A367 ALAND T005 Countries LAND1
1 A367 KAPPL T681A Conditions: Applications KAPPL
0 A367 KBSTAT T686E Conditions: Processing Status KBSTAT
1 A367 KSCHL T685 Conditions: Types KAPPL
1 A367 KSCHL T685 Conditions: Types KSCHL
0 A367 MANDT T000 Clients MANDT
1 A367 MATNR MARA General Material Data MANDT
1 A367 MATNR MARA General Material Data MATNR
0 A367 REGIO T005S Taxes: Region (Province) Key LAND1
1 A367 WERKS T001W Plants/Branches MANDT
1 A367 WERKS T001W Plants/Branches WERKS