S012 - Purchasing

Purchasing information is stored in SAP table S012.
It is part of development package MCS in software component LO-LIS-DC. This development package consists of objects that can be grouped under "R/3 application development: Logistics Information Warehouse".

Fields for table S012

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
MANDT	Client	X	MANDT	CLNT	6	T000
SSOUR	Statistic(s) origin	X	SSOUR	CHAR	8
VRSIO	Version number in the information structure	X	VRSIO	CHAR	6	*
SPMON	Period to analyze - month	X	SPMON	NUMC	12
SPTAG	Period to analyze - current date	X	SPTAG	DATS	16
SPWOC	Period to analyze - week	X	SPWOC	NUMC	12
SPBUP	Period to analyze - posting period	X	SPBUP	NUMC	12
EKORG	Purchasing organization	X	EKORG	CHAR	8	T024E
LIFNR	Vendor's account number	X	ELIFN	CHAR	20	LFA1
MATNR	Material Number	X	MATNR	CHAR	80	MARA
WERKS	Plant	X	EWERK	CHAR	8	T001W
ESOKZ	Purchasing info record category	X	ESOKZ	CHAR	2
MATKL	Material Group	X	MATKL	CHAR	18	T023
INFNR	Number of purchasing info record	X	INFNR	CHAR	20	EINA
LAND1	Country/Region Key of Supplier	X	MCLANDL	CHAR	6	T005
PERIV	Fiscal Year Variant		PERIV	CHAR	4	*
VWDAT	Pointer to administrative data		VWDAT	NUMC	20
BASME	Base Unit of Measure		MEINS	UNIT	6	T006
HWAER	Local Currency		HWAER	CUKY	10	TCURC
MENGE	Purchase order quantity		MC_MENGE	QUAN	8
WEMNG	Quantity of goods received		MC_WEMNG	QUAN	8
WEMGM	Goods receipt qty in base unit (calculate wtd.delivery time)		MC_WEMGMAX	QUAN	8
REMNG	Invoice receipt quantity		MC_REMNG	QUAN	8
LSMNG	Target delivery quantity in base unit of measure		MC_LSMNG	QUAN	8
NETWR	Effective order value		MC_EFFWR	CURR	8
REWRT	Invoice Amount		MC_REWRT	CURR	8
ABSTP	Number of purchase order items		MC_ABSTP	DEC	5
ABSTE	Number of purchase order item schedule lines		MC_ABSTE	DEC	5
AANFP	Number of requests for quotation items		MC_AANFP	DEC	5
AANGP	Number of Quotation Items		MC_AANGP	DEC	5
AKONP	Number of contract items		MC_AKONP	DEC	5
ALFPP	Number of scheduling agreement items		MC_ALFPP	DEC	5
ALFPE	Number of delivery schedules		MC_ALFPE	DEC	5
ALIEF	Number of deliveries		MC_ALIEF	DEC	5
MABW1	Deviation 1 in the quantity delivered		MC_MABW1	DEC	5
MABW2	Variance 2 in the quantity delivered		MC_MABW2	DEC	5
MABW3	Variance 3 in the quantity delivered		MC_MABW3	DEC	5
MABW4	Variance 4 in the quantity delivered		MC_MABW4	DEC	5
MABW5	Variance 5 in the quantity delivered		MC_MABW5	DEC	5
TABW1	Delivery date variance 1 in days		MC_TABW1	DEC	5
TABW2	Delivery date variance 2 in days		MC_TABW2	DEC	5
TABW3	Delivery date variance 3 in days		MC_TABW3	DEC	5
TABW4	Delivery date variance 4 in days		MC_TABW4	DEC	5
TABW5	Delivery date variance 5 in days		MC_TABW5	DEC	5
LFZTA	Total delivery time in days		MC_LFZTA	DEC	7
LFZTG	Weighted total delivery time		MC_LFZTG	DEC	8
MENGE_R	Order quantity (returns)		MC_MENGE_R	QUAN	8
REMNG_R	Invoice receipt quantity of returns		MC_REMNG_R	QUAN	8
WEMNG_R	Goods receipt quantity of returns		MC_WEMNG_R	QUAN	8
REWRT_R	Invoice amount: Returns		MC_REWRT_R	CURR	8
EFFWR_R	Effective order value of returns		MC_EFFWR_R	CURR	8
WEWRT	Value of goods received in local currency		MC_WEWERT	CURR	7
REMNG_B	Invoice receipt quantity as at posting date		MC_REMNG_B	QUAN	8
WEWRT_B	Goods receipt value as at posting date		MC_WEWRT_B	CURR	8
REWRT_B	Invoice Amount as at Posting Date		MC_REWRT_B	CURR	8
REMNG_R_B	IR quantity: Returns as at posting date		MC_REMNG_R_B	QUAN	8
REWRT_R_B	IR value: Returns as at posting date		MC_REWRT_R_B	CURR	8
WEWRT_R_B	GR value: Returns as at posting date		MC_WEWRT_R_B	CURR	8