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