I_FISCALDATEFUNCTIONVALUE

CDS View

Fiscal Date Function values

I_FISCALDATEFUNCTIONVALUE is a CDS View in S/4HANA. Fiscal Date Function values. It contains 6 fields. 23 CDS views read from this table.

Used by 23 CDS view(s) 6 fields

CDS Views using this table (23)

ViewTypeJoinVDMDescription
DATEFUNC_FISCAL_SIMULATE_QUERY view from Simulates the date range values
F_FsclDteFuncRngeVal view from DERIVATION_FUNCTION Fiscal Range Date Functions
F_FsclDteFuncSglVal view from DERIVATION_FUNCTION Fiscal Single Date Functions
F_FsclPerdDteFuncSglVal view from DERIVATION_FUNCTION Fiscal Period Single Date Functions
F_FsclQtrDteFuncSglVal view from DERIVATION_FUNCTION Fiscal Quarter Single Date Functions
F_FsclWkDteFuncSglVal view from DERIVATION_FUNCTION Fiscal Week Single Date Functions
F_FsclYrDteFuncRngeVal view from DERIVATION_FUNCTION Fiscal Year Range Date Functions
F_FsclYrDteFuncSglVal view from DERIVATION_FUNCTION Fiscal Year Single Date Functions
F_FsclYrPerdDteFuncRngeVal view from DERIVATION_FUNCTION Fiscal Year Period Range Date Functions
F_FsclYrPerdDteFuncSglVal view from DERIVATION_FUNCTION Fiscal Year Period Single Date Functions
F_FsclYrQtrDteFuncRngeVal view from DERIVATION_FUNCTION Fiscal Year Quarter Range Date Functions
F_FsclYrQtrDteFuncSglVal view from DERIVATION_FUNCTION Fiscal Year Quarter Single Date Function
F_FsclYrWkDteFuncRngeVal view from DERIVATION_FUNCTION Fiscal Year Week Range Date Functions
F_FsclYrWkDteFuncSglVal view from DERIVATION_FUNCTION Fiscal Year Week Single Date Functions
I_FiscalCalDateFunction view from COMPOSITE Dates for Fiscal Calendar Date Functions
I_FsclDateFuncRangeFiscalValue view_entity from COMPOSITE Fiscal Time Ranges for Range of Fiscal Date Function
I_FsclDateFuncRangeForLedger view_entity from COMPOSITE Fiscal Date Function for Ledger
P_ActualBalFlowDateFunc2 view_entity inner COMPOSITE P_ActualBalFlowDateFunc2
P_FiscalCalendarDateDteFnction view_entity from COMPOSITE Fiscal Calendar Date with Date Function
P_FiscalDateFunctionValueFY view_entity from COMPOSITE P_FiscalDateFunctionValueFY
P_LastDayOfFsclDteFunction view inner BASIC Last day of fiscal date function
P_LastDayofFsclDteFunctionV2 view_entity from BASIC Last day of fiscal date function V2
P_PlanBalFlowDateFunc2 view_entity inner COMPOSITE P_PlanBalFlowDateFunc2

Fields (6)

KeyField CDS FieldsUsed in Views
KEY DateFunction DateFunction 4
KEY DateFunctionValidityDate DateFunctionValidityDate 2
KEY FiscalYearVariant FiscalYearVariant 3
_DateFunction _DateFunction 2
DateFunctionEndDate DateFunctionEndDate 2
DateFunctionStartDate DateFunctionStartDate 2 
@AbapCatalog.sqlViewName: 'IFSCLDATEFUNCVAL'
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Fiscal Date Function values'
@ObjectModel.representativeKey: 'DateFunction'
@ObjectModel.usageType.dataClass: #META
@ObjectModel.usageType.serviceQuality:  #A
@ObjectModel.usageType.sizeCategory:  #S
@ClientHandling.algorithm: #SESSION_VARIABLE
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]
@VDM.viewType: #BASIC
define view I_FiscalDateFunctionValue
  as select from fiscaldatefn_val

  association [1..1] to I_FiscalDateFunction as _DateFunction      on _DateFunction.DateFunction = $projection.DateFunction
  association [1..1] to I_FiscalYearVariant  as _FiscalYearVariant on _FiscalYearVariant.FiscalYearVariant = $projection.FiscalYearVariant
  association [1..1] to I_CalendarDate       as _ValidityDate      on _ValidityDate.CalendarDate = $projection.DateFunctionValidityDate

{
//      @ObjectModel.foreignKey.association: '_Datefunction'

  key datefunction                  as DateFunction,
      @ObjectModel.foreignKey.association: '_FiscalYearVariant'
  key datefunctionfiscalyearvariant as FiscalYearVariant,
      @Semantics.businessDate.at: true
      @ObjectModel.foreignKey.association: '_ValidityDate'
  key valid_for_date                as DateFunctionValidityDate,

      datefunctionstartdate         as DateFunctionStartDate,
      datefunctionenddate           as DateFunctionEndDate,
      
      fiscalweekstart               as FiscalWeekStart,
      fiscalyearweekstart           as FiscalYearWeekStart,
      fiscalweekend                 as FiscalWeekEnd,
      fiscalyearweekend             as FiscalYearWeekEnd,
      fiscalperiodstart             as FiscalPeriodStart,
      fiscalyearperiodstart         as FiscalYearPeriodStart,
      fiscalperiodend               as FiscalPeriodEnd,
      fiscalyearperiodend           as FiscalYearPeriodEnd,
      fiscalperiodsingle            as FiscalPeriodSingle,
      fiscalyearperiodsingle        as FiscalYearPeriodSingle,
      fiscalquarterstart            as FiscalQuarterStart,
      fiscalyearquarterstart        as FiscalYearQuarterStart,
      fiscalquarterend              as FiscalQuarterEnd,
      fiscalyearquarterend          as FiscalYearQuarterEnd,
      fiscalyearstart               as FiscalYearStart,
      fiscalyearend                 as FiscalYearEnd,
                    

      _DateFunction,
      _FiscalYearVariant,
      _ValidityDate
}

Learn More