C_SupplierByPurchasingCat

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 C_SupplierByPurchasingCat.
-- 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: CSUPLRBYPURGCAT
-- Parameters: P_KeyDate : sydate

CREATE VIEW C_SupplierByPurchasingCat AS
SELECT
  _PurgCat.PurgCatUUID AS PurgCatUUID,
  _Suplr.Supplier AS Supplier,
  _PurgCat.BusinessPartner AS BusinessPartner,
  cast(_Suplr.Supplier as /srmsmc/odata_lifnr preserving type ) AS PurchasingCategorySupplier,
  _PurgCat.AuthorizationGroup AS AuthorizationGroup,
  _Suplr.SupplierName AS SupplierName,
  _Suplr.CreatedByUser AS CreatedByUser,
  _Suplr.CreationDate AS CreationDate,
  _Suplr.SupplierCorporateGroup AS SupplierCorporateGroup,
  _Suplr.PostingIsBlocked AS PostingIsBlocked,
  cast(_Suplr.PurchasingIsBlocked as /srmsmc/purch_block preserving type ) AS PurchasingIsBlocked,
  _Suplr.InternationalLocationNumber3 AS InternationalLocationNumber3,
  _Suplr.AddressID AS AddressID,
  cast('' as contactcardformattedaddress ) AS FormattedAddress,
  cast( coalesce( _PurgCat._SupplierControlData.IsPreferredSupplier, '' ) as sstn_preferred_supplier_ind preserving type ) AS IsPreferredSupplier,
  cast( coalesce( _PurgCat._SupplierControlData.IsStrategicPartner, '' ) as sstn_strategic_partner_ind preserving type ) AS IsStrategicPartner,
  _PurgCat._SupplierControlData.SupplierQualificationLevel AS SupplierQualificationLevel,
  _PurgCat._SupplierSustainabilityData[1: ValidityStartDate <= $parameters.P_KeyDate and ValidityEndDate >= $parameters.P_KeyDate].OverallScore AS OverallScore,
  cast( 0 as /srmsmc/year_to_date_spend_lng ) AS SupplierTotalNetAmtInDspCrcy,
  coalesce(_SupplierAnnualSpend( P_KeyDate : $parameters.P_KeyDate ).SupplierTotalNetAmtInDspCrcy, 0) AS PurgCatTotalSpendInDspCrcy,
  _DisplayCurrencySupplier.SupplierDisplayCurrency AS SupplierDisplayCurrency,
  _PurgCat.DataController1 AS DataController1,
  _PurgCat.DataController2 AS DataController2,
  _PurgCat.DataController3 AS DataController3,
  _PurgCat.DataController4 AS DataController4,
  _PurgCat.DataController5 AS DataController5,
  _PurgCat.DataController6 AS DataController6,
  _PurgCat.DataController7 AS DataController7,
  _PurgCat.DataController8 AS DataController8,
  _PurgCat.DataController9 AS DataController9,
  _PurgCat.DataController10 AS DataController10,
  _PurgCat.DataControllerSet AS DataControllerSet,
  _Suplr._SupplierBankDetails AS _SupplierBankDetails,
  _Suplr._SupplierCompany AS _SupplierCompany,
  _Suplr._SupplierPurchasingOrg AS _SupplierPurchasingOrg,
  _PurgCat._PurchasingCategory AS _PurchasingCategory
FROM I_Supplier AS _Suplr
LEFT OUTER JOIN I_SupplierQualificationLvl AS _SupplierQualificationLvl ON supplierqualificationlevel = _SupplierQualificationLvl.SupplierQualificationLevel  -- association [0..1]
LEFT OUTER JOIN P_DisplayCurrencySupplier AS _DisplayCurrencySupplier ON BusinessPartner = _DisplayCurrencySupplier.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN P_SupplierAnnualSpend AS _SupplierAnnualSpend ON PurgCatUUID = _SupplierAnnualSpend.PurgCatUUID AND Supplier = _SupplierAnnualSpend.Supplier  -- association [0..1]
;