R_SftyCertTmplApprvlSegmentTP

DDL: R_SFTYCERTTMPLAPPRVLSEGMENTTP Type: view_entity TRANSACTIONAL Package: VDM_EAM_WCM_SAFETY_CERTIFICATE
29 Fields 1 Data Sources 3 Associations

Safety Certificate Template Approval Segment

R_SftyCertTmplApprvlSegmentTP is a Transactional CDS View that provides data about "Safety Certificate Template Approval Segment" in SAP S/4HANA. It reads from 1 data source (I_SftyCertApprovalSegment) and exposes 29 fields with key fields SafetyCertificateInternalID, SftyCertApprovalSegmentValue, NumberOfSftyCertApprovals. It has 3 associations to related views. Part of development package VDM_EAM_WCM_SAFETY_CERTIFICATE.

Data Sources (1)

SourceAliasJoin Type
I_SftyCertApprovalSegment I_SftyCertApprovalSegment 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.SftyCertRevokeLongTextKey = _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_SftyCertTmplApprvlHistory _SftyCertTmpAprvlHistExtension $projection.SafetyCertificateInternalID = _SftyCertTmpAprvlHistExtension.SafetyCertificateInternalID and $projection.SftyCertApprovalSegmentValue = _SftyCertTmpAprvlHistExtension.SftyCertApprovalSegmentValue and $projection.NumberOfSftyCertApprovals = _SftyCertTmpAprvlHistExtension.NumberOfSftyCertApprovals

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY 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
EndUserText.label Safety Certificate Template Approval Segment view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificateInternalID I_SftyCertApprovalSegment SafetyCertificateInternalID Object number
KEY SftyCertApprovalSegmentValue I_SftyCertApprovalSegment SftyCertApprovalSegmentValue Counter
KEY NumberOfSftyCertApprovals I_SftyCertApprovalSegment NumberOfSftyCertApprovals Counter
SafetyCertificateApprovalCode
SafetyCertificate I_SftyCertApprovalSegment SafetyCertificate WC Document
SftyCertApprovalEnteredByUser I_SftyCertApprovalSegment SftyCertApprovalEnteredByUser Entered by
SftyCertApprovalEntryDate I_SftyCertApprovalSegment SftyCertApprovalEntryDate Created on
SftyCertApprovalEntryTime I_SftyCertApprovalSegment SftyCertApprovalEntryTime Entered At
ApprovalDateTime I_SftyCertApprovalSegment ApprovalDateTime Time Stamp
SftyCertApprovedFromDate I_SftyCertApprovalSegment SftyCertApprovedFromDate App.fr date
SftyCertApprovedToDate I_SftyCertApprovalSegment SftyCertApprovedToDate App.to date
SftyCertApprovedFromTime I_SftyCertApprovalSegment SftyCertApprovedFromTime Entered At
SftyCertApprovedToTime I_SftyCertApprovalSegment SftyCertApprovedToTime AppToTime
SftyCertApprovalDactvtdByUsr I_SftyCertApprovalSegment SftyCertApprovalDactvtdByUsr Deactivated by
SftyCertApprvlDeactivationDate I_SftyCertApprovalSegment SftyCertApprvlDeactivationDate Deactivated on
SftyCertApprvlDeactivationTime I_SftyCertApprovalSegment SftyCertApprvlDeactivationTime Deactivated at
SftyCertRevokeDateTime I_SftyCertApprovalSegment SftyCertRevokeDateTime Time Stamp
SftyCertApprvlSgmtIsInactive I_SftyCertApprovalSegment SftyCertApprvlSgmtIsInactive Permit inactive
SftyCertificateApprovalComment I_SftyCertApprovalSegment SftyCertificateApprovalComment Approval Comment
SftyCertApprovalDescription I_SftyCertApprovalSegment SftyCertApprovalDescription Permit Text
TextObjectKey I_SftyCertApprovalSegment TextObjectKey Text Name
SftyCertRevokeLongTextKey I_SftyCertApprovalSegment SftyCertRevokeLongTextKey Text Name
PlainLongText _LongText PlainLongText Long Text
SftyCertRevokeLongText _LongTextRevoke PlainLongText Long Text
_CreatedByUser _CreatedByUser
_RejectByUser _RejectByUser
_SafetyCertificateTemplate _SafetyCertificateTemplate
_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_SftyCertTmplApprvlSegmentTP.
-- 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_SftyCertTmplApprvlSegmentTP AS
SELECT
  I_SftyCertApprovalSegment.SafetyCertificateInternalID AS SafetyCertificateInternalID,
  I_SftyCertApprovalSegment.SftyCertApprovalSegmentValue AS SftyCertApprovalSegmentValue,
  I_SftyCertApprovalSegment.NumberOfSftyCertApprovals AS NumberOfSftyCertApprovals,
  I_SftyCertApprovalSegment._SafetyCertificateApproval.SafetyCertificateApprovalCode AS SafetyCertificateApprovalCode,
  I_SftyCertApprovalSegment.SafetyCertificate AS SafetyCertificate,
  I_SftyCertApprovalSegment.SftyCertApprovalEnteredByUser AS SftyCertApprovalEnteredByUser,
  I_SftyCertApprovalSegment.SftyCertApprovalEntryDate AS SftyCertApprovalEntryDate,
  I_SftyCertApprovalSegment.SftyCertApprovalEntryTime AS SftyCertApprovalEntryTime,
  I_SftyCertApprovalSegment.ApprovalDateTime AS ApprovalDateTime,
  I_SftyCertApprovalSegment.SftyCertApprovedFromDate AS SftyCertApprovedFromDate,
  I_SftyCertApprovalSegment.SftyCertApprovedToDate AS SftyCertApprovedToDate,
  I_SftyCertApprovalSegment.SftyCertApprovedFromTime AS SftyCertApprovedFromTime,
  I_SftyCertApprovalSegment.SftyCertApprovedToTime AS SftyCertApprovedToTime,
  I_SftyCertApprovalSegment.SftyCertApprovalDactvtdByUsr AS SftyCertApprovalDactvtdByUsr,
  I_SftyCertApprovalSegment.SftyCertApprvlDeactivationDate AS SftyCertApprvlDeactivationDate,
  I_SftyCertApprovalSegment.SftyCertApprvlDeactivationTime AS SftyCertApprvlDeactivationTime,
  I_SftyCertApprovalSegment.SftyCertRevokeDateTime AS SftyCertRevokeDateTime,
  I_SftyCertApprovalSegment.SftyCertApprvlSgmtIsInactive AS SftyCertApprvlSgmtIsInactive,
  I_SftyCertApprovalSegment.SftyCertificateApprovalComment AS SftyCertificateApprovalComment,
  I_SftyCertApprovalSegment.SftyCertApprovalDescription AS SftyCertApprovalDescription,
  I_SftyCertApprovalSegment.TextObjectKey AS TextObjectKey,
  I_SftyCertApprovalSegment.SftyCertRevokeLongTextKey AS SftyCertRevokeLongTextKey,
  _LongText.PlainLongText AS PlainLongText,
  _LongTextRevoke.PlainLongText AS SftyCertRevokeLongText
FROM I_SftyCertApprovalSegment
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 SftyCertRevokeLongTextKey = _LongTextRevoke.TextObjectKey AND _LongTextRevoke.TextObjectCategory = 'APPROVAL' AND _LongTextRevoke.TextObjectType = 'LTXT' AND _LongTextRevoke.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_SftyCertTmplApprvlHistory AS _SftyCertTmpAprvlHistExtension ON SafetyCertificateInternalID = _SftyCertTmpAprvlHistExtension.SafetyCertificateInternalID AND SftyCertApprovalSegmentValue = _SftyCertTmpAprvlHistExtension.SftyCertApprovalSegmentValue AND NumberOfSftyCertApprovals = _SftyCertTmpAprvlHistExtension.NumberOfSftyCertApprovals  -- association [0..1]
;

Learn More