I_WORKPERMITSAFETYREQUIREMENT

CDS View

Work Permit Safety Requirements

I_WORKPERMITSAFETYREQUIREMENT is a CDS View in S/4HANA. Work Permit Safety Requirements. 6 CDS views read from this table.

Used by 6 CDS view(s)

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_NatureOfWork view from BASIC Nature of Work
I_NatureOfWorkGroup view from BASIC Nature of Work Group
I_PersonalProtectiveEquipment view from BASIC Personal Protective Equipment
I_PrsnlPrtcvEquipmentGroup view from BASIC Personal Protective Equipment Group
I_SafetyPrecaution view_entity from BASIC Safety Precaution Category
I_SafetyPrecautionGroup view_entity from BASIC Safety Precaution Group Details 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Permit Safety Requirements'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view entity I_WorkPermitSafetyRequirement
  as select from           wrkpmtsftyrqmt  as _Wrkpmtsftyrqmt
    left outer to one join ptwwrkpmtassgmt as _WrkPmtAssgmt on  _Wrkpmtsftyrqmt.iwerk        = _WrkPmtAssgmt.iwerk
                                                            and _Wrkpmtsftyrqmt.wapiuse      = _WrkPmtAssgmt.workpermittype
                                                            and _Wrkpmtsftyrqmt.grp_category = _WrkPmtAssgmt.ptwsftyrqmtcategory
                                                            and _Wrkpmtsftyrqmt.grp_id       = _WrkPmtAssgmt.ptwsftyrqmtgrp
                                                            and _Wrkpmtsftyrqmt.item_id      = _WrkPmtAssgmt.ptwsftyrqmt


  association [1..1] to I_WorkPermitBasic            as _WorkPermit                 on  _Wrkpmtsftyrqmt.wapinr = _WorkPermit.WorkPermit
{
  key _Wrkpmtsftyrqmt.wapinr                 as WorkPermit,
  key _Wrkpmtsftyrqmt.grp_category           as WorkPermitGroupCategory,
  key _Wrkpmtsftyrqmt.grp_id                 as WrkPmtSafetyRequirementGroup,
  key _Wrkpmtsftyrqmt.item_id                as WorkPermitSafetyRequirement,
      _Wrkpmtsftyrqmt.iwerk as MaintenancePlanningPlant,
      _WorkPermit.WorkPermitInternalID,
      _Wrkpmtsftyrqmt.wapiuse as WorkPermitType,
      //_WorkPermit.WorkPermitType,

     // _WorkPermit.MaintenancePlanningPlant,

      _WorkPermit.WrkPmtMgmtObjSubType,
      _Wrkpmtsftyrqmt.checkbox               as WrkPmtSftyRqmtIsSelected,
      _Wrkpmtsftyrqmt.comments               as UserCommentsText,
      _Wrkpmtsftyrqmt.implementedby          as CreatedByUser,
      _Wrkpmtsftyrqmt.implementedon          as CreationDateTime,
      _Wrkpmtsftyrqmt.implemented            as WrkPmtSftyRqmtIsImplemented,
      _WrkPmtAssgmt.ptwsftyprcautnisimplmtbl as EntryIsRequired,
      _WrkPmtAssgmt.ptwsftycerttype          as SafetyCertificateType,
      _WrkPmtAssgmt.ptwsftyprcautnimplmtnblkdby as WrkPmtSftyPrcautnIsBlocked
}

Learn More