Oij05_Cds_Nom_Gsim

CDS View for joining nom and global sim | view: OIJ05_V_NOMGSIM | TRAN | Extraction: Not supported | Component: Trader's and Scheduler's Workbench
Tables used: OIJPEG, OIJ_SCHED, OIJ05_SCHED_SIM, LFA1, MAKT, OIGVT, OIJ07_PEGGING_TY, OIJLOC, OIJTS, TVTRT
Column Name Description
Column Name Description
ATL_CRDT_VAL ATL Credit Amount
Column Name Description
QTYIN Qty received in TS
QTYOUT Qty delivered from TS
MENGE Scheduled qty
QTYFCR First requested quantity
PRORATEQTY Prorated Quantity
ASSIGNEDQTY Assigned Quantity
ACTUALQTY Actual posted quantity
ITBOTOLABS Absolute tolerance qty over
ITBUTOLABS Absolute tolerance qty under
LDRATE Planned load/discharge rate
GA_CONF_QTY Confirmed Quantity
GA_TECHSCH_QTY Technical Scheduled Quantity Field
GA_CONF_QTY_CAL Calculated Values of Confirmed Quantity Field
GA_TSCH_QTY_CAL Calculated Values of Technical Scheduled Quantity Field
GA_ALLOCATED_QTY Allocated Quantity
ATL_CRDT_QTY ATL Credit Quantity
📏 Actual posted quantity Parallel Unit of Measure (actualuom_par):
actualqty_par Actual posted parallel quantity
Column Name Description
SENTDAT Last header action date
SENTTIME Last header 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
IDATE Scheduled date
ACTDAT Last item action date
ACTTIME Last item action time
ERDAT_I Date on which the record was created
ERZEIT_I Time of creation
AEDAT_I Last Changed On
AEZEIT_I Time of day the record was changed
itime null
idate_to null
itime_to null
Column Name Description
NOMCL Nomination Class Show values
NOMST Nomination header status Show values
NMBALCH Balance check indicator (default) Show values
WORKLIST Worklist entry indicator Show values
NMBLOCK Blocking indicator Show values
LOV_GL Gain Loss LOV posting indicator Show values
BOOKTS Book TS indicator Show values
BLOIND_I Blocking indicator Show values
DELIND_I Deletion indicator Show values
ISTAT Nomination Item status Show values
ISUBSTAT Nomination Item sub-status Show values
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
sim_sched_typ Simulation Schedule category Show values
sched_stat TSW: Status of Simulated Schedule line Show values
Column Name Description Domain name
NOMTK Nomination (technical) Key OIJ_NOMTK
NOMIT Nomination Key Item OIJ_ITEM
NOMTYP Nomination type OIJ_NOMTYP
BUSTYP Business type OIRA_RNBT
NOMNR Nomination number OIJ_NOMNR
NMSHTYPE TD shipment type OIG_TDSTYP
STAGES_ID GUID in 'CHAR' format with upper-/lowercase (!) SYSUUID_22
SENTNAM Last user who worked on object USNAM
ITEMS Nomination item counter NUM04
COUNTER1 Nomination planned item Counter NUM04
COUNTER2 Nomination scheduled Item Counter NUM04
COUNTER3 Nomination rejected Item Counter NUM04
COUNTER4 Nomination confirmed Item Counter NUM04
COUNTER5 Nomination partially complete Item Counter NUM04
COUNTER6 Nomination completed Item Counter NUM04
APO_SHIPMENT_ID GUID in 'CHAR' format with upper-/lowercase (!) SYSUUID_22
APO_SHIPMENT_NUM Shipment Number TKNUM
NOMTYPDESC IS-Oil: Descriptive text OI0_TEXT
SHTYP Shipment type SHTYP
TKNUM Shipment Number TKNUM
TSYST Transport system OIJ_TSYST
TSNAM OIL-TSW: Transport system name OIJ_TSNAM
NMSHIPPER Shipper LIFNR
NAME1 Name 1 NAME
NMCARRIER Transport system Carrier LIFNR
CARR_NAME Name 1 NAME
CYCLE Nomination Pipeline cycle ID CHAR10
NMWERK Transport system In-transit Plant WERKS
NMLGORT Transport system In-transit Storage Location LGORT
NMVEHICLE TD Vehicle Number OIG_VHLNMR
VEH_TEXT TD vehicle header text OIG_TEXT
NMVESSEL TD vehicle identifier OIG_LICNMR
NMTPLST Transportation planning point TPLST
ROUTE Route ROUTE
EV_GROUP TD - event default group OIG_EVGRP
VKTRA Mode of Transport VKTRA
BEZEI Description TEXT20
TST_FROM_MIN Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
TST_TO_MAX Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
SHNUM TD shipment number OIG_SHNUM
SHNUM_I TD shipment number OIG_SHNUM
ERNAM Name of Person Responsible for Creating the Object USNAM
AENAM Name of Person Who Changed Object USNAM
SITYP Schedule type OIJ_SITYP
SCHED_TST_FROM Scheduled / Acceptance / Pipe Batch Start Timestamp TZNTSTMPS
SCHED_TST_TO Scheduled / Acceptance / Pipe Batch End Timestamp TZNTSTMPS
LOCID Location ID OIJ_LOCID
LOCNAM Location name (used by system owner) OIJ_LOCNAM
S_MATNR_I Scheduled material MATNR
S_MAKTX Material Description TEXT40
MATNR_I Demand material MATNR
MAKTX Material Description TEXT40
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
IMPOEXPO Import / Export Partner LIFNR
FLAG_IMEX Import / Export Partner Indicator OIJ_IMEXFL
OWNER Valuation Type BWTAR
CHARG_O Batch origin Location CHARG
CHARG_D Batch destination Location CHARG
RVP RVP value DEC3_1
VALUATIONTYPE_O Valuation Type Origin Loc. BWTAR
VALUATIONTYPE_D Valuation Type Destination Loc. BWTAR
SHITEM Shipment item OIG_SHITM
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
PRORATE_ROUTINE Prorate Calculation Routine Type OIJ_EL_DM_PR_RT
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
LESSHNUM Shipment Number TKNUM
LESTPNUM Shipment item TPNUM
ATL_DELV_NUMBER ATL credit check delivery number VBELN
ATL_DELV_ITM ATL credit check delivery item POSNR
locpt Location Partner Plant WERKS
locsl Location Partner Storage Location LGORT
ERNAM_I Name of Person Responsible for Creating the Object USNAM
AENAM_I Name of Person Who Changed Object USNAM
railcarqty Number of Railcars INT4_NOS
sim_sched_id TSW: Nomination Simulation ID OIJ_NOMTK
sim_sched_ln TSW: Nomination Simulation Line item OIJ_ITEMNO
updkz Update indicator UPDKZ
user_id User ID OIJ05_USER
sim_version TSW: Simulation Version OIJ_SIMVERS
sched_comm Short comment CHAR80
ipw_txt NPW/IPW: User comment / text TEXTA1024
nom_sim null
pegid Pegging identifier OIJ_PEGID
pegtype Pegging type OIJ_PEGTYPE
CD_NOMTK null
CD_NOMIT null
CD_NOMCL null
CD_NOMTYP null
CD_BUSTYP null
CD_NOMNR null
CD_NOMST null
CD_NMSHTYPE null
CD_NMBALCH null
CD_STAGES_ID null
CD_WORKLIST null
CD_SENTDAT null
CD_SENTTIME null
CD_SENTNAM null
CD_ITEMS null
CD_COUNTER1 null
CD_COUNTER2 null
CD_COUNTER3 null
CD_COUNTER4 null
CD_COUNTER5 null
CD_COUNTER6 null
CD_APO_SHIPMENT_ID null
CD_APO_SHIPMENT_NUM null
CD_NMBLOCK null
CD_NOMTYPDESC null
CD_SHTYP null
CD_TKNUM null
CD_LOV_GL null
CD_TSYST null
CD_TSNAM null
CD_NMSHIPPER null
CD_NAME1 null
CD_NMCARRIER null
CD_CARR_NAME null
CD_CYCLE null
CD_NMWERK null
CD_NMLGORT null
CD_NMVEHICLE null
CD_VEH_TEXT null
CD_NMVESSEL null
CD_NMTPLST null
CD_ROUTE null
CD_BOOKTS null
CD_EV_GROUP null
CD_VKTRA null
CD_BEZEI null
CD_QTYIN null
CD_QTYOUT null
CD_UNIT null
CD_TST_FROM_MIN null
CD_TST_TO_MAX null
CD_BLOIND_I null
CD_DELIND_I null
CD_SHNUM null
CD_SHNUM_I null
CD_ERDAT null
CD_ERZEIT null
CD_ERNAM null
CD_AEDAT null
CD_AEZEIT null
CD_AENAM null
CD_SITYP null
CD_ISTAT null
CD_ISUBSTAT null
CD_IDATE null
CD_SCHED_TST_FROM null
CD_SCHED_TST_TO null
CD_LOCID null
CD_LOCNAM null
CD_S_MATNR_I null
CD_S_MAKTX null
CD_MATNR_I null
CD_MAKTX null
CD_MENGE null
CD_UNIT_I null
CD_UNIT_I_T null
CD_DOCIND null
CD_DOCNR null
CD_DOCITM null
CD_DOCSCHEDLN null
CD_QTYFCR null
CD_QTYFCR_UOM null
CD_WORKLIST_I null
CD_TANK null
CD_CONS null
CD_PARTNR null
CD_CONPAT null
CD_INSPE null
CD_IMPOEXPO null
CD_FLAG_IMEX null
CD_OWNER null
CD_CHARG_O null
CD_CHARG_D null
CD_RVP null
CD_VALUATIONTYPE_O null
CD_VALUATIONTYPE_D null
CD_SHITEM null
CD_ILOCK null
CD_PRORATEQTY null
CD_ASSIGNEDQTY null
CD_ACTDAT null
CD_ACTTIME null
CD_ACTUALS null
CD_ACTUALQTY null
CD_ACTUALUOM null
CD_ITBOTOL null
CD_ITBUTOL null
CD_ITBOTOLABS null
CD_ITBUTOLABS null
CD_ITTOLUNIT null
CD_UNLIMITED null
CD_BLOIND null
CD_DELIND null
CD_UPDATEXDOK null
CD_INCOMPLETE_FLAG null
CD_DOCTYP null
CD_LDRATE null
CD_LDQUOM null
CD_LDTUOM null
CD_THIRD_NOMNR null
CD_UPMAT null
CD_REFITEM null
CD_STLTY null
CD_STLKN null
CD_CHARG_D_CREATE null
CD_CHARG_O_CREATE null
CD_CO_CARR null
CD_CO_SHIP null
CD_CO_TSYST null
CD_COMMCTL null
CD_SOLDTO null
CD_PRORATE_ROUTINE null
CD_CHARG_L null
CD_CHARG_L_CREATE null
CD_TCNUM null
CD_TCITM null
CD_GA_NMSHIPPER null
CD_GA_CONF_QTY null
CD_GA_CONF_UOM null
CD_GA_TECHSCH_QTY null
CD_GA_TECHSCH_UOM null
CD_GA_CONF_QTY_CAL null
CD_GA_TSCH_QTY_CAL null
CD_GA_ALLOCATED_QTY null
CD_GA_ALLOCATED_UOM null
CD_GA_RANK null
CD_CYCLE_ITEM null
CD_LESSHNUM null
CD_LESTPNUM null
CD_ATL_DELV_NUMBER null
CD_ATL_DELV_ITM null
CD_ATL_CRDT_QTY null
CD_ATL_CRDT_UOM null
CD_ATL_CRDT_VAL null
CD_ATL_CRDT_CURR null
CD_PRE_EXIST_IND null
CD_PLANIND null
CD_LOCPT null
CD_LOCSL null
CD_QUICKCONF null
CD_ERDAT_I null
CD_ERZEIT_I null
CD_ERNAM_I null
CD_AEDAT_I null
CD_AEZEIT_I null
CD_AENAM_I null
CD_ACTUALQTY_PAR null
CD_ACTUALUOM_PAR null
CD_LOV_IND null
CD_FERRYIND null
CD_RAILCARQTY null
CD_IPW_TXT null
CD_ITIME null
CD_IDATE_TO null
CD_ITIME_TO null
CD_SIM_SCHED_TYP null
CE_NOMTYP null
CE_QUICKCONF null
CE_EXTAPPSIM null
CE_NMSHTYPE null