SAP table A501 (Material/Plant)
SAP table A501 has 7 primary key fields being MANDT,KAPPL,KSCHL,MATNR,WERKS,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
Client
CLNT
3
0
T000
MANDT
Application
CHAR
2
0
T681A
KAPPL
Condition Type
CHAR
4
0
T685
KSCHA
Material Number
CHAR
40
0
MARA
MATNR
Plant
CHAR
4
0
T001W
WERKS_D
Release Status
CHAR
1
0
KFRST
Possible values
Released
A
Blocked
B
Released for pricing simulation
C
Released for planning and pricing simulation
D
In Review
E
Rejected
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
A501 foreign key relationships
Table
Field
Check Table
Check Field
0 A501
KAPPL
T681A Conditions: Applications
KAPPL
1 A501
KBSTAT
T686E Conditions: Processing Status
KBSTAT
0 A501
KSCHL
T685 Conditions: Types
KAPPL
0 A501
KSCHL
T685 Conditions: Types
KSCHL
1 A501
MANDT
T000 Clients
MANDT
0 A501
MATNR
MARA General Material Data
MATNR
1 A501
WERKS
T001W Plants/Branches
MANDT
1 A501
WERKS
T001W Plants/Branches
WERKS