P_PurchaseOrderPriceVariance1

DDL: P_PURCHASEORDERPRICEVARIANCE1 Type: view_entity CONSUMPTION Package: ODATA_MM_ANALYTICS
23 Fields 2 Data Sources

Purchase Order Price Variance

P_PurchaseOrderPriceVariance1 is a Consumption CDS View that provides data about "Purchase Order Price Variance" in SAP S/4HANA. It reads from 2 data sources (I_PurchaseOrder, I_PurchaseOrderItem) and exposes 23 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
I_PurchaseOrder PurchaseOrder inner
I_PurchaseOrderItem PurchaseOrderItem from

Parameters (3)

NameTypeDefault
P_Material matnr
P_StartDate vdm_validitystart
P_EndDate vdm_validityend

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_PurchaseOrderItem PurchaseOrder Purchasing Document
KEY PurchaseOrderItem I_PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderItemUniqueID I_PurchaseOrderItem PurchaseOrderItemUniqueID Document Item
PurchaseOrderType I_PurchaseOrder PurchaseOrderType PO Type
Supplier I_PurchaseOrder Supplier Supplier
PurchasingOrganization I_PurchaseOrder PurchasingOrganization Purchasing Organization
PurchasingGroup I_PurchaseOrder PurchasingGroup Purchasing Group
CompanyCode I_PurchaseOrder CompanyCode Receiver Company Code
PurchaseOrderDate I_PurchaseOrder PurchaseOrderDate PO Date
MaterialGroup I_PurchaseOrderItem MaterialGroup Product Group
Material I_PurchaseOrderItem Material Vehicle Model
Plant I_PurchaseOrderItem Plant Valuation Area
PurchaseContract I_PurchaseOrderItem PurchaseContract Purchasing Doc.
PurchasingInfoRecord I_PurchaseOrderItem PurchasingInfoRecord Info Record
PurchaseOrderQuantityUnit I_PurchaseOrderItem PurchaseOrderQuantityUnit Order Unit
OrderQuantity I_PurchaseOrderItem OrderQuantity Quantity
DocumentCurrency I_PurchaseOrderItem DocumentCurrency Document Currency
NetPriceAmount I_PurchaseOrderItem NetPriceAmount Net Price
NetAmount I_PurchaseOrderItem NetAmount Stated Amount
OrdPriceUnitToOrderUnitDnmntr I_PurchaseOrderItem OrdPriceUnitToOrderUnitDnmntr Quantity Conversion Denominator
OrderPriceUnitToOrderUnitNmrtr I_PurchaseOrderItem OrderPriceUnitToOrderUnitNmrtr Quantity Conversion Numerator
NetPriceQuantity I_PurchaseOrderItem NetPriceQuantity Price Unit
OrderPriceUnit I_PurchaseOrderItem OrderPriceUnit Order Price Un.

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_PurchaseOrderPriceVariance1.
-- 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_Material : matnr, P_StartDate : vdm_validitystart, P_EndDate : vdm_validityend

CREATE VIEW P_PurchaseOrderPriceVariance1 AS
SELECT
  PurchaseOrderItem.PurchaseOrder AS PurchaseOrder,
  PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderItem.PurchaseOrderItemUniqueID AS PurchaseOrderItemUniqueID,
  PurchaseOrder.PurchaseOrderType AS PurchaseOrderType,
  PurchaseOrder.Supplier AS Supplier,
  PurchaseOrder.PurchasingOrganization AS PurchasingOrganization,
  PurchaseOrder.PurchasingGroup AS PurchasingGroup,
  PurchaseOrder.CompanyCode AS CompanyCode,
  PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  PurchaseOrderItem.Material AS Material,
  PurchaseOrderItem.Plant AS Plant,
  PurchaseOrderItem.PurchaseContract AS PurchaseContract,
  PurchaseOrderItem.PurchasingInfoRecord AS PurchasingInfoRecord,
  PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PurchaseOrderItem.OrderQuantity AS OrderQuantity,
  PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  PurchaseOrderItem.NetPriceAmount AS NetPriceAmount,
  PurchaseOrderItem.NetAmount AS NetAmount,
  PurchaseOrderItem.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  PurchaseOrderItem.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  PurchaseOrderItem.NetPriceQuantity AS NetPriceQuantity,
  PurchaseOrderItem.OrderPriceUnit AS OrderPriceUnit
FROM I_PurchaseOrderItem AS PurchaseOrderItem
INNER JOIN I_PurchaseOrder AS PurchaseOrder ON /* join condition not captured in parsed metadata */
;

Learn More