I_FiscalYearForCompanyCode

DDL: I_FISCALYEARFORCOMPANYCODE Type: view_entity BASIC Package: FINS_PERIOD_VDM

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. Part of development package FINS_PERIOD_VDM.

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 (14)

NameValueLevelField
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API 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
Analytics.technicalName IFIFYEARCC view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ObjectModel.sapObjectNodeType.name FiscalYear view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode
KEY FiscalYear I_FiscalCalendarDate FiscalYear
FiscalYearStartDate I_FiscalCalendarDate FiscalYearStartDate
FiscalYearEndDate I_FiscalCalendarDate FiscalYearEndDate
_CompanyCode _CompanyCode 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@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 }
@Analytics.technicalName: 'IFIFYEARCC'

@ObjectModel.modelingPattern: #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities: [#ANALYTICAL_DIMENSION, 
                                     #CDS_MODELING_ASSOCIATION_TARGET, 
                                     #CDS_MODELING_DATA_SOURCE,
                                     #EXTRACTION_DATA_SOURCE,
                                     #SQL_DATA_SOURCE]
                                     
@ObjectModel.sapObjectNodeType.name: 'FiscalYear'

define view entity I_FiscalYearForCompanyCode as select from I_FiscalCalendarDate as I_FiscalCalendarDate inner join I_CompanyCode as 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 I_FiscalCalendarDate.FiscalYear,

    I_FiscalCalendarDate.FiscalYearStartDate,
    I_FiscalCalendarDate.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, I_FiscalCalendarDate.FiscalYear, I_FiscalCalendarDate.FiscalYearStartDate, I_FiscalCalendarDate.FiscalYearEndDate

Learn More