P_IRM_Term_Structure

DDL: P_IRM_TERM_STRUCTURE SQL: PTERMSTRUC Type: view COMPOSITE

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

1 data source(s) 1 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate CalendarDate from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName PTERMSTRUC view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.serviceQuality #B view
VDM.private true view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY CalendarDate I_CalendarDate CalendarDate 
@AbapCatalog.sqlViewName: 'PTERMSTRUC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.preserveKey:true 
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #B
@VDM.private:true
define view P_IRM_Term_Structure
  with parameters
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : vdm_v_key_date
  as select from I_CalendarDate as CalendarDate
{
  key CalendarDate.CalendarDate,
      case
      when CalendarDate.CalendarDate <  DATS_ADD_MONTHS($parameters.P_KeyDate, 3, 'NULL')  then '0'
      when CalendarDate.CalendarDate >= DATS_ADD_MONTHS($parameters.P_KeyDate, 3, 'NULL')  and CalendarDate.CalendarDate < DATS_ADD_MONTHS($parameters.P_KeyDate, 6, 'NULL')  then '1'
      when CalendarDate.CalendarDate >= DATS_ADD_MONTHS($parameters.P_KeyDate, 6, 'NULL')  and CalendarDate.CalendarDate < DATS_ADD_MONTHS($parameters.P_KeyDate, 12, 'NULL') then '2'
      when CalendarDate.CalendarDate >= DATS_ADD_MONTHS($parameters.P_KeyDate, 12, 'NULL') and CalendarDate.CalendarDate < DATS_ADD_MONTHS($parameters.P_KeyDate, 36, 'NULL') then '3'
      when CalendarDate.CalendarDate >= DATS_ADD_MONTHS($parameters.P_KeyDate, 36, 'NULL') and CalendarDate.CalendarDate < DATS_ADD_MONTHS($parameters.P_KeyDate, 60, 'NULL') then '4'
      else '5' end as SortSequence
}
where
  CalendarDate.CalendarDate >= $parameters.P_KeyDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARDATE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More