I_PurchasingCategorySupplier

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_PurchasingCategorySupplier.
-- 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: IPURGCATSUPPLIER

CREATE VIEW I_PurchasingCategorySupplier AS
SELECT
  PurgCatPartyUUID,
  PurgCatUUID,
  I_BusinessPartner.BusinessPartnerUUID AS BusinessPartnerUUID,
  cast(substring( SLCParty,1,10) as bu_partner preserving type) AS BusinessPartner,
  cast(I_Supplier_to_BusinessPartner.Supplier as /srmsmc/supplier_id preserving type) AS Supplier,
  I_Supplier.AuthorizationGroup AS AuthorizationGroup,
  I_Supplier.DataController1 AS DataController1,
  I_Supplier.DataController2 AS DataController2,
  I_Supplier.DataController3 AS DataController3,
  I_Supplier.DataController4 AS DataController4,
  I_Supplier.DataController5 AS DataController5,
  I_Supplier.DataController6 AS DataController6,
  I_Supplier.DataController7 AS DataController7,
  I_Supplier.DataController8 AS DataController8,
  I_Supplier.DataController9 AS DataController9,
  I_Supplier.DataController10 AS DataController10,
  I_Supplier.DataControllerSet AS DataControllerSet
FROM I_PurchasingCategoryParty AS party
INNER JOIN I_BusinessPartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_Supplier_to_BusinessPartner ON /* join condition not captured in parsed metadata */
INNER JOIN I_Supplier ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchasingCategory AS _PurchasingCategory ON PurgCatUUID = _PurchasingCategory.PurgCatUUID  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON _Supplier.Supplier = Supplier  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON BusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_SupplierSustainabilityData AS _SupplierSustainabilityData ON BusinessPartner = _SupplierSustainabilityData.Supplier  -- association [0..*]
LEFT OUTER JOIN I_SupplierControlData AS _SupplierControlData ON BusinessPartner = _SupplierControlData.BusinessPartner  -- association [0..1]
;