SAP ABAP Table V_OLR3_EKKX (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	V_OLR3_EKKX	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	BSART	☑	ESART	BSART	CHAR	4	0	Purchasing Document Type
4	BSAKZ	☑	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
5	ERNAM	☑	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
6	PINCR	☑	PINCR	PINCR	NUMC	5	0	Item Number Interval
7	LPONR	☑	LPONR	EBELP	NUMC	5	0	Last Item Number	EKPO
8	LIFNR	☑	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	LFA1
9	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
10	ZTERM	☑	DZTERM	ZTERM	CHAR	4	0	Terms of payment key
11	ZBD1T	☑	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
12	ZBD2T	☑	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
13	ZBD3T	☑	DZBDET	ZBDXT	DEC	3	0	Cash (Prompt Payment) Discount Days
14	ZBD1P	☑	DZBD1P	PRZ23	DEC	5	3	Cash discount percentage 1
15	ZBD2P	☑	DZBD2P	PRZ23	DEC	5	3	Cash Discount Percentage 2
16	EKORG	☑	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
17	EKGRP	☑	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	T024
18	WAERS	☑	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
19	WKURS	☑	WKURS	KURSP	DEC	9	5	Exchange Rate
20	KUFIX	☑	KUFIX	XFELD	CHAR	1	0	Indicator: Fixing of Exchange Rate
21	BEDAT	☑	EBDAT	DATUM	DATS	8	0	Purchasing Document Date
22	KDATB	☑	KDATB	DATUM	DATS	8	0	Start of Validity Period
23	KDATE	☑	KDATE	DATUM	DATS	8	0	End of Validity Period
24	BWBDT	☑	BWBDT	DATUM	DATS	8	0	Closing Date for Applications
25	ANGDT	☑	ANGAB	DATUM	DATS	8	0	Deadline for Submission of Bid/Quotation
26	BNDDT	☑	EBNDT	DATUM	DATS	8	0	Binding Period for Quotation
27	GWLDT	☑	MM_GWLDT	DATUM	DATS	8	0	Warranty Date
28	AUSNR	☑	AUSCH	EBELN	CHAR	10	0	Bid invitation number	EKKO
29	ANGNR	☑	ANGNR	ANGNR	CHAR	10	0	Quotation Number
30	IHRAN	☑	IHRAN	DATUM	DATS	8	0	Quotation Submission Date
31	IHREZ	☑	IHREZ	TEXT12	CHAR	12	0	Your Reference
32	VERKF	☑	EVERK	TEXT30	CHAR	30	0	Responsible Salesperson at Vendor's Office
33	TELF1	☑	TELF0	TEXT16	CHAR	16	0	Vendor's Telephone Number
34	LLIEF	☑	LLIEF	LIFNR	CHAR	10	0	Supplying Vendor	LFA1
35	ABGRU	☑	ABDUM	CHAR2	CHAR	2	0	Field Not Used
36	AUTLF	☑	KMPLF	XFELD	CHAR	1	0	Complete Delivery Stipulated for Each Purchase Order
37	WEAKT	☑	WEAKT	XFELD	CHAR	1	0	Indicator: Goods Receipt Message
38	RESWK	☑	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	T001W
39	LBLIF	☑	LBLIF	LIFNR	CHAR	10	0	Field not used	LFA1
40	KTWRT	☑	KTWRT	WERT15	CURR	15	2	Target Value for Header Area per Distribution
41	SUBMI	☑	SUBMI	CHAR10	CHAR	10	0	Collective Number
42	KNUMV	☑	KNUMV	KNUMV	CHAR	10	0	Number of the document condition
43	KALSM	☑	KALSM_D	KALSM	CHAR	6	0	Procedure (Pricing, Output Control, Acct. Det., Costing,...)	T683
44	LIFRE	☑	LIFRE	LIFNR	CHAR	10	0	Different Invoicing Party	LFA1
45	EXNUM	☑	EXNUM	EXNUM	CHAR	10	0	Number of foreign trade data in MM and SD documents	EIKP
46	UNSEZ	☑	UNSEZ	TEXT12	CHAR	12	0	Our Reference
47	LOGSY	☑	LOGSYSTEM	LOGSYS	CHAR	10	0	Logical System
48	UPINC	☑	UPINC	PINCR	NUMC	5	0	Item Number Interval for Subitems
49	STAKO	☑	STAKO	XFELD	CHAR	1	0	Document with time-dependent conditions
50	FRGGR	☑	FRGGR	FRGGR	CHAR	2	0	Release group	T16FG
51	FRGSX	☑	FRGSX	FRGSX	CHAR	2	0	Release Strategy	T16FS
52	FRGKE	☑	FRGKE	FRGKE	CHAR	1	0	Release Indicator: Purchasing Document	T16FB
53	FRGZU	☑	FRGZU	FRGZU	CHAR	8	0	Release status
54	FRGRL	☑	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
55	LANDS	☑	LAND1_STML	LAND1	CHAR	3	0	Country for Tax Return	T005
56	LPHIS	☑	LPHIS	XFELD	CHAR	1	0	Indicator for scheduling agreement release documentation
57	STCEG_L	☑	STCEG_L	LAND1	CHAR	3	0	Country of sales tax ID number
58	STCEG	☑	STCEG	STCEG	CHAR	20	0	VAT Registration Number
59	ABSGR	☑	ABSGR	NUMC02	NUMC	2	0	Reason for Cancellation	T165R
60	ADDNR	☑	ADDI_BELNR	ADDI_BELNR	CHAR	10	0	Document number for additional
61	KORNR	☑	KORNR	KORNR	CHAR	1	0	Correction of miscellaneous provisions
62	MEMORY	☑	MEMER	XFELD	CHAR	1	0	Purchase order not yet complete
63	PROCSTAT	☑	MEPROCSTATE	MEPROCSTATE	CHAR	2	0	Purchasing document processing state
64	RLWRT	☑	RLWRT	WERT15	CURR	15	2	Total value at time of release
65	REVNO	☑	REVNO	REVNO	CHAR	8	0	Version number in Purchasing
66	EBELP	☑	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document
67	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
68	STATU	☐	ASTAT	ASTAT	CHAR	1	0	RFQ status
69	AEDAT	☐	PAEDT	DATUM	DATS	8	0	Purchasing Document Item Change Date
70	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
71	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
72	EMATN	☐	EMATNR	MATNR	CHAR	18	0	Material number	MARA
73	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
74	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
75	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
76	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
77	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
78	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
79	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
80	KTMNG	☐	KTMNG	MENGE	QUAN	13	3	Target Quantity
81	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
82	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
83	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	T006
84	BPUMZ	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
85	BPUMN	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
86	UMREZ	☐	UMBSZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Unit to Base Unit
87	UMREN	☐	UMBSN	UMBSN	DEC	5	0	Denominator for Conversion of Order Unit to Base Unit
88	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
89	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
90	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
91	BRTWR	☐	BBWERT	WERT7	CURR	13	2	Gross order value in PO currency
92	AGDAT	☐	ANGAB	DATUM	DATS	8	0	Deadline for Submission of Bid/Quotation
93	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
94	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
95	BONUS	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
96	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
97	SPINF	☐	SPINF	SPINF	CHAR	1	0	Indicator: Update Info Record
98	PRSDR	☐	PRSDR	XFELD	CHAR	1	0	Price Printout
99	SCHPR	☐	SCHPR	XFELD	CHAR	1	0	Indicator: Estimated Price
100	MAHNZ	☐	MAHNZ	PACK2	DEC	3	0	Number of Reminders/Expediters
101	MAHN1	☐	MAHN1	MAHNT	DEC	3	0	Number of Days for First Reminder/Expediter
102	MAHN2	☐	MAHN2	MAHNT	DEC	3	0	Number of Days for Second Reminder/Expediter
103	MAHN3	☐	MAHN3	MAHNT	DEC	3	0	Number of Days for Third Reminder/Expediter
104	UEBTO	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
105	UEBTK	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
106	UNTTO	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
107	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
108	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	T149C
109	ABSKZ	☐	ABSKZ	XFELD	CHAR	1	0	Rejection Indicator
110	AGMEM	☐	AGMEM	AGMEM	CHAR	3	0	Internal Comment on Quotation	TMAM
111	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
112	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
113	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
114	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
115	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
116	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
117	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
118	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
119	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
120	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
121	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
122	KZABS	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
123	LABNR	☐	LABNR	TEXT20	CHAR	20	0	Order Acknowledgment Number
124	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
125	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
126	ABDAT	☐	ABDAT	DATUM	DATS	8	0	Reconciliation date for agreed cumulative quantity
127	ABFTZ	☐	ABFTZ	MENG13	QUAN	13	3	Agreed Cumulative Quantity
128	ETFZ1	☐	ETFZ1	PACK2	DEC	3	0	Firm Zone (Go-Ahead for Production)
129	ETFZ2	☐	ETFZ2	PACK2	DEC	3	0	Trade-Off Zone (Go-Ahead for Materials Procurement)
130	KZSTU	☐	MRPRE	KZFIX	CHAR	1	0	Firm/Trade-Off Zones Binding with Regard to Mat. Planning
131	NOTKZ	☐	NOTKZ	XFELD	CHAR	1	0	Exclusion in Outline Agreement Item with Material Class
132	LMEIN	☐	LAGME	MEINS	UNIT	3	0	Base Unit of Measure	T006
133	EVERS	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	T027A
134	ZWERT	☐	DZWERT	WERT7	CURR	13	2	Target value for outline agreement in document currency
135	NAVNW	☐	NAVNW	WERT7	CURR	13	2	Non-deductible input tax
136	ABMNG	☐	NORAM	MENG13	QUAN	13	3	Standard release order quantity
137	PRDAT	☐	PREDT	DATUM	DATS	8	0	Date of Price Determination
138	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
139	EFFWR	☐	EFFWR	WERT7	CURR	13	2	Effective value of item
140	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
141	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	KNA1
142	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	ADRC
143	EKKOL	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
144	SKTOF	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
145	STAFO	☐	STAFO	STAFO	CHAR	6	0	Update group for statistics update
146	PLIFZ	☐	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
147	NTGEW	☐	ENTGE	MENG13	QUAN	13	3	Net Weight
148	GEWEI	☐	EGEWE	MEINS	UNIT	3	0	Unit of Weight	T006
149	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
150	ETDRK	☐	ETDRK	ETDRK	CHAR	1	0	Indicator: Print-relevant schedule lines exist
151	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
152	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
153	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
154	INSNC	☐	INSNC	XFELD	CHAR	1	0	Quality inspection indicator cannot be changed
155	SSQSS	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	TQ08
156	ZGTYP	☐	QZGTYP	QZGTYP	CHAR	4	0	Certificate Type	TQ05
157	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
158	BSTAE	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	T163L
159	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
160	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund
161	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center
162	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
163	KO_GSBER	☐	GSBER_GP	GSBER	CHAR	4	0	Business area reported to the partner
164	KO_PARGB	☐	PARGB_GP	GSBER	CHAR	4	0	assumed business area of the business partner
165	KO_PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	CEPC
166	KO_PPRCTR	☐	PPRCTR	PRCTR	CHAR	10	0	Partner Profit Center	CEPC
167	MEPRF	☐	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
168	BRGEW	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
169	VOLUM	☐	VOLUM	MENG13	QUAN	13	3	Volume
170	VOLEH	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
171	INCO1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
172	INCO2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
173	VORAB	☐	VORAB	XFELD	CHAR	1	0	Advance procurement: project stock
174	KOLIF	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
175	LTSNR	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
176	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
177	FPLNR	☐	IPLNR	CHAR10	CHAR	10	0	Invoicing plan number
178	GNETWR	☐	GNETWR	WERT7	CURR	13	2	Currently not used
179	STAPO	☐	STAPO	XFELD	CHAR	1	0	Item is statistical
180	UEBPO	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	EKPO
181	LEWED	☐	LEWED	DATUM	DATS	8	0	Latest Possible Goods Receipt
182	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
183	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
184	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	MARA
185	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
186	KANBA	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
187	ADRN2	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	ADRC
188	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
189	XERSY	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
190	EILDT	☐	EILDT	DATUM	DATS	8	0	Start Date for GR-Based Settlement
191	DRDAT	☐	DRDAT	DATUM	DATS	8	0	Last Transmission
192	DRUHR	☐	DRUHR	UZEIT	TIMS	6	0	Time
193	DRUNR	☐	DRUNR	NUMC4	NUMC	4	0	Sequential Number
194	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
195	ABELN	☐	ABELN	ABELN	CHAR	10	0	Allocation Table Number	AUKO
196	ABELP	☐	ABELP	ABELP	NUMC	5	0	Item number of allocation table
197	ANZPU	☐	ANZPU	MENG13	QUAN	13	3	Number of Points
198	PUNEI	☐	PUNEI	MEINS	UNIT	3	0	Points unit	T006
199	SAISO	☐	SAISO	SAISO	CHAR	4	0	Season Category	T6WSP
200	SAISJ	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
201	EBON2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
202	EBON3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
203	EBONF	☐	EBONY	XFELD	CHAR	1	0	Item Relevant to Subsequent (Period-End Rebate) Settlement
204	MLMAA	☐	CK_ML_MAAC	XFELD	CHAR	1	0	Material ledger activated at material level
205	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
206	ANFNR	☐	ANFNR	EBELN	CHAR	10	0	RFQ Number	EKKO
207	ANFPS	☐	ANFPS	EBELP	NUMC	5	0	Item Number of RFQ	EKPO
208	KZKFG	☐	KZCUH	KZCUH	CHAR	1	0	Origin of Configuration
209	USEQU	☐	USEQU	USEQU	CHAR	1	0	Quota arrangement usage	TMQ2
210	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer
211	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
212	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	EBAN
213	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
214	UPTYP	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	TMSI1
215	UPVOR	☐	UPVOR	CHAR1	CHAR	1	0	Subitems Exist
216	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
217	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
218	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
219	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
220	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
221	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
222	SIKGR	☐	SIKGR	SIKGR	CHAR	3	0	Processing key for sub-items	TMSI2
223	MFZHI	☐	MFZHI	MENG15	QUAN	15	3	Maximum Cumulative Material Go-Ahead Quantity
224	FFZHI	☐	FFZHI	MENG15	QUAN	15	3	Maximum Cumulative Production Go-Ahead Quantity
225	RETPO	☐	RETPO	XFELD	CHAR	1	0	Returns Item
226	AUREL	☐	AUREL	AUREL	CHAR	1	0	Relevant to Allocation Table
227	BSGRU	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering	TBSG
228	LFRET	☐	LFRET	LFART	CHAR	4	0	Delivery Type for Returns to Vendors	TVLK
229	MFRGR	☐	MFRGR	MFRGR	CHAR	8	0	Material freight group	TMFG
230	NRFHG	☐	NRFHG	NRFHG	CHAR	1	0	Material qualifies for discount in kind
231	J_1BNBM	☐	J_1BNBMCO1	STEUC	CHAR	16	0	Brazilian NCM Code	T604F
232	J_1BMATUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
233	J_1BMATORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
234	J_1BOWNPRO	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
235	J_1BINDUST	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
236	ABUEB	☐	ABUEB	ABUEB	CHAR	4	0	Release Creation Profile	T163P
237	NLABD	☐	NLABD	DATUM	DATS	8	0	Next Forecast Delivery Schedule Transmission
238	NFABD	☐	NFABD	DATUM	DATS	8	0	Next JIT Delivery Schedule Transmission
239	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
240	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
241	FABKZ	☐	FABKZ	FABKZ	CHAR	1	0	Indicator: Item Relevant to JIT Delivery Schedules
242	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	J_1AINFT20
243	J_1AIDATEP	☐	J_1AIDATEP	J_1AUDATEP	DATS	8	0	Last day of the time period where the index value is valid
244	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile
245	EGLKZ	☐	EGLKZ	XFELD	CHAR	1	0	"Outward Delivery Completed" Indicator
246	KZTLF	☐	KZTUL	KZTUL	CHAR	1	0	Partial Delivery at Item Level (Stock Transfer)
247	KZFME	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
248	RDPRF	☐	RDPRF	RDPRF	CHAR	4	0	Rounding Profile	RDPR
249	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
250	CHG_SRV	☐	CHG_SRV	XFELD	CHAR	1	0	Configuration changed
251	CHG_FPLNR	☐	CHG_FPLNR	XFELD	CHAR	1	0	No invoice for this item although not free of charge
252	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
253	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
254	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
255	NOVET	☐	NOVET	XFELD	CHAR	1	0	Item blocked for SD delivery
256	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
257	TZONRC	☐	TSEGZONREC	TZNZONE	CHAR	6	0	Time zone of recipient location
258	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
259	LEBRE	☐	LEBRE	XFELD	CHAR	1	0	Indicator for Service-Based Invoice Verification
260	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	MDLV
261	XCONDITIONS	☐	XCONDITIONS	XCONDITIONS	CHAR	1	0	Conditions for item although no invoice
262	APOMS	☐	APOMS	APOMS	CHAR	1	0	APO as Planning System
263	CCOMP	☐	MMPUR_CCOMP	MMPUR_CCOMP	CHAR	1	0	Posting Logic in the Case of Stock Transfers
264	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
265	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area
266	STATUS	☐	EPSTATU	EPSTATU	CHAR	1	0	Status of Purchasing Document Item
267	REFSITE	☐	WREFSITE	WERKS_W	CHAR	4	0	Reference Site For Purchasing

Foreign Keys

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

History

Last changed by/on	SAP	20140121
SAP Release Created in