P_SupplierPurchasingSpend

DDL: P_SUPPLIERPURCHASINGSPEND SQL: PSUPLRPURSPND Type: view CONSUMPTION
16 Fields 1 Data Sources

Purchasing Spend for Supplier

P_SupplierPurchasingSpend is a Consumption CDS View that provides data about "Purchasing Spend for Supplier" in SAP S/4HANA. It reads from 1 data source (I_PurchaseOrderItem) and exposes 16 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
I_PurchaseOrderItem PurchaseOrderItem from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate bedat
P_EndDate bedat

Annotations (11)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PSUPLRPURSPND view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Purchasing Spend for Supplier view
VDM.private true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem
Supplier
PurchasingOrganization
PurchasingGroup
CompanyCode
PurchaseOrderDate
CreatedByUser
Currency
MaterialGroup I_PurchaseOrderItem MaterialGroup Product Group
Material I_PurchaseOrderItem Material Vehicle Model
Plant I_PurchaseOrderItem Plant Valuation Area
PurchaseOrderItemCategory I_PurchaseOrderItem PurchaseOrderItemCategory Item Category
PurchaseOrderCategory I_PurchaseOrderItem PurchaseOrderCategory Doc. Category
DisplayCurrency
_Plant I_PurchaseOrderItem _Plant

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

CREATE VIEW P_SupplierPurchasingSpend AS
SELECT
  PurchaseOrder,
  cast( PurchaseOrderItem.PurchaseOrderItem as vdm_purchaseorderitem ) AS PurchaseOrderItem,
  PurchaseOrderItem._PurchaseOrder.Supplier AS Supplier,
  PurchaseOrderItem._PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrderItem._PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrderItem._PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrderItem._PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrderItem._PurchaseOrder.CreatedByUser AS CreatedByUser,
  PurchaseOrderItem._PurchaseOrder.DocumentCurrency AS Currency,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  PurchaseOrderItem.PurchaseOrderCategory AS PurchaseOrderCategory,
  cast( :P_DisplayCurrency as displaycurrency ) AS DisplayCurrency,
  PurchaseOrderItem._Plant AS _Plant
FROM I_PurchaseOrderItem AS PurchaseOrderItem
;

Learn More