I_EHSLOCATIONHIERARCHYREVISION

CDS View

Location Hierarchy Revision

I_EHSLOCATIONHIERARCHYREVISION is a CDS View in S/4HANA. Location Hierarchy Revision. It contains 2 fields. 39 CDS views read from this table.

Used by 39 CDS view(s) 2 fields

CDS Views using this table (39)

ViewTypeJoinVDMDescription
C_EquipSftyInstrnAreaFltrVH view inner CONSUMPTION All Factory Area for Safety Instruction for Equipment
C_EquipSftyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Safety Instruction for Equipment
C_GnrcSftyInstrnAreaFltrVH view inner CONSUMPTION Factory location areas for generic safety instruction
C_GnrcSftyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Generic Safety Instruction
C_GnrcSftyInstrnFactoryFltrVH view inner CONSUMPTION Factory locations for generic safety instruction
C_HzdsSubstInventoryFltrLocVH view inner CONSUMPTION HSI: Location Filter Value Help
C_HzdsSubstInventoryFreeLoc view inner CONSUMPTION HSI: Set of free locations
C_HzdsSubstInventoryLocVH view inner CONSUMPTION HSI: Location Value Help
C_SafetyInstrnEquipmentFltrVH view inner CONSUMPTION SI: Equipment Value Help for Filter Bar
C_SafetyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Safety Instruction
C_SafetyInstrnFactoryByPlantVH view inner CONSUMPTION Value Help for Factories by SI Structure
C_SafetyInstructionEquipmentVH view inner CONSUMPTION SI: Equipment Value Help
C_SafetyInstructionFactoryVH view inner CONSUMPTION HSI: Location Value Help
C_SftyInstrnFactoryAreaFltrVH view inner CONSUMPTION All Factory Areas for Safety Instruction
C_SubstSftyInstrnAreaFltrVH view inner CONSUMPTION All Factory Areas for Safety Instruction for Substance
C_SubstSftyInstrnFactoryAreaVH view inner CONSUMPTION Factory Areas for Safety Instruction for Substance
I_AprvdChemicalsForRskAtLocVH view inner COMPOSITE Approved Chemical for Location
I_CurEHSLocationInclRoot view inner COMPOSITE Current revision of EHS Locations
I_CurrentEHSLocationHierarchy view inner COMPOSITE Current EHS Location Structure Hierarchy
I_CurrentEHSLocationPath view inner COMPOSITE Current EHS Location Structure Path
I_CurrentEHSLocHierValueHelp view inner COMPOSITE EHS Location Value Help
I_CurrentEHSParentLocation view inner COMPOSITE Current EHS Parent Location
I_EHSCmplncAnlysLocTypeTaskC view inner COMPOSITE Compl Analysis Cube of Tasks by Loc type
I_EHSLocationExpanded view inner COMPOSITE EHS Location and Sublocations
I_EHSLocationForFiltering view inner COMPOSITE EHS Location and Sublocations for Filtering
I_EHSLocationHierarchy view inner COMPOSITE EHS Location Hierarchy
I_EHSLocationValueHelp view inner COMPOSITE EHS Location Value Help
I_EHSLocEnvrnmtlDtaRespInhtd view_entity inner COMPOSITE Location Environmental Data Responsible Inherited
I_EHSLocRespManagerInherited view inner COMPOSITE Location Responsible Manager Inherited
I_EHSLocRespMgrAndTechnInhtd view inner COMPOSITE Loc Responisble Manager and Operator
I_EHSLocRespTechnInherited view inner COMPOSITE Location Responsible Technician Inheritd
I_EHSLtstLocHierarchyRevision view from COMPOSITE Latest Location Hierarchy Revision
I_FavoriteEHSLocationExpanded view inner COMPOSITE Favorite EHS Location and Sublocations
I_MyEHSLocationExpanded view inner COMPOSITE My EHS Location and Sublocations
I_ReldSftyInstrnFactoryVH view_entity inner COMPOSITE Factories for Safety Instruction
I_ReldSftyInstrnFctryAreaVH view_entity inner COMPOSITE Factory Areas for Safety Instruction
I_WasteStreamPtOfGnrtnLoc view inner COMPOSITE Waste Stream Pt Of Generation Location
I_WasteStreamStorageLoc view inner COMPOSITE Waste Stream Storage Location
P_SftyInstrnTextBlockFactory view inner CONSUMPTION

Fields (2)

KeyField CDS FieldsUsed in Views
KEY RevisionEndDate RevisionEndDate 1
RevisionStartDate RevisionStartDate 1 
@AbapCatalog:{
    sqlViewName: 'IEHSLHRREV',
    compiler.compareFilter: true,
    preserveKey:true
 }
@EndUserText.label: 'Location Hierarchy Revision'
@AccessControl.authorizationCheck: #NOT_ALLOWED

@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@VDM.viewType: #BASIC
// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata:{
            allowExtensions:true,
            ignorePropagatedAnnotations:true
}
@ObjectModel:{
    representativeKey: ['EHSLocHierarchyUUID'],
// used for BOBF Master Data Object

    usageType:{ serviceQuality: #C,        // < 15 msec

                         sizeCategory:  #S,         // < 1.000

                         dataClass: #ORGANIZATIONAL },
    supportedCapabilities:  [ #ANALYTICAL_PROVIDER, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #ANALYTICAL_DIMENSION, #ANALYTICAL_DIMENSION, #EXTRACTION_DATA_SOURCE ]
}

define view I_EHSLocationHierarchyRevision
  as select from ehfndd_lhr_rev as rev
{

      @ObjectModel.text.element:  [ 'RevisionDescription' ]
  key parent_key     as EHSLocHierarchyUUID,

      @Semantics.businessDate.to
  key end_date       as RevisionEndDate,
  
      @Semantics.text: true
      revision_descr as RevisionDescription,
      
      @Semantics.businessDate.from
      split_date     as RevisionStartDate,
      
      db_key         as EHSLocHierarchyRevisionUUID,

      @Semantics.systemDateTime.lastChangedAt
      lchg_date_time as LastChangeDate

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EHFNDD_LHR_REV"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More