P_DaysPyblOutstandingPybls000

DDL: P_DAYSPYBLOUTSTANDINGPYBLS000 SQL: PDPOPYBLS000 Type: view COMPOSITE

P_DaysPyblOutstandingPybls000 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ReceivablesPayablesItem) and exposes 12 fields.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_ReceivablesPayablesItem RPI from

Parameters (2)

NameTypeDefault
P_PyblsRollingAverageMonths abap.int4
P_TodayDate sydate

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PDPOPYBLS000 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 (12)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
Supplier Creditor
FinancialAccountType FinancialAccountType
SpecialGLCode SpecialGLCode
GLAccount GLAccount
CompanyCodeCurrency CompanyCodeCurrency
Credit
PostingDate PostingDate
ClearingDate ClearingDate
LastRollingMonth
FirstPyblsAvgMonth
FirstPayablesClearingDate 
@AbapCatalog.sqlViewName: 'PDPOPYBLS000'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter:true

define view P_DaysPyblOutstandingPybls000
  with parameters
    P_PyblsRollingAverageMonths : abap.int4,
    @Environment.systemField: #SYSTEM_DATE
    P_TodayDate:   sydate
  as select from I_ReceivablesPayablesItem      as RPI
{
  CompanyCode,
  Creditor as Supplier,
  FinancialAccountType,
  SpecialGLCode,
  GLAccount,
  CompanyCodeCurrency,
  sum( AmountInCompanyCodeCurrency )      as Credit,
  PostingDate,
  ClearingDate,
  substring(:P_TodayDate, 1, 6) as LastRollingMonth,
  substring(dats_add_months( :P_TodayDate, -(:P_PyblsRollingAverageMonths + 10), 'FAIL'), 1, 6) as FirstPyblsAvgMonth,
  cast(dats_add_months( :P_TodayDate, -(:P_PyblsRollingAverageMonths + 11), 'FAIL') as farp_augdt)  as FirstPayablesClearingDate
  
}
where
      FinancialAccountType = 'K'
  and PostingDate <= :P_TodayDate
  
group by
  CompanyCode,
  Creditor,
  FinancialAccountType,
  SpecialGLCode,
  GLAccount,
  CompanyCodeCurrency,
  PostingDate,
  ClearingDate

Learn More