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 WorkPermitApprovalHistory
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
{

  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'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TEXTOBJECTPLAINLONGTEXT",
"I_WORKPERMITAPPROVAL",
"I_WORKPERMITAPPRVLSGMT"
],
"ASSOCIATED":
[
"I_TEXTOBJECTPLAINLONGTEXT",
"I_USER",
"R_WORKPERMITTP"
],
"BASE":
[
"I_WORKPERMITAPPRVLSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More