Cds_Oijnomi

cds view for oijnomi | view: V_OIJNOMI | TRAN | Extraction: Not supported | Component: Trader's and Scheduler's Workbench
Tables used: OIJNOMI
Column Name Description
NOMTK FK Nomination (technical) Key
NOMIT Nomination Key Item
Column Name Description
💲 ATL Credit Currency (ATL_CRDT_CURR):
ATL_CRDT_VAL ATL Credit Amount
Column Name Description
📏 Scheduled UoM (UNIT_I):
MENGE Scheduled qty
PRORATEQTY Prorated Quantity
ASSIGNEDQTY Assigned Quantity
📏 First Requested Quantity UoM (QTYFCR_UOM):
QTYFCR First requested quantity
📏 Actual posted quantity Unit of Measure (ACTUALUOM):
ACTUALQTY Actual posted quantity
📏 Absolute tolerance UoM (ITTOLUNIT):
ITBOTOLABS Absolute tolerance qty over
ITBUTOLABS Absolute tolerance qty under
📏 Planned load/discharge rate quantity UoM (LDQUOM):
LDRATE Planned load/discharge rate
📏 Unit of Measure for Confirmed Quantity Field (GA_CONF_UOM):
GA_CONF_QTY Confirmed Quantity
GA_CONF_QTY_CAL Calculated Values of Confirmed Quantity Field
📏 Unit of Measure for Technical Scheduled Quantity Field (GA_TECHSCH_UOM):
GA_TECHSCH_QTY Technical Scheduled Quantity Field
GA_TSCH_QTY_CAL Calculated Values of Technical Scheduled Quantity Field
📏 Unit of Measure for Allocated Quantity Field (GA_ALLOCATED_UOM):
GA_ALLOCATED_QTY Allocated Quantity
📏 Base Unit of Measure (ATL_CRDT_UOM):
ATL_CRDT_QTY ATL Credit Quantity
📏 Actual posted quantity Parallel Unit of Measure (ACTUALUOM_PAR):
ACTUALQTY_PAR Actual posted parallel quantity
OIH_FOLQTY Excise Tax Follow-On License Quantity
OIH_FOLQTY_GI Excise Tax Follow-On License Quantity to Mat. (STO)
Column Name Description
IDATE Scheduled date
ACTDAT Last item action date
ACTTIME Last item action time
ERDAT Date on which the record was created
ERZEIT Time of creation
AEDAT Last Changed On
AEZEIT Time of day the record was changed
OIDATFM1 Excise Duty License Valid from Date
OIDATTO1 Valid to date for excise duty tax certificate
OIDATFM1_GI Excise Duty License Valid from Date for Mat. (STO)
OIDATTO1_GI Valid To Date for Excise Duty Tax Certificate for Mat. (STO)
_DATAAGING Data Filter Value for Data Aging
Column Name Description
DOCIND Reference document indicator (PSX) Show values
WORKLIST_I Worklist entry indicator Show values
ILOCK Nomination item complete flag Show values
ACTUALS Nomination item partially complete Show values
UNLIMITED Unlimited Overdelivery Allowed Show values
BLOIND Blocking indicator Show values
DELIND Deletion indicator Show values
UPDATEXDOK Update external details failure flag Show values
INCOMPLETE_FLAG Incompletion Flag Show values
STLTY BOM category Show values
CHARG_D_CREATE Destination Batch create new flag Show values
CHARG_O_CREATE Origin Batch create new flag Show values
COMMCTL Nomination Communication Control Show values
CHARG_L_CREATE Load Batch create new flag Show values
PRE_EXIST_IND ATL Preexisting Delivery Indicator Show values
PLANIND Planning location flag Show values
QUICKCONF Quick Confirm check box Show values
LOV_IND TSW: Ticket Type 'Left on Vehicle' Show values
FERRYIND By Ferry Show values
OIOILCON Oil content in a material as a percentage Show values
OIEDBAL Excise duty balancing is required (indicator) Show values
OIPRICIE ED pricing: external (indicator) Show values
OIEDBALM Excise duty balancing method indicator Show values
OIPIPEVAL Validation indicator for pipeline fields (X=ON, blank=OFF) Show values
OIEDOK Excise duty validation indicator Show values
OIEDOK_GI Excise Duty Validation Indicator for Material (STO) Show values
OIEDBAL_GI Excise Duty Balancing is Required for Mat. (STO) Show values
OIEDBALM_GI Excise Duty Balancing Method Indicator for Mat. (STO) Show values
Column Name Description Domain name
SCHED_TST_FROM Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
SCHED_TST_TO Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
DOCNR Nomination Reference Document OIJ_DOCNR
DOCITM Nomination Reference Document Item NUM06
DOCSCHEDLN Nomination Reference Document Schedule line EETEN
TANK Tankage Partner OIJ_PARTNR
CONS Consignee Partner OIJ_PARTNR
PARTNR Location Partner OIJ_PARTNR
CONPAT Contract Partner OIJ_PARTNR
INSPE Inspector OIJ_PARTNR
RVP RVP value DEC3_1
ITBOTOL Quantity tolerance over (percentage) DEC3_1
ITBUTOL Quantity tolerance under (%) DEC3_1
DOCTYP Reference Document Type CHAR04
THIRD_NOMNR Partner Nomination number OIJ_NOMNR
UPMAT Pricing reference material of main item MATNR
REFITEM Higher-level item in bill of material structures OIJ_ITEM
STLKN BOM item node number KNTNR
CO_CARR Connecting carrier LIFNR
CO_SHIP Connecting shipper LIFNR
CO_TSYST Connecting Transport System OIJ_TSYST
SOLDTO Customer Sold-to or Vendor OIJ_SOLDTO
CHARG_L Batch load CHARG
TCNUM TSW :Trading Contract number OIJ_TCNR
TCITM TSW: Trading contract item number OIJ_TCITM
GA_NMSHIPPER Shipper LIFNR
GA_RANK Rank OIJ_RANK
CYCLE_ITEM Nomination Pipeline cycle ID at Item Level CHAR10
ATL_DELV_NUMBER ATL credit check delivery number VBELN
ATL_DELV_ITM ATL credit check delivery item POSNR
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
LOCNAM Location name (used by system owner) OIJ_LOCNAM
NOMIT_CONS OIL-TSW: Referenced nomination item for bunker consumption OIJ_NOMIT_CONS
RAILCARQTY Number of Railcars INT4_NOS
OICERTF1 Excise tax external license number OIH_CERTF1
OICERTF1_GI Excise Tax External License Number Used During GI (STO) OIH_CERTF1
OIC_PORGIN Tax origin OIC_PORGIN
OIC_PDESTN Tax destination OIC_PDESTN
OIC_PTRIP Pipeline trip number (external) OIC_PTRIP
OIC_PBATCH Pipeline operator´s external batch number OIC_PBATCH
OIC_AORGIN Alternate origin OIC_PORGIN
OIC_ADESTN Alternate destination OIC_PDESTN
OIC_TRUCKN Truck number OIC_TRUCKN
OIA_BASELO Base location OIA_BASELO
LICIN_NUM Excise tax internal license number OIH_LICIN
LICEXT_NUM Excise tax external license number OIH_CERTF1
OIH_DISTLIC Distributor License CHAR1
DUMMY_NOMITM_INCL_EEW_PS Data Element for Extension Fields: Sample NUMC10
/DMBE/SMARTID Deal Number /DMBE/DM_SMART_ID
/DMBE/OPTIONALITYKEY Detail Number /DMBE/DM_OPTIONALITY_KEY
Master Data Relations Join Conditions
Actual posted quantity Unit of Measure
  • Client
  • Actual posted quantity Unit of Measure
  • CDS_OIJNOMI.MANDT == T006.MANDT
  • CDS_OIJNOMI.ACTUALUOM == T006.MSEHI
