C_EHSCONTROLIMPL

CDS View

Control Implementations

C_EHSCONTROLIMPL is a CDS View in S/4HANA. Control Implementations. It contains 3 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 3 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_MyOpenEHSControlImpl view from CONSUMPTION My Open Control Implementations

Fields (3)

KeyField CDS FieldsUsed in Views
_EHSLocation _EHSLocation 1
EHSControlUUID EHSControlUUID 1
EHSLocationUUID EHSLocationUUID 1 
@EndUserText.label: 'Control Implementations'

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

@AccessControl.authorizationCheck: #CHECK

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


@UI: {
  headerInfo: {
    typeName: 'Control Implementation',
    typeNamePlural: 'Control Implementations'
  }
}

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


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

// 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 }

@AccessControl.personalData.blocking: #NOT_REQUIRED

define view C_EHSControlImpl
  as select from I_EHSControlImpl
  //  with parameters

  //    @Consumption.hidden: true

  //    @Environment.systemField: #SYSTEM_DATE

  //    P_KeyDate  : sydatum


  association [1..1] to C_EHSRisk               as _EHSRisk                on $projection.EHSRiskUUID = _EHSRisk.EHSRiskUUID
  association [0..1] to C_EHSRiskAssessment     as _EHSRiskAssessment      on $projection.EHSRiskAssessmentUUID = _EHSRiskAssessment.EHSRiskAssessmentUUID 
  association [1..1] to C_EHSLocation           as _EHSLocation            on $projection.EHSLocationUUID = _EHSLocation.EHSLocationUUID
  association [1..1] to I_EHSCtrlTaskStatus     as _EHSControlTaskStatus   on $projection.EHSControlTaskStatus = _EHSControlTaskStatus.EHSControlTaskStatus
  association [1..1] to I_EHSControl            as _EHSControl             on $projection.EHSControlUUID = _EHSControl.EHSControlUUID
  association [0..1] to C_EHSCtrlImplmtnRespCntctCard as _ResponsibleContactCard on $projection.EHSControlInstanceUUID = _ResponsibleContactCard.EHSControlInstanceUUID
  association [0..1] to I_Material              as _Material               on $projection.Material = _Material.Material
  association [0..1] to I_FunctionalLocation    as _FunctionalLocation     on $projection.FunctionalLocation = _FunctionalLocation.FunctionalLocation
  association [0..1] to I_Equipment             as _Equipment              on $projection.Equipment = _Equipment.Equipment
{
  key EHSControlInstanceUUID,

      @ObjectModel.foreignKey.association: '_EHSControl'
      EHSControlUUID,
      _EHSControl,

      @ObjectModel.foreignKey.association: '_EHSRisk'
      EHSRiskUUID,
      _EHSRisk,
      EHSRiskRevisionUUID,      
  
      @ObjectModel.foreignKey.association: '_EHSRiskAssessment'    
      EHSRiskAssessmentUUID,
      _EHSRiskAssessment,      

      @ObjectModel.foreignKey.association: '_EHSCtrlImplementationStatus'
      EHSControlImplStatus,
      _EHSCtrlImplementationStatus,

      @ObjectModel.foreignKey.association: '_EHSControlRefCategory'
      EHSControlRefCategory,
      _EHSControlRefCategory,

      I_EHSControlImpl.ResponsiblePerson,
      _ResponsibleContactCard,

      @ObjectModel.foreignKey.association: '_EHSCtrlEffect'
      DesiredEHSControlEffect,
      _EHSCtrlEffect,

      @ObjectModel.foreignKey.association: '_EHSGoalTarget'
      EHSControlTarget,
      _EHSGoalTarget,

      EHSControlObjective,

      @ObjectModel.foreignKey.association: '_FunctionalLocation'
      FunctionalLocation,
      _FunctionalLocation,
      
      @ObjectModel.foreignKey.association: '_Equipment'
      Equipment,
      _Equipment,
      
      MaintenanceObject,
      TechObjIsEquipOrFuncnlLoc,
      
      @ObjectModel.foreignKey.association: '_Material'
      Material,
      _Material,

      Hazard,
      @ObjectModel.foreignKey.association: '_EHSCatalog'
      EHSControlCatalog,
      _EHSCatalog,

      @ObjectModel.foreignKey.association: '_EHSLocation'
      EHSLocationUUID,
      _EHSLocation,

      @ObjectModel.foreignKey.association: '_EHSRiskStatus'
      EHSRiskStatus,
      _EHSRiskStatus,

      @ObjectModel.foreignKey.association: '_EHSRiskLevel'
      EHSRiskLevel,
      _EHSRiskLevel,

      @ObjectModel.text.association: '_EHSControlRemarkText'
      EHSControlRemarkUUID,
      _EHSControlRemarkText,

      EHSControlTaskStatus,

      EHSTaskDueDate,      
      EHSActnDuUTCDteTmeCriticality,

      _EHSControlTaskStatus,
      EHSControlAdhocTitle,
      EHSControlIsAdhoc
}

Learn More