OIJ_OIL_ADD_INCL SAP (Adiitional IS-OIL Fields) Structure details
Dictionary Type: Structure
Description: Adiitional IS-OIL Fields
Description: Adiitional IS-OIL Fields
ABAP Code to SELECT data from OIJ_OIL_ADD_INCL
Related tables to OIJ_OIL_ADD_INCL
Access table OIJ_OIL_ADD_INCL
Related tables to OIJ_OIL_ADD_INCL
Access table OIJ_OIL_ADD_INCL
Structure field list including key, data, relationships and ABAP select examples
OIJ_OIL_ADD_INCL 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 "Adiitional IS-OIL Fields" 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_OIJ_OIL_ADD_INCL TYPE OIJ_OIL_ADD_INCL.
The OIJ_OIL_ADD_INCL table consists of various fields, each holding specific information or linking keys about Adiitional IS-OIL Fields data available in SAP. These include OITAXFROM (Excise duty tax key for 'from' location), OIHANTYP (Excise Duty Handling Type), OITAXGRP (Excise Duty Group), OITAXTO (Excise duty tax key for 'to' location).. 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: Can be enhanced (character-type or numeric)
SAP OIJ_OIL_ADD_INCL 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 |
| OITAXFROM | Excise duty tax key for 'from' location | OIH_TAXFRO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
| OIHANTYP | Excise Duty Handling Type | OIH_HANTYP | CHAR | 2 | OIH5 | OIH_HANTYP | |||
| OITAXGRP | Excise Duty Group | OIH_TAXGRP | CHAR | 2 | OIH2 | OIH_TAXGRP | |||
| OITAXTO | Excise duty tax key for 'to' location | OIH_TAXTO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
| OIOILCON | Oil content in a material as a percentage | OIH_OILCON | DEC | 5(2) | OIH_OILCON | ||||
| OIEDBAL | Excise duty balancing is required (indicator) | OIH_EDBAL | CHAR | 1 | X | ||||
| OIPRICIE | ED pricing: external (indicator) | OIH_PRICIE | CHAR | 1 | X | ||||
| OIINEX | Code for internal or external excise duty rate determination | OIH_INEX | CHAR | 2 | OIH16 | OIH_INEX | |||
| OIEDBALM | Excise duty balancing method indicator | OIH_EDBALM | CHAR | 1 | OIH_EDBALM | ||||
| LOG_PROC | Logistic Procedure | OIH_LOGPROC | CHAR | 1 | Assigned to domain | CHAR1 | |||
| TAX_PROC | Tax Procedure | OIH_TAXPROC | CHAR | 2 | Assigned to domain | CHAR2 | |||
| OICERTF1 | Excise tax external license number | OIH_CERTF1 | CHAR | 15 | OIH_CERTF1 | ||||
| OIDATFM1 | Excise Duty License Valid from Date | OIH_DATFM1 | DATS | 8 | DATUM | ||||
| OIDATTO1 | Valid to date for excise duty tax certificate | OIH_DATTO1 | DATS | 8 | DATUM | ||||
| OIH_LICTP | License type | OIH_LICTP | CHAR | 4 | OIH20 | OIH_LICTP | OII | ||
| OIH_LICIN | Excise tax internal license number | OIH_LICIN | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | OIH | OIHL |
| OIH_LCFOL | Follow-on license for quantity license | OIH_LCFOL | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | ||
| OIH_FOLQTY | Excise Tax Follow-On License Quantity | OIH_FOLQTY | QUAN | 13(3) | MENG13 | ||||
| OICERTF1_GI | Excise Tax External License Number Used During GI (STO) | OIH_CERTF1_GI | CHAR | 15 | OIH_CERTF1 | ||||
| OIDATFM1_GI | Excise Duty License Valid from Date for Mat. (STO) | OIH_DATFM1_GI | DATS | 8 | DATUM | ||||
| OIDATTO1_GI | Valid To Date for Excise Duty Tax Certificate for Mat. (STO) | OIH_DATTO1_GI | DATS | 8 | DATUM | ||||
| OIH_LICTP_GI | License Type to Material (STO) | OIH_LICTP_GI | CHAR | 4 | OIH20 | OIH_LICTP | OII | ||
| OIH_LICIN_GI | Excise Tax Internal License Number to Mat. (STO) | OIH_LICIN_GI | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | OIH | OIHL |
| OIH_LCFOL_GI | Follow-On License for Quantity License to Mat. (STO) | OIH_LCFOL_GI | CHAR | 10 | OIHL | ALPHA | OIH_LICIN | ||
| OIH_FOLQTY_GI | Excise Tax Follow-On License Quantity to Mat. (STO) | OIH_FOLQTY_GI | QUAN | 13(3) | MENG13 | ||||
| OIPIPEVAL | Validation indicator for pipeline fields (X=ON, blank=OFF) | OID_PIPEV | CHAR | 1 | X | ||||
| OIC_LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | LFA1 | ALPHA | LIFNR | LIF | KRED_C |
| OIC_DCITYC | Destination city code | OIC_DCITYC | CHAR | 4 | T005G | CITYC | |||
| OIC_DCOUNC | Destination county code | OIC_DCOUNC | CHAR | 3 | T005E | COUNC | |||
| OIC_DREGIO | Destination region | OIC_DREGIO | CHAR | 3 | T005S | REGIO | |||
| OIC_DLAND1 | Destination country | OIC_DLAND1 | CHAR | 3 | T005 | LAND1 | |||
| OIC_OCITYC | Origin city code | OIC_OCITYC | CHAR | 4 | T005G | CITYC | |||
| OIC_OCOUNC | Origin county code | OIC_OCOUNC | CHAR | 3 | T005E | COUNC | |||
| OIC_OREGIO | Origin region | OIC_OREGIO | CHAR | 3 | T005S | REGIO | |||
| OIC_OLAND1 | Origin country | OIC_OLAND1 | CHAR | 3 | T005 | LAND1 | |||
| OIC_PORGIN | Tax origin | OIC_PORGIN | CHAR | 15 | OIC_PORGIN | ||||
| OIC_PDESTN | Tax destination | OIC_PDESTN | CHAR | 15 | OIC_PDESTN | ||||
| OIC_PTRIP | Pipeline trip number (external) | OIC_PTRIP | CHAR | 16 | OIC_PTRIP | ||||
| OIC_PBATCH | Pipeline operator´s external batch number | OIC_PBATCH | CHAR | 16 | OIC_PBATCH | ||||
| OIC_MOT | IS-OIL MAP external details mode of transport | OIC_MOT | CHAR | 2 | TVTR | VKTRA | |||
| OIC_AORGIN | Alternate origin | OIC_AORGIN | CHAR | 15 | OIC_PORGIN | ||||
| OIC_ADESTN | Alternate destination | OIC_ADESTN | CHAR | 15 | OIC_PDESTN | ||||
| OIC_TRUCKN | Truck number | OIC_TRUCKN | CHAR | 10 | OIC_TRUCKN | ||||
| OIA_BASELO | Base location | OIA_BASELO | CHAR | 15 | OIA_BASELO | ||||
| OIEDOK | Excise duty validation indicator | OIH_EDOK | CHAR | 1 | X | ||||
| OIEDOK_GI | Excise Duty Validation Indicator for Material (STO) | OIH_EDOK_GI | CHAR | 1 | X | ||||
| OIEDBAL_GI | Excise Duty Balancing is Required for Mat. (STO) | OIH_EDBAL_GI | CHAR | 1 | X | ||||
| OIEDBALM_GI | Excise Duty Balancing Method Indicator for Mat. (STO) | OIH_EDBALM_GI | CHAR | 1 | OIH_EDBALM | ||||
| OIHANTYP_GI | Excise Duty Handling Type - Denotes Use of Material | OIH_HANTYP_GI | CHAR | 2 | OIH5 | OIH_HANTYP | |||
| OIINEX_GI | Code for Internal or External Excise Duty Rate Determination | OIH_INEX_GI | CHAR | 2 | OIH16 | OIH_INEX | |||
| OITAXGRP_GI | Excise Duty Group | OIH_TAXGRP | CHAR | 2 | OIH2 | OIH_TAXGRP | |||
| OITAXFROM_GI | Excise duty tax key for 'from' location | OIH_TAXFRO | CHAR | 2 | OIH4 | OIH_TAXKEY | |||
| OITAXTO_GI | Excise duty tax key for 'to' location | OIH_TAXTO | CHAR | 2 | OIH4 | OIH_TAXKEY |
| Key field | Non-key field |
How do I retrieve data from SAP structure OIJ_OIL_ADD_INCL using ABAP code?
As OIJ_OIL_ADD_INCL 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 OIJ_OIL_ADD_INCL as there is no data to select.How to access SAP table OIJ_OIL_ADD_INCL
Within an ECC or HANA version of SAP you can also view further information about OIJ_OIL_ADD_INCL 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