CDS Views for Hydrocarbon Product Management (IS-OIL-DS-HPM)

CDS View NameDescriptionSQL View Name
C_DATEFORMATVHDate Format Value HelpCDATFORMATVH
C_DECIMALFORMATVHDecimal notation format value helpCDECFORMATVH
C_OILPHYSPARAMUOMVHUoM Value Help for Physical ParametersCPHYPARUOMVH
C_PHYSINVTRYGAUGERDNGPhysical Inventory gauge readingCPHYINVGR
C_PHYSINVTRYVOLMASSRDNGPhysical Inventory for VMRCPIVMR
C_PHYSPARAMGAUGERDNGGauge Reading Physical ParametersCPHYPARGR
C_PHYSPARAMVOLMASSRDNGPhysical Parameters VMRCPPVMR
C_PLANTHELPVOLMASSRDNGPlant Value help for Volume/Mass ReadingCPLNTVMR
C_PLANTVALUEHELPGAUGERDNGPlant Value help for Gauge ReadingCPLANTHLPGR
C_SILOTANKHELPSilo Tank Value HelpCSMTANKHELP
C_TIMEFORMATVHTime format value helpCTIMEFORMATVH
C_VOLUMEMASSMATERIALVALUEHELPMaterial Value Help for volume or mass entryCMATERIALH
I_DATEFORMATVHDate Format Value HelpIDATFORMATVH
I_DECIMALFORMATVHDecimal notation format value helpIDECFORMATVH
I_MAPPINGPLANTCheck mapping table for plantINONSILOPLANT
I_MATERIALDESCRIPTIONMaterial DescriptionIMATDESC
I_MATERIALVALUEHELPMaterial value helpIMATLHLP
I_OILPHYSPARAMUOMVHUoM Value Help for Physical ParametersIPHYPARUOMVH
I_PHYSINVTRYGAUGERDNGPhysical Inventory gauge readingIPHYINVGR
I_PHYSINVTRYGAUGERDNGFLDTank Dip Table FieldsIPHYINVGRFLD
I_PHYSINVTRYVOLMASSRDNGPhysical Inventory for VMRIPIVMR
I_PHYSINVTRYVOLMASSRDNGFLDPhysical Inventory VMR Table FieldsIPHYINVVMRFLD
I_PHYSPARAMGAUGERDNGGauge Reading Physical ParametersIPHYPARGR
I_PHYSPARAMVOLMASSRDNGPhysical Parameters VMRIPPVMR
I_PLANTHELPPlant value helpIPLNTHLP
I_PLANTINMAPPINGTABLECheck mapping table for plantICHKPLNTMAP
I_SILOMANAGEDPLANTPlant value check for silo managementICHKSILOPLNT
I_SILOMANAGEDPLANTGAUGECheck for Silo Managed plantIGAUGESM
I_SILOTANKHELPSilo Tank Value HelpISMTANKHELP
I_STORAGELOCATIONINDEXIndex for storage location/sequence no.ISLOCIND
I_TIMEDEPDNTMATLASSIGNTime Dependent Material assignment to SOCITIMDPTMATASMT
I_TIMEFORMATVHTime format value helpITIMEFORMATVH
I_VOLUMEMASSSILOMANAGEDPLANTPlant value check for Silo managementINONSILOPLNT
OIB_BOOK_INVENTORYBook inventory with valuation type and methodOIBBOOKINV
OIB_DDL_DIP_MAXTIMSTMPGet the latest timestampOIBTANKTS
OIB_DDL_MARCHO1CDS View for MARCHO1 on MATDOCOILOIB_V_MARCHO1
OIB_DDL_MARCHO1_AGMARCHO1 Compatibility View: AggregationOIB_V_MARCHO1_AG
OIB_DDL_MARCHO1_PRCDS View for All Periods for MARCHO1OIB_V_MARCHO1_PR
OIB_DDL_MARCO1MARCO1 Compatibility ViewOIB_V_MARCO1
OIB_DDL_MARCO1_AGMARCO1 Compatibility View: AggregationOIB_V_MARCO1_AG
OIB_DDL_MARCO1_DIFMARCO1 Compatibility View: DifferentiationOIB_V_MARCO1_DIF
OIB_DDL_MARDHO1CDS View for MARDHO1 on MATDOCOILOIB_V_MARDHO1
OIB_DDL_MARDHO1_AGCDS View for Sums on MARDHO1 per PeriodOIB_V_MARDHO1_AG
OIB_DDL_MARDHO1_PRCDS View for All Periods for MARDHO1OIB_V_MARDHO1_PR
OIB_DDL_MARDO1MARDO1 Compatibility ViewOIB_V_MARDO1
OIB_DDL_MARDO1_AGMARDO1 Compatibility View: AggregationOIB_V_MARDO1_AG
OIB_DDL_MARDO1_DIFMARDO1 Compatibility View: DifferentiationOIB_V_MARDO1_DIF
OIB_DDL_MCHBHO1CDS View for MCHBHO1 on MATDOCOILOIB_V_MCHBHO1
OIB_DDL_MCHBHO1_AGCDS View for Sums on MCHBHO1 per PeriodOIB_V_MCHBHO1_AG
OIB_DDL_MCHBHO1_PRCDS View for All Periods for MCHBHO1OIB_V_MCHBHO1_PR
OIB_DDL_MCHBO1MCHBO1 Compatibility ViewOIB_V_MCHBO1
OIB_DDL_MCHBO1_AGMCHBO1 Compatibility View: AggregationOIB_V_MCHBO1_AG
OIB_DDL_MCHBO1_DIFMCHBO1 Compatibility View: DifferentiationOIB_V_MCHBO1_DIF
OIB_DDL_MKOLHO1CDS View for MKOLHO1 on MATDOCOILOIB_V_MKOLHO1
OIB_DDL_MKOLHO1_AGCDS View for Sums on MKOLHO1 per PeriodOIB_V_MKOLHO1_AG
OIB_DDL_MKOLHO1_PRCDS View for All Periods for MKOLHO1OIB_V_MKOLHO1_PR
OIB_DDL_MKOLO1MKOLO1 Compatibility ViewOIB_V_MKOLO1
OIB_DDL_MKOLO1_AGMKOLO1 Compatibility view: AggregationOIB_V_MKOLO1_AG
OIB_DDL_MKOLO1_DIFMKOLO1 Compatibility view: DifferentiationOIB_V_MKOLO1_DIF
OIB_DDL_MSEGO1MSEGO1 Compatibility ViewOIB_V_MSEGO1
OIB_DDL_MSEGO2MSEGO2 Compatibility ViewOIB_V_MSEGO2
OIB_DDL_MSEGO2_UOMMSEGO2 Compatibility View: UoM SegregationOIB_V_MSEGO2_UOM
OIB_DDL_MSKAHO1CDS View for MSKAHO1 on MATDOCOILOIB_V_MSKAHO1
OIB_DDL_MSKAHO1_AGCDS View for Sums on MSKAHO1 per PeriodOIB_V_MSKAHO1_AG
OIB_DDL_MSKAHO1_PRCDS View for All Periods for MSKAHO1OIB_V_MSKAHO1_PR
OIB_DDL_MSKAO1MSKAO1 Compatibility ViewOIB_V_MSKAO1
OIB_DDL_MSKAO1_AGMSKAO1 Compatibility View: AggregationOIB_V_MSKAO1_AG
OIB_DDL_MSKAO1_DIFMSKAO1 Compatibility View: DiferentiationOIB_V_MSKAO1_DIF
OIB_DDL_MSKUHO1CDS View for MSKUHO1 on MATDOCOILOIB_V_MSKUHO1
OIB_DDL_MSKUHO1_AGCDS View for Sums on MSKUHO1 per PeriodOIB_V_MSKUHO1_AG
OIB_DDL_MSKUHO1_PRCDS View for All Periods for MSKUHO1OIB_V_MSKUHO1_PR
OIB_DDL_MSKUO1MSKUO1 Compatibility ViewOIB_V_MSKUO1
OIB_DDL_MSKUO1_AGMSKUO1 Compatibility View: AggregationOIB_V_MSKUO1_AG
OIB_DDL_MSKUO1_DIFMSKUO1 Compatibility View: DifferentiationOIB_V_MSKUO1_DIF
OIB_DDL_MSLBHO1CDS View for MSLBHO1 on MATDOCOILOIB_V_MSLBHO1
OIB_DDL_MSLBHO1_AGCDS View for Sums on MSLBHO1 per PeriodOIB_V_MSLBHO1_AG
OIB_DDL_MSLBHO1_PRCDS View for All Periods for MSLBHO1OIB_V_MSLBHO1_PR
OIB_DDL_MSLBO1MSLBO1 Compatibility ViewOIB_V_MSLBO1
OIB_DDL_MSLBO1_AGMSLBO1 Compatibility View: AggregationOIB_V_MSLBO1_AG
OIB_DDL_MSLBO1_DIFMSLBO1 Compatibility ViewOIB_V_MSLBO1_DIF
OIB_DDL_MSPRHO1CDS View for MSPRHO1 on MATDOCOILOIB_V_MSPRHO1
OIB_DDL_MSPRHO1_AGCDS View for Sums on MSPRHO1 per PeriodOIB_V_MSPRHO1_AG
OIB_DDL_MSPRHO1_PRCDS View for All Periods for MSPRHO1OIB_V_MSPRHO1_PR
OIB_DDL_MSPRO1MSPRO1 Compatibility ViewOIB_V_MSPRO1
OIB_DDL_MSPRO1_AGMSPRO1 Compatibility View: AggregationOIB_V_MSPRO1_AG
OIB_DDL_MSPRO1_DIFMSPRO1 Compatibility View: DifferentiationOIB_V_MSPRO1_DIF
OIB_DDL_TANKDIP_MAXGet the latest entry from tank dipOIBTNKDIPMAX
OIB_DDL_TANK_QTY_AGGRAggregation of quantity plant levelOIBAGGRQTY
OIB_DDL_UOM_INSERT_AGGAggeration of base UoM Qty. to calculate new UoM Qty.OIB_V_UOM_AGG
OIB_LOCATION_SCHEMACDS to get location schemaOIBLOCSHEMA
OIB_MBEW_QUANTITYBook inventory with valuation type and base UomOIBMBEW
OIB_MIG_SUMMATION_DDLSummation on MATDOCOIL for MigrationOIB_MIG_SUM_V
OIB_PHYINV_ADDQTYPhysical inv additional quantityOIBPHYADQTY
OIB_PHYINV_AGGRAggregation of physical inventoryOIBPHYAGGR
OIB_PHYINV_ALLOCLatest physical inventory records for allocationOIBPHYALLOC
OIB_PLANT_ALLOCPlant Selection for AllocationOIBPLANTALLOC
OIB_SCHEMA_LOC_MAXCDS to get latest location schemaOIBLOCSHEMAMAX
OIB_SCHEMA_LOC_MAXTIMECDS to get latest location schemaOIBLOCSHEMAMAXT
OIB_TANKDIP_DATESilo management tank strapping historyOIBTANKDIPDATE
OIB_USERDEF_VMR_CDSConversion parameters for user defaults VMROIBUSERDEF_V