R_WrkPmtTmplApprovalSegmentTP

DDL: R_WRKPMTTMPLAPPROVALSEGMENTTP Type: view_entity TRANSACTIONAL Package: VDM_EAM_WCM_PERMIT_TO_WORK
27 Fields 1 Data Sources 3 Associations

Work Permit Approval Segment View

R_WrkPmtTmplApprovalSegmentTP 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 27 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 _LongTextRvk $projection.WrkPmtTmplRevokeLongTextKey = _LongTextRvk.TextObjectKey and _LongTextRvk.TextObjectCategory = 'APPROVAL' and _LongTextRvk.TextObjectType = 'LTXT' and _LongTextRvk.Language = $session.system_language -- Extensions, do not expose as association:
[0..1] E_WrkPmtTmplApprovalHistory _PermitTmplApprvlHistExtension $projection.WorkPermitInternalID = _PermitTmplApprvlHistExtension.WorkPermitInternalID and $projection.WrkPermitApprvlSgmt = _PermitTmplApprvlHistExtension.WrkPermitApprvlSgmt and $projection.NumberOfWrkPermitApprovals = _PermitTmplApprvlHistExtension.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 (27)

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
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
WrkPmtTmplRevokeLongTextKey I_WorkPermitApprvlSgmt WorkPermitRevokeLongTextKey Text Name
PlainLongText _LongText PlainLongText Long Text
WrkPmtTmplRevokeLongText _LongTextRvk PlainLongText Long Text
_CreatedByUser _CreatedByUser
_RejectByUser _RejectByUser
_WorkPermitTmpl _WorkPermitTmpl
_LongText _LongText

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_WrkPmtTmplApprovalSegmentTP.
-- 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_WrkPmtTmplApprovalSegmentTP AS
SELECT
  I_WorkPermitApprvlSgmt.WorkPermitInternalID AS WorkPermitInternalID,
  I_WorkPermitApprvlSgmt.WrkPermitApprvlSgmt AS WrkPermitApprvlSgmt,
  I_WorkPermitApprvlSgmt.NumberOfWrkPermitApprovals AS NumberOfWrkPermitApprovals,
  I_WorkPermitApprvlSgmt.WorkPermit AS WorkPermit,
  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 WrkPmtTmplRevokeLongTextKey,
  _LongText.PlainLongText AS PlainLongText,
  _LongTextRvk.PlainLongText AS WrkPmtTmplRevokeLongText
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 _LongTextRvk ON WrkPmtTmplRevokeLongTextKey = _LongTextRvk.TextObjectKey AND _LongTextRvk.TextObjectCategory = 'APPROVAL' AND _LongTextRvk.TextObjectType = 'LTXT' AND _LongTextRvk.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_WrkPmtTmplApprovalHistory AS _PermitTmplApprvlHistExtension ON WorkPermitInternalID = _PermitTmplApprvlHistExtension.WorkPermitInternalID AND WrkPermitApprvlSgmt = _PermitTmplApprvlHistExtension.WrkPermitApprvlSgmt AND NumberOfWrkPermitApprovals = _PermitTmplApprvlHistExtension.NumberOfWrkPermitApprovals  -- association [0..1]
;

Learn More