SAP ABAP Table MMDA_PUR_S_PO_ITM (Extract Structure For PO ITM Datasource)

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_PO_ITM	Table Relationship Diagram
Short Description	Extract Structure For PO ITM Datasource

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	ROCANCEL	☐	ROCANCEL	BOOLE	CHAR	1	0	Indicator: Cancel Data Record
2	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
3	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
4	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
5	BUDAT	☐	MC_BUDAT	DATUM	DATS	8	0	Posting date of goods received or invoice receipt for order
6	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
7	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	*
8	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
9	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
10	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
11	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
12	LBLIF	☐	LBLIF	LIFNR	CHAR	10	0	Field not used	*
13	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
14	LIFRE	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	*
15	LLIEF	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	*
16	LOGSY	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
17	ORGLOGSY	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
18	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
19	STATU	☐	ESTAK	ESTAK	CHAR	1	0	Status of Purchasing Document
20	SYDAT	☐	MC_ERFDAT	DATUM	DATS	8	0	Date on which the purchasing document was entered
21	WAERS	☐	BSTWA	WAERS	CUKY	5	0	Purchase order currency	*
22	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
23	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
24	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
25	AKTWE	☐	MC_AKTWE	MENG13	QUAN	13	3	Current goods receipt quantity in order unit
26	ALAV	☐	MC_ALAV	DEC3	DEC	3	0	Points score: Shipping notif. GR date - notified date
27	ALIEF	☐	MC_ALIEF	MCZAEHLER	DEC	9	0	Number of deliveries
28	BSGRU	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering
29	BWAPPLNM	☐	RSAPPLNM	RSAPPLNM	CHAR	30	0	Application Component
30	BWVORG	☐	MCW_BWVORG	NUM3	NUMC	3	0	SAP BW transaction key
31	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
32	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
33	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
34	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
35	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
36	KTMNG	☐	KTMNG	MENGE	QUAN	13	3	Target Quantity
37	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
38	KZMAB	☐	MC_KZMAB	CHAR1	CHAR	1	0	Indicator: relevant quantity deviation
39	KZPOS	☐	MC_KZPOS	X	CHAR	1	0	Indicator: item counter relevant (R/2->R/3 link, schd.agmt)
40	KZTAB	☐	MC_KZTAB	CHAR1	CHAR	1	0	Indicator: relevant schedule deviation
41	LAVI	☐	MC_LAVI	DEC3	DEC	3	0	Points score: Shipping notification
42	LFZTA	☐	MC_LFZTA	DECV13	DEC	13	0	Total delivery time in days
43	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
44	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	*
45	MABW	☐	MC_MABW	PRZ32V	DEC	6	2	Variance in the quantity delivered as %
46	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
47	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
48	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
49	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
50	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
51	NETWR	☐	MC_BNETWR	WERT7	CURR	13	2	Net order value in order currency
52	PEINH	☐	PEINH	PACK3	DEC	5	0	Price unit
53	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
54	PWEV	☐	MC_PWEV	DEC3	DEC	3	0	Points score for compliance with shipping instructions
55	PWFR	☐	MC_PWFR	DEC3	DEC	3	0	Points score for on-time delivery
56	PWMT	☐	MC_PWMT	DEC3	DEC	3	0	Points score for quantity reliability
57	PWTT	☐	MC_PWTT	DEC3	DEC	3	0	Points score for on-time delivery performance
58	PWWE	☐	MC_PWWE	DEC3	DEC	3	0	Points score for quality of services
59	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
60	TABW	☐	MC_TABW	PL2	DEC	3	0	Delivery Date Variance in Days
61	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
62	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
63	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
64	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
65	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
66	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
67	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
68	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
69	PERIV	☐	PERIV	PERIV	CHAR	2	0	Fiscal Year Variant	*
70	QUAN_INT	☐	MC_QUAN_INT	PL2	DEC	3	0	Interval for Quantity Interval
71	TIME_INT	☐	MC_TIME_INT	PL2	DEC	3	0	Interval for Date Split
72	NOTIME	☐	MC_NOTIME	PL2	DEC	3	0	Counter for Date Split
73	NOQUAN	☐	MC_NOQUAN	PL2	DEC	3	0	Counter for Quantity Interval
74	NOPOS	☐	MC_NOPOS	PL2	DEC	3	0	Counter for Items
75	PWLIF	☐	PWLIF	LIFNR	CHAR	10	0	Goods supplier	*
76	PREST	☐	PREST	LIFNR	CHAR	10	0	Invoicing party	*
77	PLIWK	☐	PLIWK	LIFNR	CHAR	10	0	Supplying plant to which partner roles have been assigned	*
78	PLIEF	☐	PLIEF	LIFNR	CHAR	10	0	Vendor to whom partner roles have been assigned	*
79	PBEST	☐	PBEST	LIFNR	CHAR	10	0	Ordering address	*
80	MGABW	☐	MGABW	GLATT	DEC	3	2	Smoothing Factor: Quantity Variance
81	LFABW	☐	LFABW	GLATT	DEC	3	2	Smoothing Factor: Date Variance
82	MAXBW	☐	BEWERX	BEWER	DEC	3	0	Best Score
83	VVABW	☐	VVABW	GLATT	DEC	3	2	Smoothing Factor: Compliance with Shipping Instructions
84	UZEIT	☐	UZEIT	UZEIT	TIMS	6	0	Time
85	MCEX_UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
86	MCEX_UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
87	MCEX_UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
88	TIMESTAMP	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)

History

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