C_SrvcPurOrderSpendCube

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_SrvcPurOrderSpendCube.
-- 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.
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW C_SrvcPurOrderSpendCube AS
SELECT
  PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderItem.Supplier AS Supplier,
  _Supplier.Country AS Country,
  PurchaseOrderItem.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderItem.CompanyCode AS CompanyCode,
  PurchaseOrderItem.PurchasingGroup AS PurchasingGroup,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.ProductType AS ProductTypeCode,
  PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  PurchaseOrderItem.PurchaseOrderDate AS PurchaseOrderDate,
  _CalendarDate.CalendarWeek AS CalendarWeek,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  _CalendarDate.CalendarQuarter AS CalendarQuarter,
  _CalendarDate.CalendarYear AS CalendarYear,
  PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  cast( $parameters.P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  cast( currency_conversion( amount => PurchaseOrderItem.NetAmount, source_currency => PurchaseOrderItem.DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => PurchaseOrderItem.PurchaseOrderDate ) as abap.curr( 21, 2 ) ) as PurOrdNetAmountInDisplayCrcy AS curr212asPurOrdNetAmountInDisplayCrcy,
  cast( ServiceEntrySheet.NetAmount as abap.curr( 21, 2 ) ) AS TotalNetAmount,
  cast( History.InvoiceAmtInDisplayCurrency as mm_pur_ana_de_invoice_amount ) AS InvoiceAmtInDisplayCurrency
FROM P_PurOrdItmServiceSpnd
LEFT OUTER JOIN P_PurOrdServiceInvoice ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PurOrdServiceEntry ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseOrderStatus AS _PurchaseOrderStatus ON PurchaseOrderItem.PurchaseOrder = _PurchaseOrderStatus.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _CalendarDate ON PurchaseOrderItem.PurchaseOrderDate = _CalendarDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentStatus AS _PurchasingDocumentStatus ON purchasingdocumentstatus = _PurchasingDocumentStatus.PurchasingDocumentStatus  -- association [1..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _MaterialGroup ON MaterialGroup = _MaterialGroup.ProductGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchaseOrderItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [1..1]
;