R_WorkPermitApprovalSegmentTP

DDL: R_WORKPERMITAPPROVALSEGMENTTP Type: view_entity TRANSACTIONAL Package: VDM_EAM_WCM_PERMIT_TO_WORK
29 Fields 1 Data Sources 3 Associations

Work Permit Approval Segment View

R_WorkPermitApprovalSegmentTP is a Transactional CDS View that provides data about "Work Permit Approval Segment View" in SAP S/4HANA. It reads from 1 data source (I_WorkPermitApprvlSgmt) and exposes 29 fields with key fields WorkPermitInternalID, WrkPermitApprvlSgmt, NumberOfWrkPermitApprovals. It has 3 associations to related views. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

Data Sources (1)

SourceAliasJoin Type
I_WorkPermitApprvlSgmt I_WorkPermitApprvlSgmt from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_TextObjectPlainLongText _LongText $projection.TextObjectKey = _LongText.TextObjectKey and _LongText.TextObjectCategory = 'APPROVAL' and _LongText.TextObjectType = 'LTXT' and _LongText.Language = $session.system_language
[0..1] I_TextObjectPlainLongText _LongTextRevoke $projection.WorkPermitRevokeLongTextKey = _LongTextRevoke.TextObjectKey and _LongTextRevoke.TextObjectCategory = 'APPROVAL' and _LongTextRevoke.TextObjectType = 'LTXT' and _LongTextRevoke.Language = $session.system_language -- Extensions, do not expose as association:
[0..1] E_WorkPermitApprovalHistory _WorkPermitApprvlHistExtension $projection.WorkPermitInternalID = _WorkPermitApprvlHistExtension.WorkPermitInternalID and $projection.WrkPermitApprvlSgmt = _WorkPermitApprvlHistExtension.WrkPermitApprvlSgmt and $projection.NumberOfWrkPermitApprovals = _WorkPermitApprvlHistExtension.NumberOfWrkPermitApprovals

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Work Permit Approval Segment View view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #META view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY WorkPermitInternalID I_WorkPermitApprvlSgmt WorkPermitInternalID Object number
KEY WrkPermitApprvlSgmt I_WorkPermitApprvlSgmt WrkPermitApprvlSgmt Counter
KEY NumberOfWrkPermitApprovals I_WorkPermitApprvlSgmt NumberOfWrkPermitApprovals Counter
WorkPermit I_WorkPermitApprvlSgmt WorkPermit Application
WorkPermitApproval
WrkPermitApprvlEnteredByUsr I_WorkPermitApprvlSgmt WrkPermitApprvlEnteredByUsr Entered by
WrkPermitApprvlEntryDate I_WorkPermitApprvlSgmt WrkPermitApprvlEntryDate Created on
WrkPermitApprvlEntryTime I_WorkPermitApprvlSgmt WrkPermitApprvlEntryTime Entered At
ApprovalDateTime I_WorkPermitApprvlSgmt ApprovalDateTime Time Stamp
WrkPermitAprvdFromDate I_WorkPermitApprvlSgmt WrkPermitAprvdFromDate App.fr date
WrkPermitAprvdToDate I_WorkPermitApprvlSgmt WrkPermitAprvdToDate App.to date
WrkPermitAprvdFromTime I_WorkPermitApprvlSgmt WrkPermitAprvdFromTime Entered At
WrkPermitAprvdToTime I_WorkPermitApprvlSgmt WrkPermitAprvdToTime AppToTime
WrkPermitApprvlDactvtdByUsr I_WorkPermitApprvlSgmt WrkPermitApprvlDactvtdByUsr Deactivated by
WrkPmtApprvlDeactivationDate I_WorkPermitApprvlSgmt WrkPmtApprvlDeactivationDate Deactivated on
WrkPmtApprvlDeactivationTime I_WorkPermitApprvlSgmt WrkPmtApprvlDeactivationTime Deactivated at
WorkPermitRevokeDateTime I_WorkPermitApprvlSgmt WorkPermitRevokeDateTime Time Stamp
WrkPermitApprvlSgmtIsInactive I_WorkPermitApprvlSgmt WrkPermitApprvlSgmtIsInactive Permit inactive
WorkPermitApprovalComment I_WorkPermitApprvlSgmt WorkPermitApprovalComment Approval Comment
WorkPermitApprovalDescription I_WorkPermitApprvlSgmt WorkPermitApprovalDescription Permit Text
TextObjectKey I_WorkPermitApprvlSgmt TextObjectKey Text Name
WorkPermitRevokeLongTextKey I_WorkPermitApprvlSgmt WorkPermitRevokeLongTextKey Text Name
PlainLongText _LongText PlainLongText Long Text
WorkPermitRevokeLongText _LongTextRevoke PlainLongText Long Text
_CreatedByUser _CreatedByUser
_RejectByUser _RejectByUser
_WorkPermit _WorkPermit
_LongText _LongText
_LongTextRevoke _LongTextRevoke

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_WorkPermitApprovalSegmentTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_WorkPermitApprovalSegmentTP AS
SELECT
  I_WorkPermitApprvlSgmt.WorkPermitInternalID AS WorkPermitInternalID,
  I_WorkPermitApprvlSgmt.WrkPermitApprvlSgmt AS WrkPermitApprvlSgmt,
  I_WorkPermitApprvlSgmt.NumberOfWrkPermitApprovals AS NumberOfWrkPermitApprovals,
  I_WorkPermitApprvlSgmt.WorkPermit AS WorkPermit,
  I_WorkPermitApprvlSgmt._WorkPermitApproval.WorkPermitApproval AS WorkPermitApproval,
  I_WorkPermitApprvlSgmt.WrkPermitApprvlEnteredByUsr AS WrkPermitApprvlEnteredByUsr,
  I_WorkPermitApprvlSgmt.WrkPermitApprvlEntryDate AS WrkPermitApprvlEntryDate,
  I_WorkPermitApprvlSgmt.WrkPermitApprvlEntryTime AS WrkPermitApprvlEntryTime,
  I_WorkPermitApprvlSgmt.ApprovalDateTime AS ApprovalDateTime,
  I_WorkPermitApprvlSgmt.WrkPermitAprvdFromDate AS WrkPermitAprvdFromDate,
  I_WorkPermitApprvlSgmt.WrkPermitAprvdToDate AS WrkPermitAprvdToDate,
  I_WorkPermitApprvlSgmt.WrkPermitAprvdFromTime AS WrkPermitAprvdFromTime,
  I_WorkPermitApprvlSgmt.WrkPermitAprvdToTime AS WrkPermitAprvdToTime,
  I_WorkPermitApprvlSgmt.WrkPermitApprvlDactvtdByUsr AS WrkPermitApprvlDactvtdByUsr,
  I_WorkPermitApprvlSgmt.WrkPmtApprvlDeactivationDate AS WrkPmtApprvlDeactivationDate,
  I_WorkPermitApprvlSgmt.WrkPmtApprvlDeactivationTime AS WrkPmtApprvlDeactivationTime,
  I_WorkPermitApprvlSgmt.WorkPermitRevokeDateTime AS WorkPermitRevokeDateTime,
  I_WorkPermitApprvlSgmt.WrkPermitApprvlSgmtIsInactive AS WrkPermitApprvlSgmtIsInactive,
  I_WorkPermitApprvlSgmt.WorkPermitApprovalComment AS WorkPermitApprovalComment,
  I_WorkPermitApprvlSgmt.WorkPermitApprovalDescription AS WorkPermitApprovalDescription,
  I_WorkPermitApprvlSgmt.TextObjectKey AS TextObjectKey,
  I_WorkPermitApprvlSgmt.WorkPermitRevokeLongTextKey AS WorkPermitRevokeLongTextKey,
  _LongText.PlainLongText AS PlainLongText,
  _LongTextRevoke.PlainLongText AS WorkPermitRevokeLongText
FROM I_WorkPermitApprvlSgmt
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongText ON TextObjectKey = _LongText.TextObjectKey AND _LongText.TextObjectCategory = 'APPROVAL' AND _LongText.TextObjectType = 'LTXT' AND _LongText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _LongTextRevoke ON WorkPermitRevokeLongTextKey = _LongTextRevoke.TextObjectKey AND _LongTextRevoke.TextObjectCategory = 'APPROVAL' AND _LongTextRevoke.TextObjectType = 'LTXT' AND _LongTextRevoke.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_WorkPermitApprovalHistory AS _WorkPermitApprvlHistExtension ON WorkPermitInternalID = _WorkPermitApprvlHistExtension.WorkPermitInternalID AND WrkPermitApprvlSgmt = _WorkPermitApprvlHistExtension.WrkPermitApprvlSgmt AND NumberOfWrkPermitApprovals = _WorkPermitApprvlHistExtension.NumberOfWrkPermitApprovals  -- association [0..1]
;

Learn More