I_FiscalDateFunction

DDL: I_FISCALDATEFUNCTION SQL: IFIDATEFNC Type: view BASIC Package: FINS_FI_DATE

Fiscal Date Function

I_FiscalDateFunction is a Basic CDS View (Dimension) that provides data about "Fiscal Date Function" in SAP S/4HANA. It reads from 1 data source (I_Datefunction) and exposes 18 fields with key field DateFunction. It has 1 association to related views. Part of development package FINS_FI_DATE.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_Datefunction I_Datefunction from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_FiscalDateFunctionText _DateFunctionText $projection.DateFunction = _DateFunctionText.DateFunction

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IFIDATEFNC view
AbapCatalog.compiler.compareFilter true view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Fiscal Date Function view
ObjectModel.representativeKey DateFunction view
ObjectModel.usageType.dataClass #META view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
VDM.viewType #BASIC view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY DateFunction DateFunction
DateFunctionType DateFunctionType
DateFunctionGranularity DateFunctionGranularity
DateFunctionStartPoint DateFunctionStartPoint
DateFunctionStartOffsetValue DateFunctionStartOffsetValue
DateFuncStartRelativeOffset DateFuncStartRelativeOffset
DateFunctionStartOffsetUnit DateFunctionStartOffsetUnit
DateFunctionStartRelOffsetUnit DateFunctionStartRelOffsetUnit
DateFunctionStartYearOffset DateFunctionStartYearOffset
DateFunctionStartFixedDate DateFunctionStartFixedDate
DateFunctionEndPoint DateFunctionEndPoint
DateFunctionEndOffsetValue DateFunctionEndOffsetValue
DateFunctionEndRelativeOffset DateFunctionEndRelativeOffset
DateFunctionEndOffsetUnit DateFunctionEndOffsetUnit
DateFunctionEndRelOffsetUnit DateFunctionEndRelOffsetUnit
DateFunctionEndYearOffset DateFunctionEndYearOffset
DateFunctionEndFixedDate DateFunctionEndFixedDate
_DateFunctionText _DateFunctionText 
@AbapCatalog.sqlViewName: 'IFIDATEFNC'
@AbapCatalog.compiler.compareFilter: true
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Fiscal Date Function'
@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_FiscalDateFunction as select from I_Datefunction 

  association [0..*] to I_FiscalDateFunctionText as _DateFunctionText on $projection.DateFunction = _DateFunctionText.DateFunction

{
  @ObjectModel.text.association:'_DateFunctionText'
  key DateFunction,
//  ABAPLanguageVersion, 

  DateFunctionType, 
  DateFunctionGranularity,
//  DateFunctionCalendarType,

  DateFunctionStartPoint, 
  DateFunctionStartOffsetValue, 
  DateFuncStartRelativeOffset, 
  DateFunctionStartOffsetUnit, 
  DateFunctionStartRelOffsetUnit,
  DateFunctionStartYearOffset, 
  DateFunctionStartFixedDate, 
  DateFunctionEndPoint, 
  DateFunctionEndOffsetValue, 
  DateFunctionEndRelativeOffset, 
  DateFunctionEndOffsetUnit, 
  DateFunctionEndRelOffsetUnit,
  DateFunctionEndYearOffset, 
  DateFunctionEndFixedDate,
  
  _DateFunctionText
} where DateFunctionCalendarType = '02';

Learn More