P_PriceVarianceOpsSE

DDL: P_PRICEVARIANCEOPSSE SQL: PPRICEVAROSE Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS
45 Fields 6 Data Sources

Price Variance Stack for Operational SE

P_PriceVarianceOpsSE is a Consumption CDS View that provides data about "Price Variance Stack for Operational SE" in SAP S/4HANA. It reads from 6 data sources and exposes 45 fields with key fields PurchaseOrder, PurchaseOrderItem, PurchaseOrderItem, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

Data Sources (6)

SourceAliasJoin Type
P_PurchDocAttributes P_PurchDocAttributes inner
P_PurchDocAttributes P_PurchDocAttributes inner
P_PurchDocAttributes P_PurchDocAttributes inner
I_SuplrEvalVarianceScoreInfo PriceVariance from
I_SuplrEvalVarianceScoreInfo PriceVariance union_all
I_SuplrEvalVarianceScoreInfo PriceVariance union_all

Parameters (2)

NameTypeDefault
P_StartDate budat
P_EndDate budat

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName PPRICEVAROSE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.preserveKey true view

Fields (45)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder I_SuplrEvalVarianceScoreInfo PurchasingDocument Purchasing Document
KEY PurchaseOrderItem I_SuplrEvalVarianceScoreInfo PurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingOrganization SupplrDimension PurchasingOrganization Purchasing Organization
PurchasingGroup SupplrDimension PurchasingGroup Purchasing Group
CompanyCode SupplrDimension CompanyCode Receiver Company Code
Supplier SupplrDimension Supplier Supplier
Plant SupplrDimension Plant Valuation Area
Material SupplrDimension Material Vehicle Model
MaterialGroup SupplrDimension MaterialGroup Product Group
PurchaseOrderDate PurchasingDocumentOrderDate PO Date
NetAmount NetAmount Stated Amount
DocumentCurrency I_SuplrEvalVarianceScoreInfo DocumentCurrency Document Currency
PriceVarianceScore PriceVarianceScore Price Variance Score
P_StartDate
PurchasingDocumentasPurchaseOrder
KEY PurchaseOrderItem I_SuplrEvalVarianceScoreInfo PurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingOrganization SupplrDimension PurchasingOrganization Purchasing Organization
PurchasingGroup SupplrDimension PurchasingGroup Purchasing Group
CompanyCode SupplrDimension CompanyCode Receiver Company Code
Supplier SupplrDimension Supplier Supplier
Plant SupplrDimension Plant Valuation Area
Material SupplrDimension Material Vehicle Model
MaterialGroup SupplrDimension MaterialGroup Product Group
PurchaseOrderDate PurchasingDocumentOrderDate PO Date
NetAmount NetAmount Stated Amount
DocumentCurrency I_SuplrEvalVarianceScoreInfo DocumentCurrency Document Currency
PriceVarianceScore PriceVarianceScore Price Variance Score
P_StartDate
PurchasingDocumentasPurchaseOrder
KEY PurchaseOrderItem I_SuplrEvalVarianceScoreInfo PurchasingDocumentItem Purchasing Doc. Item
PurchasingDocumentCategory PurchasingDocumentCategory Doc. Category
PurchasingOrganization SupplrDimension PurchasingOrganization Purchasing Organization
PurchasingGroup SupplrDimension PurchasingGroup Purchasing Group
CompanyCode SupplrDimension CompanyCode Receiver Company Code
Supplier SupplrDimension Supplier Supplier
Plant SupplrDimension Plant Valuation Area
Material SupplrDimension Material Vehicle Model
MaterialGroup SupplrDimension MaterialGroup Product Group
PurchaseOrderDate PurchasingDocumentOrderDate PO Date
NetAmount NetAmount Stated Amount
DocumentCurrency I_SuplrEvalVarianceScoreInfo DocumentCurrency Document Currency
PriceVarianceScore PriceVarianceScore Price Variance Score
SuplrEvalRelevantDocCategory

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_PriceVarianceOpsSE.
-- 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: PPRICEVAROSE
-- Parameters: P_StartDate : budat, P_EndDate : budat

CREATE VIEW P_PriceVarianceOpsSE AS
SELECT
  PriceVariance.PurchasingDocument AS PurchaseOrder,
  PriceVariance.PurchasingDocumentItem AS PurchaseOrderItem,
  PurchasingDocumentCategory,
  SupplrDimension.PurchasingOrganization AS PurchasingOrganization,
  SupplrDimension.PurchasingGroup AS PurchasingGroup,
  SupplrDimension.CompanyCode AS CompanyCode,
  SupplrDimension.Supplier AS Supplier,
  SupplrDimension.Plant AS Plant,
  SupplrDimension.Material AS Material,
  SupplrDimension.MaterialGroup AS MaterialGroup,
  PurchasingDocumentOrderDate AS PurchaseOrderDate,
  NetAmount,
  PriceVariance.DocumentCurrency AS DocumentCurrency,
  PriceVarianceScore,
  cast ( '1' as mmpur_ana_de_se_doc_config ) as SuplrEvalRelevantDocCategory AS P_StartDate,
  cast ( '3' as mmpur_ana_de_se_doc_config ) AS SuplrEvalRelevantDocCategory
FROM I_SuplrEvalVarianceScoreInfo AS PriceVariance
INNER JOIN P_PurchDocAttributes ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): I_SuplrEvalVarianceScoreInfo
;

Learn More