P_GLFiscalYearByKeyDate

DDL: P_GLFISCALYEARBYKEYDATE SQL: PGLFISYRKEY Type: view CONSUMPTION Package: ODATA_GL_OVP

Fiscal Year By Key Date

P_GLFiscalYearByKeyDate is a Consumption CDS View that provides data about "Fiscal Year By Key Date" in SAP S/4HANA. It reads from 1 data source (I_CalendarDate) and exposes 4 fields. Part of development package ODATA_GL_OVP.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_CalendarDate I_CalendarDate from

Parameters (1)

NameTypeDefault
P_KeyDate vdm_v_key_date

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName PGLFISYRKEY view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (4)

KeyFieldSource TableSource FieldDescription
FiscalYear
FiscalPeriod
IntervalEndDate CalendarDate
IntervalStartDate 
@AbapCatalog.sqlViewName: 'PGLFISYRKEY'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MIXED

@VDM.viewType: #CONSUMPTION
@VDM.private:true
define view P_GLFiscalYearByKeyDate
  with parameters
    P_KeyDate : vdm_v_key_date
  as select from I_CalendarDate
{
    cast(substring (:P_KeyDate,1,4) as gjahr) as FiscalYear,
    cast(concat('0',substring (:P_KeyDate,5,2)) as fins_fiscalperiod) as FiscalPeriod,
    CalendarDate as IntervalEndDate,
    dats_add_days(CalendarDate, -30, 'NULL') as IntervalStartDate
}
where CalendarDate = $session.system_date

Learn More