C_PurchaseOrderSpend

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_PurchaseOrderSpend.
-- 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_PurchaseOrderSpend AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  PurchaseOrder.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrder.AccountAssignmentNumber AS AccountAssignmentNumber,
  PurchasingCategoryMatlGroup.PurgCatUUID AS PurgCatUUID,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.SupplierCountry AS SupplierCountry,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrder.CalendarYear AS CalendarYear,
  PurchaseOrder.CalendarQuarter AS CalendarQuarter,
  PurchaseOrder.CalendarMonth AS CalendarMonth,
  PurchaseOrder.CalendarWeek AS CalendarWeek,
  PurchaseOrder.YearQuarter AS YearQuarter,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  PurchaseOrder.Material AS Material,
  PurchaseOrder.MaterialGroup AS MaterialGroup,
  PurchaseOrder.Plant AS Plant,
  PurchaseOrder.ProductType AS ProductTypeCode,
  PurchaseOrder.ServicePerformer AS ServicePerformer,
  PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  PurchasingCategoryMatlGroup._PurchasingCategory.PurgCatName AS PurgCatName,
  PurchaseOrder.WBSElementInternalID AS WBSElementInternalID,
  PurchaseOrder.WBSElement AS WBSElement,
  PurchaseOrder.WBSDescription AS WBSDescription,
  _WBSElement.CustomerProjectName AS CustomerProjectName,
  _WBSElement.CustProjWorkPackageName AS CustProjWorkPackageName,
  PurchaseOrder.CostCenter AS CostCenter,
  cast( $parameters.P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  cast(PurchaseOrder.PurOrdNetAmountInDisplayCrcy as abap.curr(21,2)) AS PurOrdNetAmountInDisplayCrcy
FROM P_PurOrdItemAcctAssgmt
LEFT OUTER JOIN I_PurchasingCategoryMatlGroup AS PurchasingCategoryMatlGroup ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_Purordmaintaincustproj AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_PurchasingDocumentStatus AS _PurchasingDocumentStatus ON PurchasingDocumentStatus = _PurchasingDocumentStatus.PurchasingDocumentStatus  -- association [1..1]
;