P_PRICEANDQUANTITYVARIANCE4

CDS View

Price And Quantity Variance 4

P_PRICEANDQUANTITYVARIANCE4 is a CDS View in S/4HANA. Price And Quantity Variance 4. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_PriceAndQuantityVariance1 view from CONSUMPTION Price And Quantity Variance 1 
@AbapCatalog.sqlViewName: 'PMMPRCQNTYVAR4'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Price And Quantity Variance 4'
define view P_PriceAndQuantityVariance4
  with parameters
    P_StartDate : bedat,
    P_EndDate   : bedat

  as select from P_PriceAndQuantityVariance3 ( P_StartDate : $parameters.P_StartDate,
                                               P_EndDate : $parameters.P_EndDate ) as Items
{
  key PurchaseOrder,

  key PurchaseOrderItem,

      PurchasingDocumentCategory,
      PurchasingOrganization,
      Supplier,
      CompanyCode,
      PurchasingGroup,
      Plant,
      Material,
      MaterialGroup,
      PurchaseOrderDate,
      NetAmount,
      Currency,
      NetPriceAmount,

      sum(InvoiceAmountInDocCurrency) as InvoiceAmountInDocCurrency,
      sum(DeliveredQuantity)          as DeliveredQuantity

}
group by
  PurchaseOrder,
  PurchaseOrderItem,
  PurchasingDocumentCategory,
  PurchasingOrganization,
  Supplier,
  CompanyCode,
  PurchasingGroup,
  Plant,
  Material,
  MaterialGroup,
  PurchaseOrderDate,
  NetAmount,
  Currency,
  NetPriceAmount

Learn More