R_WORKPERMITSAFETYPRECAUTIONTP

CDS View

WorkPermit Safety Precaution Group

R_WORKPERMITSAFETYPRECAUTIONTP is a CDS View in S/4HANA. WorkPermit Safety Precaution Group. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_WorkPermitSafetyPrecaution view_entity projection CONSUMPTION Work Permit Safety Precaution
C_WorkPermitSafetyPrecautionTP view_entity projection CONSUMPTION Work Permit Safety Precaution Group - TP 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #S, dataClass: #META}
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@EndUserText.label: 'WorkPermit Safety Precaution Group'
@Metadata.ignorePropagatedAnnotations:true
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
define view entity R_WorkPermitSafetyPrecautionTP
  as select from I_WorkPermitSafetyPrecaution
  association        to parent R_WorkPermitTP      as _WorkPermit    on $projection.WorkPermit = _WorkPermit.WorkPermit
  association [1..1] to I_User                     as _CreatedByUser on _CreatedByUser.UserID = $projection.CreatedByUser

  -- Extensions, do not expose as association:
  association [0..1] to E_WorkPermitSafetyPrecaution   as          _WorkPermitSPRExtension
          on  _WorkPermitSPRExtension.WorkPermit                   = $projection.WorkPermit
          and _WorkPermitSPRExtension.WorkPermitGroupCategory      = $projection.WorkPermitGroupCategory
          and _WorkPermitSPRExtension.WrkPmtSafetyRequirementGroup = $projection.WrkPmtSafetyRequirementGroup
          and _WorkPermitSPRExtension.WorkPermitSafetyRequirement  = $projection.WorkPermitSafetyRequirement

{
  key WorkPermit,
  key WorkPermitGroupCategory,
  key WrkPmtSafetyRequirementGroup,
  key WorkPermitSafetyRequirement,
      WorkPermitInternalID,
      UserCommentsText,
      CreatedByUser,
      _CreatedByUser.UserDescription as CreatedByUserName,
      CreationDateTime,
      WrkPmtSftyRqmtIsSelected,
      WrkPmtSftyRqmtIsImplemented,
      WrkPmtSftyRqmtCriticalityCode,
      CriticalityText,
      _CreatedByUser,
      MaintenancePlanningPlant,
      WorkPermitType,
      _WorkPermit,
      _SftyPrcautnGroupTxt.WrkPmtSftyRequirementGroupText,
      _SftyPrcautnItemTxt.WrkPmtSafetyRequirementText ,
      SafetyCertificateType,
      SftyCertificateTypeDescription
}
where WrkPmtMgmtObjSubType = 'P'

Learn More