I_FiscalYearForCompanyCode

DDL: I_FISCALYEARFORCOMPANYCODE SQL: IFIFYEARCC Type: view BASIC

Fiscal Year for Company Code

I_FiscalYearForCompanyCode is a Basic CDS View (Dimension) that provides data about "Fiscal Year for Company Code" in SAP S/4HANA. It reads from 2 data sources (I_CompanyCode, I_FiscalCalendarDate) and exposes 5 fields with key fields CompanyCode, FiscalYear. It has 1 association to related views.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_CompanyCode I_CompanyCode inner
I_FiscalCalendarDate I_FiscalCalendarDate from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CompanyCode _CompanyCode $projection.CompanyCode = _CompanyCode.CompanyCode

Annotations (16)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName IFIFYEARCC view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Fiscal Year for Company Code view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey FiscalYear view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode
KEY FiscalYear FiscalYear
FiscalYearStartDate FiscalYearStartDate
FiscalYearEndDate FiscalYearEndDate
_CompanyCode _CompanyCode 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@AbapCatalog.sqlViewName: 'IFIFYEARCC'
@AbapCatalog.compiler.compareFilter: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Fiscal Year for Company Code'
@VDM.viewType: #BASIC

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #CUSTOMIZING

@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'FiscalYear'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }

@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, 
                                     #CDS_MODELING_ASSOCIATION_TARGET, 
                                     #CDS_MODELING_DATA_SOURCE,
                                     #EXTRACTION_DATA_SOURCE,
                                     #SQL_DATA_SOURCE]
                                     
define view I_FiscalYearForCompanyCode as select from I_FiscalCalendarDate inner join I_CompanyCode
                                                 on   I_FiscalCalendarDate.FiscalYearVariant = I_CompanyCode.FiscalYearVariant
                                                 
association [0..1] to I_CompanyCode  as _CompanyCode  on $projection.CompanyCode  = _CompanyCode.CompanyCode

{
  
      //--[ GENERATED:012:29JlHNUf7jY4ip0dSlCN8W

      @Consumption.valueHelpDefinition: [ 
        { entity:  { name:    'I_CompanyCodeStdVH',
                     element: 'CompanyCode' }
        }]
      // ]--GENERATED

@ObjectModel.foreignKey.association: '_CompanyCode'      
key cast( I_CompanyCode.CompanyCode as fis_bukrs preserving type ) as CompanyCode,

key FiscalYear,

    FiscalYearStartDate,
    FiscalYearEndDate,

//    Next functionality deleted to get BASIC view with 3 tables   

//    cast( NextFiscalYear as fins_next_fiscalyear )               as NextFiscalYear,

//    cast( NextFiscalYearStartDate as fins_next_fyear_startdate ) as NextFiscalYearStartDate,

//    cast( NextFiscalYearEndDate as fins_next_fyear_enddate )     as NextFiscalYearEndDate,


    _CompanyCode        

} group by I_CompanyCode.CompanyCode, FiscalYear, FiscalYearStartDate, FiscalYearEndDate

Learn More