P_PriceVariance5

DDL: P_PRICEVARIANCE5 SQL: PMMPRICEVAR5 Type: view CONSUMPTION
24 Fields 1 Data Sources

Price Variance 5

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

Data Sources (1)

SourceAliasJoin Type
P_PriceVariance4 P_PriceVariance4 from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate budat
P_EndDate budat

Annotations (6)

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

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PurchaseOrderItem Purchasing Document Item
PurchaseOrderType PurchaseOrderType PO Type
Supplier Supplier Supplier
PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
PurchaseOrderDate PurchaseOrderDate PO Date
CompanyCode CompanyCode Receiver Company Code
Material Material Vehicle Model
MaterialGroup MaterialGroup Product Group
Plant Plant Valuation Area
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
NetPriceAmountInDocCurr NetPriceAmount Net Price
PurchaseOrderQuantityUnit PurchaseOrderQuantityUnit Order Unit
NetAmount NetAmount Stated Amount
OrderPriceUnit OrderPriceUnit Order Price Un.
QtyInPurchaseOrderPricUnit QtyInPurchaseOrderPricUnit
NetValueAmountInDocCurrency
NetPriceQuantity NetPriceQuantity Price Unit
OrderQuantity OrderQuantity Quantity
DocumentCurrency DocumentCurrency Document Currency
InvoiceCurrency InvoiceCurrency Valuation Crcy
DeliveredQuantity QtyInPurchaseOrderPricUnit
InvoiceAmountInDocCurrency InvoiceAmountInDocCurrency

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_PriceVariance5.
-- 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: PMMPRICEVAR5
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : budat, P_EndDate : budat

CREATE VIEW P_PriceVariance5 AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderType,
  Supplier,
  cast( PurchasingOrganization as mm_a_purg_org ) AS PurchasingOrganization,
  PurchasingGroup,
  PurchaseOrderDate,
  CompanyCode,
  Material,
  MaterialGroup,
  Plant,
  PurchasingDocumentCategory,
  NetPriceAmount AS NetPriceAmountInDocCurr,
  PurchaseOrderQuantityUnit,
  NetAmount,
  OrderPriceUnit,
  QtyInPurchaseOrderPricUnit,
  division( NetPriceAmount, NetPriceQuantity , 6 ) AS NetValueAmountInDocCurrency,
  NetPriceQuantity,
  OrderQuantity,
  DocumentCurrency,
  InvoiceCurrency,
  QtyInPurchaseOrderPricUnit AS DeliveredQuantity,
  InvoiceAmountInDocCurrency
FROM P_PriceVariance4
;

Learn More