Which tables does I_FiscalYearPeriodForVariant use?

I_FiscalYearPeriodForVariant reads from 1 data source(s): P_FiscalYearPeriod.

How many fields does I_FiscalYearPeriodForVariant have?

I_FiscalYearPeriodForVariant has 17 fields. Key fields: FiscalYearVariant, FiscalYearPeriod.

I_FiscalYearPeriodForVariant

DDL: I_FISCALYEARPERIODFORVARIANT SQL: IFIFYEARPERDFYV Type: view BASIC

Fiscal Year Period For Fiscal Year Variant

I_FiscalYearPeriodForVariant is a Basic CDS View (Dimension) that provides data about "Fiscal Year Period For Fiscal Year Variant" in SAP S/4HANA. It reads from 1 data source (P_FiscalYearPeriod) and exposes 17 fields with key fields FiscalYearVariant, FiscalYearPeriod. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
P_FiscalYearPeriod	P_FiscalYearPeriod	from

Associations (6)

Cardinality	Target	Alias	Condition
[0..1]	I_FiscalYearVariant	_FiscalYearVariant	`$projection.FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant`
[0..1]	I_CalendarDate	_FiscalPeriodStartDate	`$projection.FiscalPeriodStartDate = _FiscalPeriodStartDate.CalendarDate`
[0..1]	I_FiscalYearForVariant	_FiscalYear	`$projection.FiscalYearVariant = _FiscalYear.FiscalYearVariant and $projection.FiscalYear = _FiscalYear.FiscalYear`
[0..1]	I_FiscalPeriodForVariant	_FiscalPeriod	`$projection.FiscalYearVariant = _FiscalPeriod.FiscalYearVariant and $projection.FiscalYear = _FiscalPeriod.FiscalYear and $projection.FiscalPeriod = _FiscalPeriod.FiscalPeriod`
[0..*]	I_FiscalYearPeriodText	_Text	`$projection.FiscalYearVariant = _Text.FiscalYearVariant and $projection.FiscalYear = _Text.FiscalYear and $projection.FiscalPeriod = _Text.FiscalPeriod`
[0..1]	I_FiscalYearForVariant	_FiscalYearForVariant	`$projection.FiscalYearVariant = _FiscalYearForVariant.FiscalYearVariant and $projection.FiscalYear = _FiscalYearForVariant.FiscalYear`

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	IFIFYEARPERDFYV	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
EndUserText.label	Fiscal Year Period For Fiscal Year Variant	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#BASIC	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
Analytics.dataExtraction.enabled	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.representativeKey	FiscalYearPeriod	view
Analytics.dataCategory	#DIMENSION	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view

Fields (17)

Key	Field	Source Field
KEY	FiscalYearVariant	fiscal_year_variant
KEY	FiscalYearPeriod	fiscal_year_period
	FiscalYear	fiscal_year
	FiscalPeriod	fiscal_period
	FiscalPeriodStartDate	fiscal_period_start_date
	FiscalPeriodEndDate	fiscal_period_end_date
	IsSpecialPeriod	is_special_period
	FiscalYearStartDate	fiscal_year_start_date
	FiscalYearEndDate	fiscal_year_end_date
	NextFiscalPeriod	next_fiscal_period
	NextFiscalPeriodFiscalYear	next_fiscal_period_fiscal_year
	_FiscalYearVariant	_FiscalYearVariant
	_FiscalPeriodStartDate	_FiscalPeriodStartDate
	_FiscalYear	_FiscalYear
	_FiscalPeriod	_FiscalPeriod
	_Text	_Text
	_FiscalYearForVariant	_FiscalYearForVariant

@AbapCatalog.sqlViewName: 'IFIFYEARPERDFYV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Fiscal Year Period For Fiscal Year Variant'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@Analytics.dataExtraction.enabled:true

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'FiscalYearPeriod'
@Analytics: { dataCategory: #DIMENSION }

@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, #CDS_MODELING_ASSOCIATION_TARGET, #SQL_DATA_SOURCE, #CDS_MODELING_DATA_SOURCE, #EXTRACTION_DATA_SOURCE]

define view I_FiscalYearPeriodForVariant as select from P_FiscalYearPeriod 

association [0..1] to I_FiscalYearVariant      as _FiscalYearVariant     on  $projection.FiscalYearVariant     = _FiscalYearVariant.FiscalYearVariant
association [0..1] to I_CalendarDate           as _FiscalPeriodStartDate on  $projection.FiscalPeriodStartDate = _FiscalPeriodStartDate.CalendarDate
association [0..1] to I_FiscalYearForVariant   as _FiscalYear            on  $projection.FiscalYearVariant     = _FiscalYear.FiscalYearVariant
                                                                         and $projection.FiscalYear            = _FiscalYear.FiscalYear
association [0..1] to I_FiscalPeriodForVariant as _FiscalPeriod          on  $projection.FiscalYearVariant     = _FiscalPeriod.FiscalYearVariant
                                                                         and $projection.FiscalYear            = _FiscalPeriod.FiscalYear
                                                                         and $projection.FiscalPeriod          = _FiscalPeriod.FiscalPeriod
association [0..*] to I_FiscalYearPeriodText   as _Text                  on  $projection.FiscalYearVariant     = _Text.FiscalYearVariant
                                                                         and $projection.FiscalYear            = _Text.FiscalYear
                                                                         and $projection.FiscalPeriod          = _Text.FiscalPeriod

association [0..1] to I_FiscalYearForVariant   as _FiscalYearForVariant  on  $projection.FiscalYearVariant     = _FiscalYearForVariant.FiscalYearVariant
                                                                         and $projection.FiscalYear            = _FiscalYearForVariant.FiscalYear

{
 
@ObjectModel.foreignKey.association: '_FiscalYearVariant'     
//@Semantics.fiscal.yearVariant: true     

key fiscal_year_variant            as FiscalYearVariant,
key fiscal_year_period             as FiscalYearPeriod,

//@ObjectModel.foreignKey.association: '_FiscalYear'      

@ObjectModel.foreignKey.association: '_FiscalYearForVariant'      
    fiscal_year                    as FiscalYear,
@ObjectModel.text.association: '_Text'
//@ObjectModel.foreignKey.association: '_FiscalPeriod'   

    fiscal_period                  as FiscalPeriod,

//@ObjectModel.foreignKey.association: '_FiscalPeriodStartDate'      

    fiscal_period_start_date       as FiscalPeriodStartDate,
    fiscal_period_end_date         as FiscalPeriodEndDate,
    
    is_special_period              as IsSpecialPeriod,
    
    fiscal_year_start_date         as FiscalYearStartDate,
    fiscal_year_end_date           as FiscalYearEndDate,
       
    next_fiscal_period             as NextFiscalPeriod,
    next_fiscal_period_fiscal_year as NextFiscalPeriodFiscalYear,
    
    
    _FiscalYearVariant, 
    _FiscalPeriodStartDate,
    _FiscalYear,
    _FiscalPeriod,
    _Text, 
    _FiscalYearForVariant
           
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FISCALYEARPERIOD"
],
"ASSOCIATED":
[
"I_CALENDARDATE",
"I_FISCALPERIODFORVARIANT",
"I_FISCALYEARFORVARIANT",
"I_FISCALYEARPERIODTEXT",
"I_FISCALYEARVARIANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_FiscalYearPeriodForVariant view

P_FiscalYearPeriod view