I_WorkPermitPartner

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_WorkPermitPartner.
-- 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: IPERMITPARTNER

CREATE VIEW I_WorkPermitPartner 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,
  _WorkPermit.wapinr AS WorkPermit,
  _WorkPermit.iwerk AS MaintenancePlanningPlant,
  _WorkPermit.wapiuse AS WorkPermitType,
  _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 wcaap AS _WorkPermit ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Customer AS _Customer ON _Customer.Customer = Partner OR _Customer.Customer = MaintenancePartner  -- association [0..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]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = MaintenancePartner OR _Supplier.Supplier = Partner  -- association [0..1]
;