I_USFedPurchasingHistory

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_USFedPurchasingHistory.
-- 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 I_USFedPurchasingHistory AS
SELECT
  cast( PurchasingDocument as pps_purchasing_document preserving type ) AS PurchasingDocument,
  cast( PurchasingDocumentItem as pps_purchasing_document_item preserving type ) AS PurchasingDocumentItem,
  PPSPurgHistDocumentCategory,
  cast( UnitOfMeasure as uom_qty_dele preserving type ) AS UnitOfMeasure,
  sum( Quantity ) AS Quantity,
  cast( POUnitOfMeasure as uom_qty_dele preserving type ) AS POUnitOfMeasure,
  sum( PurchaseOrderQty ) AS PurchaseOrderQty,
  cast( LocalCurrency as currency preserving type ) AS LocalCurrency,
  sum( AmountInLocalCurrency ) AS AmountInLocalCurrency,
  cast( DocumentCurrency as currency preserving type ) AS DocumentCurrency,
  sum( NetValueAmountInDocCurrency ) AS NetValueAmountInDocCurrency
FROM I_PPS_PurchasingHistory
;