CDS Views for Trader's and Scheduler's Workbench (IS-OIL-DS-TSW)

CDS View NameDescriptionSQL View Name
CDSV_NOMTKGet NOMTK from OIJNOMIV_NOMTK
CDSV_NOM_DETAILSCDS view combining NOMH & NOMIV_NOM_DETAILS
CDS_EVENT_SIMCDS for OIJNE_SIMV_OIJNE_SIM
CDS_NOM_DETAILSNomination DetailsV_NOM_DETAIL
CDS_NOM_SIMActual Nominations & Simulated NominationsV_NOM_SIM
CDS_OIJNECDS combining OIJNE & OIJNE_SIMV_OIJNE
CDS_OIJNE_SIMCombining CDS_NOMTK & CDS_OIJNEV_OIJNOMI_OIJNE
CDS_OIJNOMIcds view for oijnomiV_OIJNOMI
CDS_OIJSCHEDCDS to retrieve from OIJ_SCHED based on user_idV_OIJSCHED
C_DEMANDNOMINATIONSCHEDULETPScheduling AssistantCDMNDNOMSCHEDTP
C_NOMINATIONDETAILNomination DetailsCNOMDETAIL
C_PURCONTRSOURCENOMINATIONPurchase Contract Header ViewCPURCONTRSNOM
C_SOURCENOMINATIONSCHEDPARTNERC_SourceSchedulePartnerTPCSRCENOMSCHDPART
C_SOURCENOMINATIONSCHEDULETPSource ScheduleCSRCENOMSCHEDTP
E_DEMANDNOMINATIONSCHEDULEExtension include view for Demand NominationsEDMNDNOMSCHD
E_SOURCENOMINATIONSCHEDULEExtension include view for Source NominationsESRCNOMSCHD
I_DEMANDNOMINATIONSCHEDULEDemand ScheduleIDEMANDNOMSCHED
I_DEMANDNOMINATIONSCHEDULETPDemand ScheduleIDMNDNOMSCHEDTP
I_LOCATIONPARTNERPLANTTSW Location Partner PlantILOCPARTPLANT
I_MODEOFTRANSPORTTEXTMode of Transport TextIMOTTEXT
I_MODEOFTRANSPORTVHI_MODEOFTRANSPORTVHIMODEOFTRANSVH
I_NOMINATIONDETAILInterface View for Nomination DetailsINOMDET
I_NOMINATIONEVENTNomination EventsINOMEVENTS
I_NOMINATIONLOCATIONNomination LocationINOMLOC
I_NOMINATIONMBLEVTSCONFIGNNomination details for Mobile EventsINOMCONFIG
I_NOMINATIONRELEVANTDOCUMENTTSW Relevant DocumentINOMRLVTDOC
I_NOMINATIONSCHEDBPPURGORGVHNomination BP Purchasing Organization VHINOMSCHDBPPURORG
I_NOMINATIONSCHEDULEUSERTEXTTrip created by user value helpINOMSCHEDUSERT
I_NOMINATIONSIMULATIONI_NominationSimulationINOMSIMULATION
I_SCHEDULEDMATERIALVHMaterial Value HelpISCHEDLDMATLVH
I_SCHEDULEDQUANTITYUOMVHI_ScheduledQuantityUoMVHISCHEDQTYUOMVH
I_SOURCENOMINATIONSCHEDPARTNERI_SourceSchedulePartnerTPISRCENOMSCHDPART
I_SOURCENOMINATIONSCHEDSTATUSTSource Nomination Schedule Status TextISRCNOMSCHEDSTST
I_SOURCENOMINATIONSCHEDULETPSource ScheduleISRCENOMSCHEDTP
I_TRANSPORTROUTETransportation RouteITRANSPTROUTE
I_TRANSPORTROUTESTAGETransportation Route StageITRANSROUTESTAGE
OIJ05_CDSNWBCDS for NWBOIJ05_V_NWB
OIJ05_CDSNWBECDS View For NWB EventsV_NWB_NOMI_NE
OIJ05_CDS_NOM_GSIMCDS View for joining nom and global simOIJ05_V_NOMGSIM
OIJ05_CDS_NOM_SIMCDS view joining nomination and simulationOIJ05_V_NOM_SIM
OIJ05_GNOMINATIONTo fetch global simulation NominationsV_OIJ05_GNM
OIJ05_GSCHEDFetch Global Simulations from OIJ_SCHEDOIJ05_V_GSCHED
OIJ05_GSCHED_LOCDS for Location Balancing Global Sim in OIJ_SCHEDOIJ05_V_GSIM_LO
OIJ05_GSCHED_SIMGlobal simulations marker entriesOIJ05_VGSCHEDSIM
OIJ05_GSIMSCHEDIDSimulation Schedule IDs for Global SimulationsOIJ05_V_GSIMID
OIJ05_ICSCHEDTo fetch global simulation of type ICV_OIJ05_ICSCHED
OIJ05_NOMINATIONSTo fetch nominationsV_OIJ05_NM
OIJ05_NWBTo fetch distinct nomtkV_OIJ05_NWB
OIJ05_OIJGSCHEDCDSV for GSchedV_OIJ05_OIJGSCHD
OIJ05_OIJGSCHED_SIMCDS View for Oij05_Oijgsched_SimV_OIJ05_GSCHDSIM
OIJ05_OIJNE_MKCDS for OIJ05_OIJNE_SIM_MKV_OIJ05_OIJNE_MK
OIJ05_OIJNE_SIMTo fetch Event global simulationsV_OIJNE_GSIM
OIJ05_OIJSCHEDCDSV for OIJSCHEDV_OIJ05_OIJSCHED
OIJ05_OIJSCHED_SIMCDSV for OIJ05_SCHED_SIMV_OIJ05_SCHD_SIM
OIJ05_SCHEDCDS for OIJ_SCHEDV_OIJ05_SCHED
OIJ05_SCHED_ALLNomination Simulations: IPW and GlobalOIJ05_V_SCHEDALL
OIJ09_PHYSICALINVENTORYRECENTMost Recent Physical InventoryOIJ09PHYINVR
OIJ09_SOURCENOMINATIONSCHEDULESource ScheduleOIJ09_SRCESCHED