P_TotalAccountsReceivables2

DDL: P_TOTALACCOUNTSRECEIVABLES2 SQL: PTOTALACCTRBLS2 Type: view COMPOSITE

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

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate I_CalendarDate from

Parameters (4)

NameTypeDefault
P_TodayDate sydate
P_NetDueInterval1InDays farp_net_due_interval1
P_NetDueInterval2InDays farp_net_due_interval2
P_NetDueInterval3InDays farp_net_due_interval3

Annotations (5)

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

Fields (9)

KeyFieldSource TableSource FieldDescription
CalendarDate CalendarDate
MaxNetDueIntervalInDays
DaysToTodayDate
PosNetDueInterval1InDays
PosNetDueInterval2InDays
PosNetDueInterval3InDays
NegNetDueInterval1InDays
NegNetDueInterval2InDays
NegNetDueInterval3InDays 
@AbapCatalog.sqlViewName: 'PTOTALACCTRBLS2'
@VDM.viewType: #COMPOSITE
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_TotalAccountsReceivables2
  with parameters
    P_TodayDate             : sydate,
    P_NetDueInterval1InDays : farp_net_due_interval1,
    P_NetDueInterval2InDays : farp_net_due_interval2,
    P_NetDueInterval3InDays : farp_net_due_interval3
  as select from I_CalendarDate
{
      CalendarDate,

      cast( 99999 as abap.int4 )                    as MaxNetDueIntervalInDays,
      DATS_DAYS_BETWEEN(:P_TodayDate, CalendarDate) as DaysToTodayDate,

      :P_NetDueInterval1InDays                      as PosNetDueInterval1InDays,
      :P_NetDueInterval2InDays                      as PosNetDueInterval2InDays,
      :P_NetDueInterval3InDays                      as PosNetDueInterval3InDays,

      -1 * :P_NetDueInterval1InDays - 1             as NegNetDueInterval1InDays,
      -1 * :P_NetDueInterval2InDays - 1             as NegNetDueInterval2InDays,
      -1 * :P_NetDueInterval3InDays - 1             as NegNetDueInterval3InDays
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More