I_Bankstatementmonthtext

DDL: I_BANKSTATEMENTMONTHTEXT SQL: IBSMONTHTEXT Type: view COMPOSITE

Calendar Month Text with Bank Statement Month and Year

I_Bankstatementmonthtext is a Composite CDS View (Cube) that provides data about "Calendar Month Text with Bank Statement Month and Year" in SAP S/4HANA. It reads from 1 data source (I_CalendarMonthName) and exposes 4 fields with key field CalendarMonth.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarMonthName I_CalendarMonthName from

Parameters (1)

NameTypeDefault
P_TodayDate sydate

Annotations (10)

NameValueLevelField
EndUserText.label Calendar Month Text with Bank Statement Month and Year view
Analytics.dataCategory #CUBE view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IBSMONTHTEXT view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #CUSTOMIZING view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY CalendarMonth
CalendarMonthName CalendarMonthName
BankStatementDateMonth
BankStatementDateYear 
@EndUserText.label: 'Calendar Month Text with Bank Statement Month and Year' 
@Analytics: {dataCategory: #CUBE, dataExtraction.enabled: true}
@VDM.viewType: #COMPOSITE
@AbapCatalog.sqlViewName: 'IBSMONTHTEXT'
@AccessControl.authorizationCheck: #NOT_REQUIRED 
@ClientHandling.algorithm: #SESSION_VARIABLE 
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.serviceQuality: #A 
@ObjectModel.usageType.dataClass: #CUSTOMIZING

define view I_Bankstatementmonthtext 
with parameters
  @Environment.systemField: #SYSTEM_DATE
  P_TodayDate : sydate
  as select from I_CalendarMonthName
{
   key substring(CalendarMonth, 1, 2) as CalendarMonth,
   CalendarMonthName,
   cast(substring(cast(:P_TodayDate as abap.char(8)), 5, 2) as abap.numc(2))  as BankStatementDateMonth, //month is recorded

   cast(substring(cast(:P_TodayDate as abap.char(8)), 1, 4) as abap.numc(4))  as BankStatementDateYear //recoring date 

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CALENDARMONTHNAME"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More