C_SuperiorEHSLocForIdentifyRsk

DDL: C_SUPERIOREHSLOCFORIDENTIFYRSK SQL: CEHSSUPRLOCIDRSK Type: view CONSUMPTION

Superior EHS Location for Identify Risks

C_SuperiorEHSLocForIdentifyRsk is a Consumption CDS View that provides data about "Superior EHS Location for Identify Risks" in SAP S/4HANA. It reads from 1 data source (I_CurrentEHSLocationPath) and exposes 11 fields with key fields EHSLocationUUID, EHSSuperiorLocationUUID. It has 2 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_CurrentEHSLocationPath I_CurrentEHSLocationPath from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_EHSLocationForIdentifyRisks _EHSLocationForIdentifyRisks $projection.EHSSuperiorLocationUUID = _EHSLocationForIdentifyRisks.EHSLocationUUID
[1..1] C_EHSLocation _EHSLocation $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID

Annotations (13)

NameValueLevelField
EndUserText.label Superior EHS Location for Identify Risks view
VDM.viewType #CONSUMPTION view
ObjectModel.updateEnabled false view
ObjectModel.createEnabled false view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey EHSSuperiorLocationUUID view
AbapCatalog.sqlViewName CEHSSUPRLOCIDRSK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY EHSLocationUUID EHSLocationUUID
_EHSLocation _EHSLocation
KEY EHSSuperiorLocationUUID EHSSuperiorLocationUUID
_EHSLocationForIdentifyRisks _EHSLocationForIdentifyRisks
EHSLocationHierarchyLevel EHSLocationHierarchyLevel
EHSLocationName _EHSLocationForIdentifyRisks EHSLocationName
EHSLocationAuthorizationGroup _EHSLocationForIdentifyRisks EHSLocationAuthorizationGroup
Plant _EHSLocationForIdentifyRisks Plant
CostCenter _EHSLocationForIdentifyRisks CostCenter
CompanyCode _EHSLocationForIdentifyRisks CompanyCode
BusinessArea _EHSLocationForIdentifyRisks BusinessArea 
@EndUserText.label: 'Superior EHS Location for Identify Risks'

@VDM.viewType: #CONSUMPTION
@ObjectModel.updateEnabled: false
@ObjectModel.createEnabled: false

@AccessControl.authorizationCheck: #CHECK

@ObjectModel.representativeKey: 'EHSSuperiorLocationUUID'

@AbapCatalog.sqlViewName: 'CEHSSUPRLOCIDRSK'
@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:  #XL,         // < 100.000.000

                         dataClass: #MASTER } 
                         

define view C_SuperiorEHSLocForIdentifyRsk 
  as select from I_CurrentEHSLocationPath 
  
  association [1..1] to C_EHSLocationForIdentifyRisks as _EHSLocationForIdentifyRisks on $projection.EHSSuperiorLocationUUID = _EHSLocationForIdentifyRisks.EHSLocationUUID
  association [1..1] to C_EHSLocation as _EHSLocation on $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID

{
    @ObjectModel.foreignKey.association: '_EHSLocation'     
    key EHSLocationUUID,  
    _EHSLocation,
    @ObjectModel.foreignKey.association: '_EHSLocationForIdentifyRisks'     
    key EHSSuperiorLocationUUID,
    _EHSLocationForIdentifyRisks,
    EHSLocationHierarchyLevel,
    _EHSLocationForIdentifyRisks.EHSLocationName,
    
    // fields for authorization check

    _EHSLocationForIdentifyRisks.EHSLocationAuthorizationGroup,
    _EHSLocationForIdentifyRisks.Plant,
    _EHSLocationForIdentifyRisks.CostCenter,
    _EHSLocationForIdentifyRisks.CompanyCode,
    _EHSLocationForIdentifyRisks.BusinessArea
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_EHSLOCATIONFORIDENTIFYRISKS",
"I_CURRENTEHSLOCATIONPATH"
],
"ASSOCIATED":
[
"C_EHSLOCATION",
"C_EHSLOCATIONFORIDENTIFYRISKS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More