C_PPS_PurContrDocHistoryC

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_PPS_PurContrDocHistoryC.
-- 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.

CREATE VIEW C_PPS_PurContrDocHistoryC AS
SELECT
  PurchaseContract,
  PurchaseContractItem,
  ReleaseOrder AS PurchaseOrder,
  ReleaseOrderItem,
  ReleaseOrderItemOrderQuantity,
  ReleaseOrderItemQuantityUnit,
  ReleaseOrderItemNetAmount,
  ReleaseOrderCurrency,
  PPSPurOrderItemStatus,
  PPSPurOrdItemStatusCriticality,
  ReleaseOrderItemLastChgDate,
  R_PPS_PurContrDocHistory.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  R_PPS_PurContrDocHistory.Plant AS Plant,
  _Plant.PlantName AS PlantName,
  R_PPS_PurContrDocHistory.PurchasingOrganization AS PurchasingOrganization,
  _PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  ReleaseOrderDate,
  PurgConfigurableItemNumber,
  PurchasingHistoryCategory,
  case PurchasingHistoryCategory when '1' then cast('AccountingDocument' as abap.char(20)) when 'A' then cast('Supplier' as abap.char(20)) when 'C' then cast('PurchaseOrder' as abap.char(20)) when 'E' then cast('MaterialMovement' as abap.char(20)) when 'Q' then cast('SupplierInvoice' as abap.char(20)) else cast('PurchaseOrder' as abap.char(20)) end as SemanticObject AS char20endasSemanticObject
FROM R_PPS_PurContrDocHistory
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON R_PPS_PurContrDocHistory.PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _Plant ON R_PPS_PurContrDocHistory.Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON R_PPS_PurContrDocHistory.CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PurOrderHistoryCategoryText AS _POHistoryCategoryText ON _POHistoryCategoryText.PurchaseOrderHistCategory = PurchasingHistoryCategory AND _POHistoryCategoryText.Language = $session.system_language  -- association [1..1]
;