I_SafetyCertificateTemplate

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_SafetyCertificateTemplate.
-- 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: ISFTYCERTTMPL

CREATE VIEW I_SafetyCertificateTemplate AS
SELECT
  SafetyCertificate,
  SafetyCertificateInternalID,
  SftyCertificateSubobjectType,
  SafetyCertificateType,
  SftyCertDesc,
  SftyCertHasLongText,
  LongTextKey,
  SftyCertIsDeleted,
  MaintenancePlannerGroup,
  MaintenancePlanningPlant,
  ObjectTypeCode,
  OperationWorkCenterInternalID,
  TechObjAuthorizationGroup,
  SftyCertValidFrmDate,
  SftyCertValidFrmTime,
  SftyCertValidToDate,
  SftyCertValidToTime,
  FunctionalLocation,
  _SafetyCertificateBasic.Equipment AS Equipment,
  SftyCertHasObjectList,
  CreatedByUser,
  _CreatedByUser.UserDescription AS CreatedByUserName,
  CreationDate,
  CreationTime,
  CreationDateTime,
  _LastChangedByUser.UserDescription AS UserDescription,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  LastChangeDateTime,
  SftyCertIsLinkdToDoc,
  StatusProfile,
  SafetyCertificateTmplID,
  SftyCertHasMaintRemark,
  SftyCertHasOpRemark,
  ValidFromDateTime,
  ValidToDateTime,
  SftyCertProcessingStatus,
  _SftyCertProcessingStatusText.SftyCertProcessingStatusText AS SftyCertProcessingStatusText,
  _MainWorkCenter.WorkCenter AS WorkCenter,
  _MainWorkCenter.WorkCenterInternalID AS WorkCenterInternalID,
  _MainWorkCenter._Text[1:Language = $session.system_language].WorkCenterText AS WorkCenterText,
  _MainWorkCenter.Plant AS WorkCenterPlant,
  _MainWorkCenter._WorkCenter AS _WorkCenter,
  _MainWorkCenter._Plant AS _Plant,
  cast ('' as vdm_j_system_status_concat_t) AS SftyCertCnctntdActvSystStsTxt,
  cast( '' as abap.char( 1333 ) ) AS SftyCertChgStsActnEnbldVal
FROM I_SafetyCertificateBasic AS _SafetyCertificateBasic
LEFT OUTER JOIN I_SftyCertTemplateType AS _SftyCertTemplateType ON SafetyCertificateType = _SftyCertTemplateType.SafetyCertificateType AND MaintenancePlanningPlant = _SftyCertTemplateType.MaintenancePlanningPlant  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _SftyCertPlanningPlant ON MaintenancePlanningPlant = _SftyCertPlanningPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _MainWorkCenter ON OperationWorkCenterInternalID = _MainWorkCenter.WorkCenterInternalID AND ObjectTypeCode = _MainWorkCenter.WorkCenterTypeCode  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _WorkCenterPlant ON WorkCenterPlant = _WorkCenterPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN I_MaintenancePlannerGroup AS _MaintenancePlannerGroup ON MaintenancePlannerGroup = _MaintenancePlannerGroup.MaintenancePlannerGroup AND MaintenancePlanningPlant = _MaintenancePlannerGroup.MaintenancePlanningPlant  -- association [1..1]
LEFT OUTER JOIN I_SftyCertProcessingStatusText AS _SftyCertProcessingStatusText ON _SftyCertProcessingStatusText.SftyCertProcessingStatus = SftyCertProcessingStatus AND _SftyCertProcessingStatusText.Language = $session.system_language AND _SftyCertProcessingStatusText.Name = 'PTWDSFTYCERTPROCESSINGSTATUS'  -- association [1..1]
LEFT OUTER JOIN I_SafetyCertificateStatus AS _SafetyCertificateStatus ON _SafetyCertificateStatus.SafetyCertificate = SafetyCertificate AND _SafetyCertificateStatus.SafetyCertificateInternalID = SafetyCertificateInternalID AND _SafetyCertificateStatus.StatusCode = 'I0175' AND _SafetyCertificateStatus.StatusIsInactive = ''  -- association [0..1]
LEFT OUTER JOIN I_SafetyCertificateStatus AS _SftyCertStatus ON _SftyCertStatus.SafetyCertificate = SafetyCertificate AND _SftyCertStatus.SafetyCertificateInternalID = SafetyCertificateInternalID  -- association [*]
;