SAP ABAP View WB2_V_EKKO_EKPO2 (Data Selection from PO (without WBGT))
Hierarchy
EA-GLTRADE (Software Component) SAP Enterprise Extension Global Trade
   LO-GT-TEW (Application Component) Trading Execution Workbench
     WB2B_TEW (Package) Trading Execution Workbench
Basic Data
View Type D Database View 
Database View WB2_V_EKKO_EKPO2  
Short Description Data Selection from PO (without WBGT)    
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 EKPO MANDT JL EQ 0 0
2 EKKO MANDT JR EQ AND 0 0
3 EKPO EBELN JL EQ 0 0
4 EKKO 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 MANDT_I EKPO MANDT   MANDT Client
4 EBELN_I EKPO EBELN   EBELN Purchasing Document Number
5 EBELP_I EKPO EBELP   EBELP Item Number of Purchasing Document
6 BUKRS EKKO BUKRS   BUKRS Company Code
7 BSTYP EKKO BSTYP   EBSTYP Purchasing Document Category
8 BSART EKKO BSART   ESART Purchasing Document Type
9 BSAKZ EKKO BSAKZ   BSAKZ Control indicator for purchasing document type
10 LOEKZ EKKO LOEKZ   ELOEK Deletion indicator in purchasing document
11 STATU EKKO STATU   ESTAK Status of Purchasing Document
12 AEDAT EKKO AEDAT   ERDAT Date on which the record was created
13 ERNAM EKKO ERNAM   ERNAM Name of Person who Created the Object
14 PINCR EKKO PINCR   PINCR Item Number Interval
15 LPONR EKKO LPONR   LPONR Last Item Number
16 LIFNR EKKO LIFNR   ELIFN Vendor's account number
17 SPRAS EKKO SPRAS   SPRAS Language Key
18 ZTERM EKKO ZTERM   DZTERM Terms of payment key
19 ZBD1T EKKO ZBD1T   DZBDET Cash (Prompt Payment) Discount Days
20 ZBD2T EKKO ZBD2T   DZBDET Cash (Prompt Payment) Discount Days
21 ZBD3T EKKO ZBD3T   DZBDET Cash (Prompt Payment) Discount Days
22 ZBD1P EKKO ZBD1P   DZBD1P Cash discount percentage 1
23 ZBD2P EKKO ZBD2P   DZBD2P Cash Discount Percentage 2
24 EKORG EKKO EKORG   EKORG Purchasing organization
25 EKGRP EKKO EKGRP   BKGRP Purchasing Group
26 WAERS EKKO WAERS   WAERS Currency Key
27 WKURS EKKO WKURS   WKURS Exchange Rate
28 KUFIX EKKO KUFIX   KUFIX Indicator: Fixing of Exchange Rate
29 BEDAT EKKO BEDAT   EBDAT Purchasing Document Date
30 KDATB EKKO KDATB   KDATB Start of Validity Period
31 KDATE EKKO KDATE   KDATE End of Validity Period
32 BWBDT EKKO BWBDT   BWBDT Closing Date for Applications
33 ANGDT EKKO ANGDT   ANGAB Deadline for Submission of Bid/Quotation
34 BNDDT EKKO BNDDT   EBNDT Binding Period for Quotation
35 GWLDT EKKO GWLDT   MM_GWLDT Warranty Date
36 AUSNR EKKO AUSNR   AUSCH Bid invitation number
37 ANGNR EKKO ANGNR   ANGNR Quotation Number
38 IHRAN EKKO IHRAN   IHRAN Quotation Submission Date
39 IHREZ EKKO IHREZ   IHREZ Your Reference
40 VERKF EKKO VERKF   EVERK Responsible Salesperson at Vendor's Office
41 TELF1 EKKO TELF1   TELF0 Vendor's Telephone Number
42 LLIEF EKKO LLIEF   LLIEF Supplying Vendor
43 KUNNR EKKO KUNNR   KUNNR Customer Number
44 KONNR EKKO KONNR   KONNR Number of principal purchase agreement
45 ABGRU EKKO ABGRU   ABDUM Field Not Used
46 AUTLF EKKO AUTLF   KMPLF Complete Delivery Stipulated for Each Purchase Order
47 WEAKT EKKO WEAKT   WEAKT Indicator: Goods Receipt Message
48 RESWK EKKO RESWK   RESWK Supplying (issuing) plant in case of stock transport order
49 LBLIF EKKO LBLIF   LBLIF Field not used
50 INCO1 EKKO INCO1   INCO1 Incoterms (part 1)
51 INCO2 EKKO INCO2   INCO2 Incoterms (part 2)
52 KTWRT EKKO KTWRT   KTWRT Target Value for Header Area per Distribution
53 SUBMI EKKO SUBMI   SUBMI Collective Number
54 KNUMV EKKO KNUMV   KNUMV Number of the document condition
55 KALSM EKKO KALSM   KALSM_D Procedure (Pricing, Output Control, Acct. Det., Costing,...)
56 STAFO EKKO STAFO   STAFO Update group for statistics update
57 LIFRE EKKO LIFRE   LIFRE Different Invoicing Party
58 EXNUM EKKO EXNUM   EXNUM Number of foreign trade data in MM and SD documents
59 UNSEZ EKKO UNSEZ   UNSEZ Our Reference
60 LOGSY EKKO LOGSY   LOGSYSTEM Logical System
61 UPINC EKKO UPINC   UPINC Item Number Interval for Subitems
62 STAKO EKKO STAKO   STAKO Document with time-dependent conditions
63 FRGGR EKKO FRGGR   FRGGR Release group
64 FRGSX EKKO FRGSX   FRGSX Release Strategy
65 FRGKE EKKO FRGKE   FRGKE Release Indicator: Purchasing Document
66 FRGZU EKKO FRGZU   FRGZU Release status
67 FRGRL EKKO FRGRL   FRGRL Release Not Yet Completely Effected
68 LANDS EKKO LANDS   LAND1_STML Country for Tax Return
69 LPHIS EKKO LPHIS   LPHIS Indicator for scheduling agreement release documentation
70 ADRNR EKKO ADRNR   AD_ADDRNUM Address number
71 STCEG_L EKKO STCEG_L   STCEG_L Country of sales tax ID number
72 STCEG EKKO STCEG   STCEG VAT Registration Number
73 ABSGR EKKO ABSGR   ABSGR Reason for Cancellation
74 ADDNR EKKO ADDNR   ADDI_BELNR Document number for additional
75 KORNR EKKO KORNR   KORNR Correction of miscellaneous provisions
76 MEMORY EKKO MEMORY   MEMER Purchase order not yet complete
77 LOEKZ_I EKPO LOEKZ   ELOEK Deletion indicator in purchasing document
78 STATU_I EKPO STATU   ASTAT RFQ status
79 AEDAT_I EKPO AEDAT   PAEDT Purchasing Document Item Change Date
80 TXZ01_I EKPO TXZ01   TXZ01 Short Text
81 MATNR_I EKPO MATNR   MATNR Material Number
82 EMATN_I EKPO EMATN   EMATNR Material number
83 BUKRS_I EKPO BUKRS   BUKRS Company Code
84 WERKS_I EKPO WERKS   EWERK Plant
85 LGORT_I EKPO LGORT   LGORT_D Storage location
86 BEDNR_I EKPO BEDNR   BEDNR Requirement Tracking Number
87 MATKL_I EKPO MATKL   MATKL Material Group
88 INFNR_I EKPO INFNR   INFNR Number of purchasing info record
89 IDNLF_I EKPO IDNLF   IDNLF Material Number Used by Vendor
90 KTMNG_I EKPO KTMNG   KTMNG Target Quantity
91 MENGE_I EKPO MENGE   BSTMG Purchase Order Quantity
92 MEINS_I EKPO MEINS   BSTME Order unit
93 BPRME_I EKPO BPRME   BBPRM Order Price Unit (purchasing)
94 BPUMZ_I EKPO BPUMZ   BPUMZ Numerator for Conversion of Order Price Unit into Order Unit
95 BPUMN_I EKPO BPUMN   BPUMN Denominator for Conv. of Order Price Unit into Order Unit
96 UMREZ_I EKPO UMREZ   UMBSZ Numerator for Conversion of Order Unit to Base Unit
97 UMREN_I EKPO UMREN   UMBSN Denominator for Conversion of Order Unit to Base Unit
98 NETPR_I EKPO NETPR   BPREI Net Price in Purchasing Document (in Document Currency)
99 PEINH_I EKPO PEINH   EPEIN Price unit
100 NETWR_I EKPO NETWR   BWERT Net Order Value in PO Currency
101 BRTWR_I EKPO BRTWR   BBWERT Gross order value in PO currency
102 AGDAT_I EKPO AGDAT   ANGAB Deadline for Submission of Bid/Quotation
103 WEBAZ_I EKPO WEBAZ   WEBAZ Goods receipt processing time in days
104 MWSKZ_I EKPO MWSKZ   MWSKZ Tax on sales/purchases code
105 BONUS_I EKPO BONUS   EBONU Settlement Group 1 (Purchasing)
106 INSMK_I EKPO INSMK   INSMK Stock Type
107 SPINF_I EKPO SPINF   SPINF Indicator: Update Info Record
108 PRSDR_I EKPO PRSDR   PRSDR Price Printout
109 SCHPR_I EKPO SCHPR   SCHPR Indicator: Estimated Price
110 MAHNZ_I EKPO MAHNZ   MAHNZ Number of Reminders/Expediters
111 MAHN1_I EKPO MAHN1   MAHN1 Number of Days for First Reminder/Expediter
112 MAHN2_I EKPO MAHN2   MAHN2 Number of Days for Second Reminder/Expediter
113 MAHN3_I EKPO MAHN3   MAHN3 Number of Days for Third Reminder/Expediter
114 UEBTO_I EKPO UEBTO   UEBTO Overdelivery Tolerance Limit
115 UEBTK_I EKPO UEBTK   UEBTK Indicator: Unlimited Overdelivery Allowed
116 UNTTO_I EKPO UNTTO   UNTTO Underdelivery Tolerance Limit
117 BWTAR_I EKPO BWTAR   BWTAR_D Valuation type
118 BWTTY_I EKPO BWTTY   BWTTY_D Valuation Category
119 ABSKZ_I EKPO ABSKZ   ABSKZ Rejection Indicator
120 AGMEM_I EKPO AGMEM   AGMEM Internal Comment on Quotation
121 ELIKZ_I EKPO ELIKZ   ELIKZ "Delivery Completed" Indicator
122 EREKZ_I EKPO EREKZ   EREKZ Final Invoice Indicator
123 PSTYP_I EKPO PSTYP   PSTYP Item category in purchasing document
124 KNTTP_I EKPO KNTTP   KNTTP Account assignment category
125 KZVBR_I EKPO KZVBR   KZVBR Consumption posting
126 VRTKZ_I EKPO VRTKZ   VRTKZ Distribution indicator for multiple account assignment
127 TWRKZ_I EKPO TWRKZ   TWRKZ Partial invoice indicator
128 WEPOS_I EKPO WEPOS   WEPOS Goods Receipt Indicator
129 WEUNB_I EKPO WEUNB   WEUNB Goods Receipt, Non-Valuated
130 REPOS_I EKPO REPOS   REPOS Invoice receipt indicator
131 WEBRE_I EKPO WEBRE   WEBRE Indicator: GR-Based Invoice Verification
132 KZABS_I EKPO KZABS   KZABS Order Acknowledgment Requirement
133 LABNR_I EKPO LABNR   LABNR Order Acknowledgment Number
134 KONNR_I EKPO KONNR   KONNR Number of principal purchase agreement
135 KTPNR_I EKPO KTPNR   KTPNR Item number of principal purchase agreement
136 ABDAT_I EKPO ABDAT   ABDAT Reconciliation date for agreed cumulative quantity
137 ABFTZ_I EKPO ABFTZ   ABFTZ Agreed Cumulative Quantity
138 ETFZ1_I EKPO ETFZ1   ETFZ1 Firm Zone (Go-Ahead for Production)
139 ETFZ2_I EKPO ETFZ2   ETFZ2 Trade-Off Zone (Go-Ahead for Materials Procurement)
140 KZSTU_I EKPO KZSTU   MRPRE Firm/Trade-Off Zones Binding with Regard to Mat. Planning
141 NOTKZ_I EKPO NOTKZ   NOTKZ Exclusion in Outline Agreement Item with Material Class
142 LMEIN_I EKPO LMEIN   LAGME Base Unit of Measure
143 EVERS_I EKPO EVERS   EVERS Shipping Instructions
144 ZWERT_I EKPO ZWERT   DZWERT Target value for outline agreement in document currency
145 NAVNW_I EKPO NAVNW   NAVNW Non-deductible input tax
146 ABMNG_I EKPO ABMNG   NORAM Standard release order quantity
147 PRDAT_I EKPO PRDAT   PREDT Date of Price Determination
148 BSTYP_I EKPO BSTYP   BSTYP Purchasing document category
149 EFFWR_I EKPO EFFWR   EFFWR Effective value of item
150 XOBLR_I EKPO XOBLR   XOBLR Item affects commitments
151 KUNNR_I EKPO KUNNR   EKUNNR Customer
152 ADRNR_I EKPO ADRNR   ADRNR_MM Manual address number in purchasing document item
153 EKKOL_I EKPO EKKOL   EKKOG Condition Group with Vendor
154 SKTOF_I EKPO SKTOF   ESKTOF Item Does Not Qualify for Cash Discount
155 STAFO_I EKPO STAFO   STAFO Update group for statistics update
156 PLIFZ_I EKPO PLIFZ   EPLIF Planned Delivery Time in Days
157 NTGEW_I EKPO NTGEW   ENTGE Net Weight
158 GEWEI_I EKPO GEWEI   EGEWE Unit of Weight
159 TXJCD_I EKPO TXJCD   TXJCD Tax Jurisdiction
160 ETDRK_I EKPO ETDRK   ETDRK Indicator: Print-relevant schedule lines exist
161 SOBKZ_I EKPO SOBKZ   SOBKZ Special Stock Indicator
162 ARSNR_I EKPO ARSNR   ARSNR Settlement reservation number
163 ARSPS_I EKPO ARSPS   ARSPS Item number of the settlement reservation
164 INSNC_I EKPO INSNC   INSNC Quality inspection indicator cannot be changed
165 SSQSS_I EKPO SSQSS   QSSPUR Control Key for Quality Management in Procurement
166 ZGTYP_I EKPO ZGTYP   QZGTYP Certificate Type
167 EAN11_I EKPO EAN11   EAN11 International Article Number (EAN/UPC)
168 BSTAE_I EKPO BSTAE   BSTAE Confirmation Control Key
169 REVLV_I EKPO REVLV   REVLV Revision level
170 GEBER_I EKPO GEBER   BP_GEBER Fund
171 FISTL_I EKPO FISTL   FISTL Funds Center
172 FIPOS_I EKPO FIPOS   FIPOS Commitment Item
173 KO_GSBER_I EKPO KO_GSBER   GSBER_GP Business area reported to the partner
174 KO_PARGB_I EKPO KO_PARGB   PARGB_GP assumed business area of the business partner
175 KO_PRCTR_I EKPO KO_PRCTR   PRCTR Profit Center
176 KO_PPRCTR_I EKPO KO_PPRCTR   PPRCTR Partner Profit Center
177 MEPRF_I EKPO MEPRF   MEPRF Price Determination (Pricing) Date Control
178 BRGEW_I EKPO BRGEW   BRGEW Gross weight
179 VOLUM_I EKPO VOLUM   VOLUM Volume
180 VOLEH_I EKPO VOLEH   VOLEH Volume unit
181 INCO1_I EKPO INCO1   INCO1 Incoterms (part 1)
182 INCO2_I EKPO INCO2   INCO2 Incoterms (part 2)
183 VORAB_I EKPO VORAB   VORAB Advance procurement: project stock
184 KOLIF_I EKPO KOLIF   KOLIF Prior Vendor
185 LTSNR_I EKPO LTSNR   LTSNR Vendor Subrange
186 PACKNO_I EKPO PACKNO   PACKNO Package number
187 FPLNR_I EKPO FPLNR   IPLNR Invoicing plan number
188 GNETWR_I EKPO GNETWR   GNETWR Currently not used
189 STAPO_I EKPO STAPO   STAPO Item is statistical
190 UEBPO_I EKPO UEBPO   UEBPO Higher-Level Item in Purchasing Documents
191 LEWED_I EKPO LEWED   LEWED Latest Possible Goods Receipt
192 EMLIF_I EKPO EMLIF   EMLIF Vendor to be supplied/who is to receive delivery
193 LBLKZ_I EKPO LBLKZ   LBLKZ Subcontracting vendor
194 SATNR_I EKPO SATNR   SATNR Cross-Plant Configurable Material
195 ATTYP_I EKPO ATTYP   ATTYP Material Category
196 KANBA_I EKPO KANBA   KBNKZ Kanban Indicator
197 ADRN2_I EKPO ADRN2   ADRN2 Number of delivery address
198 CUOBJ_I EKPO CUOBJ   CUOBJ Configuration (internal object number)
199 XERSY_I EKPO XERSY   XERSY Evaluated Receipt Settlement (ERS)
200 EILDT_I EKPO EILDT   EILDT Start Date for GR-Based Settlement
201 DRDAT_I EKPO DRDAT   DRDAT Last Transmission
202 DRUHR_I EKPO DRUHR   DRUHR Time
203 DRUNR_I EKPO DRUNR   DRUNR Sequential Number
204 AKTNR_I EKPO AKTNR   WAKTION Promotion
205 ABELN_I EKPO ABELN   ABELN Allocation Table Number
206 ABELP_I EKPO ABELP   ABELP Item number of allocation table
207 ANZPU_I EKPO ANZPU   ANZPU Number of Points
208 PUNEI_I EKPO PUNEI   PUNEI Points unit
209 SAISO_I EKPO SAISO   SAISO Season Category
210 SAISJ_I EKPO SAISJ   SAISJ Season Year
211 EBON2_I EKPO EBON2   EBON2 Settlement Group 2 (Rebate Settlement, Purchasing)
212 EBON3_I EKPO EBON3   EBON3 Settlement Group 3 (Rebate Settlement, Purchasing)
213 EBONF_I EKPO EBONF   EBONY Item Relevant to Subsequent (Period-End Rebate) Settlement
214 MLMAA_I EKPO MLMAA   CK_ML_MAAC Material ledger activated at material level
215 MHDRZ_I EKPO MHDRZ   MHDRZ Minimum Remaining Shelf Life
216 ANFNR_I EKPO ANFNR   ANFNR RFQ Number
217 ANFPS_I EKPO ANFPS   ANFPS Item Number of RFQ
218 KZKFG_I EKPO KZKFG   KZCUH Origin of Configuration
219 USEQU_I EKPO USEQU   USEQU Quota arrangement usage
220 UMSOK_I EKPO UMSOK   UMSOK Special stock indicator for physical stock transfer
221 BANFN_I EKPO BANFN   BANFN Purchase requisition number
222 BNFPO_I EKPO BNFPO   BNFPO Item number of purchase requisition
223 MTART_I EKPO MTART   MTART Material type
224 UPTYP_I EKPO UPTYP   UPTYP Subitem Category, Purchasing Document
225 UPVOR_I EKPO UPVOR   UPVOR Subitems Exist
226 KZWI1_I EKPO KZWI1   KZWI1 Subtotal 1 from pricing procedure for condition
227 KZWI2_I EKPO KZWI2   KZWI2 Subtotal 2 from pricing procedure for condition
228 KZWI3_I EKPO KZWI3   KZWI3 Subtotal 3 from pricing procedure for condition
229 KZWI4_I EKPO KZWI4   KZWI4 Subtotal 4 from pricing procedure for condition
230 KZWI5_I EKPO KZWI5   KZWI5 Subtotal 5 from pricing procedure for condition
231 KZWI6_I EKPO KZWI6   KZWI6 Subtotal 6 from pricing procedure for condition
232 SIKGR_I EKPO SIKGR   SIKGR Processing key for sub-items
233 MFZHI_I EKPO MFZHI   MFZHI Maximum Cumulative Material Go-Ahead Quantity
234 FFZHI_I EKPO FFZHI   FFZHI Maximum Cumulative Production Go-Ahead Quantity
235 RETPO_I EKPO RETPO   RETPO Returns Item
236 AUREL_I EKPO AUREL   AUREL Relevant to Allocation Table
237 BSGRU_I EKPO BSGRU   BSGRU Reason for Ordering
238 LFRET_I EKPO LFRET   LFRET Delivery Type for Returns to Vendors
239 MFRGR_I EKPO MFRGR   MFRGR Material freight group
240 NRFHG_I EKPO NRFHG   NRFHG Material qualifies for discount in kind
241 J_1BNBM_I EKPO J_1BNBM   J_1BNBMCO1 Brazilian NCM Code
242 J_1BMATUSE_I EKPO J_1BMATUSE   J_1BMATUSE Usage of the material
243 J_1BMATORG_I EKPO J_1BMATORG   J_1BMATORG Origin of the material
244 J_1BOWNPRO_I EKPO J_1BOWNPRO   J_1BOWNPRO Produced in-house
245 J_1BINDUST_I EKPO J_1BINDUST   J_1BINDUS3 Material CFOP category
246 ABUEB_I EKPO ABUEB   ABUEB Release Creation Profile
247 NLABD_I EKPO NLABD   NLABD Next Forecast Delivery Schedule Transmission
248 NFABD_I EKPO NFABD   NFABD Next JIT Delivery Schedule Transmission
249 KZBWS_I EKPO KZBWS   KZBWS Valuation of Special Stock
250 BONBA_I EKPO BONBA   BONBA Rebate basis 1
251 FABKZ_I EKPO FABKZ   FABKZ Indicator: Item Relevant to JIT Delivery Schedules
252 J_1AINDXP_I EKPO J_1AINDXP   J_1AINDXP Inflation Index
253 J_1AIDATEP_I EKPO J_1AIDATEP   J_1AIDATEP Last day of the time period where the index value is valid
254 MPROF_I EKPO MPROF   MPROF Mfr part profile
255 EGLKZ_I EKPO EGLKZ   EGLKZ "Outward Delivery Completed" Indicator
256 KZTLF_I EKPO KZTLF   KZTUL Partial Delivery at Item Level (Stock Transfer)
257 KZFME_I EKPO KZFME   KZWSO Units of measure usage
258 RDPRF_I EKPO RDPRF   RDPRF Rounding Profile
259 TECHS_I EKPO TECHS   TECHS Parameter Variant/Standard Variant
260 CHG_SRV_I EKPO CHG_SRV   CHG_SRV Configuration changed
261 CHG_FPLNR_I EKPO CHG_FPLNR   CHG_FPLNR No invoice for this item although not free of charge
262 MFRPN_I EKPO MFRPN   MFRPN Manufacturer Part Number
263 MFRNR_I EKPO MFRNR   MFRNR Manufacturer number
264 EMNFR_I EKPO EMNFR   EMNFR External manufacturer code name or number
265 NOVET_I EKPO NOVET   NOVET Item blocked for SD delivery
266 AFNAM_I EKPO AFNAM   AFNAM Name of requisitioner/requester
267 TZONRC_I EKPO TZONRC   TSEGZONREC Time zone of recipient location
268 IPRKZ_I EKPO IPRKZ   DATTP Period Indicator for Shelf Life Expiration Date
269 LEBRE_I EKPO LEBRE   LEBRE Indicator for Service-Based Invoice Verification
270 BERID_I EKPO BERID   BERID MRP Area
271 XCONDITIONS_I EKPO XCONDITIONS   XCONDITIONS Conditions for item although no invoice
272 APOMS_I EKPO APOMS   APOMS APO as Planning System
                 
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 46C