SAP ABAP View V_PUR_PO_ITM (View For PUR PO ITEM 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

View Type	D	Database View
Database View	V_PUR_PO_ITM
Short Description	View For PUR PO ITEM Datasource
Root table	EKKO	Purchasing Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EKKO	EKKO
2	EKPO

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EKPO	MANDT	JL	EQ				0	0
2	EKKO	MANDT	JR	EQ			AND	0	0
3	EKPO	EBELN	JL	EQ				0	0
4	EKKO	EBELN	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EKKO	MANDT		☐	MANDT	☐	Client
2	EBELN	EKKO	EBELN		☐	EBELN	☐	Purchasing Document Number
3	EBELP	EKPO	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
4	BEDAT	EKKO	BEDAT		☐	EBDAT	☐	Purchasing Document Date
5	BSART	EKKO	BSART		☐	ESART	☐	Purchasing Document Type
6	BSTYP	EKKO	BSTYP		☐	EBSTYP	☐	Purchasing Document Category
7	EKGRP	EKKO	EKGRP		☐	BKGRP	☐	Purchasing Group
8	EKORG	EKKO	EKORG		☐	EKORG	☐	Purchasing organization
9	KDATB	EKKO	KDATB		☐	KDATB	☐	Start of Validity Period
10	KDATE	EKKO	KDATE		☐	KDATE	☐	End of Validity Period
11	LBLIF	EKKO	LBLIF		☐	LBLIF	☐	Field not used
12	LIFNR	EKKO	LIFNR		☐	ELIFN	☐	Vendor's account number
13	LIFRE	EKKO	LIFRE		☐	LIFRE	☐	Different Invoicing Party
14	LLIEF	EKKO	LLIEF		☐	LLIEF	☐	Supplying Vendor
15	ADRNR	EKKO	ADRNR		☐	AD_ADDRNUM	☐	Address number
16	LOGSY	EKKO	LOGSY		☐	LOGSYSTEM	☐	Logical System
17	RESWK	EKKO	RESWK		☐	RESWK	☐	Supplying (issuing) plant in case of stock transport order
18	STATU	EKKO	STATU		☐	ESTAK	☐	Status of Purchasing Document
19	SYDAT	EKKO	BEDAT		☐	EBDAT	☐	Purchasing Document Date
20	WAERS	EKKO	WAERS		☐	WAERS	☐	Currency Key
21	WKURS	EKKO	WKURS		☐	WKURS	☐	Exchange Rate
22	BSAKZ	EKKO	BSAKZ		☐	BSAKZ	☐	Control indicator for purchasing document type
23	BUKRS	EKKO	BUKRS		☐	BUKRS	☐	Company Code
24	FRGRL	EKKO	FRGRL		☐	FRGRL	☐	Release Not Yet Completely Effected
25	KALSM	EKKO	KALSM		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
26	KNUMV	EKKO	KNUMV		☐	KNUMV	☐	Number of the document condition
27	KORNR	EKKO	KORNR		☐	KORNR	☐	Correction of miscellaneous provisions
28	KTWRT	EKKO	KTWRT		☐	KTWRT	☐	Target Value for Header Area per Distribution
29	KUFIX	EKKO	KUFIX		☐	KUFIX	☐	Indicator: Fixing of Exchange Rate
30	KUNNR	EKKO	KUNNR		☐	KUNNR	☐	Customer Number
31	LOEKZ	EKKO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
32	MEMORY	EKKO	MEMORY		☐	MEMER	☐	Purchase order not yet complete
33	REVNO	EKKO	REVNO		☐	REVNO	☐	Version number in Purchasing
34	STAFO	EKKO	STAFO		☐	STAFO	☐	Update group for statistics update
35	STAKO	EKKO	STAKO		☐	STAKO	☐	Document with time-dependent conditions
36	SUBMI	EKKO	SUBMI		☐	SUBMI	☐	Collective Number
37	AFNAM	EKPO	AFNAM		☐	AFNAM	☐	Name of requisitioner/requester
38	AKTNR	EKPO	AKTNR		☐	WAKTION	☐	Promotion
39	BSGRU	EKPO	BSGRU		☐	BSGRU	☐	Reason for Ordering
40	ELIKZ	EKPO	ELIKZ		☐	ELIKZ	☐	"Delivery Completed" Indicator
41	EMATN	EKPO	EMATN		☐	EMATNR	☐	Material number
42	EREKZ	EKPO	EREKZ		☐	EREKZ	☐	Final Invoice Indicator
43	KONNR	EKPO	KONNR		☐	KONNR	☐	Number of principal purchase agreement
44	KTMNG	EKPO	KTMNG		☐	KTMNG	☐	Target Quantity
45	KTPNR	EKPO	KTPNR		☐	KTPNR	☐	Item number of principal purchase agreement
46	LGORT	EKPO	LGORT		☐	LGORT_D	☐	Storage location
47	LMEIN	EKPO	LMEIN		☐	LAGME	☐	Base Unit of Measure
48	MATKL	EKPO	MATKL		☐	MATKL	☐	Material Group
49	MATNR	EKPO	MATNR		☐	MATNR	☐	Material Number
50	MEINS	EKPO	MEINS		☐	BSTME	☐	Order unit
51	MENGE	EKPO	MENGE		☐	BSTMG	☐	Purchase Order Quantity
52	NETPR	EKPO	NETPR		☐	BPREI	☐	Net Price in Purchasing Document (in Document Currency)
53	NETWR	EKPO	NETWR		☐	BWERT	☐	Net Order Value in PO Currency
54	PEINH	EKPO	PEINH		☐	EPEIN	☐	Price unit
55	PSTYP	EKPO	PSTYP		☐	PSTYP	☐	Item category in purchasing document
56	REPOS	EKPO	REPOS		☐	REPOS	☐	Invoice receipt indicator
57	TXZ01	EKPO	TXZ01		☐	TXZ01	☐	Short Text
58	UMREN	EKPO	UMREN		☐	UMBSN	☐	Denominator for Conversion of Order Unit to Base Unit
59	UMREZ	EKPO	UMREZ		☐	UMBSZ	☐	Numerator for Conversion of Order Unit to Base Unit
60	WEBRE	EKPO	WEBRE		☐	WEBRE	☐	Indicator: GR-Based Invoice Verification
61	WEPOS	EKPO	WEPOS		☐	WEPOS	☐	Goods Receipt Indicator
62	WERKS	EKPO	WERKS		☐	EWERK	☐	Plant
63	XERSY	EKPO	XERSY		☐	XERSY	☐	Evaluated Receipt Settlement (ERS)
64	ZWERT	EKPO	ZWERT		☐	DZWERT	☐	Target value for outline agreement in document currency
65	ANZPU	EKPO	ANZPU		☐	ANZPU	☐	Number of Points
66	BPRME	EKPO	BPRME		☐	BBPRM	☐	Order Price Unit (purchasing)
67	BPUMN	EKPO	BPUMN		☐	BPUMN	☐	Denominator for Conv. of Order Price Unit into Order Unit
68	BPUMZ	EKPO	BPUMZ		☐	BPUMZ	☐	Numerator for Conversion of Order Price Unit into Order Unit
69	BRGEW	EKPO	BRGEW		☐	BRGEW	☐	Gross weight
70	BRTWR	EKPO	BRTWR		☐	BBWERT	☐	Gross order value in PO currency
71	BSTAE	EKPO	BSTAE		☐	BSTAE	☐	Confirmation Control Key
72	BSTYP_ITM	EKPO	BSTYP		☐	BSTYP	☐	Purchasing document category
73	BUKRS_ITM	EKPO	BUKRS		☐	BUKRS	☐	Company Code
74	BWTAR	EKPO	BWTAR		☐	BWTAR_D	☐	Valuation type
75	EBONF	EKPO	EBONF		☐	EBONY	☐	Item Relevant to Subsequent (Period-End Rebate) Settlement
76	EFFWR	EKPO	EFFWR		☐	EFFWR	☐	Effective value of item
77	EGLKZ	EKPO	EGLKZ		☐	EGLKZ	☐	"Outward Delivery Completed" Indicator
78	EMNFR	EKPO	EMNFR		☐	EMNFR	☐	External manufacturer code name or number
79	FPLNR	EKPO	FPLNR		☐	IPLNR	☐	Invoicing plan number
80	GEWEI	EKPO	GEWEI		☐	EGEWE	☐	Unit of Weight
81	IDNLF	EKPO	IDNLF		☐	IDNLF	☐	Material Number Used by Vendor
82	INFNR	EKPO	INFNR		☐	INFNR	☐	Number of purchasing info record
83	KNTTP	EKPO	KNTTP		☐	KNTTP	☐	Account assignment category
84	KZWI1	EKPO	KZWI1		☐	KZWI1	☐	Subtotal 1 from pricing procedure for condition
85	KZWI2	EKPO	KZWI2		☐	KZWI2	☐	Subtotal 2 from pricing procedure for condition
86	KZWI3	EKPO	KZWI3		☐	KZWI3	☐	Subtotal 3 from pricing procedure for condition
87	KZWI4	EKPO	KZWI4		☐	KZWI4	☐	Subtotal 4 from pricing procedure for condition
88	KZWI5	EKPO	KZWI5		☐	KZWI5	☐	Subtotal 5 from pricing procedure for condition
89	KZWI6	EKPO	KZWI6		☐	KZWI6	☐	Subtotal 6 from pricing procedure for condition
90	LOEKZ_ITM	EKPO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
91	LTSNR	EKPO	LTSNR		☐	LTSNR	☐	Vendor Subrange
92	MEPRF	EKPO	MEPRF		☐	MEPRF	☐	Price Determination (Pricing) Date Control
93	MFRNR	EKPO	MFRNR		☐	MFRNR	☐	Manufacturer number
94	MFRPN	EKPO	MFRPN		☐	MFRPN	☐	Manufacturer Part Number
95	MPROF	EKPO	MPROF		☐	MPROF	☐	Mfr part profile
96	MWSKZ	EKPO	MWSKZ		☐	MWSKZ	☐	Tax on sales/purchases code
97	NAVNW	EKPO	NAVNW		☐	NAVNW	☐	Non-deductible input tax
98	NTGEW	EKPO	NTGEW		☐	ENTGE	☐	Net Weight
99	PRDAT	EKPO	PRDAT		☐	PREDT	☐	Date of Price Determination
100	PUNEI	EKPO	PUNEI		☐	PUNEI	☐	Points unit
101	RESLO	EKPO	RESLO		☐	RESLO	☐	Issuing Storage Location for Stock Transport Order
102	RETPO	EKPO	RETPO		☐	RETPO	☐	Returns Item
103	SATNR	EKPO	SATNR		☐	SATNR	☐	Cross-Plant Configurable Material
104	STAFO_ITM	EKPO	STAFO		☐	STAFO	☐	Update group for statistics update
105	STAPO_ITM	EKPO	STAPO		☐	STAPO	☐	Item is statistical
106	STATU_ITM	EKPO	STATU		☐	ASTAT	☐	RFQ status
107	TWRKZ	EKPO	TWRKZ		☐	TWRKZ	☐	Partial invoice indicator
108	VOLEH	EKPO	VOLEH		☐	VOLEH	☐	Volume unit
109	VOLUM	EKPO	VOLUM		☐	VOLUM	☐	Volume
110	VRTKZ	EKPO	VRTKZ		☐	VRTKZ	☐	Distribution indicator for multiple account assignment
111	WEBAZ	EKPO	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
112	WEUNB	EKPO	WEUNB		☐	WEUNB	☐	Goods Receipt, Non-Valuated
113	BANFN	EKPO	BANFN		☐	BANFN	☐	Purchase requisition number
114	BNFPO	EKPO	BNFPO		☐	BNFPO	☐	Item number of purchase requisition
115	MCEX_UEBTO	EKPO	UEBTO		☐	UEBTO	☐	Overdelivery Tolerance Limit
116	MCEX_UEBTK	EKPO	UEBTK		☐	UEBTK	☐	Indicator: Unlimited Overdelivery Allowed
117	MCEX_UNTTO	EKPO	UNTTO		☐	UNTTO	☐	Underdelivery Tolerance Limit

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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