P_FiscalDateFunctionValueFY

DDL: P_FISCALDATEFUNCTIONVALUEFY Type: view_entity COMPOSITE Package: FINS_PERIOD_VDM

P_FiscalDateFunctionValueFY

P_FiscalDateFunctionValueFY is a Composite CDS View that provides data about "P_FiscalDateFunctionValueFY" in SAP S/4HANA. It reads from 3 data sources (I_FiscalCalendarDate, I_FiscalDateFunctionValue, I_FiscalCalendarDate) and exposes 10 fields with key fields DateFunction, FiscalYearVariant, DateFunctionValidityDate. Part of development package FINS_PERIOD_VDM.

3 data source(s) 10 fields

Data Sources (3)

SourceAliasJoin Type
I_FiscalCalendarDate EndYear inner
I_FiscalDateFunctionValue I_FiscalDateFunctionValue from
I_FiscalCalendarDate StartYear inner

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY DateFunction I_FiscalDateFunctionValue DateFunction
KEY FiscalYearVariant I_FiscalDateFunctionValue FiscalYearVariant
KEY DateFunctionValidityDate I_FiscalDateFunctionValue DateFunctionValidityDate
DateFunctionStartDate I_FiscalDateFunctionValue DateFunctionStartDate
DateFunctionEndDate I_FiscalDateFunctionValue DateFunctionEndDate
FiscalYear I_FiscalCalendarDate FiscalYear
FiscalYearStartDate I_FiscalCalendarDate FiscalYearStartDate
StartFiscalYear I_FiscalCalendarDate FiscalYear
EndFiscalYear I_FiscalCalendarDate FiscalYear
_DateFunction I_FiscalDateFunctionValue _DateFunction 
@AccessControl.authorizationCheck: #CHECK
//@VDM.viewType: #BASIC

@VDM.viewType: #COMPOSITE
@VDM.private:true
define view entity P_FiscalDateFunctionValueFY
  as select from I_FiscalDateFunctionValue as I_FiscalDateFunctionValue
//    inner join            I_FiscalYear as StartYear on  StartYear.FiscalYearVariant   =  I_FiscalDateFunctionValue.FiscalYearVariant

//                                                                     and StartYear.FiscalYearStartDate <= I_FiscalDateFunctionValue.DateFunctionStartDate

//                                                                     and StartYear.FiscalYearEndDate   >= I_FiscalDateFunctionValue.DateFunctionStartDate

//    inner join            I_FiscalYear as EndYear   on  EndYear.FiscalYearVariant   =  I_FiscalDateFunctionValue.FiscalYearVariant

//                                                                     and EndYear.FiscalYearStartDate <= I_FiscalDateFunctionValue.DateFunctionEndDate

//                                                                     and EndYear.FiscalYearEndDate   >= I_FiscalDateFunctionValue.DateFunctionEndDate


inner join I_FiscalCalendarDate as StartYear on I_FiscalDateFunctionValue.FiscalYearVariant = StartYear.FiscalYearVariant
                                            and I_FiscalDateFunctionValue.DateFunctionStartDate = StartYear.CalendarDate
inner join I_FiscalCalendarDate as EndYear   on I_FiscalDateFunctionValue.FiscalYearVariant = EndYear.FiscalYearVariant
                                            and I_FiscalDateFunctionValue.DateFunctionEndDate = EndYear.CalendarDate                                                                     
                                                                     
{
  key  I_FiscalDateFunctionValue.DateFunction,
  key  I_FiscalDateFunctionValue.FiscalYearVariant,
  key  I_FiscalDateFunctionValue.DateFunctionValidityDate,

       I_FiscalDateFunctionValue.DateFunctionStartDate,
       I_FiscalDateFunctionValue.DateFunctionEndDate,

       StartYear.FiscalYear          as FiscalYear,
       StartYear.FiscalYearStartDate as FiscalYearStartDate,

       StartYear.FiscalYear          as StartFiscalYear,
       EndYear.FiscalYear            as EndFiscalYear,

       I_FiscalDateFunctionValue._DateFunction
}

Learn More