P_PriceAndQuantityVariance2

DDL: P_PRICEANDQUANTITYVARIANCE2 SQL: PMMPRCQNTYVAR2 Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
12 Fields 3 Data Sources

Price And Quantity Variance 2

P_PriceAndQuantityVariance2 is a Consumption CDS View that provides data about "Price And Quantity Variance 2" in SAP S/4HANA. It reads from 3 data sources (P_PriceAndQuantityVariance1, P_SuplrEvalCritrnVarcScore, P_PriceVarianceUpdatedScore) and exposes 12 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (3)

SourceAliasJoin Type
P_PriceAndQuantityVariance1 P_PriceAndQuantityVariance1 from
P_SuplrEvalCritrnVarcScore Scoring inner
P_PriceVarianceUpdatedScore UpdatedScore left_outer

Parameters (2)

NameTypeDefault
P_StartDate bedat
P_EndDate bedat

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PMMPRCQNTYVAR2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Price And Quantity Variance 2 view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder PriceVariance PurchaseOrder Purchasing Document
KEY PurchaseOrderItem PriceVariance PurchaseOrderItem Purchasing Document Item
PurchaseOrderDate PurchaseOrderDate PO Date
PurchasingOrganization PriceVariance PurchasingOrganization Purchasing Organization
PurchasingGroup PurchasingGroup Purchasing Group
CompanyCode CompanyCode Receiver Company Code
Supplier Supplier Supplier
Material Material Vehicle Model
MaterialGroup PriceVariance MaterialGroup Product Group
Plant Plant Valuation Area
PurchasingCategory PriceVariance PurchasingCategory Purchasing Category
PurgCatName PurgCatName Purchasing Cat. Name

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_PriceAndQuantityVariance2.
-- 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: PMMPRCQNTYVAR2
-- Parameters: P_StartDate : bedat, P_EndDate : bedat

CREATE VIEW P_PriceAndQuantityVariance2 AS
SELECT
  PriceVariance.PurchaseOrder AS PurchaseOrder,
  PriceVariance.PurchaseOrderItem AS PurchaseOrderItem,
  PurchaseOrderDate,
  PriceVariance.PurchasingOrganization AS PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  Supplier,
  Material,
  PriceVariance.MaterialGroup AS MaterialGroup,
  Plant,
  PriceVariance.PurchasingCategory AS PurchasingCategory,
  PurgCatName
FROM P_PriceAndQuantityVariance1
INNER JOIN P_SuplrEvalCritrnVarcScore AS Scoring ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PriceVarianceUpdatedScore AS UpdatedScore ON /* join condition not captured in parsed metadata */
;

Learn More