I_SftyCertTmplWrkPmtTemplate

DDL: I_SFTYCERTTMPLWRKPMTTEMPLATE SQL: ISCTWPT Type: view COMPOSITE
14 Fields 2 Data Sources 2 Associations

Sfty Cert Tmpl Wrk Pmt Template

I_SftyCertTmplWrkPmtTemplate is a Composite CDS View that provides data about "Sfty Cert Tmpl Wrk Pmt Template" in SAP S/4HANA. It reads from 2 data sources (I_SafetyCertificateBasic, I_SftyCertWorkPermitBasic) and exposes 14 fields with key fields SafetyCertificateInternalID, WorkPermitInternalID. It has 2 associations to related views.

Data Sources (2)

SourceAliasJoin Type
I_SafetyCertificateBasic _SafetyCertificateBasic inner
I_SftyCertWorkPermitBasic _SafetyCertificateWrkPmtBasic from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_WorkPermitTemplate _WorkPermitTemplate _WorkPermitTemplate.WorkPermitInternalID = _SafetyCertificateWrkPmtBasic.WorkPermitInternalID
[0..1] I_Plant _Plant $projection.maintenanceplanningplant = _Plant.Plant

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISCTWPT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Sfty Cert Tmpl Wrk Pmt Template view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SafetyCertificateInternalID I_SftyCertWorkPermitBasic SafetyCertificateInternalID Object number
KEY WorkPermitInternalID I_SftyCertWorkPermitBasic WorkPermitInternalID Object number
SafetyCertificate I_SafetyCertificateBasic SafetyCertificate WC Document
WorkPermit _WorkPermitTemplate WorkPermit Application
OperationWorkCenterInternalID _WorkPermitTemplate OperationWorkCenterInternalID Object ID
ObjectTypeCode _WorkPermitTemplate ObjectTypeCode Object Type
WrkPermitDesc _WorkPermitTemplate WrkPermitDesc Short Text
MaintenancePlanningPlant _WorkPermitTemplate MaintenancePlanningPlant Planning Plant
WorkPermitProcessingStatus _WorkPermitTemplate WorkPermitProcessingStatus Processing State
SftyCertWrkPmtObjectType I_SftyCertWorkPermitBasic SftyCertWrkPmtObjectType 2nd ObjTyp
WorkPermitObjectType I_SftyCertWorkPermitBasic WorkPermitObjectType 2nd ObjTyp
SftyCertProcessingContext I_SftyCertWorkPermitBasic SftyCertProcessingContext Processing Context
_WorkPermitTemplate _WorkPermitTemplate
_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 I_SftyCertTmplWrkPmtTemplate.
-- 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.
-- SQL view name: ISCTWPT

CREATE VIEW I_SftyCertTmplWrkPmtTemplate AS
SELECT
  _SafetyCertificateWrkPmtBasic.SafetyCertificateInternalID AS SafetyCertificateInternalID,
  _SafetyCertificateWrkPmtBasic.WorkPermitInternalID AS WorkPermitInternalID,
  _SafetyCertificateBasic.SafetyCertificate AS SafetyCertificate,
  _WorkPermitTemplate.WorkPermit AS WorkPermit,
  _WorkPermitTemplate.OperationWorkCenterInternalID AS OperationWorkCenterInternalID,
  _WorkPermitTemplate.ObjectTypeCode AS ObjectTypeCode,
  _WorkPermitTemplate.WrkPermitDesc AS WrkPermitDesc,
  _WorkPermitTemplate.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  _WorkPermitTemplate.WorkPermitProcessingStatus AS WorkPermitProcessingStatus,
  _SafetyCertificateWrkPmtBasic.SftyCertWrkPmtObjectType AS SftyCertWrkPmtObjectType,
  _SafetyCertificateWrkPmtBasic.WorkPermitObjectType AS WorkPermitObjectType,
  _SafetyCertificateWrkPmtBasic.SftyCertProcessingContext AS SftyCertProcessingContext
FROM I_SftyCertWorkPermitBasic AS _SafetyCertificateWrkPmtBasic
INNER JOIN I_SafetyCertificateBasic AS _SafetyCertificateBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkPermitTemplate AS _WorkPermitTemplate ON _WorkPermitTemplate.WorkPermitInternalID = _SafetyCertificateWrkPmtBasic.WorkPermitInternalID  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON maintenanceplanningplant = _Plant.Plant  -- association [0..1]
;

Learn More