P_APAgingGrid1

DDL: P_APAGINGGRID1 SQL: PAPAGINGGRID1 Type: view COMPOSITE

P_APAgingGrid1 is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_CalendarDate) and exposes 4 fields with key field CalendarDate.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate I_CalendarDate from

Parameters (1)

NameTypeDefault
P_NumberOfAgingGridColumns abap.int4

Annotations (6)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CalendarDate CalendarDate
AgingGridColumnSequence
Interval_Offset
NumberOfAgingGridColumns_x2 
@AbapCatalog.sqlViewName: 'PAPAGINGGRID1'
@VDM.viewType: #COMPOSITE
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
//Try to get a list of entries to present the aging intervals

//Corresponding to AccountsPayableFlexibleAgingQuery Projection4

define view P_APAgingGrid1
with parameters
    P_NumberOfAgingGridColumns : abap.int4
as select from
I_CalendarDate
{
    key CalendarDate,
    DATS_DAYS_BETWEEN(CalendarDate, cast('20000101' as abap.dats)) as AgingGridColumnSequence,
    DATS_DAYS_BETWEEN(CalendarDate, cast('20000101' as abap.dats)) - :P_NumberOfAgingGridColumns as Interval_Offset,
    :P_NumberOfAgingGridColumns * 2 as NumberOfAgingGridColumns_x2 
};  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More