SAP table S013E (S013 - Structural Information)

SAP table S013E has 8 primary key fields being MANDT,SSOUR,EKORG,LIFNR,MATNR,WERKS,ESOKZ,INFNR.

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
SSOUR Statistic(s) origin CHAR 4 0 SSOUR
EKORG Purchasing organization CHAR 4 0 T024E EKORG
LIFNR Vendor's account number CHAR 10 0 LFA1 ELIFN
MATNR Material Number CHAR 40 0 MARA MATNR
WERKS Plant CHAR 4 0 T001W EWERK
ESOKZ Purchasing info record category CHAR 1 0 ESOKZ
0 Standard
1 Chargeable
2 Consignment
3 Subcontracting
P Pipeline
INFNR Number of purchasing info record CHAR 10 0 EINA INFNR
PLOBJ Planning object CHAR 18 0 PLOBJ
PERKZ Period indicator CHAR 1 0 PERVR
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
PLTKZ Indicator: element used in planning CHAR 1 0 PLTKZ
ANTEI Proportional factor (%) for disaggregation of product group FLTP 16 16 DANTEF

S013E foreign key relationships

Table Field Check Table Check Field
0 S013E EKORG T024E Purchasing Organizations EKORG
1 S013E INFNR EINA Purchasing Info Record: General Data INFNR
0 S013E LIFNR LFA1 Supplier Master (General Section) MANDT
0 S013E LIFNR LFA1 Supplier Master (General Section) LIFNR
1 S013E MATNR MARA General Material Data MANDT
1 S013E MATNR MARA General Material Data MATNR
0 S013E PERIV T009 Fiscal Year Variants MANDT
0 S013E PERIV T009 Fiscal Year Variants PERIV
1 S013E WERKS T001W Plants/Branches WERKS