P_DAYSPYBLOUTSTANDINGPURS02

CDS View

Purchases02 for DPO app

P_DAYSPYBLOUTSTANDINGPURS02 is a CDS View in S/4HANA. Purchases02 for DPO app. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DaysPyblOutstandingPurs03 view from COMPOSITE Purchases03 for DPO app 
@AbapCatalog.sqlViewName: 'PDPOPURS02'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter:true

define view P_DaysPyblOutstandingPurs02
  with parameters
    P_PursRollingAverageMonths : abap.int4,
    P_DisplayCurrency          : vdm_v_display_currency,
    P_ExchangeRateType         : kurst,
    @Environment.systemField: #SYSTEM_DATE
    P_TodayDate                : sydate
  as select from P_DaysPyblOutstandingPurs01( P_PursRollingAverageMonths: :P_PursRollingAverageMonths,
                                              P_TodayDate: :P_TodayDate )

{
  CompanyCode,
  Supplier,
  FinancialAccountType,
  SpecialGLCode,
  GLAccount,
  PostingDate,
  CompanyCodeCurrency,

  :P_DisplayCurrency as DisplayCurrency,
  currency_conversion(
            amount => Purchases,
            source_currency => CompanyCodeCurrency,
            target_currency => :P_DisplayCurrency,
            exchange_rate_date => PostingDate,
            exchange_rate_type => :P_ExchangeRateType,
  //        error_handling => #CNV_ERROR_HANDLING.FAIL_ON_ERROR,

            round => #CDSBoolean.true,
            decimal_shift => #CDSBoolean.true,
            decimal_shift_back => #CDSBoolean.true
  )                                                       as PurchasesInDisplayCrcy
}

Learn More