C_AdhocEHSCtrlForIdentifyRisks

DDL: C_ADHOCEHSCTRLFORIDENTIFYRISKS SQL: CAHCTRLFIR Type: view CONSUMPTION

Adhoc EHS Control For Identify Risks

C_AdhocEHSCtrlForIdentifyRisks is a Consumption CDS View that provides data about "Adhoc EHS Control For Identify Risks" in SAP S/4HANA. It reads from 1 data source (I_EHSRiskControl) and exposes 14 fields with key field EHSControlInstanceUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_EHSRiskControl I_EHSRiskControl from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_EHSRisksForIdentifyRisks _EHSRisk $projection.EHSRiskUUID = _EHSRisk.EHSRiskUUID
[0..*] I_EHSCtrlTypeText _EHSCtrlTypeText $projection.EHSControlAdhocType = _EHSCtrlTypeText.EHSControlType

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CAHCTRLFIR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
UI.headerInfo.typeName Adhoc Control view
UI.headerInfo.typeNamePlural Adhoc Controls view
UI.headerInfo.title.value EHSControlAdhocTitle view
Consumption.semanticObject EHSControl view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Adhoc EHS Control For Identify Risks view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY EHSControlInstanceUUID EHSControlInstanceUUID
EHSRiskUUID I_EHSRiskControl EHSRiskUUID
_EHSRisk _EHSRisk
_EHSRiskRoot _EHSRiskRoot
EHSRiskRevisionUUID I_EHSRiskControl EHSRiskRevisionUUID
_EHSRiskRevision _EHSRiskRevision
EHSControlAdhocTitle I_EHSRiskControl EHSControlAdhocTitle
EHSControlAdhocType I_EHSRiskControl EHSControlAdhocType
_EHSControlAdhocType I_EHSRiskControl _EHSControlAdhocType
_EHSCtrlTypeText _EHSCtrlTypeText
EHSControlAdhocSubtype I_EHSRiskControl EHSControlAdhocSubtype
_EHSControlAdhocSubtype I_EHSRiskControl _EHSControlAdhocSubtype
EHSControlRemarkUUID
_EHSControlRemarkText I_EHSRiskControl _EHSControlRemarkText
@AbapCatalog.sqlViewName: 'CAHCTRLFIR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_EHSControlRemarkText']

@VDM.viewType: #CONSUMPTION

@ObjectModel.semanticKey: ['EHSControlInstanceUUID'] // this will make the title column bold in smart templates


@UI: {
  headerInfo: {
    typeName: 'Adhoc Control',
    typeNamePlural: 'Adhoc Controls',
    title: {
      value: 'EHSControlAdhocTitle'
    }   
  }
}

@Consumption.semanticObject: 'EHSControl'
//@ObjectModel.representativeKey: 'EHSRiskAssessmentUUID'


// Client handling by session

@ClientHandling.algorithm: #SESSION_VARIABLE

// used for BOBF Master Data Object

@ObjectModel.usageType:{ serviceQuality: #D,        // < 100 msec

                         sizeCategory:  #L,         // < 10.000.000

                         dataClass: #MIXED }

@EndUserText.label: 'Adhoc EHS Control For Identify Risks'
define view C_AdhocEHSCtrlForIdentifyRisks as select from I_EHSRiskControl
  association [1..1] to C_EHSRisksForIdentifyRisks as _EHSRisk on $projection.EHSRiskUUID = _EHSRisk.EHSRiskUUID
  association [0..*] to I_EHSCtrlTypeText as _EHSCtrlTypeText on $projection.EHSControlAdhocType = _EHSCtrlTypeText.EHSControlType
 {
  
  key EHSControlInstanceUUID,
  @Consumption.valueHelpDefinition: [{ entity: { name: 'I_EHSRiskStdVH', element: 'EHSRiskUUID' }}]      
  I_EHSRiskControl.EHSRiskUUID,
  _EHSRisk,  
  _EHSRiskRoot,
  I_EHSRiskControl.EHSRiskRevisionUUID,
  _EHSRiskRevision,
  I_EHSRiskControl.EHSControlAdhocTitle,
  @ObjectModel.text.association: '_EHSCtrlTypeText'
  I_EHSRiskControl.EHSControlAdhocType,
  I_EHSRiskControl._EHSControlAdhocType,
  _EHSCtrlTypeText,
  I_EHSRiskControl.EHSControlAdhocSubtype,
  I_EHSRiskControl._EHSControlAdhocSubtype,
    
  @ UI: {
        textArrangement: #TEXT_ONLY,
        multiLineText: true
  }
  I_EHSRiskControl.EHSControlRemarkUUID,
  I_EHSRiskControl._EHSControlRemarkText
  
} where I_EHSRiskControl.EHSControlIsAdhoc = 'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EHSRISKCONTROL"
],
"ASSOCIATED":
[
"C_EHSRISKSFORIDENTIFYRISKS",
"I_EHSCONTROLSUBTYPE",
"I_EHSCONTROLTYPE",
"I_EHSCTRLTYPETEXT",
"I_EHSRISKREVISION",
"I_EHSRISKROOT",
"I_EHSTEXTCOLLECTIONTEXT"
],
"BASE":
[
"I_EHSRISKCONTROL"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/