C_PurchasingCategoryFs

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_PurchasingCategoryFs.
-- 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: CPURGCATEGORYFS
-- Parameters: P_KeyDate : sydate

CREATE VIEW C_PurchasingCategoryFs AS
SELECT
  PurgCatUUID,
  cast( PurchasingCategory as /srmsmc/purchasing_category_id preserving type ) AS PurchasingCategory,
  cast( PurgCatName as /srmsmc/purchasing_cat_name preserving type ) AS PurgCatName,
  _PurchasingCategoryDesc[1: Language = $session.system_language].PurgCatDescription AS Name,
  CreationDateTime,
  cast( I_PurchasingCategory.CreatedByUser as vdm_createdbyuserid preserving type) AS CreatedByUser,
  cast( _CreatedByUser.UserDescription as /srmsmc/created_by_user_desc preserving type) AS CreatedByUserFullName,
  LastChangeDateTime,
  cast( I_PurchasingCategory.LastChangedByUser as vdm_lastchangedbyuserid preserving type ) AS LastChangedByUser,
  cast( _LastChangedByUser.UserDescription as /srmsmc/last_changed_by_desc preserving type) AS LastChangedByUserFullName,
  I_PurchasingCategory.PurgCatTranslationOvrlStatus AS PurgCatTranslationOvrlStatus,
  PurgCatIsInactive,
  cast( I_PurchasingCategory._PurchaserResponsible.UserID as /srmsmc/purresponsiblename ) AS PurchaserResponsible,
  I_PurchasingCategory._PurchaserResponsible._BusinessUser.PersonFullName AS PurchaserRespFullName,
  cast( _PurgCatSupplierInfo.SupplierCount as /srmsmc/total_number ) AS SupplierCount,
  cast( _PurgCatSupplierInfo.PreferredSupplierCount as /srmsmc/preferred_suplr_count ) AS PreferredSupplierCount,
  cast( _PurgCatSupplierInfo.BlockedSupplierCount as /srmsmc/blocked_suplr_count ) AS BlockedSupplierCount,
  cast( 0 as /srmsmc/year_to_date_spend_lng ) AS PurgCatTotalSpendInDspCrcy,
  cast( _DisplayCurrency.DisplayCurrency as waers preserving type ) AS DisplayCurrency,
  cast( '' as abap.char( 1 ) ) AS UICT_CrteActyButtonIsHidden,
  cast( '' as abap.char( 1 ) ) AS UICT_ActyFacetIsHidden,
  cast( '' as abap.char( 1 ) ) AS UICT_IsReadOnly
FROM I_PurchasingCategory
LEFT OUTER JOIN C_SupplierByPurchasingCat AS _SupplierByPurchasingCat ON PurgCatUUID = _SupplierByPurchasingCat.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN P_PurgCatSupplierInfo AS _PurgCatSupplierInfo ON PurgCatUUID = _PurgCatSupplierInfo.PurgCatUUID  -- association [0..1]
LEFT OUTER JOIN P_TotalOrderValue AS _TotalOrderValue ON PurgCatUUID = _TotalOrderValue.PurgCatUUID  -- association [0..1]
LEFT OUTER JOIN C_ActivitiesByPurgCat AS _SupplierActivity ON PurgCatUUID = _SupplierActivity.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN I_InactiveStatusText AS _InactiveStatusText ON PurgCatIsInactive = _InactiveStatusText.PurgCatIsInactive AND _InactiveStatusText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_PurgCatMatlGroup AS _PurgCatMatlGroup ON PurgCatUUID = _PurgCatMatlGroup.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN C_PurgCatPlanSpend AS _PurgCatPlanSpend ON PurgCatUUID = _PurgCatPlanSpend.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN I_PurchasingCategoryValueHelp AS _PurchasingCategoryValueHelp ON PurchasingCategory = _PurchasingCategoryValueHelp.PurchasingCategory  -- association [0..1]
LEFT OUTER JOIN C_PurCatPurchRespValueHelp AS _PurCatPurchRespValueHelp ON _PurCatPurchRespValueHelp.UserID = PurchaserResponsible  -- association [0..1]
LEFT OUTER JOIN C_PurCatCreaByValueHelp AS _PurCatCreaByValueHelp ON _PurCatCreaByValueHelp.CreatedByUser = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN C_PurCatLastChByValueHelp AS _PurCatLastChByValueHelp ON _PurCatLastChByValueHelp.LastChangedByUser = LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN C_PurgCatTranslStsValueHelp AS _PurgCatTranslStsValueHelp ON _PurgCatTranslStsValueHelp.SLCTranslationStatus = PurgCatTranslationOvrlStatus  -- association [0..1]
LEFT OUTER JOIN P_DisplayCurrency AS _DisplayCurrency ON PurgCatUUID = _DisplayCurrency.PurgCatUUID  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON _CreatedByUser.UserID = CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON _LastChangedByUser.UserID = LastChangedByUser  -- association [0..1]
;