CDS Views for Environment Management (EHS-SUS-EM)

CDS View NameDescriptionSQL View Name
C_AMOUNTAmount DataCAMOUNT
C_CALCDEFRESULTHEADERCalculationCCALCRESHEAD
C_DATACOLLECTIONData CollectionCDATACOLLECTION
C_EHSCMPLNCANLYSBYLOCTYPEQCompl Analysis Query of Tasks by LoctypeCEHSCALTQ
C_EHSCMPLNCANLYSFLTRTASKQCompliance Analysis FIlter QueryIEHSCAFLTRTQ
C_EHSCMPLNCANLYSLOCHIERQCompliance Analysis Query for Loc HierCEHSCALHQ
C_EHSCMPLNCANLYSRQMTTASKQCompliance Analysis Query for Req TasksCEHSCARQTQ
C_EHSCMPLNCSCENRELATEDTASKCompliance Scenario Related Task ListCEHSSCENRELTASK
C_EHSCMPLNCSCENTASKDEFTYPEVHEHS Compliance Scenario Task Definition Value HelpCEHSCSCENTDTVH
C_EHSCMPLNCSCENTSKDEFCompliance Scenario Task DefinitionsCEHSSCENDEF
C_EHSCMPLNCSCENTSKDEFANDINSTCEScenario Task Inst. and Future Defs.CEHSSCENDEFINST
C_EHSDATAPERIODVALUEHELPValue Help for Data PeriodCEHSDPERF4
C_EHSMYDATACOLLECTIONMy Data CollectionsCEHSMYDC
C_EHSMYDATACOLLECTIONAMOUNTSMy Data Collection AmountsCEHSAMNSMYDC
C_EHSSCHEDULEVALUEHELPValue Help for ScheduleCSCHEDULEF4
C_ENVRMTAMOUNTSOVERVIEWQEnvironmental Amounts Overview QueryCENVAMNSOVRVIEWQ
C_EXPORTPROFILEExport ProfileCEXPORTPROFILE
C_LOCATIONAGGREGATIONLocation AggregationCLOCAGGR
C_SAMPLINGSamplingCSAMPL
C_SAMPLINGDEFINITIONROOTSamplingCSAMPLROOT
C_SCENARIOLIMITMonitor Scenario Limit DataCSCENARIOLIMIT
EHENV_ADEF_AMNSAggregation AmountsEHENVV_AAMN
EHENV_ADEF_AMNS_AT_LOCATIONAgreggation Amounts at LocationEHENVV_AAMN4LOC
EHENV_ADEF_AMNS_AT_LOCATION_TAggregation Amounts at Location TextEHENVV_AAM4LOCT
EHENV_ADEF_AMNS_TAggregation Amounts TextEHENVV_AAMNT
EHENV_ADEF_CDEF_DEFSLocation Aggregation - Calculation DefinitionsEHENV_ADEF_CDEF
EHENV_ADEF_DEFS_ALLLocation Aggregation - Get allEHENV_ADEF_ALL
EHENV_ADEF_MDEF_DEFSLocation Aggregation - Measurement DefinitionsEHENV_ADEF_MDEF
EHENV_ADEF_SDEF_DEFSLocation Aggregation - Sampling DefinitionsEHENV_ADEF_SDEF
EHENV_AMNS_ALLAll AmountsEHENVV_AMNALL
EHENV_AMNS_ALL_LOCAmounts for all locationsEHENVV_AMNST
EHENV_AMNS_ALL_LOC_FILTERAmounts for all locations filterEHENVV_ALL_AMNS
EHENV_AMNS_AT_LOCAmounts at location and its sublocationsEHENVV_AMNS_LOC
EHENV_AMNS_AT_LOCATIONAmounts for a LocationEHENVV_AMNS4LOC
EHENV_AMNS_AT_LOC_FILTERAmounts for location and sublocations filterEHENVV_AMNS_FLT
EHENV_AMNS_EXAmounts with Value date/time extended dataEHENVV_AMNS_EX
EHENV_AMNS_EXTAmounts Extended View with Mount textEHENVV_AMNS_EXT
EHENV_CDEF_AMNSCalculation AmountsEHENVV_CAMN
EHENV_CDEF_AMNS_ALLAll CDEFs for AmountsEHENVV_AMNS_CDEF
EHENV_CDEF_AMNS_ALL_PAll CDEFs for Amounts with parameterEHENVV_AM_CDEF
EHENV_CDEF_AMNS_AT_LOCATIONCalculation Amounts At LocationEHENVV_CAMN4LOC
EHENV_CDEF_AMNS_AT_LOCATION_TCalculation Amouonts at location with translated textsEHENVV_CMAM4LOCT
EHENV_CDEF_AMNS_TCalculation Amounts with TextsEHENVV_CAMNT
EHENV_LOCATION_ALLRetrieves current revision locationsEHENVV_LOC_ALL
EHENV_LOCATION_FILTERRetrieves current revision location and its sublocationsEHENVV_LOC_FLT
EHENV_MDEF_AMNSMeasurement AmountsEHENVV_MAMN
EHENV_MDEF_AMNS_AT_LOCATIONMeasurement Amounts At LocationEHENVV_MAMN4LOC
EHENV_MDEF_AMNS_AT_LOCATION_TAmounts At Location with Domain TextsEHENVV_MAM4LOCT
EHENV_MDEF_AMNS_TMeasurement Amounts with TextsEHENVV_MAMNT
EHENV_SCENARIO_LIMITSEnvironmental Scenario LimitsEHENVV_SCEN_LMT
EHENV_SCEN_LOC_ACTIVEActive Scenarios for a UserEHENVV_SCEN_LOCA
EHENV_SCEN_MDEF_SCHEDULESScenario - Measurement Definitions schedulesEHENV_SCEN_SCHE
EHENV_SCEN_USRA_LOC_CURR_REVActive Scenarios per user and location current revisionEHENVV_SCEN_USCR
EHENV_SCEN_USR_ACTIVEActive Scenarios for a UserEHENVV_SCEN_USRA
EHENV_SDEF_AMNSSampling AmountsEHENVV_SAMN
EHENV_SDEF_AMNS_AT_LOCATIONSampling Amounts at LocationEHENVV_SAMN4LOC
EHENV_SDEF_AMNS_AT_LOCATION_TSampling Amounts at Location as TextEHENVV_SMAM4LOCT
EHENV_SDEF_AMNS_TSampling Amounts with TextsEHENVV_SAMNT
I_CALCDEFRESULTHEADERCalculation Definition - Result HeaderICDEFRESH
I_DATACOLLCURRENTSCHEDULEData Collection Current ScheduleIMDEFCURSCH
I_DATACOLLECTIONROOTData Collection RootIMDEFROOT
I_DATACOLLECTIONROOTBASICData Collection RootIMDEFROOTB
I_DATACOLLECTIONSCHEDULEData Collection ScheduleIMDEFSCHE
I_EHSACTIVESCENEHS Scenarios with an active revisionIEHSACTIVESCEN
I_EHSACTIVESCENDATACOLLEHS Data Collections of active scenariosIEHSACTSCENDC
I_EHSACTIVITYLIMITSEHS Activity LimitsIEHSACTLIM
I_EHSACTIVITYTITLEEHS Activity TitleIEHSACTTIT
I_EHSCMPLNCANLYSFLTRTASKCCompliance Analysis FIlter CubeIEHSCAFLTRTC
I_EHSCMPLNCANLYSLOCHIERCCompliance Analysis Cube for Loc HierIEHSCALHC
I_EHSCMPLNCANLYSLOCTYPETASKCCompl Analysis Cube of Tasks by Loc typeIEHSCALTTC
I_EHSCMPLNCANLYSRQMTTASKCCompliance Analysis Cube for Req TasksIEHSCARQTC
I_EHSCMPLNCSCENAUTHZNFIELDSEHS Compliance Scenario Authorization FieldsIEHSCPLSCAUTH
I_EHSCMPLNCSCENCALCEHS Compliance Scenario CalculationIEHSCLMPSCENCALC
I_EHSCMPLNCSCENCURRENTREVISIONEHS Compliance Scenario Current RevisionIEHSSCENCURREV
I_EHSCMPLNCSCENDATACOLLEHS Compliance Scenario Data CollectionIEHSCMPLSCENCOLL
I_EHSCMPLNCSCENINITREVISIONEHS Compliance Scenario Initial RevisionIEHSSCENINITREV
I_EHSCMPLNCSCENINITREVISIONDTEEHS Compl. Scen. Initial Revision DateIEHSCMPLINITDATE
I_EHSCMPLNCSCENLIMITEHS Compliance Scenario LimitIEHSCMPLSCENLMT
I_EHSCMPLNCSCENLOCAGGRGNEHS Compliance Scenario Loc. AggregationIEHSSCENLOCAGGR
I_EHSCMPLNCSCENNAMEEHS Compliance Scenario NameICMPLSCENNAME
I_EHSCMPLNCSCENPERCALCEHS Compliance Scenario CalculationIEHSSCENPERCALC
I_EHSCMPLNCSCENPERDATACOLLEHS Compliance Scenario Rev. Data Coll.IEHSSCENPERCOLL
I_EHSCMPLNCSCENPERLOCAGGRGNEHS Compl. Scen. Rev. Loc. AggregationIEHSSCENPERAGGR
I_EHSCMPLNCSCENPERSMPLGEHS Compliance Scenario SamplingISCENPERSAMPLING
I_EHSCMPLNCSCENREVISIONEHS Compliance Scenario RevisionIEHSCMPLSCENREV
I_EHSCMPLNCSCENROOTEHS Compliance Scenario RootIEHSCMPLSCENROOT
I_EHSCMPLNCSCENSMPLGEHS Compliance Scenario SamplingIEHSSCENSAMPL
I_EHSDATAPERIODEHS Data PeriodIEHSDPERIOD
I_EHSDATAPERIODTEXTEHS Data Period textIEHSDPERTXT
I_EHSFORECASTMETHODEHS Forecast MethodIEHSFCSTM
I_EHSFORECASTMETHODTEXTEHS Forecast Method TextIEHSFCSTMTXT
I_EHSMYDATACOLLECTIONMy Data CollectionsIEHSMYDC
I_EHSSCHEDULEEHS ScheduleIEHSSCHE
I_EHSSCHEDULETEXTEHS Schedule TextIEHSSCHETXT
I_ENVRMTAMOUNTSFORACTIVITYAmounts for ActivitiesIENVAMNSFORACT
I_ENVRMTAMOUNTSOVERVIEWAmounts Overview with Substance informationIENVAMNSOVRVIEW
I_EXPORTPROFILEExport Profile - BasicIEXPORTPROFILE
I_LOCAGGREGATIONROOTLocation Aggregation RootIADEFROOT
I_SAMPLINGDEFINITIONROOTSampling Definition RootISDEFROOT
I_SAMPLINGHEADERSampling Definition - HeaderISDEFHEAD
I_SAMPLINGREFERENCESampling Definition - SamplingRefISDEFSAMP
P_CALCPERIODCalculation PeriodPCALCPERIOD
P_DATACOLLDEFPERIODData Collection PeriodPMDEFPERIOD
P_EHSMYDATACOLPENDINGAMOUNTSMy Data Collection Pending AmountsPMYDCPENDAM
P_LOCAGGREGATIONPERIODLocation Aggregation PeriodPLOCAGGRPERIOD
P_SAMPLINGPERIODSampling PeriodPSAMPLPERIOD