R_WORKPERMITAPPROVALSEGMENTTP

CDS View

Work Permit Approval Segment View

R_WORKPERMITAPPROVALSEGMENTTP is a CDS View in S/4HANA. Work Permit Approval Segment View. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_WorkPermitApprovalHistory view_entity projection CONSUMPTION WorkPermit Approval History
C_WorkPermitApprovalSegmentTP view_entity projection CONSUMPTION Approval History 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Work Permit Approval Segment View'
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #S, dataClass: #META}
@VDM.viewType: #TRANSACTIONAL
@VDM.usage.type: [#TRANSACTIONAL_PROCESSING_SERVICE]
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

define view entity R_WorkPermitApprovalSegmentTP
  as select from I_WorkPermitApprvlSgmt
  association        to parent R_WorkPermitTP     as _WorkPermit on  _WorkPermit.WorkPermit = $projection.WorkPermit
  association [0..1] to I_TextObjectPlainLongText as _LongText   on  $projection.TextObjectKey    = _LongText.TextObjectKey
                                                                 and _LongText.TextObjectCategory = 'APPROVAL'
                                                                 and _LongText.TextObjectType     = 'LTXT'
                                                                 and _LongText.Language           = $session.system_language
   association [0..1] to I_TextObjectPlainLongText as _LongTextRevoke   on  $projection.WorkPermitRevokeLongTextKey    = _LongTextRevoke.TextObjectKey
                                                                 and _LongTextRevoke.TextObjectCategory = 'APPROVAL'
                                                                 and _LongTextRevoke.TextObjectType     = 'LTXT'
                                                                 and _LongTextRevoke.Language           = $session.system_language
   -- Extensions, do not expose as association:
   association [0..1] to E_WorkPermitApprovalHistory as _WorkPermitApprvlHistExtension  on  $projection.WorkPermitInternalID       = _WorkPermitApprvlHistExtension.WorkPermitInternalID
                                                                                        and $projection.WrkPermitApprvlSgmt        = _WorkPermitApprvlHistExtension.WrkPermitApprvlSgmt
                                                                                        and $projection.NumberOfWrkPermitApprovals = _WorkPermitApprvlHistExtension.NumberOfWrkPermitApprovals

{

  key I_WorkPermitApprvlSgmt.WorkPermitInternalID,
  key I_WorkPermitApprvlSgmt.WrkPermitApprvlSgmt,
  key I_WorkPermitApprvlSgmt.NumberOfWrkPermitApprovals,
      I_WorkPermitApprvlSgmt.WorkPermit,
      //@Semantics.user.createdBy: true

      I_WorkPermitApprvlSgmt._WorkPermitApproval.WorkPermitApproval,
      I_WorkPermitApprvlSgmt.WrkPermitApprvlEnteredByUsr,
      @Semantics.systemDate.createdAt:true
      I_WorkPermitApprvlSgmt.WrkPermitApprvlEntryDate,
      I_WorkPermitApprvlSgmt.WrkPermitApprvlEntryTime,
      @Semantics.systemDateTime.lastChangedAt: true
      I_WorkPermitApprvlSgmt.ApprovalDateTime,
      I_WorkPermitApprvlSgmt.WrkPermitAprvdFromDate,
      I_WorkPermitApprvlSgmt.WrkPermitAprvdToDate,
      I_WorkPermitApprvlSgmt.WrkPermitAprvdFromTime,
      I_WorkPermitApprvlSgmt.WrkPermitAprvdToTime,
     // @Semantics.user.createdBy: true


      I_WorkPermitApprvlSgmt.WrkPermitApprvlDactvtdByUsr,
      I_WorkPermitApprvlSgmt.WrkPmtApprvlDeactivationDate,
      I_WorkPermitApprvlSgmt.WrkPmtApprvlDeactivationTime,
      I_WorkPermitApprvlSgmt.WorkPermitRevokeDateTime,
      I_WorkPermitApprvlSgmt.WrkPermitApprvlSgmtIsInactive,
      I_WorkPermitApprvlSgmt.WorkPermitApprovalComment,
      I_WorkPermitApprvlSgmt.WorkPermitApprovalDescription,
      I_WorkPermitApprvlSgmt.TextObjectKey,
      I_WorkPermitApprvlSgmt.WorkPermitRevokeLongTextKey,
      _LongText.PlainLongText,
      _LongTextRevoke.PlainLongText as WorkPermitRevokeLongText,
      _CreatedByUser,
      _RejectByUser,
      _WorkPermit,
      _LongText,
      _LongTextRevoke
}
where
  WrkPmtMgmtObjSubType = 'P'

Learn More