SAP table A363 (Plant/Vendor/Material)
SAP table A363 has 8 primary key fields being MANDT,KAPPL,KSCHL,WERKS,LIFNR,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
Client
CLNT
3
0
T000
MANDT
Application
CHAR
2
0
T681A
KAPPL
Condition Type
CHAR
4
0
T685
KSCHA
Plant
CHAR
4
0
T001W
WERKS_D
Vendor's account number
CHAR
10
0
LFA1
ELIFN
Material Number
CHAR
40
0
MARA
MATNR
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
A363 foreign key relationships
Table
Field
Check Table
Check Field
0 A363
KAPPL
T681A Conditions: Applications
KAPPL
1 A363
KBSTAT
T686E Conditions: Processing Status
KBSTAT
0 A363
KSCHL
T685 Conditions: Types
KAPPL
0 A363
KSCHL
T685 Conditions: Types
KSCHL
1 A363
LIFNR
LFA1 Supplier Master (General Section)
MANDT
1 A363
LIFNR
LFA1 Supplier Master (General Section)
LIFNR
0 A363
MANDT
T000 Clients
MANDT
1 A363
MATNR
MARA General Material Data
MATNR
0 A363
WERKS
T001W Plants/Branches
MANDT
0 A363
WERKS
T001W Plants/Branches
WERKS