I_SftyCertTmplTechnicalObject

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_SftyCertTmplTechnicalObject.
-- 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: ISFTYCERTTOBJT

CREATE VIEW I_SftyCertTmplTechnicalObject AS
SELECT
  wcaod.objnr AS SafetyCertificateInternalID,
  wcaod.ccobj AS TechnicalObject,
  wcaod.cctyp AS SftyCertItemCatType,
  _SafetyCertificateBasic.SafetyCertificate AS SafetyCertificate,
  _SafetyCertificateBasic.MaintenancePlanningPlant AS MaintenancePlanningPlant,
  cast ('' as vdm_j_system_status_concat_t) AS TechObjCnctntdActvSystSts
FROM wcaod
INNER JOIN I_SafetyCertificateBasic AS _SafetyCertificateBasic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Equipment AS _Equipment ON TechnicalObject = _Equipment.Equipment  -- association [1..1]
LEFT OUTER JOIN I_EquipmentText AS _EquipmentText ON TechnicalObject = _EquipmentText.Equipment AND _EquipmentText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_FunctionalLocation AS _FunctionalLocation ON TechnicalObject = _FunctionalLocation.FunctionalLocation  -- association [1..1]
LEFT OUTER JOIN I_FunctionalLocationText AS _FunctionalLocationText ON TechnicalObject = _FunctionalLocationText.FunctionalLocation AND _FunctionalLocationText.Language = $session.system_language  -- association [1..1]
;