A_PurgCat

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 A_PurgCat.
-- 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: APURGCATRT

CREATE VIEW A_PurgCat AS
SELECT
  PurgCatUUID,
  PurchasingCategory,
  PurgCatName,
  CreationDateTime,
  cast(CreatedByUser as /srmsmc/created_by ) AS CreatedByUser,
  LastChangeDateTime,
  cast(LastChangedByUser as /srmsmc/last_changed_by ) AS LastChangedByUser,
  Language,
  PurgCatIsInactive,
  PurgCatTranslationOvrlStatus
FROM I_PurchasingCategory
LEFT OUTER JOIN A_PurgCatDescription AS _PurgCatDescription ON PurgCatUUID = _PurgCatDescription.PurgCatUUID  -- association [1..*]
LEFT OUTER JOIN A_PurgCatPlannedSpend AS _PurgCatPlannedSpend ON PurgCatUUID = _PurgCatPlannedSpend.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN A_PurgCatMaterialGroup AS _PurgCatMaterialGroup ON PurgCatUUID = _PurgCatMaterialGroup.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN A_PurgCatPurchaserResponsible AS _PurgCatPurchaserResponsible ON PurgCatUUID = _PurgCatPurchaserResponsible.PurgCatUUID  -- association [1..1]
LEFT OUTER JOIN A_PurgCatSupplier AS _PurgCatSupplier ON PurgCatUUID = _PurgCatSupplier.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN A_PurgCatTranslationStatus AS _PurgCatTranslationStatus ON PurgCatUUID = _PurgCatTranslationStatus.PurgCatUUID  -- association [0..*]
LEFT OUTER JOIN A_PurgCatMember AS _PurgCatMember ON PurgCatUUID = _PurgCatMember.PurgCatUUID  -- association [0..*]
;