P_PurOrdItmServiceSpnd

DDL: P_PURORDITMSERVICESPND SQL: PPOITMSERSPND Type: view CONSUMPTION
21 Fields 2 Data Sources

Purchase Order Item - Service Spend

P_PurOrdItmServiceSpnd is a Consumption CDS View that provides data about "Purchase Order Item - Service Spend" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrder, I_PurchaseOrderItem) and exposes 21 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrder PurchaseOrder inner
I_PurchaseOrderItem PurchaseOrderItem from

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPOITMSERSPND view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Purchase Order Item - Service Spend view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
Supplier I_PurchaseOrder Supplier Supplier
PurchasingOrganization I_PurchaseOrder PurchasingOrganization Purchasing Organization
CompanyCode I_PurchaseOrder CompanyCode Receiver Company Code
PurchasingGroup I_PurchaseOrder PurchasingGroup Purchasing Group
Material I_PurchaseOrderItem Material Vehicle Model
MaterialGroup I_PurchaseOrderItem MaterialGroup Product Group
Plant I_PurchaseOrderItem Plant Valuation Area
ProductType ProductType Product Type Group
ServicePerformer ServicePerformer Service Performer
PurchaseOrderDate I_PurchaseOrder PurchaseOrderDate PO Date
DocumentCurrency I_PurchaseOrderItem DocumentCurrency Document Currency
PurchaseOrderItemCategory PurchaseOrderItemCategory Item Category
NetAmount I_PurchaseOrderItem NetAmount Stated Amount
OverallLimitAmount I_PurchaseOrderItem OverallLimitAmount Overall Limit
ExpectedOverallLimitAmount I_PurchaseOrderItem ExpectedOverallLimitAmount Expected Value
_PurchasingOrganization I_PurchaseOrder _PurchasingOrganization
_PurchasingGroup I_PurchaseOrder _PurchasingGroup
_Supplier I_PurchaseOrder _Supplier
_Plant _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_PurOrdItmServiceSpnd.
-- 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: PPOITMSERSPND
-- Parameters: P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PurOrdItmServiceSpnd AS
SELECT
  PurchaseOrder.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Plant AS Plant,
  ProductType,
  ServicePerformer,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItemCategory,
  PurchaseOrderItem.NetAmount AS NetAmount,
  PurchaseOrderItem.OverallLimitAmount AS OverallLimitAmount,
  PurchaseOrderItem.ExpectedOverallLimitAmount AS ExpectedOverallLimitAmount,
  PurchaseOrder._PurchasingOrganization AS _PurchasingOrganization,
  PurchaseOrder._PurchasingGroup AS _PurchasingGroup,
  PurchaseOrder._Supplier AS _Supplier
FROM I_PurchaseOrderItem AS PurchaseOrderItem
INNER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
;

Learn More