C_PurOrdServiceSpend

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

CREATE VIEW C_PurOrdServiceSpend AS
SELECT
  PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderItem.Supplier AS Supplier,
  PurchaseOrderItem.Supplier AS SupplierName,
  PurchaseOrderItem._Supplier.Country AS SupplierCountry,
  _SupplierName.Country AS Country,
  PurchaseOrderItem.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderItem.PurchasingOrganization AS PurchasingOrganizationName,
  PurchaseOrderItem.CompanyCode AS CompanyCode,
  PurchaseOrderItem.PurchasingGroup AS PurchasingGroup,
  PurchaseOrderItem.PurchasingGroup AS PurchasingGroupName,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchasingDocumentStatus,
  PurchaseOrderItem.Material AS Product,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.MaterialGroup AS ProductGroup,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.Plant AS PlantName,
  cast ( ProductType as producttype) AS ProductType,
  ProductType AS ProductTypeCode,
  ServicePerformer,
  PurchaseOrderItem.PurchaseOrderDate AS PurchaseOrderDate,
  _CalendarDate.CalendarWeek AS CalendarWeek,
  _CalendarDate.CalendarMonth AS CalendarMonth,
  _CalendarDate.CalendarQuarter AS CalendarQuarter,
  _CalendarDate.CalendarYear AS CalendarYear,
  PurchaseOrderItemCategory,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  cast( ServiceEntrySheet.NetAmount as mm_pur_ses_confirmed ) AS TotalNetAmount,
  cast( InvoiceAmtInDisplayCurrency as mm_pur_ana_de_invoice_amount ) AS InvoiceAmtInDisplayCurrency,
  PurchaseOrderItem._Plant AS _Plant,
  PurchaseOrderItem._PurchasingOrganization AS _PurchasingOrganization,
  PurchaseOrderItem._PurchasingGroup AS _PurchasingGroup,
  PurchaseOrderItem._Supplier AS _Supplier
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_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_MaterialGroup AS _MaterialGroup ON MaterialGroup = _MaterialGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentItemCategory AS _PurgDocumentItemCategory ON PurchaseOrderItemCategory = _PurgDocumentItemCategory.PurchasingDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON SupplierCountry = _Country.Country  -- association [1..1]
LEFT OUTER JOIN I_Country AS _CountryName ON country = _CountryName.Country  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _PlantName ON PlantName = _PlantName.Plant  -- association [1..1]
LEFT OUTER JOIN I_Supplier AS _SupplierName ON SupplierName = _SupplierName.Supplier  -- association [1..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganizationName ON PurchasingOrganizationName = _PurchasingOrganizationName.PurchasingOrganization  -- association [1..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroupName ON PurchasingGroupName = _PurchasingGroupName.PurchasingGroup  -- association [1..1]
;