SAP ABAP Table MGV_EKPO (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	MGV_EKPO	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	EKKO
3	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
4	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
5	STATU	☐	ASTAT	ASTAT	CHAR	1	0	RFQ status
6	AEDAT	☐	PAEDT	DATUM	DATS	8	0	Purchasing Document Item Change Date
7	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
8	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
9	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	MARA
10	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
11	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
12	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
13	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
14	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
15	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
16	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
17	KTMNG	☐	KTMNG	MENGE	QUAN	13	3	Target Quantity
18	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
19	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
20	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
21	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
22	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
23	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
24	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
25	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
26	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
27	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
28	BRTWR	☐	BBWERT	WERT7	CURR	13	2	Gross order value in PO currency
29	AGDAT	☐	ANGAB	DATUM	DATS	8	0	Deadline for Submission of Bid/Quotation
30	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
31	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
32	BONUS	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
33	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
34	SPINF	☐	SPINF	SPINF	CHAR	1	0	Indicator: Update Info Record
35	PRSDR	☐	PRSDR	XFELD	CHAR	1	0	Price Printout
36	SCHPR	☐	SCHPR	XFELD	CHAR	1	0	Indicator: Estimated Price
37	MAHNZ	☐	MAHNZ	PACK2	DEC	3	0	Number of Reminders/Expediters
38	MAHN1	☐	MAHN1	MAHNT	DEC	3	0	Number of Days for First Reminder/Expediter
39	MAHN2	☐	MAHN2	MAHNT	DEC	3	0	Number of Days for Second Reminder/Expediter
40	MAHN3	☐	MAHN3	MAHNT	DEC	3	0	Number of Days for Third Reminder/Expediter
41	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
42	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
43	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
44	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
45	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
46	ABSKZ	☐	ABSKZ	XFELD	CHAR	1	0	Rejection Indicator
47	AGMEM	☐	AGMEM	AGMEM	CHAR	3	0	Internal Comment on Quotation	TMAM
48	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
49	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
50	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
51	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
52	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
53	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
54	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
55	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
56	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
57	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
58	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
59	KZABS	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
60	LABNR	☐	LABNR	TEXT20	CHAR	20	0	Order Acknowledgment Number
61	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
62	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
63	ABDAT	☐	ABDAT	DATUM	DATS	8	0	Reconciliation date for agreed cumulative quantity
64	ABFTZ	☐	ABFTZ	MENG13	QUAN	13	3	Agreed Cumulative Quantity
65	ETFZ1	☐	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
66	ETFZ2	☐	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)
67	KZSTU	☐	MRPRE	KZFIX	CHAR	1	0	Firm/Trade-Off Zones Binding with Regard to Mat. Planning
68	NOTKZ	☐	NOTKZ	XFELD	CHAR	1	0	Exclusion in Outline Agreement Item with Material Class
69	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
70	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
71	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
72	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
73	ABMNG	☐	NORAM	MENG13	QUAN	13	3	Standard release order quantity
74	PRDAT	☐	PREDT	DATUM	DATS	8	0	Date of Price Determination
75	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
76	EFFWR	☐	EFFWR	WERT7	CURR	13	2	Effective value of item
77	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
78	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	KNA1
79	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	ADRC
80	EKKOL	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
81	SKTOF	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
82	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
83	PLIFZ	☐	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
84	NTGEW	☐	ENTGE	MENG13	QUAN	13	3	Net Weight
85	GEWEI	☐	EGEWE	MEINS	UNIT	3	0	Unit of Weight	T006
86	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
87	ETDRK	☐	ETDRK	ETDRK	CHAR	1	0	Indicator: Print-relevant schedule lines exist
88	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
89	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
90	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
91	INSNC	☐	INSNC	XFELD	CHAR	1	0	Quality inspection indicator cannot be changed
92	SSQSS	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	TQ08
93	ZGTYP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	TQ05
94	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
95	BSTAE	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	T163L
96	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
97	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
98	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center
99	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
100	KO_GSBER	☐	GSBER_GP	GSBER	CHAR	4	0	Business area reported to the partner
101	KO_PARGB	☐	PARGB_GP	GSBER	CHAR	4	0	assumed business area of the business partner
102	KO_PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
103	KO_PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
104	MEPRF	☐	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
105	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
106	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
107	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
108	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
109	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
110	VORAB	☐	VORAB	XFELD	CHAR	1	0	Advance procurement: project stock
111	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
112	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
113	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
114	FPLNR	☐	IPLNR	CHAR10	CHAR	10	0	Invoicing plan number
115	GNETWR	☐	GNETWR	WERT7	CURR	13	2	Currently not used
116	STAPO	☐	STAPO	XFELD	CHAR	1	0	Item is statistical
117	UEBPO	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	EKPO
118	LEWED	☐	LEWED	DATUM	DATS	8	0	Latest Possible Goods Receipt
119	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
120	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
121	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
122	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
123	VSART	☐	VERSART	VERSART	CHAR	2	0	Shipping type
124	HANDOVERLOC	☐	HANDOVER_LOC	HANDOVER_LOC	CHAR	10	0	Location for a physical handover of goods
125	KANBA	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
126	ADRN2	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	ADRC
127	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
128	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
129	EILDT	☐	EILDT	DATUM	DATS	8	0	Start Date for GR-Based Settlement
130	DRDAT	☐	DRDAT	DATUM	DATS	8	0	Last Transmission
131	DRUHR	☐	DRUHR	UZEIT	TIMS	6	0	Time
132	DRUNR	☐	DRUNR	NUMC4	NUMC	4	0	Sequential Number
133	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
134	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
135	ABELP	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table
136	ANZPU	☐	ANZPU	MENG13	QUAN	13	3	Number of Points
137	PUNEI	☐	PUNEI	MEINS	UNIT	3	0	Points unit	T006
138	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
139	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
140	EBON2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
141	EBON3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
142	EBONF	☐	EBONY	XFELD	CHAR	1	0	Item Relevant to Subsequent (Period-End Rebate) Settlement
143	MLMAA	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
144	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
145	ANFNR	☐	ANFNR	EBELN	CHAR	10	0	RFQ Number	EKKO
146	ANFPS	☐	ANFPS	EBELP	NUMC	5	0	Item Number of RFQ	EKPO
147	KZKFG	☐	KZCUH	KZCUH	CHAR	1	0	Origin of Configuration
148	USEQU	☐	USEQU	USEQU	CHAR	1	0	Quota arrangement usage	TMQ2
149	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer
150	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
151	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
152	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
153	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	TMSI1
154	UPVOR	☐	UPVOR	CHAR1	CHAR	1	0	Subitems Exist
155	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
156	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
157	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
158	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
159	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
160	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
161	SIKGR	☐	SIKGR	SIKGR	CHAR	3	0	Processing key for sub-items	TMSI2
162	MFZHI	☐	MFZHI	MENG15	QUAN	15	3	Maximum Cumulative Material Go-Ahead Quantity
163	FFZHI	☐	FFZHI	MENG15	QUAN	15	3	Maximum Cumulative Production Go-Ahead Quantity
164	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
165	AUREL	☐	AUREL	AUREL	CHAR	1	0	Relevant to Allocation Table
166	BSGRU	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering	TBSG
167	LFRET	☐	LFRET	LFART	CHAR	4	0	Delivery Type for Returns to Vendors	TVLK
168	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	TMFG
169	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
170	J_1BNBM	☐	J_1BNBMCO1	STEUC	CHAR	16	0	Brazilian NCM Code	T604F
171	J_1BMATUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
172	J_1BMATORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
173	J_1BOWNPRO	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
174	J_1BINDUST	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
175	ABUEB	☐	ABUEB	ABUEB	CHAR	4	0	Release Creation Profile	T163P
176	NLABD	☐	NLABD	DATUM	DATS	8	0	Next Forecast Delivery Schedule Transmission
177	NFABD	☐	NFABD	DATUM	DATS	8	0	Next JIT Delivery Schedule Transmission
178	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
179	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
180	FABKZ	☐	FABKZ	FABKZ	CHAR	1	0	Indicator: Item Relevant to JIT Delivery Schedules
181	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
182	J_1AIDATEP	☐	J_1AIDATEP	J_1AUDATEP	DATS	8	0	Last day of the time period where the index value is valid
183	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile
184	EGLKZ	☐	EGLKZ	XFELD	CHAR	1	0	"Outward Delivery Completed" Indicator
185	KZTLF	☐	KZTUL	KZTUL	CHAR	1	0	Partial Delivery at Item Level (Stock Transfer)
186	KZFME	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
187	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	RDPR
188	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
189	CHG_SRV	☐	CHG_SRV	XFELD	CHAR	1	0	Configuration changed
190	CHG_FPLNR	☐	CHG_FPLNR	XFELD	CHAR	1	0	No invoice for this item although not free of charge
191	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
192	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
193	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
194	NOVET	☐	NOVET	XFELD	CHAR	1	0	Item blocked for SD delivery
195	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
196	TZONRC	☐	TSEGZONREC	TZNZONE	CHAR	6	0	Time zone of recipient location
197	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
198	LEBRE	☐	LEBRE	XFELD	CHAR	1	0	Indicator for Service-Based Invoice Verification
199	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV
200	XCONDITIONS	☐	XCONDITIONS	XCONDITIONS	CHAR	1	0	Conditions for item although no invoice
201	APOMS	☐	APOMS	APOMS	CHAR	1	0	APO as Planning System
202	CCOMP	☐	MMPUR_CCOMP	MMPUR_CCOMP	CHAR	1	0	Posting Logic in the Case of Stock Transfers
203	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
204	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area
205	STATUS	☐	EPSTATU	EPSTATU	CHAR	1	0	Status of Purchasing Document Item
206	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	T001L
207	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds
208	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item
209	WEORA	☐	WEORA	XFELD	CHAR	1	0	Acceptance At Origin
210	SRV_BAS_COM	☐	SRV_BAS_COM	XFELD	CHAR	1	0	Service-Based Commitment
211	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
212	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
213	EMPST	☐	EMPST	TEXT25	CHAR	25	0	Receiving point
214	DIFF_INVOICE	☐	DIFF_INVOICE	DIFF_INVOICE	CHAR	2	0	Differential Invoicing
215	TRMRISK_RELEVANT	☐	PUR_TRM_RISK_RELEVANCY	LOGTRM_RISK_RELEVANCY	CHAR	2	0	Risk Relevancy in Purchasing
216	SPE_ABGRU	☐	ABGRU	ABGRU	CHAR	2	0	Reason for rejection of quotations and sales orders
217	SPE_CRM_SO	☐	/SPE/VBELN_CRM	/SPE/VBELN_CRM	CHAR	10	0	CRM Sales Order Number for TPOP Process
218	SPE_CRM_SO_ITEM	☐	/SPE/POSNR_CRM	/SPE/POSNR_CRM	NUMC	6	0	CRM Sales Order Item Number in TPOP Process
219	SPE_CRM_REF_SO	☐	/SPE/REF_VBELN_CRM	/SPE/REF_VBELN_CRM	CHAR	35	0	CRM Reference Order Number for TPOP Process
220	SPE_CRM_REF_ITEM	☐	/SPE/REF_POSNR_CRM	/SPE/REF_POSNR_CRM	CHAR	6	0	CRM Reference Sales Order Item Number in TPOP Process
221	SPE_CRM_FKREL	☐	/SPE/FKREL_CRM	FKREL	CHAR	1	0	Billing Relevance CRM
222	SPE_CHNG_SYS	☐	/SPE/INB_CHNG_SYS	/SPE/SYSTYPE_SHORT	CHAR	1	0	Last Changer's System Type
223	SPE_INSMK_SRC	☐	/SPE/INSMK_SRC	INSMK	CHAR	1	0	Stock Type of Source Storage Location in STO
224	SPE_CQ_CTRLTYPE	☐	/SPE/CQ_CONTROL_TYPE	/SPE/CQ_CONTROL_TYPE	CHAR	1	0	CQ Control Type
225	SPE_CQ_NOCQ	☐	/SPE/CQ_NOCQ	XFELD	CHAR	1	0	No Transmission of Cumulative Quantities in SA Release
226	REASON_CODE	☐	/SAPPSPRO/_GR_REASON_CODE	/SAPPSPRO/_GR_REASON_CODE	CHAR	4	0	Goods Receipt Reason Code
227	CQU_SAR	☐	CQU_SAR	MENG15	QUAN	15	3	Cumulative Goods Receipts from Redirected Purchase Orders
228	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
229	SPE_EWM_DTC	☐	/SPE/EWM_DTC	XFELD	CHAR	1	0	EWM Delivery Based Tolerance Check
230	EXLIN	☐	EXLIN	EXLIN	CHAR	40	0	Item Number Length
231	EXSNR	☐	EXSNR	EXSNR	NUMC	5	0	External Sorting
232	EHTYP	☐	EHTYP	EHTYP	CHAR	4	0	External Hierarchy Category	TMSRM_EHTYP
233	RETPC	☐	RETPZ	PRZ32	DEC	5	2	Retention in Percent
234	DPTYP	☐	ME_DPTYP	ME_DPTYPE_DOMAIN	CHAR	4	0	Down Payment Indicator
235	DPPCT	☐	ME_DPPCNT	PRZ32	DEC	5	2	Down Payment Percentage
236	DPAMT	☐	ME_DPAMNT	WERT11	CURR	11	2	Down Payment Amount in Document Currency
237	DPDAT	☐	ME_DPDDAT	DATS	DATS	8	0	Due Date for Down Payment
238	FLS_RSTO	☐	FLS_RSTO	XFELD	CHAR	1	0	Store Return with Inbound and Outbound Delivery
239	EXT_RFX_NUMBER	☐	ME_PUR_EXT_DOC_ID	ME_EXT_DOC_ID	CHAR	35	0	Document Number of External Document
240	EXT_RFX_ITEM	☐	ME_PUR_EXT_DOC_ITEM_ID	ME_EXT_DOC_ITEM_ID	CHAR	10	0	Item Number of External Document
241	EXT_RFX_SYSTEM	☐	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System
242	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
243	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
244	BLK_REASON_ID	☐	BLK_REASON_ID	BLK_REASON_ID	CHAR	4	0	Blocking Reason - ID
245	BLK_REASON_TXT	☐	BLK_REASON_TXT	BLK_REASON_TXT	CHAR	40	0	Blocking Reason - Text
246	ITCONS	☐	ME_IR_CO_ORDER	XFELD	CHAR	1	0	Real-Time Consumption Posting of Subcontracting Components
247	FIXMG	☐	ME_FIXMG	ME_FIXMG	CHAR	1	0	Delivery Date and Quantity Fixed
248	WABWE	☐	WABWE	XFELD	CHAR	1	0	Indicator for GI-based goods receipt
249	TC_AUT_DET	☐	J_1BTC_AUT_DET	MWSKZ	CHAR	2	0	Tax Code Automatically Determined
250	MANUAL_TC_REASON	☐	J_1BMANUAL_TC_REASON	J_1BMANUAL_TC_REASON	CHAR	2	0	Manual Tax Code Reason
251	FISCAL_INCENTIVE	☐	J_1BFISCAL_INCENTIVE_CODE	J_1BFISCAL_INCENTIVE_CODE	CHAR	4	0	Tax Incentive Type
252	TAX_SUBJECT_ST	☐	J_1BTC_TAX_SUBJECT_ST	J_1BYES_NO	CHAR	1	0	Tax Subject to Substituição Tributária
253	FISCAL_INCENTIVE_ID	☐	J_1BFISCAL_INCENTIVE_ID	J_1BFISCAL_INCENTIVE_ID	CHAR	4	0	Incentive ID
254	/BEV1/NEGEN_ITEM	☐	/BEV1/NEGEN_ITEM_FLAG	XFELD	CHAR	1	0	Indicator: Item Is Generated
255	/BEV1/NEDEPFREE	☐	/BEV1/NEDEPFREE	XFELD	CHAR	1	0	Indicator: Dependent Items Are Free of Charge
256	/BEV1/NESTRUCCAT	☐	/BEV1/NESTRUC_CAT	/BEV1/NESTRUC_CAT	CHAR	1	0	Structure Category for Material Relationship
257	ADVCODE	☐	/ISDFPS/ADVCODE	/ISDFPS/ADVCODE	CHAR	2	0	Advice Code
258	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period
259	EXCPE	☐	EXCPE	NUM02	NUMC	2	0	Acceptance Period
260	IUID_RELEVANT	☐	IUID_RELEVANT	UID_RELEVANT	CHAR	1	0	IUID-Relevant
261	MRPIND	☐	J_1IRMRPIND	J_1IRMRPIND	CHAR	1	0	Max. Retail Price Relevant
262	REFSITE	☐	WREFSITE	WERKS_W	CHAR	4	0	Reference Site For Purchasing
263	REF_ITEM	☐	WRF_PSCD_REF_ITEM	EBELP	NUMC	5	0	Reference Item for Remaining Qty Cancellation
264	SOURCE_ID	☐	WRF_POHF_SOURCE_ID	WRF_POHF_SOURCE_ID	CHAR	3	0	Origin Profile	WRFT_POHF_SOURCE
265	SOURCE_KEY	☐	WRF_POHF_SOURCE_KEY	WRF_POHF_SOURCE_KEY	CHAR	32	0	Key in Source System
266	PUT_BACK	☐	WRF_POHF_PUT_BACK_POG	XFELD	CHAR	1	0	Indicator for Putting Back from Grouped PO Document
267	POL_ID	☐	WRF_POHF_POL_ID	WRF_POHF_POL_ID	CHAR	10	0	Order List Item Number
268	CONS_ORDER	☐	WRF_CONS_ORDER	WRF_CONS_ORDER	CHAR	1	0	Purchase Order for Consignment
269	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
270	MATNR_VERS	☐	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MGV_EKPO	ABELN	AUKO	ABELN	KEY	1	N
2	MGV_EKPO	ABUEB	T163P	ABUEB
3	MGV_EKPO	ADRN2	ADRC	ADDRNUMBER
4	MGV_EKPO	ADRNR	ADRC	ADDRNUMBER	KEY	1	CN
5	MGV_EKPO	AGMEM	TMAM	AGMEM	REF	C	CN
6	MGV_EKPO	AKTNR	WAKH	AKTNR	KEY	1	N
7	MGV_EKPO	ANFNR	EKKO	EBELN	REF	1	N
8	MGV_EKPO	ANFPS	EKPO	EBELP	REF	1	N
9	MGV_EKPO	BERID	MDLV	BERID	REF	1	CN
10	MGV_EKPO	BNFPO	EBAN	BNFPO	REF	1	N
11	MGV_EKPO	BPRME	T006	MSEHI	REF	1	N
12	MGV_EKPO	BSGRU	TBSG	BSGRU	REF	1	N
13	MGV_EKPO	BSTAE	T163L	BSTAE	KEY	1	N
14	MGV_EKPO	BUKRS	T001	BUKRS	REF	1	N
15	MGV_EKPO	BWTAR	T149D	BWTAR	REF	1	N
16	MGV_EKPO	BWTTY	T149C	BWTTY	REF	1	N
17	MGV_EKPO	EBELN	EKKO	EBELN	KEY	1	N
18	MGV_EKPO	EHTYP	TMSRM_EHTYP	EHTYP
19	MGV_EKPO	EMATN	MARA	MATNR	REF	1	N
20	MGV_EKPO	EMLIF	LFA1	LIFNR	KEY	1	N
21	MGV_EKPO	EVERS	T027A	EVERS	REF	1	N
22	MGV_EKPO	FIPOS	FMFPO	FIPOS	REF	C	CN
23	MGV_EKPO	GEWEI	T006	MSEHI	REF	1	N
24	MGV_EKPO	INCO1	TINC	INCO1	REF	1	N
25	MGV_EKPO	INFNR	EINA	INFNR	REF	1	N
26	MGV_EKPO	J_1AINDXP	J_1AINFT20	J_1AINDX	KEY	1	CN
27	MGV_EKPO	J_1BNBM	T604F	STEUC	KEY	1	CN
28	MGV_EKPO	KNTTP	T163K	KNTTP	REF	1	N
29	MGV_EKPO	KOLIF	LFA1	LIFNR	REF	1	CN
30	MGV_EKPO	KONNR	EKKO	EBELN	REF	1	N
31	MGV_EKPO	KO_PPRCTR	CEPC	PRCTR	REF	1	CN
32	MGV_EKPO	KO_PRCTR	CEPC	PRCTR	REF	1	CN
33	MGV_EKPO	KTPNR	EKPO	EBELP	REF	1	N
34	MGV_EKPO	KUNNR	KNA1	KUNNR	REF	1	N
35	MGV_EKPO	LFRET	TVLK	LFART	REF	1	CN
36	MGV_EKPO	LGORT	T001L	LGORT	REF	1	N
37	MGV_EKPO	LMEIN	T006	MSEHI	REF	1	N
38	MGV_EKPO	LTSNR	WYT1	LTSNR	KEY	1	N
39	MGV_EKPO	MANDT	T000	MANDT	KEY	1	N
40	MGV_EKPO	MATKL	T023	MATKL	REF	1	N
41	MGV_EKPO	MATNR	MARA	MATNR	REF	1	N
42	MGV_EKPO	MEINS	T006	MSEHI	REF	1	N
43	MGV_EKPO	MFRGR	TMFG	MFRGR	REF	1	CN
44	MGV_EKPO	MFRNR	LFA1	LIFNR	REF	1	N
45	MGV_EKPO	MTART	T134	MTART
46	MGV_EKPO	MWSKZ	T007A	MWSKZ	KEY	1	CN
47	MGV_EKPO	PACKNO	ESLH	PACKNO	KEY	1	N
48	MGV_EKPO	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
49	MGV_EKPO	PRIO_URG	PURG	PRIO_URG	REF	1	CN
50	MGV_EKPO	PSTYP	T163	PSTYP	REF	1	N
51	MGV_EKPO	PUNEI	T006	MSEHI	KEY	1	N
52	MGV_EKPO	RDPRF	RDPR	RDPRF	REF	1	N
53	MGV_EKPO	RESLO	T001L	LGORT
54	MGV_EKPO	SAISO	T6WSP	SAISO	KEY	1	N
55	MGV_EKPO	SATNR	MARA	MATNR	REF	1	N
56	MGV_EKPO	SIKGR	TMSI2	SIKGR	REF	1	N
57	MGV_EKPO	SOBKZ	T148	SOBKZ	REF	1	N
58	MGV_EKPO	SOURCE_ID	WRFT_POHF_SOURCE	SOURCE_ID
59	MGV_EKPO	SSQSS	TQ08	QM_PUR	KEY	1	N
60	MGV_EKPO	TXJCD	TTXJ	TXJCD	REF	1	CN
61	MGV_EKPO	UEBPO	EKPO	EBELP
62	MGV_EKPO	UPTYP	TMSI1	UPTYP	REF	1	N
63	MGV_EKPO	USEQU	TMQ2	USEQU	KEY	1	N
64	MGV_EKPO	VOLEH	T006	MSEHI	REF	1	N
65	MGV_EKPO	WERKS	T001W	WERKS	REF	1	N
66	MGV_EKPO	ZGTYP	TQ05	ZGTYP	KEY	1	N

History

Last changed by/on	SAP	20140121
SAP Release Created in