P_FINTRANSBUSVOLKEYDATE

CDS View

P_FINTRANSBUSVOLKEYDATE is a CDS View in S/4HANA. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_FinTransOpenFlowBusVol view from COMPOSITE
P_FXOptionTransBusVol view from COMPOSITE 
@AbapCatalog.sqlViewName: 'PTRANSBUSVOLDATE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S
@ClientHandling.algorithm: #SESSION_VARIABLE  
@VDM.private:true
define view P_FinTransBusVolKeyDate 
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_StartDate               : vdm_v_start_date,
    @Environment.systemField: #SYSTEM_DATE
    P_EndDate                 : vdm_v_end_date,
    P_FinTransAmtRptgFrequency : ftr_date_granularity
as select from P_FTR_ASGN_FIRST_DATE_OF_TERM(P_StartDate : $parameters.P_StartDate,
                                             P_EndDate   : $parameters.P_EndDate,
                                             P_CrdtLineReportingFrequency : $parameters.P_FinTransAmtRptgFrequency)  as CalendarDate 
{
  CalendarDate.KeyDate
}
where 
  CalendarDate.CON_DAY    = $parameters.P_FinTransAmtRptgFrequency

union all 

select distinct from P_Ftr_Last_Date_Of_Last_Term(P_StartDate : $parameters.P_StartDate,
                                             P_EndDate   : $parameters.P_EndDate,
                                             P_CrdtLineReportingFrequency : $parameters.P_FinTransAmtRptgFrequency)  as CalendarDate
{
  CalendarDate.KeyDate
}
where
      CalendarDate.CON_WEEK_END     = $parameters.P_FinTransAmtRptgFrequency
  or  CalendarDate.CON_MONTH_END    = $parameters.P_FinTransAmtRptgFrequency
  or  CalendarDate.CON_QUARTER_END  = $parameters.P_FinTransAmtRptgFrequency

Learn More