SAP ABAP Table EKPO (Purchasing Document Item)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ SRM-EBP (Application Component) Enterprise Buyer
     ⤷ BBP_APPLICATION (Package) Structure Package EBP
       ⤷ ME (Package) Application development R/3 Purchasing

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	EKPO	Table Relationship Diagram
Short Description	Purchasing Document Item

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	EBELN	☑	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
4	.INCLUDE	☐				0	0	Purchasing Document Item: Data Part
5	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
6	STATU	☐	ASTAT	ASTAT	CHAR	1	0	RFQ status
7	AEDAT	☐	PAEDT	DATUM	DATS	8	0	Purchasing Document Item Change Date
8	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
9	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
10	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
11	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
12	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
13	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
14	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
15	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
16	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
17	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
18	KTMNG	☐	KTMNG	MENGE	QUAN	13	3	Target Quantity
19	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
20	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
21	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
22	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
23	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
24	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
25	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
26	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
27	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
28	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
29	BRTWR	☐	BBWERT	WERT7	CURR	13	2	Gross order value in PO currency
30	AGDAT	☐	ANGAB	DATUM	DATS	8	0	Deadline for Submission of Bid/Quotation
31	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
32	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
33	BONUS	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
34	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
35	SPINF	☐	SPINF	SPINF	CHAR	1	0	Indicator: Update Info Record
36	PRSDR	☐	PRSDR	XFELD	CHAR	1	0	Price Printout
37	SCHPR	☐	SCHPR	XFELD	CHAR	1	0	Indicator: Estimated Price
38	MAHNZ	☐	MAHNZ	PACK2	DEC	3	0	Number of Reminders/Expediters
39	MAHN1	☐	MAHN1	MAHNT	DEC	3	0	Number of Days for First Reminder/Expediter
40	MAHN2	☐	MAHN2	MAHNT	DEC	3	0	Number of Days for Second Reminder/Expediter
41	MAHN3	☐	MAHN3	MAHNT	DEC	3	0	Number of Days for Third Reminder/Expediter
42	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
43	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
44	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
45	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
46	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
47	ABSKZ	☐	ABSKZ	XFELD	CHAR	1	0	Rejection Indicator
48	AGMEM	☐	AGMEM	AGMEM	CHAR	3	0	Internal Comment on Quotation	*
49	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
50	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
51	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
52	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
53	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
54	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
55	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
56	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
57	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
58	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
59	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
60	KZABS	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
61	LABNR	☐	LABNR	TEXT20	CHAR	20	0	Order Acknowledgment Number
62	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
63	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
64	ABDAT	☐	ABDAT	DATUM	DATS	8	0	Reconciliation date for agreed cumulative quantity
65	ABFTZ	☐	ABFTZ	MENG13	QUAN	13	3	Agreed Cumulative Quantity
66	ETFZ1	☐	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
67	ETFZ2	☐	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)
68	KZSTU	☐	MRPRE	KZFIX	CHAR	1	0	Firm/Trade-Off Zones Binding with Regard to Mat. Planning
69	NOTKZ	☐	NOTKZ	XFELD	CHAR	1	0	Exclusion in Outline Agreement Item with Material Class
70	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
71	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	*
72	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
73	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
74	ABMNG	☐	NORAM	MENG13	QUAN	13	3	Standard release order quantity
75	PRDAT	☐	PREDT	DATUM	DATS	8	0	Date of Price Determination
76	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
77	EFFWR	☐	EFFWR	WERT7	CURR	13	2	Effective value of item
78	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
79	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	*
80	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	ADRC
81	EKKOL	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
82	SKTOF	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
83	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
84	PLIFZ	☐	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
85	NTGEW	☐	ENTGE	MENG13	QUAN	13	3	Net Weight
86	GEWEI	☐	EGEWE	MEINS	UNIT	3	0	Unit of Weight	T006
87	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
88	ETDRK	☐	ETDRK	ETDRK	CHAR	1	0	Indicator: Print-relevant schedule lines exist
89	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
90	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
91	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
92	INSNC	☐	INSNC	XFELD	CHAR	1	0	Quality inspection indicator cannot be changed
93	SSQSS	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	*
94	ZGTYP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	*
95	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
96	BSTAE	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	*
97	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
98	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
99	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
100	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
101	KO_GSBER	☐	GSBER_GP	GSBER	CHAR	4	0	Business area reported to the partner	*
102	KO_PARGB	☐	PARGB_GP	GSBER	CHAR	4	0	assumed business area of the business partner	*
103	KO_PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
104	KO_PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	*
105	MEPRF	☐	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
106	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
107	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
108	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
109	INCO1	☐	INCO1	CRM_INCOTERMS1	CHAR	3	0	Incoterms (part 1)	*
110	INCO2	☐	INCO2	CRM_INCOTERMS2	CHAR	28	0	Incoterms (part 2)
111	VORAB	☐	VORAB	XFELD	CHAR	1	0	Advance procurement: project stock
112	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
113	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	*
114	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
115	FPLNR	☐	IPLNR	CHAR10	CHAR	10	0	Invoicing plan number
116	GNETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
117	STAPO	☐	STAPO	XFELD	CHAR	1	0	Item is statistical
118	UEBPO	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	EKPO
119	LEWED	☐	LEWED	DATUM	DATS	8	0	Latest Possible Goods Receipt
120	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
121	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
122	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
123	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
124	KANBA	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
125	ADRN2	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	ADRC
126	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
127	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
128	EILDT	☐	EILDT	DATUM	DATS	8	0	Start Date for GR-Based Settlement
129	DRDAT	☐	DRDAT	DATUM	DATS	8	0	Last Transmission
130	DRUHR	☐	DRUHR	UZEIT	TIMS	6	0	Time
131	DRUNR	☐	DRUNR	NUMC4	NUMC	4	0	Sequential Number
132	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
133	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	*
134	ABELP	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table	*
135	ANZPU	☐	ANZPU	MENG13	QUAN	13	3	Number of Points
136	PUNEI	☐	PUNEI	MEINS	UNIT	3	0	Points unit	T006
137	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	*
138	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
139	EBON2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
140	EBON3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
141	EBONF	☐	EBONY	XFELD	CHAR	1	0	Item Relevant to Subsequent (Period-End Rebate) Settlement
142	MLMAA	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
143	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
144	ANFNR	☐	ANFNR	EBELN	CHAR	10	0	RFQ Number	EKKO
145	ANFPS	☐	ANFPS	EBELP	NUMC	5	0	Item Number of RFQ	EKPO
146	KZKFG	☐	KZCUH	KZCUH	CHAR	1	0	Origin of Configuration
147	USEQU	☐	USEQU	USEQU	CHAR	1	0	Quota arrangement usage	*
148	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
149	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
150	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
151	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
152	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	*
153	UPVOR	☐	UPVOR	CHAR1	CHAR	1	0	Subitems Exist
154	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
155	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
156	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
157	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
158	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
159	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
160	SIKGR	☐	SIKGR	SIKGR	CHAR	3	0	Processing key for sub-items	*
161	MFZHI	☐	MFZHI	MENG15	QUAN	15	3	Maximum Cumulative Material Go-Ahead Quantity
162	FFZHI	☐	FFZHI	MENG15	QUAN	15	3	Maximum Cumulative Production Go-Ahead Quantity
163	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
164	AUREL	☐	AUREL	AUREL	CHAR	1	0	Relevant to Allocation Table
165	BSGRU	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering	*
166	LFRET	☐	LFRET	LFART	CHAR	4	0	Delivery Type for Returns to Vendors	*
167	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	*
168	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
169	J_1BNBM	☐	J_1BNBMCO1	STEUC	CHAR	16	0	Brazilian NCM Code	*
170	J_1BMATUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
171	J_1BMATORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
172	J_1BOWNPRO	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
173	J_1BINDUST	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
174	ABUEB	☐	ABUEB	ABUEB	CHAR	4	0	Release Creation Profile	*
175	NLABD	☐	NLABD	DATUM	DATS	8	0	Next Forecast Delivery Schedule Transmission
176	NFABD	☐	NFABD	DATUM	DATS	8	0	Next JIT Delivery Schedule Transmission
177	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
178	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
179	FABKZ	☐	FABKZ	FABKZ	CHAR	1	0	Indicator: Item Relevant to JIT Delivery Schedules
180	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	*
181	J_1AIDATEP	☐	J_1AIDATEP	J_1AUDATEP	DATS	8	0	Last day of the time period where the index value is valid
182	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
183	EGLKZ	☐	EGLKZ	XFELD	CHAR	1	0	"Outward Delivery Completed" Indicator
184	KZTLF	☐	KZTUL	KZTUL	CHAR	1	0	Partial Delivery at Item Level (Stock Transfer)
185	KZFME	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
186	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	*
187	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
188	CHG_SRV	☐	CHG_SRV	XFELD	CHAR	1	0	Configuration changed
189	CHG_FPLNR	☐	CHG_FPLNR	XFELD	CHAR	1	0	No invoice for this item although not free of charge
190	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
191	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
192	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
193	NOVET	☐	NOVET	XFELD	CHAR	1	0	Item blocked for SD delivery
194	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
195	TZONRC	☐	TSEGZONREC	TZNZONE	CHAR	6	0	Time zone of recipient location	*
196	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
197	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EKPO	ADRN2	ADRC	ADDRNUMBER
2	EKPO	ADRNR	ADRC	ADDRNUMBER	KEY	1	CN
3	EKPO	ANFNR	EKKO	EBELN	REF	1	N
4	EKPO	ANFPS	EKPO	EBELP	REF	1	N
5	EKPO	BNFPO	EBAN	BNFPO	REF	1	N
6	EKPO	BPRME	T006	MSEHI	REF	1	N
7	EKPO	BUKRS	T001	BUKRS	REF	1	N
8	EKPO	EBELN	EKKO	EBELN	KEY	1	N
9	EKPO	EMLIF	LFA1	LIFNR	KEY	1	N
10	EKPO	FIPOS	FMFPO	FIPOS	REF	C	CN
11	EKPO	GEWEI	T006	MSEHI	REF	1	N
12	EKPO	KOLIF	LFA1	LIFNR	REF	1	CN
13	EKPO	KONNR	EKKO	EBELN	REF	1	N
14	EKPO	KTPNR	EKPO	EBELP	REF	1	N
15	EKPO	LMEIN	T006	MSEHI	REF	1	N
16	EKPO	MANDT	T000	MANDT	KEY	1	N
17	EKPO	MATKL	T023	MATKL	REF	1	N
18	EKPO	MEINS	T006	MSEHI	REF	1	N
19	EKPO	MFRNR	LFA1	LIFNR	REF	1	N
20	EKPO	PUNEI	T006	MSEHI	KEY	1	N
21	EKPO	TXJCD	TTXJ	TXJCD	REF	1	CN
22	EKPO	UEBPO	EKPO	EBELP
23	EKPO	VOLEH	T006	MSEHI	REF	1	N
24	EKPO	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130604
SAP Release Created in