Valuation Type in Transit
  • Client
  • Valuation Type in Transit
  • CDS_OIJNOMI.MANDT == T149D.MANDT
  • CDS_OIJNOMI.BWTAR_INTRANSIT == T149D.BWTAR
Duty To
  • Client
  • Duty To
  • CDS_OIJNOMI.MANDT == KNA1.MANDT
  • CDS_OIJNOMI.DUTY_TO == KNA1.KUNNR
Import / Export Partner Indicator
  • Import / Export Partner Indicator
  • Client
  • CDS_OIJNOMI.FLAG_IMEX == OIJIMEX.FLAG_IMEX
  • CDS_OIJNOMI.MANDT == OIJIMEX.MANDT
Excise Duty Handling Type at Discharge
  • Client
  • Excise Duty Handling Type at Discharge
  • CDS_OIJNOMI.MANDT == OIH5.MANDT
  • CDS_OIJNOMI.HT_DIS == OIH5.HANTYP
Excise Duty Handling Type Gain/Loss
  • Client
  • Excise Duty Handling Type Gain/Loss
  • CDS_OIJNOMI.MANDT == OIH5.MANDT
  • CDS_OIJNOMI.HT_GL == OIH5.HANTYP
Excise Duty Handling Type at Load
  • Client
  • Excise Duty Handling Type at Load
  • CDS_OIJNOMI.MANDT == OIH5.MANDT
  • CDS_OIJNOMI.HT_LOAD == OIH5.HANTYP
