SAP ABAP Table MMDA_PUR_S_PUR_C01 (Purchasing Data (Similar to InfoCube 0PUR_C01))

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM (Application Component) Materials Management
     ⤷ MMDA (Package) Data Provisioning for Real Time Reporting in MM

Basic Data

Table Category	INTTAB	Structure
Structure	MMDA_PUR_S_PUR_C01	Table Relationship Diagram
Short Description	Purchasing Data (Similar to InfoCube 0PUR_C01)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	CALDAY	☐	RSCALDAY	DATUM	DATS	8	0	Calendar day
2	CALMONTH	☐	RSCALMONTH	RSCALMONTH	NUMC	6	0	Calendar year / month
3	CALWEEK	☐	RSCALWEEK	RSCALWEEK	NUMC	6	0	Calendar year / week
4	FISCPER	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
5	FISCVARNT	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
6	DOC_DATE	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
7	COUNTRY	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
8	INFO_REC	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
9	INFO_TYPE	☐	ESOKZ	ESOKZ	CHAR	1	0	Purchasing info record category
10	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
11	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
12	PURCH_ORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
13	REVERSEDOC	☐	ILOEA	XFELD	CHAR	1	0	Purchasing info: General data flagged for deletion
14	VENDOR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
15	VERSION	☐	VERSN	COVERSI	CHAR	3	0	Version	*
16	VTYPE	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
17	CT_FLG	☐	MMPUR_BOOL	CHAR1	CHAR	1	0	Boolean type
18	PLANT	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
19	GR_RE_IND	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
20	DELIVERIES	☐	DELIVERIES		DEC	17	3	Number of Deliveries
21	DEL_DT_VR1	☐	DEL_DT_VR		DEC	17	3	Delivery Date Variance
22	DEL_DT_VR2	☐	DEL_DT_VR		DEC	17	3	Delivery Date Variance
23	DEL_DT_VR3	☐	DEL_DT_VR		DEC	17	3	Delivery Date Variance
24	DEL_DT_VR4	☐	DEL_DT_VR		DEC	17	3	Delivery Date Variance
25	DEL_DT_VR5	☐	DEL_DT_VR		DEC	17	3	Delivery Date Variance
26	QTY_DEV_1	☐	QTY_DEV		DEC	17	3	Delivery Quantity Variance
27	QTY_DEV_2	☐	QTY_DEV		DEC	17	3	Delivery Quantity Variance
28	QTY_DEV_3	☐	QTY_DEV		DEC	17	3	Delivery Quantity Variance
29	QTY_DEV_4	☐	QTY_DEV		DEC	17	3	Delivery Quantity Variance
30	QTY_DEV_5	☐	QTY_DEV		DEC	17	3	Delivery Quantity Variance
31	IR_VAL_RET	☐	IR_VAL_RET	WERTV9	CURR	17	2	Invoiced Amount: Returns
32	WTDDELTIME	☐	WTDDELTIME		DEC	17	3	Weighted Total Delivery Time
33	EFF_VAL_RE	☐	EFF_VAL_RE	WERTV9	CURR	17	2	Effective Order Value of Returns
34	GR_VAL	☐	GR_VAL	WERTV9	CURR	17	2	Value of Goods Received
35	GR_VAL_PD	☐	GR_VAL_PD	WERTV9	CURR	17	2	Goods Receipt Value at Posting Date
36	INV_RC_QTY	☐	INV_RC_QTY	MENGV15_3	QUAN	15	3	Invoice Receipt Quantity at Posting Date
37	INV_RC_VAL	☐	INV_RC_VAL	WERTV9	CURR	17	2	Invoice Amount as Posting Date
38	GR_QTY	☐	GR_QTY	MENGV15_3	QUAN	15	3	Actual Goods Receipt Quantity
39	GR_QTY_RET	☐	GR_QTY_RET	MENGV15_3	QUAN	15	3	Goods Receipt Quantity of Returns
40	GR_QTY_WDT	☐	GR_QTY_WDT	MENGV15_3	QUAN	15	3	GR Qty in Base Unit (Calculate Weighted Delivery Time)
41	GR_VAL_R_P	☐	GR_VAL_R_P	WERTV9	CURR	17	2	GR Value: Returns at Posting Date
42	INVCD_AMNT	☐	INVCD_AMNT	WERTV9	CURR	17	2	Invoiced Amount
43	IR_QTY_RET	☐	IR_QTY_RET	MENGV15_3	QUAN	15	3	Invoice Receipt Quantity of Returns
44	IR_QTY_R_P	☐	IR_QTY_R_P	MENGV15_3	QUAN	15	3	IR Quantity: Returns at Posting Date
45	IR_VAL_R_P	☐	IR_VAL_R_P	WERTV9	CURR	17	2	IR Value: Returns at Posting Date
46	IV_REC_QTY	☐	IV_REC_QTY	MENGV15_3	QUAN	15	3	Invoice Receipt Quantity
47	ORDER_VAL	☐	ORDER_VAL	WERTV9	CURR	17	2	Effective Purchase Order Value
48	TAR_DL_QTY	☐	TAR_DL_QTY	MENGV15_3	QUAN	15	3	Target Delivery Quantity
49	PO_QTY_RET	☐	PO_QTY_RET	MENGV15_3	QUAN	15	3	Order Quantity (Returns)
50	CONTR_ITEM	☐	CONTR_ITEM		DEC	17	3	Number of Contract Items
51	DEL_SCHEDS	☐	DEL_SCHEDS		DEC	17	3	Number of Scheduling Agreement Schedule Lines
52	PO_ITEMLNS	☐	PO_ITEMLNS		DEC	17	3	Number of Purchase Order Schedule Lines
53	PO_ITEMS	☐	PO_ITEMS		DEC	17	3	Number of Purchase Order Items
54	PO_QTY	☐	PO_QTY	MENGV15_3	QUAN	15	3	Order Quantity
55	QUOT_ITEMS	☐	QUOT_ITEMS		DEC	17	3	Number of Quotation Items
56	RFQ_ITEMS	☐	RFQ_ITEMS		DEC	17	3	Number of Request for Quotation Items
57	SCH_AGR_IT	☐	SCH_AGR_IT		DEC	17	3	Number of Scheduling Agreement Items
58	TOTDELTIME	☐	TOTDELTIME		DEC	17	3	Total Delivery Time in Days
59	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
60	LOC_CURRCY	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
61	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

History

Last changed by/on	SAP	20110901
SAP Release Created in	606