I_FinancialStatementVersion

DDL: I_FINANCIALSTATEMENTVERSION SQL: IFSVERSION Type: view BASIC Package: FINS_FIS_FICO

Financial Statement Version

I_FinancialStatementVersion is a Basic CDS View (Dimension) that provides data about "Financial Statement Version" in SAP S/4HANA. It reads from 1 data source (t011) and exposes 16 fields with key field FinancialStatementVariant. It has 3 associations to related views. Part of development package FINS_FIS_FICO.

Data Sources (1)

SourceAliasJoin Type
t011 t011 from

Associations (3)

CardinalityTargetAliasCondition
[1..*] I_FinancialStatementVersionT _Text $projection.FinancialStatementVariant = _Text.FinancialStatementVariant
[0..1] I_ChartOfAccounts _ChartOfAccounts $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
[1..1] I_Language _Language $projection.MaintenanceLanguage = _Language.Language

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IFSVERSION view
EndUserText.label Financial Statement Version view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.representativeKey FinancialStatementVariant view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #ORGANIZATIONAL view
Metadata.allowExtensions true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementVariant versn
MaintenanceLanguage dspra
LanguageISOCode _Language LanguageISOCode
ChartOfAccounts ktopl
GroupChartOfAccountIsUsed xergs
FunctionalAreaIsUsed xfber
FinancialStatementNotesItem anhng
FinancialStatementOrphansItem zuord
FinStatementProfitAndLossItem erggv
FinStatementNetProfitItem ergpa
FinancialStatementNetLossItem ergak
FinStatementLiabilitiesItem pssva
FinancialStatementAssetsItem aktva
_Text _Text
_ChartOfAccounts _ChartOfAccounts
_Language _Language
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@VDM.viewType: #BASIC
@AbapCatalog.sqlViewName: 'IFSVERSION'
@EndUserText.label: 'Financial Statement Version'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@ObjectModel.representativeKey: 'FinancialStatementVariant'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
  serviceQuality: #A,
  sizeCategory: #S,
  dataClass: #ORGANIZATIONAL
}
@Metadata.allowExtensions:true
define view I_FinancialStatementVersion
  as select from t011
  association [1..*] to I_FinancialStatementVersionT as _Text            on $projection.FinancialStatementVariant = _Text.FinancialStatementVariant
  association [0..1] to I_ChartOfAccounts            as _ChartOfAccounts on $projection.ChartOfAccounts = _ChartOfAccounts.ChartOfAccounts
  association [1..1] to I_Language                   as _Language        on $projection.MaintenanceLanguage = _Language.Language
{
      @ObjectModel.text.association: '_Text'
  key versn as FinancialStatementVariant,
      @ObjectModel.foreignKey.association: '_Language'
      dspra as MaintenanceLanguage,
      _Language.LanguageISOCode,
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
      ktopl as ChartOfAccounts,
      xergs as GroupChartOfAccountIsUsed,
      xfber as FunctionalAreaIsUsed,
      
      anhng as FinancialStatementNotesItem,
      zuord as FinancialStatementOrphansItem,
      erggv as FinStatementProfitAndLossItem,
      ergpa as FinStatementNetProfitItem,
      ergak as FinancialStatementNetLossItem,
      pssva as FinStatementLiabilitiesItem,
      aktva as FinancialStatementAssetsItem,
              
      _Text,
      _ChartOfAccounts,
      _Language
}