Import / Export Partner
  • Client
  • Import / Export Partner
  • CDS_OIJNOMI.MANDT == LFA1.MANDT
  • CDS_OIJNOMI.IMPOEXPO == LFA1.LIFNR
Nomination Item status
  • ?
  • Nomination Item status
  • Client
  • CDS_OIJNOMI.[column in domain "OIJ_REFTAB"] == OIJSTAT.TABNAME
  • CDS_OIJNOMI.ISTAT == OIJSTAT.STATUS
  • CDS_OIJNOMI.MANDT == OIJSTAT.MANDT
Nomination Item sub-status
  • ?
  • Nomination Item status
  • Client
  • Nomination Item sub-status
Absolute tolerance UoM
  • Client
  • Absolute tolerance UoM
  • CDS_OIJNOMI.MANDT == T006.MANDT
  • CDS_OIJNOMI.ITTOLUNIT == T006.MSEHI
Location ID
  • Client
  • Location ID
  • CDS_OIJNOMI.MANDT == OIJLOC.MANDT
  • CDS_OIJNOMI.LOCID == OIJLOC.LOCID
Location Partner Plant
  • Location Partner Plant
  • Client
  • CDS_OIJNOMI.LOCPT == T001W.WERKS
  • CDS_OIJNOMI.MANDT == T001W.MANDT
Location Partner Storage Location
  • Location Partner Plant
  • Client
  • Location Partner Storage Location
  • CDS_OIJNOMI.LOCPT == T001L.WERKS
  • CDS_OIJNOMI.MANDT == T001L.MANDT
  • CDS_OIJNOMI.LOCSL == T001L.LGORT
Demand material
  • Demand material
  • Client
  • CDS_OIJNOMI.MATNR_I == MARA.MATNR
  • CDS_OIJNOMI.MANDT == MARA.MANDT
Destination city code
  • Client
  • Destination region
  • Destination city code
  • Destination country/Region
  • CDS_OIJNOMI.MANDT == T005G.MANDT
  • CDS_OIJNOMI.OIC_DREGIO == T005G.REGIO
  • CDS_OIJNOMI.OIC_DCITYC == T005G.CITYC
  • CDS_OIJNOMI.OIC_DLAND1 == T005G.LAND1
Destination county code
  • Destination county code
  • Client
  • Destination region
  • Destination country/Region
  • CDS_OIJNOMI.OIC_DCOUNC == T005E.COUNC
  • CDS_OIJNOMI.MANDT == T005E.MANDT
  • CDS_OIJNOMI.OIC_DREGIO == T005E.REGIO
  • CDS_OIJNOMI.OIC_DLAND1 == T005E.LAND1
Destination country/Region
  • Client
  • Destination country/Region
  • CDS_OIJNOMI.MANDT == T005.MANDT
  • CDS_OIJNOMI.OIC_DLAND1 == T005.LAND1
