SAP ABAP Table S012BIW2 (S012BIW2 * Purchasing)

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	S012BIW2	Table Relationship Diagram
Short Description	S012BIW2 * Purchasing

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	MATKL	☑	MATKL	MATKL	CHAR	9	0	Material Group	T023
14	INFNR	☑	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
15	LAND1	☑	MCLANDL	LAND1	CHAR	3	0	Country key of vendor	T005
16	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
17	VWDAT	☐	VWDAT	VWDAT	NUMC	10	0	Pointer to administrative data
18	BASME	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
19	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	TCURC
20	MENGE	☐	MC_MENGE	MENGV15_3	QUAN	15	3	Purchase order quantity
21	WEMNG	☐	MC_WEMNG	MENGV15_3	QUAN	15	3	Quantity of goods received
22	WEMGM	☐	MC_WEMGMAX	MENGV15_3	QUAN	15	3	Goods receipt qty in base unit (calculate wtd.delivery time)
23	REMNG	☐	MC_REMNG	MENGV15_3	QUAN	15	3	Invoice receipt quantity
24	LSMNG	☐	MC_LSMNG	MENGV15_3	QUAN	15	3	Target delivery quantity in base unit of measure
25	NETWR	☐	MC_EFFWR	WERTV8	CURR	15	2	Effective order value
26	REWRT	☐	MC_REWRT	WERTV8	CURR	15	2	Invoice Amount
27	ABSTP	☐	MC_ABSTP	MCZAEHLER	DEC	9	0	Number of purchase order items
28	ABSTE	☐	MC_ABSTE	MCZAEHLER	DEC	9	0	Number of purchase order item schedule lines
29	AANFP	☐	MC_AANFP	MCZAEHLER	DEC	9	0	Number of requests for quotation items
30	AANGP	☐	MC_AANGP	MCZAEHLER	DEC	9	0	Number of Quotation Items
31	AKONP	☐	MC_AKONP	MCZAEHLER	DEC	9	0	Number of contract items
32	ALFPP	☐	MC_ALFPP	MCZAEHLER	DEC	9	0	Number of scheduling agreement items
33	ALFPE	☐	MC_ALFPE	MCZAEHLER	DEC	9	0	Number of delivery schedules
34	ALIEF	☐	MC_ALIEF	MCZAEHLER	DEC	9	0	Number of deliveries
35	MABW1	☐	MC_MABW1	MCZAEHLER	DEC	9	0	Deviation 1 in the quantity delivered
36	MABW2	☐	MC_MABW2	MCZAEHLER	DEC	9	0	Variance 2 in the quantity delivered
37	MABW3	☐	MC_MABW3	MCZAEHLER	DEC	9	0	Variance 3 in the quantity delivered
38	MABW4	☐	MC_MABW4	MCZAEHLER	DEC	9	0	Variance 4 in the quantity delivered
39	MABW5	☐	MC_MABW5	MCZAEHLER	DEC	9	0	Variance 5 in the quantity delivered
40	TABW1	☐	MC_TABW1	MCZAEHLER	DEC	9	0	Delivery date variance 1 in days
41	TABW2	☐	MC_TABW2	MCZAEHLER	DEC	9	0	Delivery date variance 2 in days
42	TABW3	☐	MC_TABW3	MCZAEHLER	DEC	9	0	Delivery date variance 3 in days
43	TABW4	☐	MC_TABW4	MCZAEHLER	DEC	9	0	Delivery date variance 4 in days
44	TABW5	☐	MC_TABW5	MCZAEHLER	DEC	9	0	Delivery date variance 5 in days
45	LFZTA	☐	MC_LFZTA	DECV13	DEC	13	0	Total delivery time in days
46	LFZTG	☐	MC_LFZTG	DECV15_1	DEC	15	1	Weighted total delivery time
47	MENGE_R	☐	MC_MENGE_R	MENGV15_3	QUAN	15	3	Order quantity (returns)
48	REMNG_R	☐	MC_REMNG_R	MENGV15_3	QUAN	15	3	Invoice receipt quantity of returns
49	WEMNG_R	☐	MC_WEMNG_R	MENGV15_3	QUAN	15	3	Goods receipt quantity of returns
50	REWRT_R	☐	MC_REWRT_R	WERTV8	CURR	15	2	Invoice amount: Returns
51	EFFWR_R	☐	MC_EFFWR_R	WERTV8	CURR	15	2	Effective order value of returns
52	WEWRT	☐	MC_WEWERT	WERT7	CURR	13	2	Value of goods received in local currency
53	REMNG_B	☐	MC_REMNG_B	MENGV15_3	QUAN	15	3	Invoice receipt quantity as at posting date
54	WEWRT_B	☐	MC_WEWRT_B	WERTV8	CURR	15	2	Goods receipt value as at posting date
55	REWRT_B	☐	MC_REWRT_B	WERTV8	CURR	15	2	Invoice Amount as at Posting Date
56	REMNG_R_B	☐	MC_REMNG_R_B	MENGV15_3	QUAN	15	3	IR quantity: Returns as at posting date
57	REWRT_R_B	☐	MC_REWRT_R_B	WERTV8	CURR	15	2	IR value: Returns as at posting date
58	WEWRT_R_B	☐	MC_WEWRT_R_B	WERTV8	CURR	15	2	GR value: Returns as at posting date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	S012BIW2	BASME	T006	MSEHI
2	S012BIW2	EKORG	T024E	EKORG
3	S012BIW2	HWAER	TCURC	WAERS
4	S012BIW2	INFNR	EINA	INFNR
5	S012BIW2	LAND1	T005	LAND1
6	S012BIW2	LIFNR	LFA1	LIFNR
7	S012BIW2	MANDT	T000	MANDT
8	S012BIW2	MATKL	T023	MATKL
9	S012BIW2	MATNR	MARA	MATNR
10	S012BIW2	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20110901
SAP Release Created in