E3OILO1 SAP (RO item core data) Structure details
Description: RO item core data
Structure field list including key, data, relationships and ABAP select examples
E3OILO1 is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "RO item core data" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_E3OILO1 TYPE E3OILO1.
The E3OILO1 table consists of various fields, each holding specific information or linking keys about RO item core data data available in SAP. These include POSNR (Item number of the SD document), MATNR (Material Number), TQUANT (Target quantity in sales units), CONVFAK (Factor for converting sales units to base units (target qty)).. 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: Cannot Be Enhanced
SAP E3OILO1 structure 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 |
| POID | Sales and Distribution Document Number | VBELN | CHAR | 10 | Assigned to domain | ALPHA | VBELN | AUN | |
| POSNR | Item number of the SD document | POSNR | NUMC | 6 | Assigned to domain | POSNR | |||
| MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
| TQUANT | Target quantity in sales units | DZMENG | QUAN | 13(3) | MENG13 | ||||
| CONVFAK | Factor for converting sales units to base units (target qty) | UMZIZ | DEC | 5 | UMBSZ | ||||
| SCAQUA | Scale quantity in base unit of measure | SMENG | QUAN | 13(3) | MENG13 | ||||
| REDATE | Reconciliation Date for Agreed Cumulative Quantity | ABDAT | DATS | 8 | DATUM | ||||
| QUANDEV | Allowed deviation in quantity (absolute) | ABSFZ | QUAN | 13(3) | MENG13 | ||||
| POITEM | Item Number of the Underlying Purchase Order | POSEX | CHAR | 6 | ALPHA | POSEX | |||
| RELDEV | Allowed deviation in quantity (in percent) | KBVER | DEC | 3 | PACK2 | ||||
| DAYSHIFT | Days by which the quantity can be shifted | KEVER | DEC | 3 | PACK2 | ||||
| FQIND | Quantity is Fixed | FMENG | CHAR | 1 | XFELD | ||||
| UOIND | Unlimited overdelivery allowed | UEBTK_V | CHAR | 1 | XFELD | ||||
| ODTOLLI | Overdelivery Tolerance Limit | UEBTO | DEC | 3(1) | PRZ21 | ||||
| UDTOLLI | Underdelivery Tolerance Limit | UNTTO | DEC | 3(1) | PRZ21 | ||||
| NMBPD | Maximum Number of Partial Deliveries Allowed Per Item | ANTLF | DEC | 1 | ANTLF | ||||
| PDIND | Partial delivery at item level | KZTLF | CHAR | 1 | KZTLF | ||||
| BSIND | Batch split allowed | CHSPL | CHAR | 1 | XFELD | ||||
| COQUAN | Cumulative Order Quantity in Sales Units | KWMENG | QUAN | 15(3) | MENG15 | ||||
| CRDQUAN | Cumulative required delivery qty (all dlv-relev.sched.lines) | LSMENG | QUAN | 15(3) | MENG15 | ||||
| CCQUANSU | Cumulative confirmed quantity in sales unit | KBMENG | QUAN | 15(3) | MENG15 | ||||
| CCQUANBU | Cumulative confirmed quantity in base unit | KLMENG | QUAN | 15(3) | MENG15 | ||||
| SALUNIT | Sales unit | VRKME | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
| DELPRI | Delivery Priority | LPRIO | NUMC | 2 | Assigned to domain | LPRIO | |||
| PLANT | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
| STRLOC | Storage Location | LGORT_D | CHAR | 4 | Assigned to domain | LGORT | LAG | ||
| SHPPNT | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | Assigned to domain | VSTEL | VST | ||
| ROUTE | Route | ROUTE | CHAR | 6 | Assigned to domain | ROUTE | |||
| FSPT | Fixed shipping processing time in days (= setup time) | VBEAF | DEC | 5(2) | DEC3_2 | ||||
| VSPT | Character field, 8 characters long | CHAR8 | CHAR | 8 | CHAR8 | ||||
| MINDQUAN | Minimum delivery quantity in delivery note processing | MINLF | QUAN | 13(3) | MENG13 | ||||
| DDQIND | Delivery date and quantity fixed | FIXMG | CHAR | 1 | XFELD | ||||
| PROCENT | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
| PLMAT | Planning material | VPMAT | CHAR | 18 | Assigned to domain | MATN1 | MATNR | ||
| PLPLANT | Not More Closely Defined Area, Possibly Used for Patchlevels | CHAR4 | CHAR | 4 | CHAR4 | ||||
| REQTYPE | Requirements type | BEDAE | CHAR | 4 | Assigned to domain | BEDAE | BDA |
| Key field | Non-key field |
How do I retrieve data from SAP structure E3OILO1 using ABAP code?
As E3OILO1 is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on E3OILO1 as there is no data to select.How to access SAP table E3OILO1
Within an ECC or HANA version of SAP you can also view further information about E3OILO1 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