P_PurReqnPriceCalculation

DDL: P_PURREQNPRICECALCULATION SQL: PPRPRICECALC Type: view CONSUMPTION Package: ODATA_MM_ANALYTICS

Purchase Requisition Price Calculation

P_PurReqnPriceCalculation is a Consumption CDS View that provides data about "Purchase Requisition Price Calculation" in SAP S/4HANA. It reads from 1 data source (I_PurchaseRequisitionItemBasic) and exposes 5 fields with key fields Material, Plant. Part of development package ODATA_MM_ANALYTICS.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_PurchaseRequisitionItemBasic PurchaseRequisition from

Parameters (3)

NameTypeDefault
P_DisplayCurrency displaycurrency
P_StartDate bedat
P_EndDate bedat

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PPRPRICECALC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.private true view
VDM.viewType #CONSUMPTION view
EndUserText.label Purchase Requisition Price Calculation view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY Material I_PurchaseRequisitionItemBasic Material
KEY Plant I_PurchaseRequisitionItemBasic Plant
PurchasingOrganization I_PurchaseRequisitionItemBasic PurchasingOrganization
PurchasingGroup I_PurchaseRequisitionItemBasic PurchasingGroup
MaterialGroup I_PurchaseRequisitionItemBasic MaterialGroup 
@AbapCatalog.sqlViewName: 'PPRPRICECALC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE //Inserted by VDM CDS Suite Plugin

@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality:  #D
@ObjectModel.usageType.sizeCategory: #L
@VDM.private: true
@VDM.viewType : #CONSUMPTION
@EndUserText.label: 'Purchase Requisition Price Calculation'
define view P_PurReqnPriceCalculation
  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate       : bedat,
    P_EndDate         : bedat

  as select from I_PurchaseRequisitionItemBasic as PurchaseRequisition
{


  key PurchaseRequisition.Material,
  key PurchaseRequisition.Plant,
//      PurchaseRequisition.Supplier,

//      PurchaseRequisition.FixedSupplier,

      PurchaseRequisition.PurchasingOrganization,
      PurchaseRequisition.PurchasingGroup,
      PurchaseRequisition.MaterialGroup,
//      PurchaseRequisition.PurchaseRequisitionPrice


       case when PurchaseRequisition.PurReqnPriceQuantity >0 and PurchaseRequisition.PurReqnItemCurrency != ''
        then cast ( Division (currency_conversion(
                               amount             => PurchaseRequisition.PurchaseRequisitionPrice ,
                               source_currency    => PurchaseRequisition.PurReqnItemCurrency,
                               target_currency    =>  :P_DisplayCurrency,
                               exchange_rate_date => PurchaseRequisition.PurReqCreationDate,
                               exchange_rate_type => 'M'

                               ), PurchaseRequisition.PurReqnPriceQuantity,5) as abap.curr(21,5) )

      else 0
      end                                           as PurchaseRequisitionPrice
}where
      PurchaseRequisition.CreationDate >= $parameters.P_StartDate
  and PurchaseRequisition.CreationDate <= $parameters.P_EndDate
  and Material <> ''

Learn More