P_NONMNGDPURCHASINGSPEND4

CDS View

Non Managed Spend

P_NONMNGDPURCHASINGSPEND4 is a CDS View in S/4HANA. Non Managed Spend. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_NonMngdPurchasingSpend2 view from CONSUMPTION Non Managed Spend 
@AbapCatalog.sqlViewName: 'PMMNONMNGDPURS4'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #CONSUMPTION
@VDM.private: true
@AccessControl.personalData.blocking: #NOT_REQUIRED
define view P_NonMngdPurchasingSpend4 // ^3119821


  with parameters
    P_DisplayCurrency : displaycurrency,
    P_StartDate       : budat,
    P_EndDate         : budat

  as select from P_NonMngdPurchasingSpend1( P_DisplayCurrency:$parameters.P_DisplayCurrency , P_StartDate: $parameters.P_StartDate,
                                       P_EndDate: $parameters.P_EndDate) as Supplier


{
  key Supplier.AccountingDocument,
  key Supplier.FiscalYear,
  key Supplier.CompanyCode,
  key Supplier.Creditor,

      Supplier.PostingDate,
      Supplier.AccountingDocumentType,
      Supplier.CompanyCodeCurrency,

      case when Supplier.PostingDate is not null
                   then   currency_conversion(  amount         => Supplier.AmountInCompanyCodeCurrency,
                                            source_currency    => Supplier.CompanyCodeCurrency,
                                            target_currency    => $parameters.P_DisplayCurrency,
                                            exchange_rate_date => Supplier.PostingDate
                           )
                  else 0
       end as SupplierAmount


} // v3119821

Learn More