V_OLR3_EKKX SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
Table View field list including key, data, relationships and ABAP select examples
V_OLR3_EKKX is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The V_OLR3_EKKX table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include EBELN (Purchasing Document Number), BSART (Purchasing Document Type), BSAKZ (Control indicator for purchasing document type), ERNAM (Name of Person who Created the Object).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP V_OLR3_EKKX table view fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| EBELN | Purchasing Document Number | EBELN | CHAR | 10 | ALPHA | EBELN | BES | MEKK_C | |
| BSART | Purchasing Document Type | ESART | CHAR | 4 | BSART | BSA | |||
| BSAKZ | Control indicator for purchasing document type | BSAKZ | CHAR | 1 | BSAKZ | ||||
| ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
| PINCR | Item Number Interval | PINCR | NUMC | 5 | PINCR | ||||
| LPONR | Last Item Number | LPONR | NUMC | 5 | EKPO | EBELP | |||
| LIFNR | Vendor Account Number | ELIFN | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
| SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
| ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
| ZBD1T | Cash (Prompt Payment) Discount Days | DZBDET | DEC | 3 | ZBDXT | ||||
| ZBD2T | Cash (Prompt Payment) Discount Days | DZBDET | DEC | 3 | ZBDXT | ||||
| ZBD3T | Cash (Prompt Payment) Discount Days | DZBDET | DEC | 3 | ZBDXT | ||||
| ZBD1P | Cash Discount Percentage 1 | DZBD1P | DEC | 5(3) | PRZ23 | ||||
| ZBD2P | Cash Discount Percentage 2 | DZBD2P | DEC | 5(3) | PRZ23 | ||||
| EKORG | Purchasing Organization | EKORG | CHAR | 4 | T024E | EKORG | EKO | ||
| EKGRP | Purchasing Group | BKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
| WAERS | Currency Key | WAERS | CUKY | 5 | TCURC | WAERS | FWS | ||
| WKURS | Exchange Rate | WKURS | DEC | 9(5) | EXCRT | KURSP | |||
| KUFIX | Indicator: Fixing of Exchange Rate | KUFIX | CHAR | 1 | XFELD | ||||
| BEDAT | Purchasing Document Date | EBDAT | DATS | 8 | DATUM | ||||
| KDATB | Start of Validity Period | KDATB | DATS | 8 | DATUM | ||||
| KDATE | End of Validity Period | KDATE | DATS | 8 | DATUM | ||||
| BWBDT | Closing Date for Applications | BWBDT | DATS | 8 | DATUM | ||||
| ANGDT | Deadline for Submission of Bid/Quotation | ANGAB | DATS | 8 | DATUM | ||||
| BNDDT | Binding Period for Quotation | EBNDT | DATS | 8 | DATUM | ||||
| GWLDT | Warranty Date | MM_GWLDT | DATS | 8 | DATUM | ||||
| AUSNR | Bid invitation number | AUSCH | CHAR | 10 | EKKO | ALPHA | EBELN | BES | |
| ANGNR | Quotation Number | ANGNR | CHAR | 10 | ANGNR | ||||
| IHRAN | Quotation Submission Date | IHRAN | DATS | 8 | DATUM | ||||
| IHREZ | Your Reference | IHREZ | CHAR | 12 | TEXT12 | ||||
| VERKF | Responsible Salesperson at Vendor's Office | EVERK | CHAR | 30 | TEXT30 | ||||
| TELF1 | Vendor's Telephone Number | TELF0 | CHAR | 16 | TEXT16 | ||||
| LLIEF | Supplying Vendor | LLIEF | CHAR | 10 | LFA1 | ALPHA | LIFNR | LLI | |
| ABGRU | Field Not Used | ABDUM | CHAR | 2 | CHAR2 | ||||
| AUTLF | Complete Delivery Stipulated for Each Purchase Order | KMPLF | CHAR | 1 | XFELD | ||||
| WEAKT | Indicator: Goods Receipt Message | WEAKT | CHAR | 1 | XFELD | ||||
| RESWK | Supplying (Issuing) Plant in Stock Transport Order | RESWK | CHAR | 4 | T001W | WERKS | |||
| LBLIF | Field not used | LBLIF | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | |
| KTWRT | Target Value for Header Area per Distribution | KTWRT | CURR | 15(2) | WERT15 | ||||
| SUBMI | Collective Number | SUBMI | CHAR | 10 | CHAR10 | ||||
| KNUMV | Number of the document condition | KNUMV | CHAR | 10 | KNUMV | ||||
| KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | CHAR | 6 | T683 | KALSM | |||
| LIFRE | Different Invoicing Party | LIFRE | CHAR | 10 | LFA1 | ALPHA | LIFNR | LRE | |
| EXNUM | Number of foreign trade data in MM and SD documents | EXNUM | CHAR | 10 | EIKP | EXNUM | |||
| UNSEZ | Our Reference | UNSEZ | CHAR | 12 | TEXT12 | ||||
| LOGSY | Logical System | LOGSYSTEM | CHAR | 10 | ALPHA | LOGSYS | |||
| UPINC | Item Number Interval for Subitems | UPINC | NUMC | 5 | PINCR | ||||
| STAKO | Document with time-dependent conditions | STAKO | CHAR | 1 | XFELD | ||||
| FRGGR | Release group | FRGGR | CHAR | 2 | T16FG | FRGGR | |||
| FRGSX | Release Strategy | FRGSX | CHAR | 2 | T16FS | FRGSX | |||
| FRGKE | Release Indicator: Purchasing Document | FRGKE | CHAR | 1 | T16FB | FRGKE | |||
| FRGZU | Release status | FRGZU | CHAR | 8 | FRGZU | ||||
| FRGRL | Release Not Yet Completely Effected | FRGRL | CHAR | 1 | XFELD | ||||
| LANDS | Country for Tax Return | LAND1_STML | CHAR | 3 | T005 | LAND1 | |||
| LPHIS | Indicator for scheduling agreement release documentation | LPHIS | CHAR | 1 | XFELD | ||||
| STCEG_L | Country of Sales Tax ID Number | STCEG_L | CHAR | 3 | LAND1 | LND | |||
| STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
| ABSGR | Reason for Cancellation | ABSGR | NUMC | 2 | T165R | NUMC02 | |||
| ADDNR | Document number for additional | ADDI_BELNR | CHAR | 10 | ALPHA | ADDI_BELNR | |||
| KORNR | Correction of miscellaneous provisions | KORNR | CHAR | 1 | KORNR | ||||
| MEMORY | Purchase order not yet complete | MEMER | CHAR | 1 | XFELD | ||||
| PROCSTAT | Purchasing document processing state | MEPROCSTATE | CHAR | 2 | MEPROCSTATE | ||||
| RLWRT | Total value at time of release | RLWRT | CURR | 15(2) | WERT15 | ||||
| REVNO | Version number in Purchasing | REVNO | CHAR | 8 | ALPHA | REVNO | |||
| EBELP | Item Number of Purchasing Document | EBELP | NUMC | 5 | EBELP | BSP | |||
| LOEKZ | Deletion Indicator in Purchasing Document | ELOEK | CHAR | 1 | ELOEK | ||||
| STATU | RFQ status | ASTAT | CHAR | 1 | ASTAT | ||||
| AEDAT | Purchasing Document Item Change Date | PAEDT | DATS | 8 | DATUM | ||||
| TXZ01 | Short Text | TXZ01 | CHAR | 40 | TEXT40 | ||||
| MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
| EMATN | Material Number | EMATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | |
| BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
| WERKS | Plant | EWERK | CHAR | 4 | T001W | WERKS | WRK | ||
| LGORT | Storage Location | LGORT_D | CHAR | 4 | T001L | LGORT | LAG | ||
| BEDNR | Requirement Tracking Number | BEDNR | CHAR | 10 | CHAR10 | ||||
| MATKL | Material Group | MATKL | CHAR | 9 | T023 | MATKL | MKL | S_WBWG | |
| INFNR | Number of Purchasing Info Record | INFNR | CHAR | 10 | EINA | ALPHA | INFNR | INF | MEIN_C |
| IDNLF | Material Number Used by Vendor | IDNLF | CHAR | 35 | IDNEX | ||||
| KTMNG | Target Quantity | KTMNG | QUAN | 13(3) | MENGE | ||||
| MENGE | Purchase Order Quantity | BSTMG | QUAN | 13(3) | MENG13 | ||||
| MEINS | Purchase Order Unit of Measure | BSTME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| BPRME | Order Price Unit (Purchasing) | BBPRM | UNIT | 3 | T006 | CUNIT | MEINS | ||
| BPUMZ | Numerator for Conversion of Order Price Unit into Order Unit | BPUMZ | DEC | 5 | UMBSZ | ||||
| BPUMN | Denominator for Conv. of Order Price Unit into Order Unit | BPUMN | DEC | 5 | UMBSN | ||||
| UMREZ | Numerator for Conversion of Order Unit to Base Unit | UMBSZ | DEC | 5 | UMBSZ | ||||
| UMREN | Denominator for Conversion of Order Unit to Base Unit | UMBSN | DEC | 5 | UMBSN | ||||
| NETPR | Net Price in Purchasing Document (in Document Currency) | BPREI | CURR | 11(2) | WERT11 | ||||
| PEINH | Price Unit | EPEIN | DEC | 5 | DEC5 | ||||
| NETWR | Net Order Value in PO Currency | BWERT | CURR | 13(2) | WERT7 | ||||
| BRTWR | Gross order value in PO currency | BBWERT | CURR | 13(2) | WERT7 | ||||
| AGDAT | Deadline for Submission of Bid/Quotation | ANGAB | DATS | 8 | DATUM | ||||
| WEBAZ | Goods Receipt Processing Time in Days | WEBAZ | DEC | 3 | DEC3 | ||||
| MWSKZ | Tax on sales/purchases code | MWSKZ | CHAR | 2 | T007A | MWSKZ | |||
| BONUS | Settlement Group 1 (Purchasing) | EBONU | CHAR | 2 | EBONU | ||||
| INSMK | Stock Type | INSMK | CHAR | 1 | INSMK | ||||
| SPINF | Indicator: Update Info Record | SPINF | CHAR | 1 | SPINF | ||||
| PRSDR | Price Printout | PRSDR | CHAR | 1 | XFELD | ||||
| SCHPR | Indicator: Estimated Price | SCHPR | CHAR | 1 | XFELD | ||||
| MAHNZ | Number of Reminders/Expediters | MAHNZ | DEC | 3 | PACK2 | ||||
| MAHN1 | Number of Days for First Reminder/Expediter | MAHN1 | DEC | 3 | MAHNT | ||||
| MAHN2 | Number of Days for Second Reminder/Expediter | MAHN2 | DEC | 3 | MAHNT | ||||
| MAHN3 | Number of Days for Third Reminder/Expediter | MAHN3 | DEC | 3 | MAHNT | ||||
| UEBTO | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
| UEBTK | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | XFELD | ||||
| UNTTO | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | T149D | BWTAR | BWT | ||
| BWTTY | Valuation Category | BWTTY_D | CHAR | 1 | T149C | BWTTY | |||
| ABSKZ | Rejection Indicator | ABSKZ | CHAR | 1 | XFELD | ||||
| AGMEM | Internal Comment on Quotation | AGMEM | CHAR | 3 | TMAM | AGMEM | |||
| ELIKZ | 'Delivery Completed' Indicator | ELIKZ | CHAR | 1 | XFELD | ||||
| EREKZ | Final Invoice Indicator | EREKZ | CHAR | 1 | XFELD | ||||
| PSTYP | Item Category in Purchasing Document | PSTYP | CHAR | 1 | T163 | PSTYP | |||
| KNTTP | Account Assignment Category | KNTTP | CHAR | 1 | T163K | KNTTP | KNT | ||
| KZVBR | Consumption Posting | KZVBR | CHAR | 1 | KZVBR | ||||
| VRTKZ | Distribution indicator for multiple account assignment | VRTKZ | CHAR | 1 | VRTKZ | ||||
| TWRKZ | Partial Invoice Indicator | TWRKZ | CHAR | 1 | TWRKZ | ||||
| WEPOS | Goods Receipt Indicator | WEPOS | CHAR | 1 | XFELD | ||||
| WEUNB | Goods Receipt, Non-Valuated | WEUNB | CHAR | 1 | XFELD | ||||
| REPOS | Invoice Receipt Indicator | REPOS | CHAR | 1 | XFELD | ||||
| WEBRE | Indicator: GR-Based Invoice Verification | WEBRE | CHAR | 1 | XFELD | ||||
| KZABS | Order Acknowledgment Requirement | KZABS | CHAR | 1 | XFELD | ||||
| LABNR | Order Acknowledgment Number | LABNR | CHAR | 20 | TEXT20 | ||||
| KONNR | Number of Principal Purchase Agreement | KONNR | CHAR | 10 | EKKO | ALPHA | EBELN | KTR | |
| KTPNR | Item Number of Principal Purchase Agreement | KTPNR | NUMC | 5 | EKPO | EBELP | |||
| ABDAT | Reconciliation Date for Agreed Cumulative Quantity | ABDAT | DATS | 8 | DATUM | ||||
| ABFTZ | Agreed Cumulative Quantity | ABFTZ | QUAN | 13(3) | MENG13 | ||||
| ETFZ1 | Firm Zone (Go-Ahead for Production) | ETFZ1 | DEC | 3 | PACK2 | ||||
| ETFZ2 | Trade-Off Zone (Go-Ahead for Materials Procurement) | ETFZ2 | DEC | 3 | PACK2 | ||||
| KZSTU | Firm/Trade-Off Zones Binding with Regard to Mat. Planning | MRPRE | CHAR | 1 | KZFIX | ||||
| NOTKZ | Exclusion in Outline Agreement Item with Material Class | NOTKZ | CHAR | 1 | XFELD | ||||
| LMEIN | Base Unit of Measure | LAGME | UNIT | 3 | T006 | CUNIT | MEINS | ||
| EVERS | Shipping Instructions | EVERS | CHAR | 2 | T027A | EVERS | |||
| ZWERT | Target Value for Outline Agreement in Document Currency | DZWERT | CURR | 13(2) | WERT7 | ||||
| NAVNW | Non-deductible input tax | NAVNW | CURR | 13(2) | WERT7 | ||||
| ABMNG | Standard release order quantity | NORAM | QUAN | 13(3) | MENG13 | ||||
| PRDAT | Date of Price Determination | PREDT | DATS | 8 | DATUM | ||||
| BSTYP | Purchasing Document Category | BSTYP | CHAR | 1 | BSTYP | ||||
| EFFWR | Effective value of item | EFFWR | CURR | 13(2) | WERT7 | ||||
| XOBLR | Item affects commitments | XOBLR | CHAR | 1 | XFELD | ||||
| KUNNR | Customer | EKUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | |
| ADRNR | Manual address number in purchasing document item | ADRNR_MM | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
| EKKOL | Condition Group with Vendor | EKKOG | CHAR | 4 | CHAR4 | ||||
| SKTOF | Item Does Not Qualify for Cash Discount | ESKTOF | CHAR | 1 | XFELD | ||||
| STAFO | Update group for statistics update | STAFO | CHAR | 6 | ALPHA | STAFO | MCF | ||
| PLIFZ | Planned Delivery Time in Days | EPLIF | DEC | 3 | DEC3 | ||||
| NTGEW | Net Weight | ENTGE | QUAN | 13(3) | MENG13 | ||||
| GEWEI | Unit of Weight | EGEWE | UNIT | 3 | T006 | CUNIT | MEINS | ||
| TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
| ETDRK | Indicator: Print-relevant schedule lines exist | ETDRK | CHAR | 1 | ETDRK | ||||
| SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | T148 | SOBKZ | |||
| ARSNR | Settlement reservation number | ARSNR | NUMC | 10 | MDNUM | ||||
| ARSPS | Item number of the settlement reservation | ARSPS | NUMC | 4 | RSPOS | ||||
| INSNC | Quality inspection indicator cannot be changed | INSNC | CHAR | 1 | XFELD | ||||
| SSQSS | Control Key for Quality Management in Procurement | QSSPUR | CHAR | 8 | TQ08 | QSSPUR | |||
| ZGTYP | Certificate Type | QZGTYP | CHAR | 4 | TQ05 | QZGTYP | QCT | ||
| EAN11 | International Article Number (EAN/UPC) | EAN11 | CHAR | 18 | EAN11 | EAN11 | EAN | ||
| BSTAE | Confirmation Control Key | BSTAE | CHAR | 4 | T163L | BSTAE | |||
| REVLV | Revision Level | REVLV | CHAR | 2 | NUMCV | REVLV | RVS | ||
| GEBER | Fund | BP_GEBER | CHAR | 10 | BP_GEBER | FIC | |||
| FISTL | Funds Center | FISTL | CHAR | 16 | FISTL | FIS | |||
| FIPOS | Commitment Item | FIPOS | CHAR | 14 | FMFPO | FIPOS | FIP | ||
| KO_GSBER | Business area reported to the partner | GSBER_GP | CHAR | 4 | GSBER | ||||
| KO_PARGB | assumed business area of the business partner | PARGB_GP | CHAR | 4 | GSBER | ||||
| KO_PRCTR | Profit Center | PRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| KO_PPRCTR | Partner Profit Center | PPRCTR | CHAR | 10 | CEPC | ALPHA | PRCTR | PPC | |
| MEPRF | Price Determination (Pricing) Date Control | MEPRF | CHAR | 1 | MEPRF | ||||
| BRGEW | Gross Weight | BRGEW | QUAN | 13(3) | MENG13 | ||||
| VOLUM | Volume | VOLUM | QUAN | 13(3) | MENG13 | ||||
| VOLEH | Volume unit | VOLEH | UNIT | 3 | T006 | CUNIT | MEINS | ||
| INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
| INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
| VORAB | Advance procurement: project stock | VORAB | CHAR | 1 | XFELD | ||||
| KOLIF | Prior Vendor | KOLIF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
| LTSNR | Vendor Subrange | LTSNR | CHAR | 6 | WYT1 | LTSNR | |||
| PACKNO | Package number | PACKNO | NUMC | 10 | ESLH | PACKNO | |||
| FPLNR | Invoicing plan number | IPLNR | CHAR | 10 | CHAR10 | ||||
| GNETWR | Currently not used | GNETWR | CURR | 13(2) | WERT7 | ||||
| STAPO | Item is statistical | STAPO | CHAR | 1 | XFELD | ||||
| UEBPO | Higher-Level Item in Purchasing Documents | UEBPO | NUMC | 5 | EKPO | EBELP | |||
| LEWED | Latest Possible Goods Receipt | LEWED | DATS | 8 | DATUM | ||||
| EMLIF | Vendor to be supplied/who is to receive delivery | EMLIF | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
| LBLKZ | Subcontracting vendor | LBLKZ | CHAR | 1 | XFELD | ||||
| SATNR | Cross-Plant Configurable Material | SATNR | CHAR | 18 | MARA | MATN1 | MATNR | ||
| ATTYP | Material Category | ATTYP | CHAR | 2 | ATTYP | MTY | |||
| KANBA | Kanban Indicator | KBNKZ | CHAR | 1 | KBNKZ | ||||
| ADRN2 | Number of delivery address | ADRN2 | CHAR | 10 | ADRC | ALPHA | AD_ADDRNUM | ||
| CUOBJ | Configuration (internal object number) | CUOBJ | NUMC | 18 | CUOBJ | CUX | |||
| XERSY | Evaluated Receipt Settlement (ERS) | XERSY | CHAR | 1 | XFELD | ||||
| EILDT | Start Date for GR-Based Settlement | EILDT | DATS | 8 | DATUM | ||||
| DRDAT | Last Transmission | DRDAT | DATS | 8 | DATUM | ||||
| DRUHR | Time | DRUHR | TIMS | 6 | UZEIT | ||||
| DRUNR | Sequential Number | DRUNR | NUMC | 4 | NUMC4 | ||||
| AKTNR | COUPON | WAKTION | CHAR | 10 | WAKH | ALPHA | WAKTION | WAK | |
| ABELN | Allocation Table Number | ABELN | CHAR | 10 | AUKO | ALPHA | ABELN | ABE | |
| ABELP | Item number of allocation table | ABELP | NUMC | 5 | ABELP | ||||
| ANZPU | Number of Points | ANZPU | QUAN | 13(3) | MENG13 | ||||
| PUNEI | Points unit | PUNEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
| SAISO | Season Category | SAISO | CHAR | 4 | T6WSP | SAISO | SAISO | ||
| SAISJ | Season Year | SAISJ | CHAR | 4 | GJAHR | CJAHR | WMSAISJ | ||
| EBON2 | Settlement Group 2 (Rebate Settlement, Purchasing) | EBON2 | CHAR | 2 | EBONU | ||||
| EBON3 | Settlement Group 3 (Rebate Settlement, Purchasing) | EBON3 | CHAR | 2 | EBONU | ||||
| EBONF | Item Relevant to Subsequent (Period-End Rebate) Settlement | EBONY | CHAR | 1 | XFELD | ||||
| MLMAA | Material ledger activated at material level | CK_ML_MAAC | CHAR | 1 | XFELD | ||||
| MHDRZ | Minimum Remaining Shelf Life | MHDRZ | DEC | 4 | DEC4 | ||||
| ANFNR | RFQ Number | ANFNR | CHAR | 10 | EKKO | ALPHA | EBELN | ANF | |
| ANFPS | Item Number of RFQ | ANFPS | NUMC | 5 | EKPO | EBELP | |||
| KZKFG | Origin of Configuration | KZCUH | CHAR | 1 | KZCUH | ||||
| USEQU | Quota arrangement usage | USEQU | CHAR | 1 | TMQ2 | USEQU | |||
| UMSOK | Special Stock Indicator for Physical Stock Transfer | UMSOK | CHAR | 1 | SOBKZ | ||||
| BANFN | Purchase Requisition Number | BANFN | CHAR | 10 | ALPHA | BANFN | BAN | MBAN_C | |
| BNFPO | Item Number of Purchase Requisition | BNFPO | NUMC | 5 | EBAN | BNFPO | BAP | ||
| MTART | Material Type | MTART | CHAR | 4 | T134 | MTART | MTA | ||
| UPTYP | Subitem Category, Purchasing Document | UPTYP | CHAR | 1 | TMSI1 | UPTYP | |||
| UPVOR | Subitems Exist | UPVOR | CHAR | 1 | CHAR1 | ||||
| KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13(2) | WERTV7 | ||||
| KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13(2) | WERTV7 | ||||
| KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13(2) | WERTV7 | ||||
| KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13(2) | WERTV7 | ||||
| KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13(2) | WERTV7 | ||||
| KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13(2) | WERTV7 | ||||
| SIKGR | Processing key for sub-items | SIKGR | CHAR | 3 | TMSI2 | SIKGR | |||
| MFZHI | Maximum Cumulative Material Go-Ahead Quantity | MFZHI | QUAN | 15(3) | MENG15 | ||||
| FFZHI | Maximum Cumulative Production Go-Ahead Quantity | FFZHI | QUAN | 15(3) | MENG15 | ||||
| RETPO | Returns Item | RETPO | CHAR | 1 | XFELD | ||||
| AUREL | Relevant to Allocation Table | AUREL | CHAR | 1 | AUREL | ||||
| BSGRU | Reason for Ordering | BSGRU | CHAR | 3 | TBSG | BSGRU | |||
| LFRET | Delivery Type for Returns to Vendors | LFRET | CHAR | 4 | TVLK | LFART | |||
| MFRGR | Material freight group | MFRGR | CHAR | 8 | TMFG | MFRGR | |||
| NRFHG | Material qualifies for discount in kind | NRFHG | CHAR | 1 | NRFHG | ||||
| J_1BNBM | Brazilian NCM Code | J_1BNBMCO1 | CHAR | 16 | T604F | STEUC | |||
| J_1BMATUSE | Usage of the material | J_1BMATUSE | CHAR | 1 | J_1BMATUSE | ||||
| J_1BMATORG | Origin of the material | J_1BMATORG | CHAR | 1 | J_1BMATORG | ||||
| J_1BOWNPRO | Produced in-house | J_1BOWNPRO | CHAR | 1 | XFELD | ||||
| J_1BINDUST | Material CFOP category | J_1BINDUS3 | CHAR | 2 | ALPHA | J_1BINDUS3 | |||
| ABUEB | Release Creation Profile | ABUEB | CHAR | 4 | T163P | ABUEB | |||
| NLABD | Next Forecast Delivery Schedule Transmission | NLABD | DATS | 8 | DATUM | ||||
| NFABD | Next JIT Delivery Schedule Transmission | NFABD | DATS | 8 | DATUM | ||||
| KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | KZBWS | ||||
| BONBA | Rebate basis 1 | BONBA | CURR | 13(2) | WERTV7 | ||||
| FABKZ | Indicator: Item Relevant to JIT Delivery Schedules | FABKZ | CHAR | 1 | FABKZ | ||||
| J_1AINDXP | Inflation Index | J_1AINDXP | CHAR | 5 | J_1AINFT20 | J_1AINDXP | |||
| J_1AIDATEP | Inflation Index Date | J_1AIDATEP | DATS | 8 | J_1AUDATEP | ||||
| MPROF | Manufacturer Part Profile | MPROF | CHAR | 4 | MPROF | ||||
| EGLKZ | 'Outward Delivery Completed' Indicator | EGLKZ | CHAR | 1 | XFELD | ||||
| KZTLF | Partial Delivery at Item Level (Stock Transfer) | KZTUL | CHAR | 1 | KZTUL | ||||
| KZFME | Units of measure usage | KZWSO | CHAR | 1 | KZWSO | ||||
| RDPRF | Rounding Profile | RDPRF | CHAR | 4 | RDPR | RDPRF | |||
| TECHS | Parameter Variant/Standard Variant | TECHS | CHAR | 12 | TECHS | ||||
| CHG_SRV | Configuration changed | CHG_SRV | CHAR | 1 | XFELD | ||||
| CHG_FPLNR | No invoice for this item although not free of charge | CHG_FPLNR | CHAR | 1 | XFELD | ||||
| MFRPN | Manufacturer Part Number | MFRPN | CHAR | 40 | CHAR40 | ||||
| MFRNR | Number of a Manufacturer | MFRNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
| EMNFR | External manufacturer code name or number | EMNFR | CHAR | 10 | CHAR10 | ||||
| NOVET | Item blocked for SD delivery | NOVET | CHAR | 1 | XFELD | ||||
| AFNAM | Name of Requisitioner/Requester | AFNAM | CHAR | 12 | AFNAM | ||||
| TZONRC | Time zone of recipient location | TSEGZONREC | CHAR | 6 | TZNZONE | ||||
| IPRKZ | Period Indicator for Shelf Life Expiration Date | DATTP | CHAR | 1 | PERKZ | DATTP | H_PERDKZ | ||
| LEBRE | Indicator for Service-Based Invoice Verification | LEBRE | CHAR | 1 | XFELD | ||||
| BERID | MRP Area | BERID | CHAR | 10 | MDLV | BERID | BERID | ||
| XCONDITIONS | Conditions for item although no invoice | XCONDITIONS | CHAR | 1 | XCONDITIONS | ||||
| APOMS | APO as Planning System | APOMS | CHAR | 1 | APOMS | ||||
| CCOMP | Posting Logic in the Case of Stock Transfers | MMPUR_CCOMP | CHAR | 1 | MMPUR_CCOMP | ||||
| GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
| FKBER | Functional Area | FKBER | CHAR | 16 | FKBER | FBE | |||
| STATUS | Status of Purchasing Document Item | EPSTATU | CHAR | 1 | EPSTATU | ||||
| REFSITE | Reference Site For Purchasing | WREFSITE | CHAR | 4 | WERKS_W |
| Key field | Non-key field |
How do I retrieve data from SAP table V_OLR3_EKKX using ABAP code
The following ABAP code Example will allow you to do a basic selection on V_OLR3_EKKX to SELECT all data from the tableDATA: WA_V_OLR3_EKKX TYPE V_OLR3_EKKX.
SELECT SINGLE *
FROM V_OLR3_EKKX
INTO CORRESPONDING FIELDS OF WA_V_OLR3_EKKX
WHERE...
How to access SAP table V_OLR3_EKKX
Within an ECC or HANA version of SAP you can also view further information about V_OLR3_EKKX and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects