SAP ABAP Table EXPD_EKPO_LINE (Structure for Selection of a PO Item)

Hierarchy

☛ EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   ⤷ PS-PRG-TRC (Application Component) Progress Tracking
     ⤷ EXPD (Package) Expediting for Order

Basic Data

Table Category	INTTAB	Structure
Structure	EXPD_EKPO_LINE	Table Relationship Diagram
Short Description	Structure for Selection of a PO Item

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	*
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	Header data for order item (EKKO for EKPO)
5	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
6	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
7	PO_STATU	☐	ESTAK	ESTAK	CHAR	1	0	Status of Purchasing Document
8	PO_AEDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
9	BEDAT	☐	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
10	PO_BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
11	PO_BSTYP	☐	EBSTYP	EBSTYP	CHAR	1	0	Purchasing Document Category
12	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	T161
13	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
14	PO_LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
15	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
16	PINCR	☐	PINCR	PINCR	NUMC	5	0	Item Number Interval
17	LPONR	☐	LPONR	EBELP	NUMC	5	0	Last Item Number	EKPO
18	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
19	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
20	ZBD1T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
21	ZBD2T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
22	ZBD3T	☐	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
23	ZBD1P	☐	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
24	ZBD2P	☐	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
25	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
26	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
27	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
28	WKURS	☐	WKURS	KURSP	DEC	9	5	Exchange Rate
29	KUFIX	☐	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
30	KDATB	☐	KDATB	DATUM	DATS	8	0	Start of Validity Period
31	KDATE	☐	KDATE	DATUM	DATS	8	0	End of Validity Period
32	BWBDT	☐	BWBDT	DATUM	DATS	8	0	Closing Date for Applications
33	ANGDT	☐	ANGAB	DATUM	DATS	8	0	Deadline for Submission of Bid/Quotation
34	BNDDT	☐	EBNDT	DATUM	DATS	8	0	Binding Period for Quotation
35	GWLDT	☐	MM_GWLDT	DATUM	DATS	8	0	Warranty Date
36	AUSNR	☐	AUSCH	EBELN	CHAR	10	0	Bid invitation number	EKKO
37	ANGNR	☐	ANGNR	ANGNR	CHAR	10	0	Quotation Number
38	IHRAN	☐	IHRAN	DATUM	DATS	8	0	Quotation Submission Date
39	IHREZ	☐	IHREZ	TEXT12	CHAR	12	0	Your Reference
40	VERKF	☐	EVERK	TEXT30	CHAR	30	0	Responsible Salesperson at Vendor's Office
41	TELF1	☐	TELF0	TEXT16	CHAR	16	0	Vendor's Telephone Number
42	LLIEF	☐	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	LFA1
43	PO_KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
44	PO_KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
45	ABGRU	☐	ABDUM	CHAR2	CHAR	2	0	Field Not Used
46	AUTLF	☐	KMPLF	XFELD	CHAR	1	0	Complete Delivery Stipulated for Each Purchase Order
47	WEAKT	☐	WEAKT	XFELD	CHAR	1	0	Indicator: Goods Receipt Message
48	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
49	LBLIF	☐	LBLIF	LIFNR	CHAR	10	0	Field not used	LFA1
50	PO_INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
51	PO_INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
52	KTWRT	☐	KTWRT	WERT15	CURR	15	2	Target Value for Header Area per Distribution
53	SUBMI	☐	SUBMI	CHAR10	CHAR	10	0	Collective Number
54	KNUMV	☐	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
55	KALSM	☐	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
56	PO_STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
57	LIFRE	☐	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	LFA1
58	EXNUM	☐	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
59	UNSEZ	☐	UNSEZ	TEXT12	CHAR	12	0	Our Reference
60	LOGSY	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
61	UPINC	☐	UPINC	PINCR	NUMC	5	0	Item Number Interval for Subitems
62	STAKO	☐	STAKO	XFELD	CHAR	1	0	Document with time-dependent conditions
63	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	T16FG
64	FRGSX	☐	FRGSX	FRGSX	CHAR	2	0	Release Strategy	T16FS
65	FRGKE	☐	FRGKE	FRGKE	CHAR	1	0	Release Indicator: Purchasing Document	T16FB
66	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
67	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
68	LANDS	☐	LAND1_STML	LAND1	CHAR	3	0	Country for Tax Return	T005
69	LPHIS	☐	LPHIS	XFELD	CHAR	1	0	Indicator for scheduling agreement release documentation
70	PO_ADRNR	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
71	STCEG_L	☐	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number	*
72	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
73	ABSGR	☐	ABSGR	NUMC02	NUMC	2	0	Reason for Cancellation	T165R
74	ADDNR	☐	ADDI_BELNR	ADDI_BELNR	CHAR	10	0	Document number for additional
75	KORNR	☐	KORNR	KORNR	CHAR	1	0	Correction of miscellaneous provisions
76	MEMORY	☐	MEMER	XFELD	CHAR	1	0	Purchase order not yet complete
77	.INCLUDE	☐				0	0	Purchasing Document Item: Data Part
78	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
79	STATU	☐	ASTAT	ASTAT	CHAR	1	0	RFQ status
80	AEDAT	☐	PAEDT	DATUM	DATS	8	0	Purchasing Document Item Change Date
81	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
82	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
83	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	MARA
84	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
85	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
86	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
87	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
88	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
89	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
90	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
91	KTMNG	☐	KTMNG	MENGE	QUAN	13	3	Target Quantity
92	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
93	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
94	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
95	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
96	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
97	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
98	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
99	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
100	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
101	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
102	BRTWR	☐	BBWERT	WERT7	CURR	13	2	Gross order value in PO currency
103	AGDAT	☐	ANGAB	DATUM	DATS	8	0	Deadline for Submission of Bid/Quotation
104	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
105	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
106	BONUS	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
107	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
108	SPINF	☐	SPINF	SPINF	CHAR	1	0	Indicator: Update Info Record
109	PRSDR	☐	PRSDR	XFELD	CHAR	1	0	Price Printout
110	SCHPR	☐	SCHPR	XFELD	CHAR	1	0	Indicator: Estimated Price
111	MAHNZ	☐	MAHNZ	PACK2	DEC	3	0	Number of Reminders/Expediters
112	MAHN1	☐	MAHN1	MAHNT	DEC	3	0	Number of Days for First Reminder/Expediter
113	MAHN2	☐	MAHN2	MAHNT	DEC	3	0	Number of Days for Second Reminder/Expediter
114	MAHN3	☐	MAHN3	MAHNT	DEC	3	0	Number of Days for Third Reminder/Expediter
115	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
116	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
117	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
118	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
119	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
120	ABSKZ	☐	ABSKZ	XFELD	CHAR	1	0	Rejection Indicator
121	AGMEM	☐	AGMEM	AGMEM	CHAR	3	0	Internal Comment on Quotation	TMAM
122	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
123	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
124	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
125	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
126	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
127	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
128	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
129	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
130	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
131	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
132	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
133	KZABS	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
134	LABNR	☐	LABNR	TEXT20	CHAR	20	0	Order Acknowledgment Number
135	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
136	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
137	ABDAT	☐	ABDAT	DATUM	DATS	8	0	Reconciliation date for agreed cumulative quantity
138	ABFTZ	☐	ABFTZ	MENG13	QUAN	13	3	Agreed Cumulative Quantity
139	ETFZ1	☐	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
140	ETFZ2	☐	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)
141	KZSTU	☐	MRPRE	KZFIX	CHAR	1	0	Firm/Trade-Off Zones Binding with Regard to Mat. Planning
142	NOTKZ	☐	NOTKZ	XFELD	CHAR	1	0	Exclusion in Outline Agreement Item with Material Class
143	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
144	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
145	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
146	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
147	ABMNG	☐	NORAM	MENG13	QUAN	13	3	Standard release order quantity
148	PRDAT	☐	PREDT	DATUM	DATS	8	0	Date of Price Determination
149	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
150	EFFWR	☐	EFFWR	WERT7	CURR	13	2	Effective value of item
151	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
152	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	KNA1
153	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	ADRC
154	EKKOL	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
155	SKTOF	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
156	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update	*
157	PLIFZ	☐	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
158	NTGEW	☐	ENTGE	MENG13	QUAN	13	3	Net Weight
159	GEWEI	☐	EGEWE	MEINS	UNIT	3	0	Unit of Weight	T006
160	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
161	ETDRK	☐	ETDRK	ETDRK	CHAR	1	0	Indicator: Print-relevant schedule lines exist
162	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
163	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
164	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
165	INSNC	☐	INSNC	XFELD	CHAR	1	0	Quality inspection indicator cannot be changed
166	SSQSS	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	TQ08
167	ZGTYP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	TQ05
168	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
169	BSTAE	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	T163L
170	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
171	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
172	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
173	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
174	KO_GSBER	☐	GSBER_GP	GSBER	CHAR	4	0	Business area reported to the partner	*
175	KO_PARGB	☐	PARGB_GP	GSBER	CHAR	4	0	assumed business area of the business partner	*
176	KO_PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
177	KO_PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
178	MEPRF	☐	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
179	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
180	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
181	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
182	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
183	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
184	VORAB	☐	VORAB	XFELD	CHAR	1	0	Advance procurement: project stock
185	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
186	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
187	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
188	FPLNR	☐	IPLNR	CHAR10	CHAR	10	0	Invoicing plan number
189	GNETWR	☐	GNETWR	WERT7	CURR	13	2	Currently not used
190	STAPO	☐	STAPO	XFELD	CHAR	1	0	Item is statistical
191	UEBPO	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	EKPO
192	LEWED	☐	LEWED	DATUM	DATS	8	0	Latest Possible Goods Receipt
193	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
194	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
195	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
196	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
197	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type	*
198	HANDOVERLOC	☐	HANDOVER_LOC	HANDOVER_LOC	CHAR	10	0	Location for a physical handover of goods
199	KANBA	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
200	ADRN2	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	ADRC
201	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
202	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
203	EILDT	☐	EILDT	DATUM	DATS	8	0	Start Date for GR-Based Settlement
204	DRDAT	☐	DRDAT	DATUM	DATS	8	0	Last Transmission
205	DRUHR	☐	DRUHR	UZEIT	TIMS	6	0	Time
206	DRUNR	☐	DRUNR	NUMC4	NUMC	4	0	Sequential Number
207	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
208	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
209	ABELP	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table	*
210	ANZPU	☐	ANZPU	MENG13	QUAN	13	3	Number of Points
211	PUNEI	☐	PUNEI	MEINS	UNIT	3	0	Points unit	T006
212	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
213	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
214	EBON2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
215	EBON3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
216	EBONF	☐	EBONY	XFELD	CHAR	1	0	Item Relevant to Subsequent (Period-End Rebate) Settlement
217	MLMAA	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
218	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
219	ANFNR	☐	ANFNR	EBELN	CHAR	10	0	RFQ Number	EKKO
220	ANFPS	☐	ANFPS	EBELP	NUMC	5	0	Item Number of RFQ	EKPO
221	KZKFG	☐	KZCUH	KZCUH	CHAR	1	0	Origin of Configuration
222	USEQU	☐	USEQU	USEQU	CHAR	1	0	Quota arrangement usage	TMQ2
223	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
224	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
225	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
226	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
227	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	TMSI1
228	UPVOR	☐	UPVOR	CHAR1	CHAR	1	0	Subitems Exist
229	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
230	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
231	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
232	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
233	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
234	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
235	SIKGR	☐	SIKGR	SIKGR	CHAR	3	0	Processing key for sub-items	TMSI2
236	MFZHI	☐	MFZHI	MENG15	QUAN	15	3	Maximum Cumulative Material Go-Ahead Quantity
237	FFZHI	☐	FFZHI	MENG15	QUAN	15	3	Maximum Cumulative Production Go-Ahead Quantity
238	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
239	AUREL	☐	AUREL	AUREL	CHAR	1	0	Relevant to Allocation Table
240	BSGRU	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering	TBSG
241	LFRET	☐	LFRET	LFART	CHAR	4	0	Delivery Type for Returns to Vendors	TVLK
242	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	TMFG
243	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
244	J_1BNBM	☐	J_1BNBMCO1	STEUC	CHAR	16	0	Brazilian NCM Code	T604F
245	J_1BMATUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
246	J_1BMATORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
247	J_1BOWNPRO	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
248	J_1BINDUST	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
249	ABUEB	☐	ABUEB	ABUEB	CHAR	4	0	Release Creation Profile	T163P
250	NLABD	☐	NLABD	DATUM	DATS	8	0	Next Forecast Delivery Schedule Transmission
251	NFABD	☐	NFABD	DATUM	DATS	8	0	Next JIT Delivery Schedule Transmission
252	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
253	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
254	FABKZ	☐	FABKZ	FABKZ	CHAR	1	0	Indicator: Item Relevant to JIT Delivery Schedules
255	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
256	J_1AIDATEP	☐	J_1AIDATEP	J_1AUDATEP	DATS	8	0	Last day of the time period where the index value is valid
257	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
258	EGLKZ	☐	EGLKZ	XFELD	CHAR	1	0	"Outward Delivery Completed" Indicator
259	KZTLF	☐	KZTUL	KZTUL	CHAR	1	0	Partial Delivery at Item Level (Stock Transfer)
260	KZFME	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
261	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	RDPR
262	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
263	CHG_SRV	☐	CHG_SRV	XFELD	CHAR	1	0	Configuration changed
264	CHG_FPLNR	☐	CHG_FPLNR	XFELD	CHAR	1	0	No invoice for this item although not free of charge
265	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
266	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
267	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
268	NOVET	☐	NOVET	XFELD	CHAR	1	0	Item blocked for SD delivery
269	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
270	TZONRC	☐	TSEGZONREC	TZNZONE	CHAR	6	0	Time zone of recipient location	*
271	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
272	LEBRE	☐	LEBRE	XFELD	CHAR	1	0	Indicator for Service-Based Invoice Verification
273	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV
274	XCONDITIONS	☐	XCONDITIONS	XCONDITIONS	CHAR	1	0	Conditions for item although no invoice
275	APOMS	☐	APOMS	APOMS	CHAR	1	0	APO as Planning System
276	CCOMP	☐	MMPUR_CCOMP	MMPUR_CCOMP	CHAR	1	0	Posting Logic in the Case of Stock Transfers
277	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
278	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
279	STATUS	☐	EPSTATU	EPSTATU	CHAR	1	0	Status of Purchasing Document Item
280	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	T001L
281	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
282	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
283	WEORA	☐	WEORA	XFELD	CHAR	1	0	Acceptance At Origin
284	SRV_BAS_COM	☐	SRV_BAS_COM	XFELD	CHAR	1	0	Service-Based Commitment
285	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
286	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
287	EMPST	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
288	DIFF_INVOICE	☐	DIFF_INVOICE	DIFF_INVOICE	CHAR	2	0	Differential Invoicing
289	TRMRISK_RELEVANT	☐	PUR_TRM_RISK_RELEVANCY	LOGTRM_RISK_RELEVANCY	CHAR	2	0	Risk Relevancy in Purchasing
290	.INCLUDE	☐				0	0	CRM data for TPOP process
291	SPE_ABGRU	☐	ABGRU	ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
292	SPE_CRM_SO	☐	/SPE/VBELN_CRM	/SPE/VBELN_CRM	CHAR	10	0	CRM Sales Order Number for TPOP Process
293	SPE_CRM_SO_ITEM	☐	/SPE/POSNR_CRM	/SPE/POSNR_CRM	NUMC	6	0	CRM Sales Order Item Number in TPOP Process
294	SPE_CRM_REF_SO	☐	/SPE/REF_VBELN_CRM	/SPE/REF_VBELN_CRM	CHAR	35	0	CRM Reference Order Number for TPOP Process
295	SPE_CRM_REF_ITEM	☐	/SPE/REF_POSNR_CRM	/SPE/REF_POSNR_CRM	CHAR	6	0	CRM Reference Sales Order Item Number in TPOP Process
296	SPE_CRM_FKREL	☐	/SPE/FKREL_CRM	FKREL	CHAR	1	0	Billing Relevance CRM
297	SPE_CHNG_SYS	☐	/SPE/INB_CHNG_SYS	/SPE/SYSTYPE_SHORT	CHAR	1	0	Last Changer's System Type
298	SPE_INSMK_SRC	☐	/SPE/INSMK_SRC	INSMK	CHAR	1	0	Stock Type of Source Storage Location in STO
299	SPE_CQ_CTRLTYPE	☐	/SPE/CQ_CONTROL_TYPE	/SPE/CQ_CONTROL_TYPE	CHAR	1	0	CQ Control Type
300	SPE_CQ_NOCQ	☐	/SPE/CQ_NOCQ	XFELD	CHAR	1	0	No Transmission of Cumulative Quantities in SA Release
301	REASON_CODE	☐	/SAPPSPRO/_GR_REASON_CODE	/SAPPSPRO/_GR_REASON_CODE	CHAR	4	0	Goods Receipt Reason Code
302	CQU_SAR	☐	CQU_SAR	MENG15	QUAN	15	3	Cumulative Goods Receipts from Redirected Purchase Orders
303	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
304	SPE_EWM_DTC	☐	/SPE/EWM_DTC	XFELD	CHAR	1	0	EWM Delivery Based Tolerance Check
305	.INCLUDE	☐				0	0	SRM Fields in Purchase Order Item
306	EXLIN	☐	EXLIN	EXLIN	CHAR	40	0	Item Number Length
307	EXSNR	☐	EXSNR	EXSNR	NUMC	5	0	External Sorting
308	EHTYP	☐	EHTYP	EHTYP	CHAR	4	0	External Hierarchy Category	TMSRM_EHTYP
309	RETPC	☐	RETPZ	PRZ32	DEC	5	2	Retention in Percent
310	DPTYP	☐	ME_DPTYP	ME_DPTYPE_DOMAIN	CHAR	4	0	Down Payment Indicator
311	DPPCT	☐	ME_DPPCNT	PRZ32	DEC	5	2	Down Payment Percentage
312	DPAMT	☐	ME_DPAMNT	WERT11	CURR	11	2	Down Payment Amount in Document Currency
313	DPDAT	☐	ME_DPDDAT	DATS	DATS	8	0	Due Date for Down Payment
314	FLS_RSTO	☐	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
315	EXT_RFX_NUMBER	☐	ME_PUR_EXT_DOC_ID	ME_EXT_DOC_ID	CHAR	35	0	Document Number of External Document
316	EXT_RFX_ITEM	☐	ME_PUR_EXT_DOC_ITEM_ID	ME_EXT_DOC_ITEM_ID	CHAR	10	0	Item Number of External Document
317	EXT_RFX_SYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System	*
318	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
319	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
320	BLK_REASON_ID	☐	BLK_REASON_ID	BLK_REASON_ID	CHAR	4	0	Blocking Reason - ID
321	BLK_REASON_TXT	☐	BLK_REASON_TXT	BLK_REASON_TXT	CHAR	40	0	Blocking Reason - Text
322	ITCONS	☐	ME_IR_CO_ORDER	XFELD	CHAR	1	0	Real-Time Consumption Posting of Subcontracting Components
323	FIXMG	☐	ME_FIXMG	ME_FIXMG	CHAR	1	0	Delivery Date and Quantity Fixed
324	WABWE	☐	WABWE	XFELD	CHAR	1	0	Indicator for GI-based goods receipt
325	.INCLUDE	☐				0	0	MM Tax Code determination
326	TC_AUT_DET	☐	J_1BTC_AUT_DET	MWSKZ	CHAR	2	0	Tax Code Automatically Determined	*
327	MANUAL_TC_REASON	☐	J_1BMANUAL_TC_REASON	J_1BMANUAL_TC_REASON	CHAR	2	0	Manual Tax Code Reason	*
328	FISCAL_INCENTIVE	☐	J_1BFISCAL_INCENTIVE_CODE	J_1BFISCAL_INCENTIVE_CODE	CHAR	4	0	Tax Incentive Type	*
329	TAX_SUBJECT_ST	☐	J_1BTC_TAX_SUBJECT_ST	J_1BYES_NO	CHAR	1	0	Tax Subject to Substituição Tributária
330	FISCAL_INCENTIVE_ID	☐	J_1BFISCAL_INCENTIVE_ID	J_1BFISCAL_INCENTIVE_ID	CHAR	4	0	Incentive ID	*
331	.INCLU--AP	☐				0	0	Empties Managment: EKPODATA Enhancement
332	/BEV1/NEGEN_ITEM	☐	/BEV1/NEGEN_ITEM_FLAG	XFELD	CHAR	1	0	Indicator: Item Is Generated
333	/BEV1/NEDEPFREE	☐	/BEV1/NEDEPFREE	XFELD	CHAR	1	0	Indicator: Dependent Items Are Free of Charge
334	/BEV1/NESTRUCCAT	☐	/BEV1/NESTRUC_CAT	/BEV1/NESTRUC_CAT	CHAR	1	0	Structure Category for Material Relationship
335	.INCLU--AP	☐				0	0	Append to EKPO for DFPS
336	ADVCODE	☐	/ISDFPS/ADVCODE	/ISDFPS/ADVCODE	CHAR	2	0	Advice Code	*
337	.INCLU--AP	☐				0	0	Budget Period
338	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
339	.INCLU--AP	☐				0	0	Add on for Public Sector
340	EXCPE	☐	EXCPE	NUM02	NUMC	2	0	Acceptance Period
341	.INCLU--AP	☐				0	0	IUID Append
342	IUID_RELEVANT	☐	IUID_RELEVANT	UID_RELEVANT	CHAR	1	0	IUID-Relevant
343	.INCLU--AP	☐				0	0	Addition of Fields to EKPODAT -Retail Localization for India
344	.INCLUDE	☐				0	0	Additional Filed for Retail Localization for India
345	MRPIND	☐	J_1IRMRPIND	J_1IRMRPIND	CHAR	1	0	Max. Retail Price Relevant
346	.INCLUDE	☐				0	0
347	EINDT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
348	SLFDT	☐	SLFDT	DATUM	DATS	8	0	Statistics-Relevant Delivery Date
349	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	TPRG
350	MATXT	☐	MAKTX	TEXT40	CHAR	40	0	Material description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	EXPD_EKPO_LINE	ABELN	AUKO	ABELN	KEY	1	N
2	EXPD_EKPO_LINE	ABSGR	T165R	ABSGR		1	N
3	EXPD_EKPO_LINE	ABUEB	T163P	ABUEB
4	EXPD_EKPO_LINE	ADRN2	ADRC	ADDRNUMBER
5	EXPD_EKPO_LINE	ADRNR	ADRC	ADDRNUMBER	KEY	1	CN
6	EXPD_EKPO_LINE	AGMEM	TMAM	AGMEM	REF	C	CN
7	EXPD_EKPO_LINE	AKTNR	WAKH	AKTNR	KEY	1	N
8	EXPD_EKPO_LINE	ANFNR	EKKO	EBELN	REF	1	N
9	EXPD_EKPO_LINE	ANFPS	EKPO	EBELP	REF	1	N
10	EXPD_EKPO_LINE	AUSNR	EKKO	EBELN		1	N
11	EXPD_EKPO_LINE	BERID	MDLV	BERID	REF	1	CN
12	EXPD_EKPO_LINE	BNFPO	EBAN	BNFPO	REF	1	N
13	EXPD_EKPO_LINE	BPRME	T006	MSEHI	REF	1	N
14	EXPD_EKPO_LINE	BSART	T161	BSART		1	N
15	EXPD_EKPO_LINE	BSGRU	TBSG	BSGRU	REF	1	N
16	EXPD_EKPO_LINE	BSTAE	T163L	BSTAE	KEY	1	N
17	EXPD_EKPO_LINE	BUKRS	T001	BUKRS	REF	1	N
18	EXPD_EKPO_LINE	BWTAR	T149D	BWTAR	REF	1	N
19	EXPD_EKPO_LINE	BWTTY	T149C	BWTTY	REF	1	N
20	EXPD_EKPO_LINE	EBELN	EKKO	EBELN		1	N
21	EXPD_EKPO_LINE	EHTYP	TMSRM_EHTYP	EHTYP
22	EXPD_EKPO_LINE	EKGRP	T024	EKGRP		1	N
23	EXPD_EKPO_LINE	EKORG	T024E	EKORG		1	N
24	EXPD_EKPO_LINE	EMATN	MARA	MATNR	REF	1	N
25	EXPD_EKPO_LINE	EMLIF	LFA1	LIFNR	KEY	1	N
26	EXPD_EKPO_LINE	EVERS	T027A	EVERS	REF	1	N
27	EXPD_EKPO_LINE	EXNUM	EIKP	EXNUM		1	N
28	EXPD_EKPO_LINE	FIPOS	FMFPO	FIPOS	REF	C	CN
29	EXPD_EKPO_LINE	FRGGR	T16FG	FRGGR		1	N
30	EXPD_EKPO_LINE	FRGKE	T16FB	FRGKE		1	N
31	EXPD_EKPO_LINE	FRGSX	T16FS	FRGSX		1	N
32	EXPD_EKPO_LINE	GEWEI	T006	MSEHI	REF	1	N
33	EXPD_EKPO_LINE	INCO1	TINC	INCO1	REF	1	N
34	EXPD_EKPO_LINE	INFNR	EINA	INFNR	REF	1	N
35	EXPD_EKPO_LINE	J_1AINDXP	J_1AINFT20	J_1AINDX	KEY	1	CN
36	EXPD_EKPO_LINE	J_1BNBM	T604F	STEUC	KEY	1	CN
37	EXPD_EKPO_LINE	KALSM	T683	KALSM		1	N
38	EXPD_EKPO_LINE	KNTTP	T163K	KNTTP	REF	1	N
39	EXPD_EKPO_LINE	KOLIF	LFA1	LIFNR	REF	1	CN
40	EXPD_EKPO_LINE	KONNR	EKKO	EBELN	REF	1	N
41	EXPD_EKPO_LINE	KO_PPRCTR	CEPC	PRCTR	REF	1	CN
42	EXPD_EKPO_LINE	KO_PRCTR	CEPC	PRCTR	REF	1	CN
43	EXPD_EKPO_LINE	KTPNR	EKPO	EBELP	REF	1	N
44	EXPD_EKPO_LINE	KUNNR	KNA1	KUNNR	REF	1	N
45	EXPD_EKPO_LINE	LANDS	T005	LAND1		1	N
46	EXPD_EKPO_LINE	LBLIF	LFA1	LIFNR		1	N
47	EXPD_EKPO_LINE	LFRET	TVLK	LFART	REF	1	CN
48	EXPD_EKPO_LINE	LGORT	T001L	LGORT	REF	1	N
49	EXPD_EKPO_LINE	LIFNR	LFA1	LIFNR		1	N
50	EXPD_EKPO_LINE	LIFRE	LFA1	LIFNR		1	N
51	EXPD_EKPO_LINE	LLIEF	LFA1	LIFNR		1	N
52	EXPD_EKPO_LINE	LMEIN	T006	MSEHI	REF	1	N
53	EXPD_EKPO_LINE	LPEIN	TPRG	PRGBZ		1	N
54	EXPD_EKPO_LINE	LPONR	EKPO	EBELP		1	N
55	EXPD_EKPO_LINE	LTSNR	WYT1	LTSNR	KEY	1	N
56	EXPD_EKPO_LINE	MATKL	T023	MATKL	REF	1	N
57	EXPD_EKPO_LINE	MATNR	MARA	MATNR	REF	1	N
58	EXPD_EKPO_LINE	MEINS	T006	MSEHI	REF	1	N
59	EXPD_EKPO_LINE	MFRGR	TMFG	MFRGR	REF	1	CN
60	EXPD_EKPO_LINE	MFRNR	LFA1	LIFNR	REF	1	N
61	EXPD_EKPO_LINE	MTART	T134	MTART
62	EXPD_EKPO_LINE	MWSKZ	T007A	MWSKZ	KEY	1	CN
63	EXPD_EKPO_LINE	PACKNO	ESLH	PACKNO	KEY	1	N
64	EXPD_EKPO_LINE	PO_BUKRS	T001	BUKRS		1	N
65	EXPD_EKPO_LINE	PO_INCO1	TINC	INCO1		1	N
66	EXPD_EKPO_LINE	PO_KONNR	EKKO	EBELN		1	N
67	EXPD_EKPO_LINE	PO_KUNNR	KNA1	KUNNR		1	N
68	EXPD_EKPO_LINE	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
69	EXPD_EKPO_LINE	PRIO_URG	PURG	PRIO_URG	REF	1	CN
70	EXPD_EKPO_LINE	PSTYP	T163	PSTYP	REF	1	N
71	EXPD_EKPO_LINE	PUNEI	T006	MSEHI	KEY	1	N
72	EXPD_EKPO_LINE	RDPRF	RDPR	RDPRF	REF	1	N
73	EXPD_EKPO_LINE	RESLO	T001L	LGORT
74	EXPD_EKPO_LINE	RESWK	T001W	WERKS		1	N
75	EXPD_EKPO_LINE	SAISO	T6WSP	SAISO	KEY	1	N
76	EXPD_EKPO_LINE	SATNR	MARA	MATNR	REF	1	N
77	EXPD_EKPO_LINE	SIKGR	TMSI2	SIKGR	REF	1	N
78	EXPD_EKPO_LINE	SOBKZ	T148	SOBKZ	REF	1	N
79	EXPD_EKPO_LINE	SPRAS	T002	SPRAS		1	N
80	EXPD_EKPO_LINE	SSQSS	TQ08	QM_PUR	KEY	1	N
81	EXPD_EKPO_LINE	TXJCD	TTXJ	TXJCD	REF	1	CN
82	EXPD_EKPO_LINE	UEBPO	EKPO	EBELP
83	EXPD_EKPO_LINE	UPTYP	TMSI1	UPTYP	REF	1	N
84	EXPD_EKPO_LINE	USEQU	TMQ2	USEQU	KEY	1	N
85	EXPD_EKPO_LINE	VOLEH	T006	MSEHI	REF	1	N
86	EXPD_EKPO_LINE	WAERS	TCURC	WAERS		1	N
87	EXPD_EKPO_LINE	WERKS	T001W	WERKS	REF	1	N
88	EXPD_EKPO_LINE	ZGTYP	TQ05	ZGTYP	KEY	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in	46C