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.
-- SQL view name: CMMPURORDSPND
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW C_PurchaseOrderSpend AS
SELECT
  cast(P_PurOrdItmAcctAssgmt.PurchaseOrder as vdm_purchaseorder) AS PurchaseOrder,
  cast(PurchaseOrderItem as vdm_purchaseorderitem) AS PurchaseOrderItem,
  AccountAssignmentNumber,
  PurgCatUUID,
  Supplier,
  SupplierCountry,
  PurchaseOrderDate,
  CalendarYear,
  CalendarQuarter,
  CalendarMonth,
  CalendarWeek,
  YearQuarter,
  PurchasingOrganization,
  CompanyCode,
  PurchasingGroup,
  PurchasingDocumentStatus,
  Material,
  P_PurOrdItmAcctAssgmt.MaterialGroup AS MaterialGroup,
  Plant,
  ProductType AS ProductTypeCode,
  cast ( ProductType as producttype) AS ProductType,
  ServicePerformer,
  PurchasingCategoryMatlGroup._PurchasingCategory.PurchasingCategory AS PurchasingCategory,
  _PurchasingCategory.PurgCatName AS PurgCatName,
  WBSElementInternalID,
  WBSElement,
  WBSDescription,
  _WBSElement.CustomerProjectName AS CustomerProjectName,
  _WBSElement.CustProjWorkPackageName AS CustProjWorkPackageName,
  CostCenter,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  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_Material AS _MaterialText ON Material = _MaterialText.Material  -- 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]
LEFT OUTER JOIN I_Country AS _Country ON SupplierCountry = _Country.Country  -- association [1..1]
;