OIJ_OIL_ADD_IO SAP (Additional ED and TDP Fields) Structure details
Description: Additional ED and TDP Fields
Related tables to OIJ_OIL_ADD_IO
Access table OIJ_OIL_ADD_IO
Structure field list including key, data, relationships and ABAP select examples
OIJ_OIL_ADD_IO 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 "Additional ED and TDP 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_IO TYPE OIJ_OIL_ADD_IO.
The OIJ_OIL_ADD_IO table consists of various fields, each holding specific information or linking keys about Additional ED and TDP 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_IO 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 | |||
OITAXGRP_TEXT | Text, 40 Characters Long | TEXT40 | CHAR | 40 | TEXT40 | ||||
OIHANTYP_TEXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
OIINEX_TEXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
OITAXFROM_TEXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
OITAXTO_TEXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
OIHANTYPGI_TEXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
OITAXGRPGI_TEXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
OIINEX_GI_TEXT | Text (20 Characters) | TEXT20 | CHAR | 20 | TEXT20 | ||||
LOG_PROC_TEXT | Text | TEXT1 | CHAR | 50 | TEXT50 | ||||
TAX_PROC_TEXT | Text | TEXT1 | CHAR | 50 | TEXT50 | ||||
BWTAR_INTRANSIT | Valuation Type in Transit | OIH_VALTYP_TRAN | CHAR | 10 | T149D | BWTAR | |||
HT_GL | Excise Duty Handling Type Gain/Loss | OIH_HANTYP_GL | CHAR | 2 | OIH5 | OIH_HANTYP | |||
HT_LOAD | Excise Duty Handling Type at Load | OIH_HANTYP_LD | CHAR | 2 | OIH5 | OIH_HANTYP | |||
HT_DIS | Excise Duty Handling Type at Discharge | OIH_HANTYP_DS | CHAR | 2 | OIH5 | OIH_HANTYP | |||
LICIN_NUM | Excise tax internal license number | OIH_LICIN | CHAR | 10 | Assigned to domain | ALPHA | OIH_LICIN | OIH | OIHL |
LICEXT_NUM | Excise tax external license number | OIH_CERTF1 | CHAR | 15 | OIH_CERTF1 | ||||
OIH_DISTLIC | Distributor License | OIH_DISTLIC | CHAR | 1 | CHAR1 | ||||
SHIP_FROM | Ship From | OIH_SHIP_FROM | CHAR | 10 | LFA1 | ALPHA | LIFNR | ||
DUTY_TO | Duty To | OIH_DUTYTO | CHAR | 10 | KNA1 | ALPHA | KUNNR |
Key field | Non-key field |
How do I retrieve data from SAP structure OIJ_OIL_ADD_IO using ABAP code?
As OIJ_OIL_ADD_IO 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_IO as there is no data to select.How to access SAP table OIJ_OIL_ADD_IO
Within an ECC or HANA version of SAP you can also view further information about OIJ_OIL_ADD_IO 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