Destination region
  • Client
  • Destination region
  • Destination country/Region
  • CDS_OIJNOMI.MANDT == T005S.MANDT
  • CDS_OIJNOMI.OIC_DREGIO == T005S.BLAND
  • CDS_OIJNOMI.OIC_DLAND1 == T005S.LAND1
Account Number of Supplier
  • Account Number of Supplier
  • Client
  • CDS_OIJNOMI.OIC_LIFNR == LFA1.LIFNR
  • CDS_OIJNOMI.MANDT == LFA1.MANDT
IS-OIL MAP external details mode of transport
  • Client
  • IS-OIL MAP external details mode of transport
  • CDS_OIJNOMI.MANDT == TVTR.MANDT
  • CDS_OIJNOMI.OIC_MOT == TVTR.VKTRA
Origin city code
  • Client
  • Origin city code
  • Origin Country/Region
  • Origin region
  • CDS_OIJNOMI.MANDT == T005G.MANDT
  • CDS_OIJNOMI.OIC_OCITYC == T005G.CITYC
  • CDS_OIJNOMI.OIC_OLAND1 == T005G.LAND1
  • CDS_OIJNOMI.OIC_OREGIO == T005G.REGIO
Origin county code
  • Client
  • Origin Country/Region
  • Origin county code
  • Origin region
  • CDS_OIJNOMI.MANDT == T005E.MANDT
  • CDS_OIJNOMI.OIC_OLAND1 == T005E.LAND1
  • CDS_OIJNOMI.OIC_OCOUNC == T005E.COUNC
  • CDS_OIJNOMI.OIC_OREGIO == T005E.REGIO
Origin Country/Region
  • Client
  • Origin Country/Region
  • CDS_OIJNOMI.MANDT == T005.MANDT
  • CDS_OIJNOMI.OIC_OLAND1 == T005.LAND1
Origin region
  • Client
  • Origin Country/Region
  • Origin region
  • CDS_OIJNOMI.MANDT == T005S.MANDT
  • CDS_OIJNOMI.OIC_OLAND1 == T005S.LAND1
  • CDS_OIJNOMI.OIC_OREGIO == T005S.BLAND
Excise Duty Handling Type
  • Client
  • Excise Duty Handling Type
  • CDS_OIJNOMI.MANDT == OIH5.MANDT
  • CDS_OIJNOMI.OIHANTYP == OIH5.HANTYP
Excise Duty Handling Type - Denotes Use of Material
  • Client
  • Excise Duty Handling Type - Denotes Use of Material
  • CDS_OIJNOMI.MANDT == OIH5.MANDT
  • CDS_OIJNOMI.OIHANTYP_GI == OIH5.HANTYP
Follow-on license for quantity license
  • Client
  • License type
  • Follow-on license for quantity license
  • CDS_OIJNOMI.MANDT == OIHL.MANDT
  • CDS_OIJNOMI.OIH_LICTP == OIHL.LICTP
  • CDS_OIJNOMI.OIH_LCFOL == OIHL.LICIN
Follow-On License for Quantity License to Mat. (STO)
  • Client
  • Follow-On License for Quantity License to Mat. (STO)
  • License Type to Material (STO)
  • CDS_OIJNOMI.MANDT == OIHL.MANDT
  • CDS_OIJNOMI.OIH_LCFOL_GI == OIHL.LICIN
  • CDS_OIJNOMI.OIH_LICTP_GI == OIHL.LICTP
Excise tax internal license number
  • ?
  • Client
  • Excise tax internal license number
  • CDS_OIJNOMI.[column in domain "OIH_LICTP"] == OIHL.LICTP
  • CDS_OIJNOMI.MANDT == OIHL.MANDT
  • CDS_OIJNOMI.OIH_LICIN == OIHL.LICIN
Excise Tax Internal License Number to Mat. (STO)
  • Excise Tax Internal License Number to Mat. (STO)
  • ?
  • Client
  • CDS_OIJNOMI.OIH_LICIN_GI == OIHL.LICIN
  • CDS_OIJNOMI.[column in domain "OIH_LICTP"] == OIHL.LICTP
  • CDS_OIJNOMI.MANDT == OIHL.MANDT
