P_QuantityVariance

DDL: P_QUANTITYVARIANCE SQL: PMMQUANTVAR Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

P_QuantityVariance

P_QuantityVariance is a Consumption CDS View that provides data about "P_QuantityVariance" in SAP S/4HANA. It reads from 2 data sources (P_SupplierEvalByQuantity, P_QuantityVarianceUpdatedScore) and exposes 10 fields with key fields PurchaseOrder, PurchaseOrderItem. Part of development package ODATA_MM_ANALYTICS.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
P_SupplierEvalByQuantity P_SupplierEvalByQuantity from
P_QuantityVarianceUpdatedScore UpdatedScore left_outer

Parameters (4)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate bedat
P_EndDate bedat
P_DateFunction datefunctionid

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PMMQUANTVAR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PurchaseOrder QuantityVariance PurchaseOrder
KEY PurchaseOrderItem QuantityVariance PurchaseOrderItem
PurchaseOrderDate PurchaseOrderDate
PurchasingOrganization QuantityVariance PurchasingOrganization
PurchasingGroup PurchasingGroup
CompanyCode CompanyCode
Supplier Supplier
Material Material
MaterialGroup QuantityVariance MaterialGroup
Plant Plant 
@AbapCatalog.sqlViewName: 'PMMQUANTVAR'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
//@EndUserText.label: 'P_QuantityVariance'

@VDM.viewType : #CONSUMPTION
@VDM.private : true
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_QuantityVariance


  with parameters
    P_DisplayCurrency           : displaycurrency,
    P_StartDate: bedat,
    P_EndDate: bedat,
    P_DateFunction              : datefunctionid
  as select from    P_SupplierEvalByQuantity( P_DisplayCurrency : $parameters.P_DisplayCurrency,
                                              P_StartDate: $parameters.P_StartDate  ,
                                         P_EndDate:$parameters.P_EndDate )    as QuantityVariance

   left outer join P_QuantityVarianceUpdatedScore  as UpdatedScore     on  QuantityVariance.PurchaseOrder     = UpdatedScore.PurchaseOrder
                                                                                 and QuantityVariance.PurchaseOrderItem = UpdatedScore.PurchaseOrderItem

{
      /* Keys */
  key QuantityVariance.PurchaseOrder                     as  PurchaseOrder,
  key QuantityVariance.PurchaseOrderItem                as  PurchaseOrderItem,

      /* Order Date */
      PurchaseOrderDate,

      /* Org Data */
      QuantityVariance.PurchasingOrganization,
      PurchasingGroup,
      CompanyCode,

      Supplier,
      Material,
      QuantityVariance.MaterialGroup,
      Plant,

      @DefaultAggregation: #AVG
      cast( case when UpdatedScore.IsScoreChanged = 'X'
        then UpdatedScore.QuantityVarianceScore
       else SupplierEvaluationScore
      end as mm_a_variance_score )                                                      as  QuantityVarianceScore 
}

Learn More