P_DaysPyblOutstandingPurs00

DDL: P_DAYSPYBLOUTSTANDINGPURS00 SQL: PDPOPURS00 Type: view COMPOSITE

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

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_ReceivablesPayablesItem I_ReceivablesPayablesItem from

Parameters (2)

NameTypeDefault
P_PursRollingAverageMonths abap.int4
P_TodayDate sydate

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PDPOPURS00 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 (9)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
Supplier Creditor
FinancialAccountType FinancialAccountType
SpecialGLCode SpecialGLCode
GLAccount GLAccount
PostingDate PostingDate
CompanyCodeCurrency CompanyCodeCurrency
Purchases
FirstPurchasePostingDate 
@AbapCatalog.sqlViewName: 'PDPOPURS00'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter:true

define view P_DaysPyblOutstandingPurs00
  with parameters
    P_PursRollingAverageMonths : abap.int4,
    @Environment.systemField: #SYSTEM_DATE
    P_TodayDate                : sydate  
  as select from I_ReceivablesPayablesItem
{
  CompanyCode,
  Creditor                                     as Supplier,
  FinancialAccountType,
  SpecialGLCode,
  GLAccount,
  PostingDate,

  CompanyCodeCurrency,
  sum(AmountInCompanyCodeCurrency)             as Purchases,
  cast(dats_add_months( :P_TodayDate, -(:P_PursRollingAverageMonths + 11), 'FAIL') as fis_budat) as FirstPurchasePostingDate

}
where
      FinancialAccountType =  'K'
  and IsSalesRelated       =  'X'
  and PostingDate          <= :P_TodayDate

group by
  CompanyCode,
  Creditor,
  FinancialAccountType,
  SpecialGLCode,
  GLAccount,
  PostingDate,
  CompanyCodeCurrency

Learn More