I_PurchasingCategory

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_PurchasingCategory.
-- 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: IPURGCATRT

CREATE VIEW I_PurchasingCategory AS
SELECT
  cast (db_key as /srmsmc/puc_uuid preserving type) AS PurgCatUUID,
  cast( id as /srmsmc/purchasing_category_id preserving type) AS PurchasingCategory,
  cast( name as /srmsmc/puc_name preserving type) AS PurgCatName,
  cast( crea_date_time as /srmsmc/created_on_ts preserving type) AS CreationDateTime,
  cast( crea_uname as vdm_createdbyuserid) AS CreatedByUser,
  cast( lchg_date_time as /srmsmc/last_changed_on_ts) AS LastChangeDateTime,
  cast( lchg_uname as vdm_lastchangedbyuserid) AS LastChangedByUser,
  cast( language_code as /srmsmc/language preserving type) AS Language,
  cast( inactive as /srmsmc/inactive_status preserving type) AS PurgCatIsInactive,
  cast(trans_status as /srmsmc/overall_transl_status preserving type ) AS PurgCatTranslationOvrlStatus,
  cast(trans_status as /srmsmc/overall_transl_status preserving type ) AS SLCTranslationStatus
FROM /srmsmc/d_puc_rt
LEFT OUTER JOIN I_PurchasingCategoryDesc AS _PurchasingCategoryDesc ON PurgCatUUID = _PurchasingCategoryDesc.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN I_PurchasingCategoryPlanSpend AS _PurchasingCategoryPlanSpend ON PurgCatUUID = _PurchasingCategoryPlanSpend.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS _PurchasingCategoryMatlGroup ON PurgCatUUID = _PurchasingCategoryMatlGroup.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN I_InactiveStatus AS _InactiveStatus ON PurgCatIsInactive = _InactiveStatus.PurgCatIsInactive  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON Language = _Language.Language  -- association [0..1]
LEFT OUTER JOIN I_SLCTranslationStatus AS _SLCTranslationStatus ON PurgCatTranslationOvrlStatus = _SLCTranslationStatus.SLCTranslationStatus  -- association [0..1]
LEFT OUTER JOIN I_SLCTranslationStatus AS _PurgCatTranslationOvrlStatus ON PurgCatTranslationOvrlStatus = _PurgCatTranslationOvrlStatus.SLCTranslationStatus  -- association [0..1]
LEFT OUTER JOIN I_PurchasingCategoryParty AS _PurchasingCategoryParty ON PurgCatUUID = _PurchasingCategoryParty.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN I_PurchasingCategorySupplier AS _Supplier ON PurgCatUUID = _Supplier.PurgCatUUID  -- association [0..1]
LEFT OUTER JOIN I_SupplierActivity AS _SupplierActivity ON PurgCatUUID = _SupplierActivity.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN I_PurchasingCatTranslationSts AS _PurchasingCatTranslationSts ON PurgCatUUID = _PurchasingCatTranslationSts.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_User AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_SLCContactCard AS _ContactCard ON ( ContactCardType = '/srmsmc/d_puc_py' AND ContactCardUUID = PurgCatUUID )  -- association [0..*]
LEFT OUTER JOIN I_PurchasingCategoryPurchResp AS _PurchaserResponsible ON PurgCatUUID = _PurchaserResponsible.PurgCatUUID  -- association [0..1]
;