P_APDaysPayOutst1

DDL: P_APDAYSPAYOUTST1 SQL: PFIAP_DPO1 Type: view COMPOSITE

P_APDaysPayOutst1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_OperationalAcctgDocItem) and exposes 8 fields.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
I_OperationalAcctgDocItem I_OperationalAcctgDocItem from

Parameters (1)

NameTypeDefault
P_DateTo hrenddate

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PFIAP_DPO1 view
VDM.private true view
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view

Fields (8)

KeyFieldSource TableSource FieldDescription
CompanyCode CompanyCode
Supplier Supplier
ClearingDate ClearingDate
PostingDate PostingDate
CompanyCodeCurrency CompanyCodeCurrency
AmountInCompanyCodeCurrency
ClearingDays
DateFrom 
@AbapCatalog.sqlViewName: 'PFIAP_DPO1'
@VDM.private: true
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
define view P_APDaysPayOutst1  
with parameters
  P_DateTo : hrenddate
as select from I_OperationalAcctgDocItem
{
  CompanyCode,
  Supplier,
  ClearingDate, 
  PostingDate, 
  CompanyCodeCurrency,
  
  abs(AmountInCompanyCodeCurrency) as AmountInCompanyCodeCurrency,
  DATS_DAYS_BETWEEN(PostingDate, ClearingDate) as ClearingDays,
  DATS_ADD_MONTHS(:P_DateTo, (-1 * 12), 'INITIAL') as DateFrom
}
where 
  (IsSalesRelated = 'X' and FinancialAccountType = 'K')
  and Supplier != ''
  and PostingDate <= ClearingDate
  and DebitCreditCode = 'H'
  and IsNegativePosting = '';

Learn More