SAP Table OIJNOMI
Nomination Item
OIJNOMI (Nomination Item) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OIJNOMI to other SAP tables.
OIJNOMI table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||||||||||
NOMTK | Nomination (technical) Key | OIJ_NOMTK | OIJNOMH | CHAR | 20 | 0 | ||||||||||||||||||||||||||||||||||
NOMIT | Nomination Key Item | OIJ_ITEM | NUMC | 10 | 0 | |||||||||||||||||||||||||||||||||||
SITYP | Schedule type | OIJ_SITYP | TOIJ_EL_SITYPES | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
ISTAT | Nomination Item status | OIJ_ISTAT | OIJSTAT | CHAR | 1 | 0 | ||||||||||||||||||||||||||||||||||
ISUBSTAT | Nomination Item sub-status | OIJ_SSTAT | OIJSUBSTAT | CHAR | 1 | 0 | ||||||||||||||||||||||||||||||||||
IDATE | Scheduled date | OIJ_IDATE | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||||
SCHED_TST_FROM | Scheduled / Acceptance / Pipe Batch Start Timestamp | OIJ_SCHED_F | DEC | 15 | 0 | |||||||||||||||||||||||||||||||||||
SCHED_TST_TO | Scheduled / Acceptance / Pipe Batch End Timestamp | OIJ_SCHED_T | DEC | 15 | 0 | |||||||||||||||||||||||||||||||||||
LOCID | Location ID | OIJ_LOCID | OIJLOC | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
S_MATNR_I | Scheduled material | OIJ_SMATNR | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||||||||||||
MATNR_I | Demand material | OIJ_MATNRI | MARA | CHAR | 18 | 0 | ||||||||||||||||||||||||||||||||||
MENGE | Scheduled qty | OIJ_MENGE | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
UNIT_I | Scheduled UoM | OIJ_UNITI | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||||||
UNIT_I_T | Scheduled UoM Time | OIJ_UNITI_T | UNIT | 3 | 0 | |||||||||||||||||||||||||||||||||||
DOCIND | Reference document indicator (PSX) | OIJ_DOCIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
DOCNR | Nomination Reference Document | OIJ_DOCNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
DOCITM | Nomination Reference Document Item | OIJ_DOCITM | NUMC | 6 | 0 | |||||||||||||||||||||||||||||||||||
DOCSCHEDLN | Nomination Reference Document Schedule line | OIJ_DOCSCHEDLN | NUMC | 4 | 0 | |||||||||||||||||||||||||||||||||||
QTYFCR | First requested quantity | OIJ_QTYFCR | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
QTYFCR_UOM | First Requested Quantity UoM | OIJ_QTYFCR_UOM | UNIT | 3 | 0 | |||||||||||||||||||||||||||||||||||
WORKLIST_I | Worklist entry indicator | OIJ_WORKLT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
TANK | Tankage Partner | OIJ_TANKAGE | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
CONS | Consignee Partner | OIJ_CONSIGNEE | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
PARTNR | Location Partner | OIJ_PARTNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
CONPAT | Contract Partner | OIJ_CONPAT | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
INSPE | Inspector | OIJ_INSPECTOR | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
IMPOEXPO | Import / Export Partner | OIJ_IMEXPO | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
FLAG_IMEX | Import / Export Partner Indicator | OIJ_IMEXFL | OIJIMEX | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OWNER | Valuation Type | BWTAR_D | T149D | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
CHARG_O | Batch origin Location | OIJ_CHARGO | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
CHARG_D | Batch destination Location | OIJ_CHARGD | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
RVP | RVP value | OIJ_RVP | DEC | 4 | 1 | |||||||||||||||||||||||||||||||||||
VALUATIONTYPE_O | Valuation Type Origin Loc. | OIJ_BWTAR_O | T149D | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
VALUATIONTYPE_D | Valuation Type Destination Loc. | OIJ_BWTAR_D | T149D | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
SHNUM | TD shipment number | OIG_SHNUM | OIGS | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
SHITEM | Shipment item | OIG_SHITM | OIGSI | NUMC | 4 | 0 | ||||||||||||||||||||||||||||||||||
ILOCK | Nomination item complete flag | OIJ_ILOCK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
PRORATEQTY | Prorated Quantity | OIJ_PRRA_QTY | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
ASSIGNEDQTY | Assigned Quantity | OIJ_ASSG_QTY | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
ACTDAT | Last item action date | OIJ_ACTDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||||
ACTTIME | Last item action time | OIJ_ACTIME | TIMS | 6 | 0 | |||||||||||||||||||||||||||||||||||
ACTUALS | Nomination item partially complete | OIJ_ACTUAL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
ACTUALQTY | Actual posted quantity | OIJ_ACTQTY | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
ACTUALUOM | Actual posted quantity Unit of Measure | OIJ_ACTUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||||||
ITBOTOL | Quantity tolerance over (percentage) | OIJ_BOTOL | DEC | 4 | 1 | |||||||||||||||||||||||||||||||||||
ITBUTOL | Quantity tolerance under (%) | OIJ_BUTOL | DEC | 4 | 1 | |||||||||||||||||||||||||||||||||||
ITBOTOLABS | Absolute tolerance qty over | OIJ_TOLABO | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
ITBUTOLABS | Absolute tolerance qty under | OIJ_TOLABS | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
ITTOLUNIT | Absolute tolerance UoM | OIJ_TOLUOM | T006 | UNIT | 3 | 0 | ||||||||||||||||||||||||||||||||||
UNLIMITED | Indicator: Unlimited Overdelivery Allowed | UEBTK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
BLOIND | Blocking indicator | OIJ_BLOIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
DELIND | Deletion indicator | OIJ_DELIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
UPDATEXDOK | Update external details failure flag | OIJ_EXDOK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
INCOMPLETE_FLAG | Incompletion Flag | OIJ_INCOMPLETE_FLAG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
DOCTYP | Reference Document Type | OIJ_DOCTYP | CHAR | 4 | 0 | |||||||||||||||||||||||||||||||||||
LDRATE | Planned load/discharge rate | OIJ_EL_LDRATE | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
LDQUOM | Planned load/discharge rate quantity UoM | OIJ_EL_LDQUOM | UNIT | 3 | 0 | |||||||||||||||||||||||||||||||||||
LDTUOM | Planned load/discharge rate time UOM | OIJ_EL_LDTUOM | UNIT | 3 | 0 | |||||||||||||||||||||||||||||||||||
THIRD_NOMNR | Partner Nomination number | OIJ_3RD_NOMNR | CHAR | 20 | 0 | |||||||||||||||||||||||||||||||||||
UPMAT | Pricing reference material of main item | UPMAT | CHAR | 18 | 0 | |||||||||||||||||||||||||||||||||||
REFITEM | Higher-level item in bill of material structures | OIJ_REF_BOM_ITEM | NUMC | 10 | 0 | |||||||||||||||||||||||||||||||||||
STLTY | BOM category | STLTY | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
STLKN | BOM item node number | STLKN | NUMC | 8 | 0 | |||||||||||||||||||||||||||||||||||
CHARG_D_CREATE | Destination Batch create new flag | OIJ_CHARG_D_C | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
CHARG_O_CREATE | Origin Batch create new flag | OIJ_CHARG_O_C | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
CO_CARR | Connecting carrier | OIJ_EL_CCA | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
CO_SHIP | Connecting shipper | OIJ_EL_CSH | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
CO_TSYST | Connecting Transport System | OIJ_EL_CTSYST | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
COMMCTL | Nomination Communication Control | OIJ_NOMCOMM | CHAR | 2 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
SOLDTO | Customer Sold-to or Vendor | OIJ_SOLDTO | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
PRORATE_ROUTINE | Prorate Calculation Routine Type | OIJ_EL_DE_PR_RT | TOIJ_EL_PR_RT | CHAR | 6 | 0 | ||||||||||||||||||||||||||||||||||
CHARG_L | Batch load | OIJ_CHARGL | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
CHARG_L_CREATE | Load Batch create new flag | OIJ_CHARG_L_C | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
TCNUM | TSW :Trading Contract number | OIJ_TCNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
TCITM | TSW: Trading contract item number | OIJ_TCITM | NUMC | 6 | 0 | |||||||||||||||||||||||||||||||||||
GA_NMSHIPPER | Shipper | OIJ_SHIPNR | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
GA_CONF_QTY | Confirmed Quantity | OIJ_CONFQTY | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
GA_CONF_UOM | Unit of Measure for Confirmed Quantity Field | OIJ_CONFUOM | UNIT | 3 | 0 | |||||||||||||||||||||||||||||||||||
GA_TECHSCH_QTY | Technical Scheduled Quantity Field | OIJ_TECHSCHQTY | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
GA_TECHSCH_UOM | Unit of Measure for Technical Scheduled Quantity Field | OIJ_TECHSCHUOM | UNIT | 3 | 0 | |||||||||||||||||||||||||||||||||||
GA_CONF_QTY_CAL | Calculated Values of Confirmed Quantity Field | OIJ_CONFQTY_CAL | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
GA_TSCH_QTY_CAL | Calculated Values of Technical Scheduled Quantity Field | OIJ_TECHSCH_QTY_CAL | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
GA_ALLOCATED_QTY | Allocated Quantity | OIJ_ALLOCATED_QTY | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
GA_ALLOCATED_UOM | Unit of Measure for Allocated Quantity Field | OIJ_ALLOCATED_UOM | UNIT | 3 | 0 | |||||||||||||||||||||||||||||||||||
GA_RANK | Rank | OIJ_RANK | INT1 | 3 | 0 | |||||||||||||||||||||||||||||||||||
CYCLE_ITEM | Nomination Pipeline cycle ID at Item Level | OIJ_ITEMCYCLE | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
LESSHNUM | Shipment Number | TKNUM | VTTK | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
LESTPNUM | Shipment item | TPNUM | VTTP | NUMC | 4 | 0 | ||||||||||||||||||||||||||||||||||
ATL_DELV_NUMBER | ATL credit check delivery number | OIJ_ATL_DELV | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
ATL_DELV_ITM | ATL credit check delivery item | OIJ_ATL_DELV_ITM | NUMC | 6 | 0 | |||||||||||||||||||||||||||||||||||
ATL_CRDT_QTY | ATL Credit Quantity | OIJ_ATL_CREDIT_QTY | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
ATL_CRDT_UOM | Base Unit of Measure | MEINS | UNIT | 3 | 0 | |||||||||||||||||||||||||||||||||||
ATL_CRDT_VAL | ATL Credit Amount | OIJ_ATL_CREDIT_AMT | CURR | 15 | 2 | |||||||||||||||||||||||||||||||||||
ATL_CRDT_CURR | ATL Credit Currency | OIJ_ATL_CREDIT_CURR | CUKY | 5 | 0 | |||||||||||||||||||||||||||||||||||
PRE_EXIST_IND | ATL Preexisting Delivery Indicator | OIJ_ATL_PREEXIST_IND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
PLANIND | Planning location flag | OIJ_PLANIN | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
LOCPT | Location Partner Plant | OIJ_LOCPT | T001W | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||||
LOCSL | Location Partner Storage Location | OIJ_LOCSL | T001L | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||||
QUICKCONF | Quick Confirm check box | OIJ_QC | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
ERDAT | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||||
ERZEIT | Time of creation | OI0_ERTIM | TIMS | 6 | 0 | |||||||||||||||||||||||||||||||||||
ERNAM | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||||||||
AEDAT | Changed On | AEDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||||
AEZEIT | Time of day the record was changed | OI0_AETIM | TIMS | 6 | 0 | |||||||||||||||||||||||||||||||||||
AENAM | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||||||||
LOCNAM | Location name (used by system owner) | OIJ_LOCNAM | CHAR | 60 | 0 | |||||||||||||||||||||||||||||||||||
VBELN | Delivery | VBELN_VL | VBUK | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
POSNR | Delivery Item | POSNR_VL | VBUP | NUMC | 6 | 0 | ||||||||||||||||||||||||||||||||||
NOMIT_CONS | OIL-TSW: Referenced nomination item for bunker consumption | OIJ_NOMIT_CONS | NUMC | 10 | 0 | |||||||||||||||||||||||||||||||||||
ACTUALQTY_PAR | Actual posted parallel quantity | OIJ_ACTQTY_PAR | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
ACTUALUOM_PAR | Actual posted quantity Parallel Unit of Measure | OIJ_ACTUOM_PAR | UNIT | 3 | 0 | |||||||||||||||||||||||||||||||||||
LOV_IND | TSW: Ticket Type 'Left on Vehicle' | OIJ_LOV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
FERRYIND | By Ferry | OIJ_RU_FERRIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
RAILCARQTY | Number of Railcars | OIJ_RU_RAILQTY | INT4 | 10 | 0 | |||||||||||||||||||||||||||||||||||
OITAXFROM | Excise duty tax key for 'from' location | OIH_TAXFRO | OIH4 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OIHANTYP | Excise Duty Handling Type | OIH_HANTYP | OIH5 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OITAXGRP | Excise Duty Group | OIH_TAXGRP | OIH2 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OITAXTO | Excise duty tax key for 'to' location | OIH_TAXTO | OIH4 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OIOILCON | Oil content in a material as a percentage | OIH_OILCON | DEC | 5 | 2 |
Possible values
|
||||||||||||||||||||||||||||||||||
OIEDBAL | Excise duty balancing is required (indicator) | OIH_EDBAL | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
OIPRICIE | ED pricing: external (indicator) | OIH_PRICIE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
OIINEX | Code for internal or external excise duty rate determination | OIH_INEX | OIH16 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OIEDBALM | Excise duty balancing method indicator | OIH_EDBALM | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
LOG_PROC | Logistic Procedure | OIH_LOGPROC | CHAR | 1 | 0 | |||||||||||||||||||||||||||||||||||
TAX_PROC | Tax Procedure | OIH_TAXPROC | CHAR | 2 | 0 | |||||||||||||||||||||||||||||||||||
OICERTF1 | Excise tax external license number | OIH_CERTF1 | CHAR | 15 | 0 | |||||||||||||||||||||||||||||||||||
OIDATFM1 | Excise Duty License Valid from Date | OIH_DATFM1 | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||||
OIDATTO1 | Valid to date for excise duty tax certificate | OIH_DATTO1 | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||||
OIH_LICTP | License type | OIH_LICTP | OIH20 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||||
OIH_LICIN | Excise tax internal license number | OIH_LICIN | OIHL | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
OIH_LCFOL | Follow-on license for quantity license | OIH_LCFOL | OIHL | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
OIH_FOLQTY | Excise Tax Follow-On License Quantity | OIH_FOLQTY | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
OICERTF1_GI | Excise Tax External License Number Used During GI (STO) | OIH_CERTF1_GI | CHAR | 15 | 0 | |||||||||||||||||||||||||||||||||||
OIDATFM1_GI | Excise Duty License Valid from Date for Mat. (STO) | OIH_DATFM1_GI | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||||
OIDATTO1_GI | Valid To Date for Excise Duty Tax Certificate for Mat. (STO) | OIH_DATTO1_GI | DATS | 8 | 0 | |||||||||||||||||||||||||||||||||||
OIH_LICTP_GI | License Type to Material (STO) | OIH_LICTP_GI | OIH20 | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||||
OIH_LICIN_GI | Excise Tax Internal License Number to Mat. (STO) | OIH_LICIN_GI | OIHL | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
OIH_LCFOL_GI | Follow-On License for Quantity License to Mat. (STO) | OIH_LCFOL_GI | OIHL | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
OIH_FOLQTY_GI | Excise Tax Follow-On License Quantity to Mat. (STO) | OIH_FOLQTY_GI | QUAN | 13 | 3 | |||||||||||||||||||||||||||||||||||
OIPIPEVAL | Validation indicator for pipeline fields (X=ON, blank=OFF) | OID_PIPEV | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
OIC_LIFNR | Account Number of Vendor or Creditor | LIFNR | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
OIC_DCITYC | Destination city code | OIC_DCITYC | T005G | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||||
OIC_DCOUNC | Destination county code | OIC_DCOUNC | T005E | CHAR | 3 | 0 | ||||||||||||||||||||||||||||||||||
OIC_DREGIO | Destination region | OIC_DREGIO | T005S | CHAR | 3 | 0 | ||||||||||||||||||||||||||||||||||
OIC_DLAND1 | Destination country | OIC_DLAND1 | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||||||||||||||
OIC_OCITYC | Origin city code | OIC_OCITYC | T005G | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||||||
OIC_OCOUNC | Origin county code | OIC_OCOUNC | T005E | CHAR | 3 | 0 | ||||||||||||||||||||||||||||||||||
OIC_OREGIO | Origin region | OIC_OREGIO | T005S | CHAR | 3 | 0 | ||||||||||||||||||||||||||||||||||
OIC_OLAND1 | Origin country | OIC_OLAND1 | T005 | CHAR | 3 | 0 | ||||||||||||||||||||||||||||||||||
OIC_PORGIN | Tax origin | OIC_PORGIN | CHAR | 15 | 0 | |||||||||||||||||||||||||||||||||||
OIC_PDESTN | Tax destination | OIC_PDESTN | CHAR | 15 | 0 | |||||||||||||||||||||||||||||||||||
OIC_PTRIP | Pipeline trip number (external) | OIC_PTRIP | CHAR | 16 | 0 | |||||||||||||||||||||||||||||||||||
OIC_PBATCH | Pipeline operator�s external batch number | OIC_PBATCH | CHAR | 16 | 0 | |||||||||||||||||||||||||||||||||||
OIC_MOT | IS-OIL MAP external details mode of transport | OIC_MOT | TVTR | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OIC_AORGIN | Alternate origin | OIC_AORGIN | CHAR | 15 | 0 | |||||||||||||||||||||||||||||||||||
OIC_ADESTN | Alternate destination | OIC_ADESTN | CHAR | 15 | 0 | |||||||||||||||||||||||||||||||||||
OIC_TRUCKN | Truck number | OIC_TRUCKN | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
OIA_BASELO | Base location | OIA_BASELO | CHAR | 15 | 0 | |||||||||||||||||||||||||||||||||||
OIEDOK | Excise duty validation indicator | OIH_EDOK | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
OIEDOK_GI | Excise Duty Validation Indicator for Material (STO) | OIH_EDOK_GI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
OIEDBAL_GI | Excise Duty Balancing is Required for Mat. (STO) | OIH_EDBAL_GI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
OIEDBALM_GI | Excise Duty Balancing Method Indicator for Mat. (STO) | OIH_EDBALM_GI | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||||||
OIHANTYP_GI | Excise Duty Handling Type - Denotes Use of Material | OIH_HANTYP_GI | OIH5 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OIINEX_GI | Code for Internal or External Excise Duty Rate Determination | OIH_INEX_GI | OIH16 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OITAXGRP_GI | Excise Duty Group | OIH_TAXGRP | OIH2 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OITAXFROM_GI | Excise duty tax key for 'from' location | OIH_TAXFRO | OIH4 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
OITAXTO_GI | Excise duty tax key for 'to' location | OIH_TAXTO | OIH4 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
BWTAR_INTRANSIT | Valuation Type in Transit | OIH_VALTYP_TRAN | T149D | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
HT_GL | Excise Duty Handling Type Gain/Loss | OIH_HANTYP_GL | OIH5 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
HT_LOAD | Excise Duty Handling Type at Load | OIH_HANTYP_LD | OIH5 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
HT_DIS | Excise Duty Handling Type at Discharge | OIH_HANTYP_DS | OIH5 | CHAR | 2 | 0 | ||||||||||||||||||||||||||||||||||
LICIN_NUM | Excise tax internal license number | OIH_LICIN | CHAR | 10 | 0 | |||||||||||||||||||||||||||||||||||
LICEXT_NUM | Excise tax external license number | OIH_CERTF1 | CHAR | 15 | 0 | |||||||||||||||||||||||||||||||||||
OIH_DISTLIC | Distributor License | OIH_DISTLIC | CHAR | 1 | 0 | |||||||||||||||||||||||||||||||||||
SHIP_FROM | Ship From | OIH_SHIP_FROM | LFA1 | CHAR | 10 | 0 | ||||||||||||||||||||||||||||||||||
DUTY_TO | Duty To | OIH_DUTYTO | KNA1 | CHAR | 10 | 0 |
OIJNOMI foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
OIJNOMI | ACTUALUOM | OIJNOMI | MANDT | T006 | Units of Measurement | MANDT |
OIJNOMI | ACTUALUOM | OIJNOMI | ACTUALUOM | T006 | Units of Measurement | MSEHI |
OIJNOMI | BWTAR_INTRANSIT | SYST | MANDT | T149D | Global Valuation Types | MANDT |
OIJNOMI | BWTAR_INTRANSIT | OIJNOMI | BWTAR_INTRANSIT | T149D | Global Valuation Types | BWTAR |
OIJNOMI | DUTY_TO | SYST | MANDT | KNA1 | General Data in Customer Master | MANDT |
OIJNOMI | DUTY_TO | OIJNOMI | DUTY_TO | KNA1 | General Data in Customer Master | KUNNR |
OIJNOMI | FLAG_IMEX | OIJNOMI | MANDT | OIJIMEX | OIL-TSW: Flag for importer/exporter or others | MANDT |
OIJNOMI | FLAG_IMEX | OIJNOMI | FLAG_IMEX | OIJIMEX | OIL-TSW: Flag for importer/exporter or others | FLAG_IMEX |
OIJNOMI | HT_DIS | OIJNOMI | HT_DIS | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
OIJNOMI | HT_DIS | SYST | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
OIJNOMI | HT_GL | SYST | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
OIJNOMI | HT_GL | OIJNOMI | HT_GL | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
OIJNOMI | HT_LOAD | SYST | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
OIJNOMI | HT_LOAD | OIJNOMI | HT_LOAD | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
OIJNOMI | IMPOEXPO | OIJNOMI | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
OIJNOMI | IMPOEXPO | OIJNOMI | IMPOEXPO | LFA1 | Vendor Master (General Section) | LIFNR |
OIJNOMI | ISTAT | OIJNOMI | MANDT | OIJSTAT | OIL-TSW : Status Table | MANDT |
OIJNOMI | ISTAT | 'OIJNOMI' | OIJSTAT | OIL-TSW : Status Table | TABNAME | |
OIJNOMI | ISTAT | OIJNOMI | ISTAT | OIJSTAT | OIL-TSW : Status Table | STATUS |
OIJNOMI | ISUBSTAT | OIJNOMI | ISTAT | OIJSUBSTAT | OIL-TSW : Substatus Table | STATUS |
OIJNOMI | ISUBSTAT | OIJNOMI | ISUBSTAT | OIJSUBSTAT | OIL-TSW : Substatus Table | SUBSTATUS |
OIJNOMI | ISUBSTAT | OIJNOMI | MANDT | OIJSUBSTAT | OIL-TSW : Substatus Table | MANDT |
OIJNOMI | ISUBSTAT | 'OIJNOMI' | OIJSUBSTAT | OIL-TSW : Substatus Table | TABNAME | |
OIJNOMI | ITTOLUNIT | OIJNOMI | ITTOLUNIT | T006 | Units of Measurement | MSEHI |
OIJNOMI | ITTOLUNIT | OIJNOMI | MANDT | T006 | Units of Measurement | MANDT |
OIJNOMI | LESSHNUM | SYST | MANDT | VTTK | Shipment Header | MANDT |
OIJNOMI | LESSHNUM | OIJNOMI | LESSHNUM | VTTK | Shipment Header | TKNUM |
OIJNOMI | LESTPNUM | OIJNOMI | LESTPNUM | VTTP | Shipment Item | TPNUM |
OIJNOMI | LESTPNUM | SYST | MANDT | VTTP | Shipment Item | MANDT |
OIJNOMI | LESTPNUM | OIJNOMI | LESSHNUM | VTTP | Shipment Item | TKNUM |
OIJNOMI | LOCID | OIJNOMI | MANDT | OIJLOC | Location table | MANDT |
OIJNOMI | LOCID | OIJNOMI | LOCID | OIJLOC | Location table | LOCID |
OIJNOMI | LOCPT | OIJNOMI | MANDT | T001W | Plants/Branches | MANDT |
OIJNOMI | LOCPT | OIJNOMI | LOCPT | T001W | Plants/Branches | WERKS |
OIJNOMI | LOCSL | OIJNOMI | LOCSL | T001L | Storage Locations | LGORT |
OIJNOMI | LOCSL | OIJNOMI | MANDT | T001L | Storage Locations | MANDT |
OIJNOMI | LOCSL | OIJNOMI | LOCPT | T001L | Storage Locations | WERKS |
OIJNOMI | MANDT | OIJNOMI | MANDT | T000 | Clients | MANDT |
OIJNOMI | MATNR_I | OIJNOMI | MANDT | MARA | General Material Data | MANDT |
OIJNOMI | MATNR_I | OIJNOMI | MATNR_I | MARA | General Material Data | MATNR |
OIJNOMI | NOMTK | OIJNOMI | NOMTK | OIJNOMH | Nomination Header | NOMTK |
OIJNOMI | NOMTK | OIJNOMI | MANDT | OIJNOMH | Nomination Header | MANDT |
OIJNOMI | OIC_DCITYC | OIJNOMI | OIC_DLAND1 | T005G | City | LAND1 |
OIJNOMI | OIC_DCITYC | OIJNOMI | OIC_DREGIO | T005G | City | REGIO |
OIJNOMI | OIC_DCITYC | OIJNOMI | OIC_DCITYC | T005G | City | CITYC |
OIJNOMI | OIC_DCITYC | SYST | MANDT | T005G | City | MANDT |
OIJNOMI | OIC_DCOUNC | SYST | MANDT | T005E | County | MANDT |
OIJNOMI | OIC_DCOUNC | OIJNOMI | OIC_DLAND1 | T005E | County | LAND1 |
OIJNOMI | OIC_DCOUNC | OIJNOMI | OIC_DREGIO | T005E | County | REGIO |
OIJNOMI | OIC_DCOUNC | OIJNOMI | OIC_DCOUNC | T005E | County | COUNC |
OIJNOMI | OIC_DLAND1 | SYST | MANDT | T005 | Countries | MANDT |
OIJNOMI | OIC_DLAND1 | OIJNOMI | OIC_DLAND1 | T005 | Countries | LAND1 |
OIJNOMI | OIC_DREGIO | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
OIJNOMI | OIC_DREGIO | OIJNOMI | OIC_DLAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
OIJNOMI | OIC_DREGIO | OIJNOMI | OIC_DREGIO | T005S | Taxes: Region (Province) Key | BLAND |
OIJNOMI | OIC_LIFNR | SYST | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
OIJNOMI | OIC_LIFNR | OIJNOMI | OIC_LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
OIJNOMI | OIC_MOT | SYST | MANDT | TVTR | Routes: Modes of Transport | MANDT |
OIJNOMI | OIC_MOT | OIJNOMI | OIC_MOT | TVTR | Routes: Modes of Transport | VKTRA |
OIJNOMI | OIC_OCITYC | OIJNOMI | OIC_OREGIO | T005G | City | REGIO |
OIJNOMI | OIC_OCITYC | OIJNOMI | OIC_OCITYC | T005G | City | CITYC |
OIJNOMI | OIC_OCITYC | SYST | MANDT | T005G | City | MANDT |
OIJNOMI | OIC_OCITYC | OIJNOMI | OIC_OLAND1 | T005G | City | LAND1 |
OIJNOMI | OIC_OCOUNC | SYST | MANDT | T005E | County | MANDT |
OIJNOMI | OIC_OCOUNC | OIJNOMI | OIC_OLAND1 | T005E | County | LAND1 |
OIJNOMI | OIC_OCOUNC | OIJNOMI | OIC_OREGIO | T005E | County | REGIO |
OIJNOMI | OIC_OCOUNC | OIJNOMI | OIC_OCOUNC | T005E | County | COUNC |
OIJNOMI | OIC_OLAND1 | SYST | MANDT | T005 | Countries | MANDT |
OIJNOMI | OIC_OLAND1 | OIJNOMI | OIC_OLAND1 | T005 | Countries | LAND1 |
OIJNOMI | OIC_OREGIO | OIJNOMI | OIC_OLAND1 | T005S | Taxes: Region (Province) Key | LAND1 |
OIJNOMI | OIC_OREGIO | OIJNOMI | OIC_OREGIO | T005S | Taxes: Region (Province) Key | BLAND |
OIJNOMI | OIC_OREGIO | SYST | MANDT | T005S | Taxes: Region (Province) Key | MANDT |
OIJNOMI | OIHANTYP | SYST | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
OIJNOMI | OIHANTYP | OIJNOMI | OIHANTYP | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
OIJNOMI | OIHANTYP_GI | SYST | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
OIJNOMI | OIHANTYP_GI | OIJNOMI | OIHANTYP_GI | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
OIJNOMI | OIH_LCFOL | OIJNOMI | OIH_LCFOL | OIHL | License Master Data | LICIN |
OIJNOMI | OIH_LCFOL | OIJNOMI | OIH_LICTP | OIHL | License Master Data | LICTP |
OIJNOMI | OIH_LCFOL | MSEG | MANDT | OIHL | License Master Data | MANDT |
OIJNOMI | OIH_LCFOL_GI | SYST | MANDT | OIHL | License Master Data | MANDT |
OIJNOMI | OIH_LCFOL_GI | OIJNOMI | OIH_LCFOL_GI | OIHL | License Master Data | LICIN |
OIJNOMI | OIH_LCFOL_GI | OIJNOMI | OIH_LICTP_GI | OIHL | License Master Data | LICTP |
OIJNOMI | OIH_LICIN | OIJNOMI | OIH_LICIN | OIHL | License Master Data | LICIN |
OIJNOMI | OIH_LICIN | * | OIHL | License Master Data | LICTP | |
OIJNOMI | OIH_LICIN | MSEG | MANDT | OIHL | License Master Data | MANDT |
OIJNOMI | OIH_LICIN_GI | SYST | MANDT | OIHL | License Master Data | MANDT |
OIJNOMI | OIH_LICIN_GI | OIJNOMI | OIH_LICIN_GI | OIHL | License Master Data | LICIN |
OIJNOMI | OIH_LICIN_GI | * | OIHL | License Master Data | LICTP | |
OIJNOMI | OIH_LICTP | MSEG | MANDT | OIH20 | License types | MANDT |
OIJNOMI | OIH_LICTP | OIJNOMI | OIH_LICTP | OIH20 | License types | LICTP |
OIJNOMI | OIH_LICTP_GI | SYST | MANDT | OIH20 | License types | MANDT |
OIJNOMI | OIH_LICTP_GI | OIJNOMI | OIH_LICTP_GI | OIH20 | License types | LICTP |
OIJNOMI | OIINEX | SYST | MANDT | OIH16 | Internal/external price conditions | MANDT |
OIJNOMI | OIINEX | OIJNOMI | OIINEX | OIH16 | Internal/external price conditions | INEX |
OIJNOMI | OIINEX_GI | SYST | MANDT | OIH16 | Internal/external price conditions | MANDT |
OIJNOMI | OIINEX_GI | OIJNOMI | OIINEX_GI | OIH16 | Internal/external price conditions | INEX |
OIJNOMI | OITAXFROM | SYST | MANDT | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | MANDT |
OIJNOMI | OITAXFROM | OIJNOMI | OITAXFROM | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | TAXKEY |
OIJNOMI | OITAXFROM_GI | OIJNOMI | OITAXFROM_GI | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | TAXKEY |
OIJNOMI | OITAXFROM_GI | SYST | MANDT | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | MANDT |
OIJNOMI | OITAXGRP | OIJNOMI | OITAXGRP | OIH2 | Excise duty tax group (IS-Oil TDP standard/core object) | TAXGRP |
OIJNOMI | OITAXGRP | SYST | MANDT | OIH2 | Excise duty tax group (IS-Oil TDP standard/core object) | MANDT |
OIJNOMI | OITAXGRP_GI | SYST | MANDT | OIH2 | Excise duty tax group (IS-Oil TDP standard/core object) | MANDT |
OIJNOMI | OITAXGRP_GI | OIJNOMI | OITAXGRP_GI | OIH2 | Excise duty tax group (IS-Oil TDP standard/core object) | TAXGRP |
OIJNOMI | OITAXTO | SYST | MANDT | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | MANDT |
OIJNOMI | OITAXTO | OIJNOMI | OITAXTO | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | TAXKEY |
OIJNOMI | OITAXTO_GI | SYST | MANDT | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | MANDT |
OIJNOMI | OITAXTO_GI | OIJNOMI | OITAXTO_GI | OIH4 | Excise duty tax status (IS-Oil TDP standard/core object) | TAXKEY |
OIJNOMI | OWNER | OIJNOMI | MANDT | T149D | Global Valuation Types | MANDT |
OIJNOMI | OWNER | OIJNOMI | OWNER | T149D | Global Valuation Types | BWTAR |
OIJNOMI | POSNR | OIJNOMI | POSNR | VBUP | Sales Document: Item Status | POSNR |
OIJNOMI | POSNR | OIJNOMI | MANDT | VBUP | Sales Document: Item Status | MANDT |
OIJNOMI | POSNR | OIJNOMI | VBELN | VBUP | Sales Document: Item Status | VBELN |
OIJNOMI | PRORATE_ROUTINE | OIJNOMI | PRORATE_ROUTINE | TOIJ_EL_PR_RT | Prorate Calculation Routine Type | PRORATE_ROUTINE |
OIJNOMI | SHIP_FROM | SYST | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
OIJNOMI | SHIP_FROM | OIJNOMI | SHIP_FROM | LFA1 | Vendor Master (General Section) | LIFNR |
OIJNOMI | SHITEM | OIJNOMI | SHITEM | OIGSI | Shipment Item | SHITEM |
OIJNOMI | SHITEM | OIJNOMI | MANDT | OIGSI | Shipment Item | CLIENT |
OIJNOMI | SHITEM | OIJNOMI | SHNUM | OIGSI | Shipment Item | SHNUMBER |
OIJNOMI | SHNUM | OIJNOMI | MANDT | OIGS | TD Shipment Header | CLIENT |
OIJNOMI | SHNUM | OIJNOMI | SHNUM | OIGS | TD Shipment Header | SHNUMBER |
OIJNOMI | SITYP | SYST | MANDT | TOIJ_EL_SITYPES | TSW: Define valid sitypes | CLIENT |
OIJNOMI | SITYP | OIJNOMI | SITYP | TOIJ_EL_SITYPES | TSW: Define valid sitypes | SITYP |
OIJNOMI | S_MATNR_I | OIJNOMI | S_MATNR_I | MARA | General Material Data | MATNR |
OIJNOMI | S_MATNR_I | OIJNOMI | MANDT | MARA | General Material Data | MANDT |
OIJNOMI | UNIT_I | OIJNOMI | MANDT | T006 | Units of Measurement | MANDT |
OIJNOMI | UNIT_I | OIJNOMI | UNIT_I | T006 | Units of Measurement | MSEHI |
OIJNOMI | VALUATIONTYPE_D | SYST | MANDT | T149D | Global Valuation Types | MANDT |
OIJNOMI | VALUATIONTYPE_D | OIJNOMI | VALUATIONTYPE_D | T149D | Global Valuation Types | BWTAR |
OIJNOMI | VALUATIONTYPE_O | SYST | MANDT | T149D | Global Valuation Types | MANDT |
OIJNOMI | VALUATIONTYPE_O | OIJNOMI | VALUATIONTYPE_O | T149D | Global Valuation Types | BWTAR |
OIJNOMI | VBELN | OIJNOMI | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
OIJNOMI | VBELN | OIJNOMI | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |