P_QUANTITYVARIANCEUPDATEDSCORE

CDS View

Quantity Variance Updated Score

P_QUANTITYVARIANCEUPDATEDSCORE is a CDS View in S/4HANA. Quantity Variance Updated Score. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_QuantityVariance view left_outer CONSUMPTION Quantity Variance
P_QuantityVariance view left_outer CONSUMPTION P_QuantityVariance 
@AbapCatalog.sqlViewName: 'PMMQTYVARUPDT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Quantity Variance Updated Score'
@VDM. private: true
@VDM.viewType: #CONSUMPTION
@AccessControl.personalData.blocking: #NOT_REQUIRED

define view P_QuantityVarianceUpdatedScore 

  as select from I_SuplrEvalAdjmtScore as SupplierScore
  
  inner join P_QuantityVarianceLastUpdt as LastUpdated on SupplierScore.PurchaseOrder = LastUpdated.PurchaseOrder
                                                        and SupplierScore.PurchaseOrderItem = LastUpdated.PurchaseOrderItem
                                                        and SupplierScore.LastChangeDateTime = LastUpdated.LastChangeDateTime
                                                        and SupplierScore.EvaluationType = '02'
                                                        and IsScoreChanged = 'X'
{
  key SupplierScore.PurchaseOrder,
  key SupplierScore.PurchaseOrderItem,
  
  SupplierScore.IsScoreChanged,
  
  SupplierScore.NewScore as QuantityVarianceScore
    
}

Learn More