R_WrkPmtTmplSftyCertTemplateTP

DDL: R_WRKPMTTMPLSFTYCERTTEMPLATETP Type: view_entity TRANSACTIONAL Package: VDM_EAM_WCM_PERMIT_TO_WORK
21 Fields 1 Data Sources 3 Associations

Wrk Pmt Tmpl Sfty Cert Template - TP

R_WrkPmtTmplSftyCertTemplateTP is a Transactional CDS View that provides data about "Wrk Pmt Tmpl Sfty Cert Template - TP" in SAP S/4HANA. It reads from 1 data source (I_WrkPmtTmplSftyCertTemplate) and exposes 21 fields with key fields WorkPermitInternalID, SafetyCertificateInternalID. It has 3 associations to related views. Part of development package VDM_EAM_WCM_PERMIT_TO_WORK.

Data Sources (1)

SourceAliasJoin Type
I_WrkPmtTmplSftyCertTemplate I_WrkPmtTmplSftyCertTemplate from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_WorkCenterText _Text $projection.OperationWorkCenterInternalID = _Text.WorkCenterInternalID and $projection.ObjectTypeCode = _Text.WorkCenterTypeCode and _Text.Language = $session.system_language
[1..1] I_SafetyCertificateTypeText _SafetyCertificateTypeText $projection.safetycertificatetype = _SafetyCertificateTypeText.SafetyCertificateType and $projection.MaintenancePlanningPlant = _SafetyCertificateTypeText.MaintenancePlanningPlant and _SafetyCertificateTypeText.Language = $session.system_language -- Extensions, do not expose as association:
[0..1] E_WrkPmtTmplSftyCertTemplate _PermitTmplSftyCertExtension $projection.WorkPermitInternalID = _PermitTmplSftyCertExtension.WorkPermitInternalID and $projection.SafetyCertificateInternalID = _PermitTmplSftyCertExtension.SafetyCertificateInternalID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Wrk Pmt Tmpl Sfty Cert Template - TP view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY WorkPermitInternalID I_WrkPmtTmplSftyCertTemplate WorkPermitInternalID Object number
KEY SafetyCertificateInternalID I_WrkPmtTmplSftyCertTemplate SafetyCertificateInternalID Object number
WorkPermit I_WrkPmtTmplSftyCertTemplate WorkPermit Application
SafetyCertificate I_WrkPmtTmplSftyCertTemplate SafetyCertificate WC Document
SftyCertDesc I_WrkPmtTmplSftyCertTemplate SftyCertDesc Short Text
MaintenancePlanningPlant I_WrkPmtTmplSftyCertTemplate MaintenancePlanningPlant Planning Plant
SafetyCertificateType
WorkCenter
ValidFromDateTime
ValidToDateTime
SftyCertWrkPmtObjectType I_WrkPmtTmplSftyCertTemplate SftyCertWrkPmtObjectType 2nd ObjTyp
WorkPermitObjectType I_WrkPmtTmplSftyCertTemplate WorkPermitObjectType 2nd ObjTyp
SftyCertProcessingStatus I_WrkPmtTmplSftyCertTemplate SftyCertProcessingStatus Proc Stat Sfty Cert
SftyCertProcessingContext I_WrkPmtTmplSftyCertTemplate SftyCertProcessingContext Processing Context
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
ObjectTypeCode ObjectTypeCode Object Type
WorkCenterText _Text WorkCenterText Work Center Text
_SafetyCertificateTemplate _SafetyCertificateTemplate
_WorkPermitTemplate _WorkPermitTemplate
_SafetyCertificateTypeText _SafetyCertificateTypeText
_Plant _Plant

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_WrkPmtTmplSftyCertTemplateTP.
-- 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_WrkPmtTmplSftyCertTemplateTP AS
SELECT
  I_WrkPmtTmplSftyCertTemplate.WorkPermitInternalID AS WorkPermitInternalID,
  I_WrkPmtTmplSftyCertTemplate.SafetyCertificateInternalID AS SafetyCertificateInternalID,
  I_WrkPmtTmplSftyCertTemplate.WorkPermit AS WorkPermit,
  I_WrkPmtTmplSftyCertTemplate.SafetyCertificate AS SafetyCertificate,
  I_WrkPmtTmplSftyCertTemplate.SftyCertDesc AS SftyCertDesc,
  I_WrkPmtTmplSftyCertTemplate.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_WrkPmtTmplSftyCertTemplate._SafetyCertificateTemplate.SafetyCertificateType AS SafetyCertificateType,
  I_WrkPmtTmplSftyCertTemplate._SafetyCertificateTemplate.WorkCenter AS WorkCenter,
  I_WrkPmtTmplSftyCertTemplate._SafetyCertificateTemplate.ValidFromDateTime AS ValidFromDateTime,
  I_WrkPmtTmplSftyCertTemplate._SafetyCertificateTemplate.ValidToDateTime AS ValidToDateTime,
  I_WrkPmtTmplSftyCertTemplate.SftyCertWrkPmtObjectType AS SftyCertWrkPmtObjectType,
  I_WrkPmtTmplSftyCertTemplate.WorkPermitObjectType AS WorkPermitObjectType,
  I_WrkPmtTmplSftyCertTemplate.SftyCertProcessingStatus AS SftyCertProcessingStatus,
  I_WrkPmtTmplSftyCertTemplate.SftyCertProcessingContext AS SftyCertProcessingContext,
  OperationWorkCenterInternalID,
  ObjectTypeCode,
  _Text.WorkCenterText AS WorkCenterText
FROM I_WrkPmtTmplSftyCertTemplate
LEFT OUTER JOIN I_WorkCenterText AS _Text ON OperationWorkCenterInternalID = _Text.WorkCenterInternalID AND ObjectTypeCode = _Text.WorkCenterTypeCode AND _Text.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_SafetyCertificateTypeText AS _SafetyCertificateTypeText ON safetycertificatetype = _SafetyCertificateTypeText.SafetyCertificateType AND MaintenancePlanningPlant = _SafetyCertificateTypeText.MaintenancePlanningPlant AND _SafetyCertificateTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN E_WrkPmtTmplSftyCertTemplate AS _PermitTmplSftyCertExtension ON WorkPermitInternalID = _PermitTmplSftyCertExtension.WorkPermitInternalID AND SafetyCertificateInternalID = _PermitTmplSftyCertExtension.SafetyCertificateInternalID  -- association [0..1]
;

Learn More