P_PriceVariance1

DDL: P_PRICEVARIANCE1 SQL: PMMPRICEVAR1 Type: view CONSUMPTION
23 Fields 1 Data Sources

Price Variance 1

P_PriceVariance1 is a Consumption CDS View that provides data about "Price Variance 1" in SAP S/4HANA. It reads from 1 data source (P_PriceVariance5) and exposes 23 fields with key fields PurchaseOrder, PurchaseOrderItem.

Data Sources (1)

SourceAliasJoin Type
P_PriceVariance5 P_PriceVariance5 from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate budat
P_EndDate budat

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMPRICEVAR1 view
EndUserText.label Price Variance 1 view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchasingOrganization PurchasingOrganization Purchasing Organization
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
PurchasingGroup PurchasingGroup Purchasing Group
Plant Plant Valuation Area
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchaseOrderDate PurchaseOrderDate PO Date
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
Currency DocumentCurrency Document Currency
InvoiceAmountInDocCurrency InvoiceAmountInDocCurrency
NetAmount NetAmount Stated Amount
NetPriceQuantity NetPriceQuantity Price Unit
OrderedQuantity OrderQuantity Quantity
DeliveredQuantity
InvoiceAmount
NetPriceAmount NetPriceAmount Net Price
PurchaseOrderNetPriceAmount PurchaseOrderNetPriceAmount
NetValueAmountInDocCurrency
OrderPriceUnit 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_PriceVariance1.
-- 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: PMMPRICEVAR1
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : budat, P_EndDate : budat

CREATE VIEW P_PriceVariance1 AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchasingOrganization,
  CompanyCode,
  Supplier,
  PurchasingGroup,
  Plant,
  Material,
  MaterialGroup,
  PurchasingDocumentCategory,
  PurchaseOrderDate,
  PurchaseOrderQuantityUnit,
  DocumentCurrency AS Currency,
  InvoiceAmountInDocCurrency,
  NetAmount,
  NetPriceQuantity,
  OrderQuantity AS OrderedQuantity,
  sum(DeliveredQuantity) AS DeliveredQuantity,
  sum(InvoiceAmount) AS InvoiceAmount,
  NetPriceAmount,
  PurchaseOrderNetPriceAmount,
  division( NetPriceAmount, NetPriceQuantity , 6 ) AS NetValueAmountInDocCurrency,
  OrderPriceUnit
FROM P_PriceVariance5
;

Learn More