C_FinancialStatementVersion

DDL: C_FINANCIALSTATEMENTVERSION SQL: CFSVERSION Type: view CONSUMPTION

Financial statement version

C_FinancialStatementVersion is a Consumption CDS View that provides data about "Financial statement version" in SAP S/4HANA. It reads from 1 data source (I_FinancialStatementVersion) and exposes 7 fields with key field FinancialStatementVariant.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_FinancialStatementVersion I_FinancialStatementVersion from

Parameters (1)

NameTypeDefault
P_Language sylangu

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName CFSVERSION view
EndUserText.label Financial statement version view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY FinancialStatementVariant FinancialStatementVariant
FinancialStatementVariantName
LanguageName
ChartOfAccounts ChartOfAccounts
ChartOfAccountsName
GroupChartOfAccountIsUsed GroupChartOfAccountIsUsed
FunctionalAreaIsUsed FunctionalAreaIsUsed 
@AbapCatalog.sqlViewName: 'CFSVERSION'
@EndUserText.label: 'Financial statement version'
@VDM.viewType: #CONSUMPTION
//@AccessControl.authorizationCheck:  #NOT_ALLOWED

@AccessControl.authorizationCheck:  #CHECK
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED


define view C_FinancialStatementVersion
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_LANGUAGE
    P_Language : sylangu
  as select from I_FinancialStatementVersion
{
  key FinancialStatementVariant,
      //MaintenanceLanguage,

      _Text[1: Language = $parameters.P_Language].FinancialStatementVariantName,
      _Language._Text[1: Language = $parameters.P_Language].LanguageName,
      ChartOfAccounts,
      _ChartOfAccounts._Text[1: Language = $parameters.P_Language].ChartOfAccountsName,

      //LanguageISOCode,

      GroupChartOfAccountIsUsed,
      FunctionalAreaIsUsed

}
where
  ChartOfAccounts <> '' 
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHARTOFACCOUNTS",
"I_CHARTOFACCOUNTSTEXT",
"I_FINANCIALSTATEMENTVERSION",
"I_FINANCIALSTATEMENTVERSIONT",
"I_LANGUAGE",
"I_LANGUAGETEXT"
],
"ASSOCIATED":
[],
"BASE":
[],
"VERSION":0
}
}*/

Learn More