R_SftyCertTemplateApprovalTP

DDL: R_SFTYCERTTEMPLATEAPPROVALTP Type: view_entity TRANSACTIONAL
22 Fields 1 Data Sources 3 Associations

Safety Certificate Template Approval

R_SftyCertTemplateApprovalTP is a Transactional CDS View that provides data about "Safety Certificate Template Approval" in SAP S/4HANA. It reads from 1 data source (I_SafetyCertificateApproval) and exposes 22 fields with key fields SafetyCertificateInternalID, NumberOfSftyCertApprovals. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SafetyCertificateApproval I_SafetyCertificateApproval 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_MasterDataDomainValueText _DomainText $projection.SftyCertificateApprovalStatus = _DomainText.DomainValue and _DomainText.Name = 'PTWDWORKPERMITAPPROVALSTATUS' and _DomainText.Language = $session.system_language -- Extensions, do not expose as association:
[0..1] E_SftyCertTemplateApproval _SftyCertTmpApprovalExtension _SftyCertTmpApprovalExtension.SafetyCertificateInternalID = $projection.SafetyCertificateInternalID and _SftyCertTmpApprovalExtension.NumberOfSftyCertApprovals = $projection.NumberOfSftyCertApprovals

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
EndUserText.label Safety Certificate Template Approval view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificateInternalID SafetyCertificateInternalID Object number
KEY NumberOfSftyCertApprovals NumberOfSftyCertApprovals Counter
SafetyCertificateApprovalCode SafetyCertificateApprovalCode Permit
SafetyCertificate SafetyCertificate WC Document
SftyCertHasLongText SftyCertHasLongText Long Text
CreationDate CreationDate Time Stamp
CreatedByUser CreatedByUser User Name
LastChangedDate LastChangedDate Created On
LastChangedByUser LastChangedByUser User Name
SftyCertificateApprovalComment SftyCertificateApprovalComment Approval Comment
SftyCertApprovalDescription SftyCertApprovalDescription Permit Text
SftyCertificateApprovalStatus SftyCertificateApprovalStatus Approval Status
SftyCertApprovalIsMandatory _ApprovalDetails SftyCertApprovalIsMandatory App. Mandatory
SftyCertApprvlHierLevelValue _ApprovalDetails SftyCertApprvlHierLevelValue Hierarchy Level
SftyCertApprvlMandText _ApprovalDetails SftyCertApprvlMandText
TextObjectKey TextObjectKey Text Name
PlainLongText _LongText PlainLongText Long Text
MaintenancePlanningPlant MaintenancePlanningPlant Planning Plant
SafetyCertificateType SafetyCertificateType Usage
_SafetyCertificateTemplate _SafetyCertificateTemplate
_DomainText _DomainText
_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_SftyCertTemplateApprovalTP.
-- 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_SftyCertTemplateApprovalTP AS
SELECT
  SafetyCertificateInternalID,
  NumberOfSftyCertApprovals,
  SafetyCertificateApprovalCode,
  SafetyCertificate,
  SftyCertHasLongText,
  CreationDate,
  CreatedByUser,
  LastChangedDate,
  LastChangedByUser,
  SftyCertificateApprovalComment,
  SftyCertApprovalDescription,
  SftyCertificateApprovalStatus,
  _ApprovalDetails.SftyCertApprovalIsMandatory AS SftyCertApprovalIsMandatory,
  _ApprovalDetails.SftyCertApprvlHierLevelValue AS SftyCertApprvlHierLevelValue,
  _ApprovalDetails.SftyCertApprvlMandText AS SftyCertApprvlMandText,
  TextObjectKey,
  _LongText.PlainLongText AS PlainLongText,
  MaintenancePlanningPlant,
  SafetyCertificateType
FROM I_SafetyCertificateApproval
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_MasterDataDomainValueText AS _DomainText ON SftyCertificateApprovalStatus = _DomainText.DomainValue AND _DomainText.Name = 'PTWDWORKPERMITAPPROVALSTATUS' AND _DomainText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_SftyCertTemplateApproval AS _SftyCertTmpApprovalExtension ON _SftyCertTmpApprovalExtension.SafetyCertificateInternalID = SafetyCertificateInternalID AND _SftyCertTmpApprovalExtension.NumberOfSftyCertApprovals = NumberOfSftyCertApprovals  -- association [0..1]
;

Learn More