I_SupplierPartnerFunc_2

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_SupplierPartnerFunc_2.
-- 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: ISUPLPARTFUNC2

CREATE VIEW I_SupplierPartnerFunc_2 AS
SELECT
  wyt3.lifnr AS Supplier,
  wyt3.ekorg AS PurchasingOrganization,
  wyt3.ltsnr AS SupplierSubrange,
  wyt3.werks AS Plant,
  cast( wyt3.parvw as parvw_unv) AS PartnerFunction,
  wyt3.parza AS PartnerCounter,
  wyt3.defpa AS DefaultPartner,
  wyt3.erdat AS CreationDate,
  wyt3.ernam AS CreatedByUser,
  tpar.nrart AS PartnerFunctionType,
  case when tpar.nrart = 'LI' then wyt3.lifn2 when tpar.nrart = 'AP' then wyt3.parnr when tpar.nrart = 'PE' then wyt3.pernr else '' end as ReferenceSupplier AS pernrelseendasReferenceSupplier,
  wyt3.parnr AS ContactPerson,
  wyt3.pernr AS PersonnelNumber,
  _SupplierPurchasing.AuthorizationGroup AS AuthorizationGroup
FROM wyt3
INNER JOIN tpar ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SupplierPurchasingOrg AS _SupplierPurchasing ON Supplier = _SupplierPurchasing.Supplier AND PurchasingOrganization = _SupplierPurchasing.PurchasingOrganization  -- association [1..1]
;