I_CNSLDTNFSITEMTEXT_2

CDS View

Cnsldtn Fincancial Statement Item - Text

I_CNSLDTNFSITEMTEXT_2 is a CDS View in S/4HANA. Cnsldtn Fincancial Statement Item - Text. It contains 8 fields. 5 CDS views read from this table.

Used by 5 CDS view(s) 8 fields

CDS Views using this table (5)

ViewTypeJoinVDMDescription
A_CnsldtnFSItemT view from BASIC Financial Statement Item - Text
A_CnsldtnFSItemT_2 view from COMPOSITE Financial Statement Item V2 - Text
I_CnsldtnFinStmntItemTextTP_2 view_entity from TRANSACTIONAL Financial Statement Item Text
I_CnsldtnRptgItemText_2 view from BASIC Consolidation Reporting Item - Text
R_CnsldtnFSItemTextTP view_entity from TRANSACTIONAL Cnsldtn FS Item - Text TP

Fields (8)

KeyField CDS FieldsUsed in Views
KEY CnsldtnFinancialStatementItem CnsldtnFinancialStatementItem,FinancialStatementItem 2
KEY ConsolidationChartOfAccounts ConsolidationChartOfAccounts 4
KEY Language Language 3
_CnsldtnChartOfAccounts _CnsldtnChartOfAccounts 1
_Language _Language 1
CnsldtnFSItemLongText CnsldtnFSItemLongText,ConsolidationRptgItemLongText,FinancialStatementItemLongText 3
CnsldtnFSItemMediumText CnsldtnFSItemMediumText,ConsolidationRptgItemMdmText,FinancialStatementItemMdmText 3
CnsldtnFSItemText CnsldtnFSItemText,ConsolidationReportingItemText,FinancialStatementItemText 3 
@AbapCatalog:{
  sqlViewName: 'ICSFSITEMT2',
  compiler.compareFilter: true
  }
@Analytics: {
  dataExtraction.enabled: true
  }
@AccessControl: {
  authorizationCheck: #MANDATORY
  }
@Metadata:{
  ignorePropagatedAnnotations: true
  }
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
  usageType: {
    dataClass: #CUSTOMIZING,
    serviceQuality: #B,
    sizeCategory: #L },
  representativeKey: 'CnsldtnFinancialStatementItem',
  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: 'Cnsldtn Fincancial Statement Item - Text'

define view I_CnsldtnFSItemText_2
  as select from fincs_fsitemt

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

  association [1..1] to I_CnsldtnChartOfAccounts as _CnsldtnChartOfAccounts on  $projection.ConsolidationChartOfAccounts = _CnsldtnChartOfAccounts.ConsolidationChartOfAccounts

  association [1..1] to I_CnsldtnFSItem_2        as _FSItem                 on  $projection.ConsolidationChartOfAccounts  = _FSItem.ConsolidationChartOfAccounts
                                                                            and $projection.CnsldtnFinancialStatementItem = _FSItem.CnsldtnFinancialStatementItem

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

      @ObjectModel.foreignKey.association: '_CnsldtnChartOfAccounts'
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_CnsldtnChartOfAccountsVH',
                                                     element: 'ConsolidationChartOfAccounts' } }]
  key cast( itclg as fincs_conschartofaccounts preserving type ) as ConsolidationChartOfAccounts,

      @ObjectModel.foreignKey.association: '_FSItem'
      @Consumption.valueHelpDefinition: [{ entity: { name: 'I_CnsldtnFSItemVH',
                                                     element: 'CnsldtnFinancialStatementItem' },
                    additionalBinding: [{ localElement: 'ConsolidationChartOfAccounts', element: 'ConsolidationChartOfAccounts', usage: #FILTER_AND_RESULT }]
      }]
  key cast ( item as fincs_consolidationfsitem preserving type ) as CnsldtnFinancialStatementItem,

      @Semantics.text: true
      @Search:{ defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      cast ( txtsh as fincs_short_text_15 preserving type )      as CnsldtnFSItemText,

      @Semantics.text
      cast ( txtmi as fincs_medium_text_50 preserving type )     as CnsldtnFSItemMediumText,

      // intentionally no @Semantics.text because char250 too long for analytics

      cast ( txtlg as fincs_long_text_250 preserving type )      as CnsldtnFSItemLongText,


      _Language, // required for value help retrieval

      _CnsldtnChartOfAccounts,
      _FSItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINCS_FSITEMT"
],
"ASSOCIATED":
[
"I_CNSLDTNCHARTOFACCOUNTS",
"I_CNSLDTNFSITEM_2",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More