I_CNSLDTNCHARTOFACCOUNTST

CDS View

Consolidation Chart of Accounts - Text

I_CNSLDTNCHARTOFACCOUNTST is a CDS View in S/4HANA. Consolidation Chart of Accounts - Text. It contains 2 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 2 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
A_CnsldtnChartOfAccountsT view from BASIC Consolidation Chart of Accounts Text
A_CnsldtnChartOfAccountsText_2 view_entity from BASIC Consolidation Chart of Accounts - Text

Fields (2)

KeyField CDS FieldsUsed in Views
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts 1
KEY Language Language 1 
@AbapCatalog:{
  sqlViewName: 'ICCCHOFACCT',
  compiler.compareFilter: true,
  preserveKey: true
  }
@Analytics: {
  dataExtraction.enabled: true
  }
@AccessControl.authorizationCheck: #CHECK
@Metadata.ignorePropagatedAnnotations:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #C,
    sizeCategory: #S},
  representativeKey: 'ConsolidationChartOfAccounts',
  dataCategory: #TEXT,
  modelingPattern: #LANGUAGE_DEPENDENT_TEXT,
  supportedCapabilities: [#CDS_MODELING_DATA_SOURCE,
                          #CDS_MODELING_ASSOCIATION_TARGET,
                          #SQL_DATA_SOURCE,
                          #EXTRACTION_DATA_SOURCE,
                          #LANGUAGE_DEPENDENT_TEXT ]
}
@Search.searchable: true
@VDM:{
  viewType: #BASIC,
  lifecycle.contract.type: #PUBLIC_LOCAL_API
  }
@EndUserText.label: 'Consolidation Chart of Accounts - Text'

define view I_CnsldtnChartOfAccountsT
  as select from tf121

  association [0..1] to I_Language               as _Language        on $projection.Language = _Language.Language

  association [0..1] to I_CnsldtnChartOfAccounts as _ChartOfAccounts on $projection.ConsolidationChartOfAccounts = _ChartOfAccounts.ConsolidationChartOfAccounts
{
      @ObjectModel.foreignKey.association: '_ChartOfAccounts'
  key cast(itclg as fincs_conschartofaccounts preserving type ) as ConsolidationChartOfAccounts,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key langu                                                     as Language,

      @Semantics.text
      @Search:{
        defaultSearchElement: true,
        ranking: #LOW,
        fuzzinessThreshold: 0.8
        }
      cast(txt as fincs_description_text_30 preserving type )   as ConsolidationChartOfAcctsText,


      _Language,
      _ChartOfAccounts
};
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"TF121"
],
"ASSOCIATED":
[
"I_CNSLDTNCHARTOFACCOUNTS",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More