SAP ABAP Table S013BIW1 (PURCHIS: Statistics for Vendor Evaluation)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MCS (Package) R/3 application development: Logistics Information Warehouse

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	S013BIW1	Table Relationship Diagram
Short Description	PURCHIS: Statistics for Vendor Evaluation

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	SSOUR	☑	SSOUR	SSOUR	CHAR	4	0	Statistic(s) origin
3	VRSIO	☑	VRSIO	VRSIO	CHAR	3	0	Version number in the information structure	*
4	SPMON	☑	SPMON	MCPERIOD	NUMC	6	0	Period to analyze - month
5	SPTAG	☑	SPTAG	DATUM	DATS	8	0	Period to analyze - current date
6	SPWOC	☑	SPWOC	MCPERIOD	NUMC	6	0	Period to analyze - week
7	SPBUP	☑	SPBUP	MCPERIOD	NUMC	6	0	Period to analyze - posting period
8	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
9	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
10	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
11	WERKS	☑	EWERK	WERKS	CHAR	4	0	Plant	T001W
12	ESOKZ	☑	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
13	INFNR	☑	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
14	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
15	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
16	PWMT1	☐	MC_PWMT1	DEC3	DEC	3	0	Points score 1 for quantity reliability
17	PWMT2	☐	MC_PWMT2	DEC3	DEC	3	0	Points score 2 for quantity reliability
18	PWTT1	☐	MC_PWTT1	DEC3	DEC	3	0	Points score 1 for on-time delivery performance
19	PWTT2	☐	MC_PWTT2	DEC3	DEC	3	0	Points score 2 for on-time delivery performance
20	PWEV1	☐	MC_PWEV1	DEC3	DEC	3	0	Points score 1 for compliance with shipping instructions
21	PWEV2	☐	MC_PWEV2	DEC3	DEC	3	0	Point score 2 for compliance with shipping instructions
22	PWWE1	☐	MC_PWWE1	DEC3	DEC	3	0	Points score 1 for service quality
23	PWWE2	☐	MC_PWWE2	DEC3	DEC	3	0	Points score 2 for quality of service
24	PWFR1	☐	MC_PWFR1	DEC3	DEC	3	0	Points score 1 for service timeliness
25	PWFR2	☐	MC_PWFR2	DEC3	DEC	3	0	Points score 2 for service timeliness
26	PWQA1	☐	MC_PWQA1	DEC3	DEC	3	0	Points score 1 for quality audit
27	PWQA2	☐	MC_PWQA2	DEC3	DEC	3	0	Points score 2 for quality audit
28	LAVI1	☐	MC_LAVI1	DEC3	DEC	3	0	Points score 1: Shipping notification
29	LAVI2	☐	MC_LAVI2	DEC3	DEC	3	0	Points score 2: Shipping notification
30	ALAV1	☐	MC_ALAV1	DEC3	DEC	3	0	Points score 1: Variance from shipping notification
31	ALAV2	☐	MC_ALAV2	DEC3	DEC	3	0	Points score 2: Variance from shipping notification

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S013BIW1	EKORG	T024E	EKORG	KEY	1	CN
2	S013BIW1	INFNR	EINA	INFNR	KEY	1	CN
3	S013BIW1	LIFNR	LFA1	LIFNR	KEY	1	CN
4	S013BIW1	MANDT	T000	MANDT	KEY	1	CN
5	S013BIW1	MATNR	MARA	MATNR	KEY	1	CN
6	S013BIW1	PERIV	T009	PERIV	KEY	1	CN
7	S013BIW1	WERKS	T001W	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in