SAP ABAP Table S011 (PURCHIS: Purchasing Group Statistics)

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	S011	Table Relationship Diagram
Short Description	PURCHIS: Purchasing Group Statistics

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	EKGRP	☑	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
10	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
11	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	T009
12	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
13	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
14	NETWR	☐	MC_EFFWR	WERTV8	CURR	15	2	Effective order value
15	REWRT	☐	MC_REWRT	WERTV8	CURR	15	2	Invoice Amount
16	ABEST	☐	MC_ABEST	MCZAEHLER	DEC	9	0	No. of purchase orders
17	ABSTP	☐	MC_ABSTP	MCZAEHLER	DEC	9	0	Number of purchase order items
18	ABSTE	☐	MC_ABSTE	MCZAEHLER	DEC	9	0	Number of purchase order item schedule lines
19	AANFR	☐	MC_AANFR	MCZAEHLER	DEC	9	0	Number of requests for quotations
20	AANFP	☐	MC_AANFP	MCZAEHLER	DEC	9	0	Number of requests for quotation items
21	AANGP	☐	MC_AANGP	MCZAEHLER	DEC	9	0	Number of Quotation Items
22	AKONT	☐	MC_AKONT	MCZAEHLER	DEC	9	0	Number of contracts
23	AKONP	☐	MC_AKONP	MCZAEHLER	DEC	9	0	Number of contract items
24	ALFPL	☐	MC_ALFPL	MCZAEHLER	DEC	9	0	Number of scheduling agreements
25	ALFPP	☐	MC_ALFPP	MCZAEHLER	DEC	9	0	Number of scheduling agreement items
26	ALFPE	☐	MC_ALFPE	MCZAEHLER	DEC	9	0	Number of delivery schedules
27	ALIEF	☐	MC_ALIEF	MCZAEHLER	DEC	9	0	Number of deliveries

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S011	EKGRP	T024	EKGRP	KEY	1	CN
2	S011	EKORG	T024E	EKORG	KEY	1	CN
3	S011	HWAER	TCURC	WAERS	KEY	1	CN
4	S011	LIFNR	LFA1	LIFNR	KEY	1	CN
5	S011	MANDT	T000	MANDT	KEY	1	CN
6	S011	PERIV	T009	PERIV	KEY	1	CN

History

Last changed by/on	SAP	20050411
SAP Release Created in