P_EHSControlsCount

DDL: P_EHSCONTROLSCOUNT SQL: PEHSCTRLCNT Type: view CONSUMPTION Package: EHHSS_BO_RAS_IMPL

Private view for the count of the EHS Controls

P_EHSControlsCount is a Consumption CDS View that provides data about "Private view for the count of the EHS Controls" in SAP S/4HANA. It reads from 1 data source (I_EHSRiskControl) and exposes 2 fields with key field EHSRiskRevisionUUID. Part of development package EHHSS_BO_RAS_IMPL.

1 data source(s) 2 fields

Data Sources (1)

SourceAliasJoin Type
I_EHSRiskControl I_EHSRiskControl from

Annotations (10)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PEHSCTRLCNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY EHSRiskRevisionUUID I_EHSRiskControl EHSRiskRevisionUUID
NumberOfEHSControls 
@VDM.private: true
@VDM.viewType: #CONSUMPTION

@AccessControl.authorizationCheck: #NOT_REQUIRED

@AbapCatalog.sqlViewName: 'PEHSCTRLCNT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 

// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #C,        // < 15 msec

                         sizeCategory:  #M,         // < 100.000

                         dataClass: #MASTER }

define view P_EHSControlsCount 
  as select from I_EHSRiskControl
    //left outer join I_EHSRiskControl on I_EHSRiskControl.EHSRiskRevisionUUID = I_EHSRiskRevision.EHSRiskRevisionUUID 

{
  key I_EHSRiskControl.EHSRiskRevisionUUID,
  //key EHSControlInstanceUUID

  count(distinct EHSControlInstanceUUID) as NumberOfEHSControls
} group by I_EHSRiskControl.EHSRiskRevisionUUID

Learn More