I_FISCALPERIODFORVARIANT

CDS View

Fiscal Period For Fiscal Year Variant

I_FISCALPERIODFORVARIANT is a CDS View in S/4HANA. Fiscal Period For Fiscal Year Variant. It contains 6 fields. 10 CDS views read from this table.

Used by 10 CDS view(s) 6 fields

CDS Views using this table (10)

ViewTypeJoinVDMDescription
FAC_DART_Z3_FISCALVARIANT view from Fiscal period for variant
I_ConsolidationYearCalculator view from COMPOSITE Consolidation Year Calculator
I_FsclYearQtrByFsclPeriod view union_all COMPOSITE Fiscal Year Quarter by Fiscal Period
P_AnalyticalAgingIncrement view inner COMPOSITE
P_CCLdgrShiftedPeriods view inner BASIC
P_CCLdgrShiftedPrevYearPer view inner BASIC
P_CCLdngLdgrPerDates view inner BASIC
P_CCLdngLdgrPeriodDates view inner BASIC
P_FiscalYearLastFiscalPeriod view from BASIC
P_Matrix_FiscalPeriodForVar view from COMPOSITE

Fields (6)

KeyField CDS FieldsUsed in Views
KEY FiscalPeriod CurrentFiscalPeriod,FiscalPeriod,PrevFiscalYearLastFiscalPeriod,PreviousFiscalPeriod 4
KEY FiscalYear CurrentFiscalYear,FiscalYear,PreviousFiscalPeriodFiscalYear,PreviousFiscalYear 3
KEY FiscalYearVariant FiscalYearVariant 1
FiscalPeriodEndDate CurrentFiscalPeriodEndDate,FiscalPeriodEndDate,PrevFsclYrLastFsclPerdEndDate,PreviousFiscalPeriodEndDate 5
FiscalPeriodStartDate CurrentFiscalPeriodStartDate,FiscalPeriodStartDate,PrevFsclYrLastFsclPerdStrtDate,PreviousFiscalPeriodStartDate 5
FiscalYearPeriod FiscalYearPeriod,PrevFsclYearLastFsclYearPeriod,PreviousFiscalYearPeriod 2 
@AbapCatalog.sqlViewName: 'IFIFFSCLPERDFYV'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@EndUserText.label: 'Fiscal Period For Fiscal Year Variant'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true

@VDM.viewType: #BASIC
@ObjectModel.representativeKey: 'FiscalPeriod'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #CUSTOMIZING
@Analytics.dataExtraction.enabled:true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@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_FiscalPeriodForVariant 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_FiscalYear           as _FiscalYear            on  $projection.FiscalYearVariant     = _FiscalYear.FiscalYearVariant
                                                                       and $projection.FiscalYear            = _FiscalYear.FiscalYear
association [0..*] to I_FiscalYearPeriodText as _Text                  on  $projection.FiscalYearVariant     = _Text.FiscalYearVariant
                                                                       and $projection.FiscalYear            = _Text.FiscalYear
                                                                       and $projection.FiscalPeriod          = _Text.FiscalPeriod
{
 
@ObjectModel.foreignKey.association: '_FiscalYearVariant'  
//@Semantics.fiscal.yearVariant: true    

key fiscal_year_variant            as FiscalYearVariant,
@ObjectModel.foreignKey.association: '_FiscalYear'      
key fiscal_year                    as FiscalYear,
@ObjectModel.text.association: '_Text'
key 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,
       
    fiscal_year_period             as FiscalYearPeriod,

    next_fiscal_period             as NextFiscalPeriod,
    next_fiscal_period_fiscal_year as NextFiscalPeriodFiscalYear,
    
    _FiscalYearVariant, 
    _FiscalPeriodStartDate,
    _FiscalYear,
    _Text 
           
} 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_FISCALYEARPERIOD"
],
"ASSOCIATED":
[
"I_CALENDARDATE",
"I_FISCALYEAR",
"I_FISCALYEARPERIODTEXT",
"I_FISCALYEARVARIANT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More