R_WrkPmtSafetyCertificateTP

DDL: R_WRKPMTSAFETYCERTIFICATETP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 1 Associations

Safety Certificate in Work Permit

R_WrkPmtSafetyCertificateTP is a Transactional CDS View that provides data about "Safety Certificate in Work Permit" in SAP S/4HANA. It reads from 1 data source (I_WorkPermitSafetyCertificate) and exposes 16 fields with key fields WorkPermitInternalID, SafetyCertificateInternalID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_WorkPermitSafetyCertificate I_WorkPermitSafetyCertificate from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_WorkPermitSafetyCertificate _WorkPermitSftyCertExtension $projection.WorkPermitInternalID = _WorkPermitSftyCertExtension.WorkPermitInternalID and $projection.SafetyCertificateInternalID = _WorkPermitSftyCertExtension.SafetyCertificateInternalID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Safety Certificate in Work Permit view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY WorkPermitInternalID I_WorkPermitSafetyCertificate WorkPermitInternalID Object number
KEY SafetyCertificateInternalID I_WorkPermitSafetyCertificate SafetyCertificateInternalID Object number
WorkPermitObjectType I_WorkPermitSafetyCertificate WorkPermitObjectType 2nd ObjTyp
SftyCertWrkPmtObjectType I_WorkPermitSafetyCertificate SftyCertWrkPmtObjectType 2nd ObjTyp
SftyCertProcessingContext I_WorkPermitSafetyCertificate SftyCertProcessingContext Processing Context
SafetyCertificateType I_WorkPermitSafetyCertificate SafetyCertificateType Usage
SftyCertificateTypeDescription I_WorkPermitSafetyCertificate SftyCertificateTypeDescription Sfty Cert Type Desc
ValidFromDateTime I_WorkPermitSafetyCertificate ValidFromDateTime Time Stamp
ValidToDateTime I_WorkPermitSafetyCertificate ValidToDateTime Time Stamp
WorkPermit I_WorkPermitSafetyCertificate WorkPermit Application
SafetyCertificate I_WorkPermitSafetyCertificate SafetyCertificate WC Document
SftyCertDesc I_WorkPermitSafetyCertificate SftyCertDesc Short Text
MaintenancePlanningPlant I_WorkPermitSafetyCertificate MaintenancePlanningPlant Planning Plant
SftyCertProcessingStatusText _SafetyCertificate SftyCertProcessingStatusText Short Description
_WorkPermit _WorkPermit
_SafetyCertificate _SafetyCertificate

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_WrkPmtSafetyCertificateTP.
-- 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_WrkPmtSafetyCertificateTP AS
SELECT
  I_WorkPermitSafetyCertificate.WorkPermitInternalID AS WorkPermitInternalID,
  I_WorkPermitSafetyCertificate.SafetyCertificateInternalID AS SafetyCertificateInternalID,
  I_WorkPermitSafetyCertificate.WorkPermitObjectType AS WorkPermitObjectType,
  I_WorkPermitSafetyCertificate.SftyCertWrkPmtObjectType AS SftyCertWrkPmtObjectType,
  I_WorkPermitSafetyCertificate.SftyCertProcessingContext AS SftyCertProcessingContext,
  I_WorkPermitSafetyCertificate.SafetyCertificateType AS SafetyCertificateType,
  I_WorkPermitSafetyCertificate.SftyCertificateTypeDescription AS SftyCertificateTypeDescription,
  I_WorkPermitSafetyCertificate.ValidFromDateTime AS ValidFromDateTime,
  I_WorkPermitSafetyCertificate.ValidToDateTime AS ValidToDateTime,
  I_WorkPermitSafetyCertificate.WorkPermit AS WorkPermit,
  I_WorkPermitSafetyCertificate.SafetyCertificate AS SafetyCertificate,
  I_WorkPermitSafetyCertificate.SftyCertDesc AS SftyCertDesc,
  I_WorkPermitSafetyCertificate.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _SafetyCertificate.SftyCertProcessingStatusText AS SftyCertProcessingStatusText
FROM I_WorkPermitSafetyCertificate
LEFT OUTER JOIN E_WorkPermitSafetyCertificate AS _WorkPermitSftyCertExtension ON WorkPermitInternalID = _WorkPermitSftyCertExtension.WorkPermitInternalID AND SafetyCertificateInternalID = _WorkPermitSftyCertExtension.SafetyCertificateInternalID  -- association [0..1]
;

Learn More