SAP table S013 (PURCHIS: Statistics for Vendor Evaluation)

SAP table S013 has 13 primary key fields being MANDT,SSOUR,VRSIO,SPMON,SPTAG,SPWOC,SPBUP,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
VRSIO Version number in the information structure CHAR 3 0 * VRSIO
SPMON Period to analyze - month NUMC 6 0 SPMON
SPTAG Period to analyze - current date DATS 8 0 SPTAG
SPWOC Period to analyze - week NUMC 6 0 SPWOC
SPBUP Period to analyze - posting period NUMC 6 0 SPBUP
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
PERIV Fiscal Year Variant CHAR 2 0 T009 PERIV
VWDAT Pointer to administrative data NUMC 10 0 VWDAT
PWMT1 Points score 1 for quantity reliability DEC 3 0 MC_PWMT1
PWMT2 Points score 2 for quantity reliability DEC 3 0 MC_PWMT2
PWTT1 Points score 1 for on-time delivery performance DEC 3 0 MC_PWTT1
PWTT2 Points score 2 for on-time delivery performance DEC 3 0 MC_PWTT2
PWEV1 Points score 1 for compliance with shipping instructions DEC 3 0 MC_PWEV1
PWEV2 Point score 2 for compliance with shipping instructions DEC 3 0 MC_PWEV2
PWWE1 Points score 1 for service quality DEC 3 0 MC_PWWE1
PWWE2 Points score 2 for quality of service DEC 3 0 MC_PWWE2
PWFR1 Points score 1 for service timeliness DEC 3 0 MC_PWFR1
PWFR2 Points score 2 for service timeliness DEC 3 0 MC_PWFR2
PWQA1 Points score 1 for quality audit DEC 3 0 MC_PWQA1
PWQA2 Points score 2 for quality audit DEC 3 0 MC_PWQA2
LAVI1 Points score 1: Shipping notification DEC 3 0 MC_LAVI1
LAVI2 Points score 2: Shipping notification DEC 3 0 MC_LAVI2
ALAV1 Points score 1: Variance from shipping notification DEC 3 0 MC_ALAV1
ALAV2 Points score 2: Variance from shipping notification DEC 3 0 MC_ALAV2

S013 foreign key relationships

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