I_SafetyCertificatePartner

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_SafetyCertificatePartner.
-- 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 I_SafetyCertificatePartner AS
SELECT
  _Partner.objnr AS MaintObjectInternalID,
  cast(_Partner.parvw as parvw_unv) AS PartnerFunction,
  _Partner.counter AS MaintenancePartnerObjectNumber,
  _Partner.obtyp AS MaintObjectCategory,
  _Partner.parnr AS MaintenancePartner,
  _SafetyCertificate.wcnr AS SafetyCertificate,
  _SafetyCertificate.iwerk AS MaintenancePlanningPlant,
  _SafetyCertificate.wcuse AS SafetyCertificateType,
  _Partner.ernam AS CreatedByUser,
  _Partner.erdat AS CreationDate,
  _Partner.erzeit AS CreationTime,
  _Partner.aenam AS LastChangedByUser,
  _Partner.aezeit AS LastChangeTime,
  _Partner.aedat AS LastChangeDate,
  lpad(ltrim(_Partner.parnr,'0'),10,'0') AS Partner
FROM ihpa AS _Partner
INNER JOIN wcahe AS _SafetyCertificate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = Partner  -- association [1..1]
LEFT OUTER JOIN I_PartnerFunction AS _PartnerFunction ON _PartnerFunction.PartnerFunction = PartnerFunction  -- association [1..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON _BusinessPartner.BusinessPartner = Partner  -- association [1..1]
;