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
Possible values
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