I_FISCALYEARFORCOMPANYCODE

CDS View

Fiscal Year for Company Code

I_FISCALYEARFORCOMPANYCODE is a CDS View in S/4HANA. Fiscal Year for Company Code. It contains 4 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 4 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
C_ExcMonthUtilize view inner CONSUMPTION Montly Utilization : FY Parameterized
C_FiscalYearForCompanyCodeVH view from CONSUMPTION Fiscal Year For Company Code Value Help
I_SAFTHeader view from BASIC SAF-T Header
P_FIARCN_CUST_BALANCE01 view inner CONSUMPTION
P_FIARCN_CUST_BALANCE03 view inner CONSUMPTION
P_GLAcctLineItemEnrcd view inner COMPOSITE
P_GLFiscalYearStart view from COMPOSITE

Fields (4)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY FiscalYear FiscalYear 2
KEY FiscalYearEndDate EndDate,FiscalYearEndDate 2
KEY FiscalYearStartDate FiscalYearStartDate,StartDate 2 
@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                     

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COMPANYCODE",
"I_FISCALCALENDARDATE"
],
"ASSOCIATED":
[
"I_COMPANYCODE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More