License type
  • Client
  • License type
  • CDS_OIJNOMI.MANDT == OIH20.MANDT
  • CDS_OIJNOMI.OIH_LICTP == OIH20.LICTP
License Type to Material (STO)
  • Client
  • License Type to Material (STO)
  • CDS_OIJNOMI.MANDT == OIH20.MANDT
  • CDS_OIJNOMI.OIH_LICTP_GI == OIH20.LICTP
Code for internal or external excise duty rate determination
  • Client
  • Code for internal or external excise duty rate determination
  • CDS_OIJNOMI.MANDT == OIH16.MANDT
  • CDS_OIJNOMI.OIINEX == OIH16.INEX
Code for Internal or External Excise Duty Rate Determination
  • Code for Internal or External Excise Duty Rate Determination
  • Client
  • CDS_OIJNOMI.OIINEX_GI == OIH16.INEX
  • CDS_OIJNOMI.MANDT == OIH16.MANDT
Excise duty tax key for 'from' location
  • Client
  • Excise duty tax key for 'from' location
  • CDS_OIJNOMI.MANDT == OIH4.MANDT
  • CDS_OIJNOMI.OITAXFROM == OIH4.TAXKEY
Excise duty tax key for 'from' location
  • Client
  • Excise duty tax key for 'from' location
  • CDS_OIJNOMI.MANDT == OIH4.MANDT
  • CDS_OIJNOMI.OITAXFROM_GI == OIH4.TAXKEY
Excise Duty Group
  • Client
  • Excise Duty Group
  • CDS_OIJNOMI.MANDT == OIH2.MANDT
  • CDS_OIJNOMI.OITAXGRP == OIH2.TAXGRP
Excise Duty Group
  • Excise Duty Group
  • Client
  • CDS_OIJNOMI.OITAXGRP_GI == OIH2.TAXGRP
  • CDS_OIJNOMI.MANDT == OIH2.MANDT
Excise duty tax key for 'to' location
  • Client
  • Excise duty tax key for 'to' location
  • CDS_OIJNOMI.MANDT == OIH4.MANDT
  • CDS_OIJNOMI.OITAXTO == OIH4.TAXKEY
Excise duty tax key for 'to' location
  • Client
  • Excise duty tax key for 'to' location
  • CDS_OIJNOMI.MANDT == OIH4.MANDT
  • CDS_OIJNOMI.OITAXTO_GI == OIH4.TAXKEY
Valuation Type
  • Client
  • Valuation Type
  • CDS_OIJNOMI.MANDT == T149D.MANDT
  • CDS_OIJNOMI.OWNER == T149D.BWTAR
Prorate Calculation Routine Type CDS_OIJNOMI.PRORATE_ROUTINE == TOIJ_EL_PR_RT.PRORATE_ROUTINE
Ship From
  • Client
  • Ship From
  • CDS_OIJNOMI.MANDT == LFA1.MANDT
  • CDS_OIJNOMI.SHIP_FROM == LFA1.LIFNR
Schedule type
  • Client
  • Schedule type
Scheduled material
  • Scheduled material
  • Client
  • CDS_OIJNOMI.S_MATNR_I == MARA.MATNR
  • CDS_OIJNOMI.MANDT == MARA.MANDT
Scheduled UoM
  • Client
  • Scheduled UoM
  • CDS_OIJNOMI.MANDT == T006.MANDT
  • CDS_OIJNOMI.UNIT_I == T006.MSEHI
Valuation Type Destination Loc.
  • Client
  • Valuation Type Destination Loc.
  • CDS_OIJNOMI.MANDT == T149D.MANDT
  • CDS_OIJNOMI.VALUATIONTYPE_D == T149D.BWTAR
Valuation Type Origin Loc.
  • Valuation Type Origin Loc.
  • Client
  • CDS_OIJNOMI.VALUATIONTYPE_O == T149D.BWTAR
  • CDS_OIJNOMI.MANDT == T149D.MANDT