P_DaysPyblOutstandingPurs03

DDL: P_DAYSPYBLOUTSTANDINGPURS03 SQL: PDPOPURS03 Type: view COMPOSITE

P_DaysPyblOutstandingPurs03 is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_CalendarDate, P_DaysPyblOutstandingPurs02) and exposes 11 fields.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
I_CalendarDate CD left_outer
P_DaysPyblOutstandingPurs02 P_DaysPyblOutstandingPurs02 from

Parameters (4)

NameTypeDefault
P_PursRollingAverageMonths abap.int4
P_DisplayCurrency vdm_v_display_currency
P_ExchangeRateType kurst
P_TodayDate sydate

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PDPOPURS03 view
VDM.viewType #COMPOSITE view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view

Fields (11)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
Supplier Supplier
FinancialAccountType FinancialAccountType
SpecialGLCode SpecialGLCode
GLAccount GLAccount
CalendarYear CalendarYear
CalendarMonth CalendarMonth
YearMonth YearMonth
CompanyCodeCurrency CompanyCodeCurrency
DisplayCurrency DisplayCurrency
PurchasesInDisplayCrcy 
@AbapCatalog.sqlViewName: 'PDPOPURS03'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter:true

define view P_DaysPyblOutstandingPurs03
  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_DaysPyblOutstandingPurs02( P_PursRollingAverageMonths: :P_PursRollingAverageMonths,
                                              P_DisplayCurrency:   :P_DisplayCurrency, 
                                              P_ExchangeRateType:  :P_ExchangeRateType,
                                              P_TodayDate:         :P_TodayDate ) as Purchases
       left outer join I_CalendarDate as CD
        on Purchases.PostingDate = CD.CalendarDate
                              
{
  CompanyCode,
  Supplier,
  FinancialAccountType,
  SpecialGLCode,
  GLAccount,
  CalendarYear,
  CalendarMonth,
  YearMonth,
  CompanyCodeCurrency,
  DisplayCurrency,
  sum(PurchasesInDisplayCrcy) as PurchasesInDisplayCrcy
} 
group by
  CompanyCode,
  Supplier,
  FinancialAccountType,
  SpecialGLCode,
  GLAccount,
  CalendarYear,
  CalendarMonth,
  YearMonth,
  CompanyCodeCurrency,
  DisplayCurrency

Learn More