SAP ABAP Table V_PUR_PO_ITM (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_PUR_PO_ITM	Table Relationship Diagram
Short Description	Generated Table for View

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	V_PUR_PO_ITM	AKTNR	WAKH	AKTNR	KEY	1	N
2	V_PUR_PO_ITM	BNFPO	EBAN	BNFPO	REF	1	N
3	V_PUR_PO_ITM	BPRME	T006	MSEHI	REF	1	N
4	V_PUR_PO_ITM	BSART	T161	BSART	REF	1	N
5	V_PUR_PO_ITM	BSGRU	TBSG	BSGRU	REF	1	N
6	V_PUR_PO_ITM	BSTAE	T163L	BSTAE	KEY	1	N
7	V_PUR_PO_ITM	BUKRS	T001	BUKRS	REF	1	N
8	V_PUR_PO_ITM	BUKRS_ITM	T001	BUKRS	REF	1	N
9	V_PUR_PO_ITM	BWTAR	T149D	BWTAR	REF	1	N
10	V_PUR_PO_ITM	EKGRP	T024	EKGRP	REF	1	N
11	V_PUR_PO_ITM	EKORG	T024E	EKORG	REF	1	N
12	V_PUR_PO_ITM	EMATN	MARA	MATNR	REF	1	N
13	V_PUR_PO_ITM	GEWEI	T006	MSEHI	REF	1	N
14	V_PUR_PO_ITM	INFNR	EINA	INFNR	REF	1	N
15	V_PUR_PO_ITM	KALSM	T683	KALSM	REF	1	N
16	V_PUR_PO_ITM	KNTTP	T163K	KNTTP	REF	1	N
17	V_PUR_PO_ITM	KONNR	EKKO	EBELN	REF	1	N
18	V_PUR_PO_ITM	KTPNR	EKPO	EBELP	REF	1	N
19	V_PUR_PO_ITM	KUNNR	KNA1	KUNNR	REF	1	N
20	V_PUR_PO_ITM	LBLIF	LFA1	LIFNR	REF	1	N
21	V_PUR_PO_ITM	LGORT	T001L	LGORT	REF	1	N
22	V_PUR_PO_ITM	LIFNR	LFA1	LIFNR	REF	1	N
23	V_PUR_PO_ITM	LIFRE	LFA1	LIFNR	REF	1	N
24	V_PUR_PO_ITM	LLIEF	LFA1	LIFNR	REF	1	N
25	V_PUR_PO_ITM	LMEIN	T006	MSEHI	REF	1	N
26	V_PUR_PO_ITM	MANDT	T000	MANDT	KEY	1	N
27	V_PUR_PO_ITM	MATKL	T023	MATKL	REF	1	N
28	V_PUR_PO_ITM	MATNR	MARA	MATNR	REF	1	N
29	V_PUR_PO_ITM	MEINS	T006	MSEHI	REF	1	N
30	V_PUR_PO_ITM	MFRNR	LFA1	LIFNR	REF	1	N
31	V_PUR_PO_ITM	MWSKZ	T007A	MWSKZ	KEY	1	CN
32	V_PUR_PO_ITM	PSTYP	T163	PSTYP	REF	1	N
33	V_PUR_PO_ITM	PUNEI	T006	MSEHI	KEY	1	N
34	V_PUR_PO_ITM	RESLO	T001L	LGORT
35	V_PUR_PO_ITM	RESWK	T001W	WERKS	REF	1	N
36	V_PUR_PO_ITM	SATNR	MARA	MATNR	REF	1	N
37	V_PUR_PO_ITM	VOLEH	T006	MSEHI	REF	1	N
38	V_PUR_PO_ITM	WAERS	TCURC	WAERS	REF	1	N
39	V_PUR_PO_ITM	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in