R_SftyCertWorkPermitTP

DDL: R_SFTYCERTWORKPERMITTP Type: view_entity TRANSACTIONAL
21 Fields 1 Data Sources 3 Associations

Work Permits in Safety Certificate

R_SftyCertWorkPermitTP is a Transactional CDS View that provides data about "Work Permits in Safety Certificate" in SAP S/4HANA. It reads from 1 data source (I_SafetyCertificateWorkPermit) and exposes 21 fields with key fields SafetyCertificateInternalID, WorkPermitInternalID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_SafetyCertificateWorkPermit I_SafetyCertificateWorkPermit 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_SafetyCertificateWorkPermit _SftyCertWrkPmtExtension $projection.SafetyCertificateInternalID = _SftyCertWrkPmtExtension.SafetyCertificateInternalID and $projection.WorkPermitInternalID = _SftyCertWrkPmtExtension.WorkPermitInternalID

Annotations (8)

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

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificateInternalID I_SafetyCertificateWorkPermit SafetyCertificateInternalID Object number
KEY WorkPermitInternalID I_SafetyCertificateWorkPermit WorkPermitInternalID Object number
SafetyCertificate I_SafetyCertificateWorkPermit SafetyCertificate WC Document
WorkPermit I_SafetyCertificateWorkPermit WorkPermit Application
MaintenancePlanningPlant I_SafetyCertificateWorkPermit MaintenancePlanningPlant Planning Plant
WorkPermitType
WorkCenter
ValidFromDateTime
ValidToDateTime
SftyCertWrkPmtObjectType I_SafetyCertificateWorkPermit SftyCertWrkPmtObjectType 2nd ObjTyp
WorkPermitObjectType I_SafetyCertificateWorkPermit WorkPermitObjectType 2nd ObjTyp
WorkPermitProcessingStatus I_SafetyCertificateWorkPermit WorkPermitProcessingStatus Processing State
SftyCertProcessingContext I_SafetyCertificateWorkPermit SftyCertProcessingContext Processing Context
IsReferenceDocument I_SafetyCertificateWorkPermit IsReferenceDocument
OperationWorkCenterInternalID OperationWorkCenterInternalID Object ID
ObjectTypeCode ObjectTypeCode Object Type
WorkCenterText _Text WorkCenterText Work Center Text
_SafetyCertificate _SafetyCertificate
_WorkPermit _WorkPermit
_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_SftyCertWorkPermitTP.
-- 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_SftyCertWorkPermitTP AS
SELECT
  I_SafetyCertificateWorkPermit.SafetyCertificateInternalID AS SafetyCertificateInternalID,
  I_SafetyCertificateWorkPermit.WorkPermitInternalID AS WorkPermitInternalID,
  I_SafetyCertificateWorkPermit.SafetyCertificate AS SafetyCertificate,
  I_SafetyCertificateWorkPermit.WorkPermit AS WorkPermit,
  I_SafetyCertificateWorkPermit.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  I_SafetyCertificateWorkPermit._WorkPermit.WorkPermitType AS WorkPermitType,
  I_SafetyCertificateWorkPermit._WorkPermit.WorkCenter AS WorkCenter,
  I_SafetyCertificateWorkPermit._WorkPermit.ValidFromDateTime AS ValidFromDateTime,
  I_SafetyCertificateWorkPermit._WorkPermit.ValidToDateTime AS ValidToDateTime,
  I_SafetyCertificateWorkPermit.SftyCertWrkPmtObjectType AS SftyCertWrkPmtObjectType,
  I_SafetyCertificateWorkPermit.WorkPermitObjectType AS WorkPermitObjectType,
  I_SafetyCertificateWorkPermit.WorkPermitProcessingStatus AS WorkPermitProcessingStatus,
  I_SafetyCertificateWorkPermit.SftyCertProcessingContext AS SftyCertProcessingContext,
  I_SafetyCertificateWorkPermit.IsReferenceDocument AS IsReferenceDocument,
  OperationWorkCenterInternalID,
  ObjectTypeCode,
  _Text.WorkCenterText AS WorkCenterText
FROM I_SafetyCertificateWorkPermit
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_SafetyCertificateWorkPermit AS _SftyCertWrkPmtExtension ON SafetyCertificateInternalID = _SftyCertWrkPmtExtension.SafetyCertificateInternalID AND WorkPermitInternalID = _SftyCertWrkPmtExtension.WorkPermitInternalID  -- association [0..1]
;

Learn More