I_FINANCIALDATASOURCET

CDS View

Financial Data Source - Text

I_FINANCIALDATASOURCET is a CDS View in S/4HANA. Financial Data Source - Text. It contains 3 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 3 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_CnsldtnFinancialDataSourceT view_entity from COMPOSITE Consolidation Financial Data Source - Text
R_FinancialDataSourceTextTP view_entity from TRANSACTIONAL Financial Data Source - Text TP

Fields (3)

KeyField CDS FieldsUsed in Views
KEY FinancialDataSource FinancialDataSource 1
KEY Language Language 2
FinancialDataSourceName FinancialDataSourceName 1 
@EndUserText.label: 'Financial Data Source - Text'
@ObjectModel:{
    representativeKey: 'FinancialDataSource',
    dataCategory: #TEXT,
    usageType: {
    serviceQuality: #A,
    sizeCategory: #M,
    dataClass: #MASTER
    },
    modelingPattern: #LANGUAGE_DEPENDENT_TEXT,
    supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT,
                            #CDS_MODELING_DATA_SOURCE,
                            #CDS_MODELING_ASSOCIATION_TARGET,
                            #SQL_DATA_SOURCE,
                            #SEARCHABLE_ENTITY]
}
@VDM :{
viewType: #BASIC,
lifecycle.contract.type: #PUBLIC_LOCAL_API
}
@Search.searchable: true
@AccessControl.authorizationCheck:#MANDATORY
@Metadata.ignorePropagatedAnnotations: true

define view entity I_FinancialDataSourceT
  as select from ffs_d_datasrce_t
  association        to parent I_FinancialDataSource as _FinancialDataSource on $projection.FinancialDataSource = _FinancialDataSource.FinancialDataSource
  association [0..1] to I_Language                   as _Language            on $projection.Language = _Language.Language

{
      @Semantics.language: true
      @ObjectModel.foreignKey.association: '_Language'
      @ObjectModel.text.element: ['LanguageName']
  key langu                                                          as Language,
      @ObjectModel.foreignKey.association: '_FinancialDataSource'
      @ObjectModel.text.element: ['FinancialDataSourceName']
  key datasource_id                                                  as FinancialDataSource,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @Semantics.text: true
      cast( datasource_tt as ffs_vdm_datasource_tt preserving type ) as FinancialDataSourceName,
      _Language._Text[Language = $session.system_language].LanguageName,

      /* Associations */
      _FinancialDataSource,
      _Language
}

Learn More