R_SftyCertTmplWrkPmtTemplateTP

DDL: R_SFTYCERTTMPLWRKPMTTEMPLATETP Type: view_entity TRANSACTIONAL
20 Fields 1 Data Sources 3 Associations

Sfty Cert Tmpl Wrk Pmt Template

R_SftyCertTmplWrkPmtTemplateTP is a Transactional CDS View that provides data about "Sfty Cert Tmpl Wrk Pmt Template" in SAP S/4HANA. It reads from 1 data source (I_SftyCertTmplWrkPmtTemplate) and exposes 20 fields with key fields SafetyCertificateInternalID, WorkPermitInternalID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SftyCertTmplWrkPmtTemplate I_SftyCertTmplWrkPmtTemplate 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_WorkPermitTypeText _WorkPermitTypeText $projection.workpermittype = _WorkPermitTypeText.WorkPermitType and $projection.MaintenancePlanningPlant = _WorkPermitTypeText.MaintenancePlanningPlant and _WorkPermitTypeText.Language = $session.system_language -- Extensions, do not expose as association:
[0..1] E_SftyCertTmplWrkPmtTemplate _SftyCertTmplWrkPmtExtension $projection.SafetyCertificateInternalID = _SftyCertTmplWrkPmtExtension.SafetyCertificateInternalID and $projection.WorkPermitInternalID = _SftyCertTmplWrkPmtExtension.WorkPermitInternalID

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 Sfty Cert Tmpl Wrk Pmt Template view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificateInternalID I_SftyCertTmplWrkPmtTemplate SafetyCertificateInternalID Object number
KEY WorkPermitInternalID I_SftyCertTmplWrkPmtTemplate WorkPermitInternalID Object number
SafetyCertificate I_SftyCertTmplWrkPmtTemplate SafetyCertificate WC Document
WorkPermit I_SftyCertTmplWrkPmtTemplate WorkPermit Application
MaintenancePlanningPlant I_SftyCertTmplWrkPmtTemplate MaintenancePlanningPlant Planning Plant
WorkPermitType
WorkCenter
ValidFromDateTime
ValidToDateTime
SftyCertWrkPmtObjectType I_SftyCertTmplWrkPmtTemplate SftyCertWrkPmtObjectType 2nd ObjTyp
WorkPermitObjectType I_SftyCertTmplWrkPmtTemplate WorkPermitObjectType 2nd ObjTyp
WorkPermitProcessingStatus I_SftyCertTmplWrkPmtTemplate WorkPermitProcessingStatus Processing State
SftyCertProcessingContext I_SftyCertTmplWrkPmtTemplate SftyCertProcessingContext Processing Context
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
ObjectTypeCode ObjectTypeCode Object Type
WorkCenterText _Text WorkCenterText Work Center Text
_SafetyCertificateTemplate _SafetyCertificateTemplate
_WorkPermitTemplate _WorkPermitTemplate
_WorkPermitTypeText _WorkPermitTypeText
_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_SftyCertTmplWrkPmtTemplateTP.
-- 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_SftyCertTmplWrkPmtTemplateTP AS
SELECT
  I_SftyCertTmplWrkPmtTemplate.SafetyCertificateInternalID AS SafetyCertificateInternalID,
  I_SftyCertTmplWrkPmtTemplate.WorkPermitInternalID AS WorkPermitInternalID,
  I_SftyCertTmplWrkPmtTemplate.SafetyCertificate AS SafetyCertificate,
  I_SftyCertTmplWrkPmtTemplate.WorkPermit AS WorkPermit,
  I_SftyCertTmplWrkPmtTemplate.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_SftyCertTmplWrkPmtTemplate._WorkPermitTemplate.WorkPermitType AS WorkPermitType,
  I_SftyCertTmplWrkPmtTemplate._WorkPermitTemplate.WorkCenter AS WorkCenter,
  I_SftyCertTmplWrkPmtTemplate._WorkPermitTemplate.ValidFromDateTime AS ValidFromDateTime,
  I_SftyCertTmplWrkPmtTemplate._WorkPermitTemplate.ValidToDateTime AS ValidToDateTime,
  I_SftyCertTmplWrkPmtTemplate.SftyCertWrkPmtObjectType AS SftyCertWrkPmtObjectType,
  I_SftyCertTmplWrkPmtTemplate.WorkPermitObjectType AS WorkPermitObjectType,
  I_SftyCertTmplWrkPmtTemplate.WorkPermitProcessingStatus AS WorkPermitProcessingStatus,
  I_SftyCertTmplWrkPmtTemplate.SftyCertProcessingContext AS SftyCertProcessingContext,
  OperationWorkCenterInternalID,
  ObjectTypeCode,
  _Text.WorkCenterText AS WorkCenterText
FROM I_SftyCertTmplWrkPmtTemplate
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_WorkPermitTypeText AS _WorkPermitTypeText ON workpermittype = _WorkPermitTypeText.WorkPermitType AND MaintenancePlanningPlant = _WorkPermitTypeText.MaintenancePlanningPlant AND _WorkPermitTypeText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN E_SftyCertTmplWrkPmtTemplate AS _SftyCertTmplWrkPmtExtension ON SafetyCertificateInternalID = _SftyCertTmplWrkPmtExtension.SafetyCertificateInternalID AND WorkPermitInternalID = _SftyCertTmplWrkPmtExtension.WorkPermitInternalID  -- association [0..1]
;

Learn More