Which tables does I_BalSheetExpsrKeyFigure use?

I_BalSheetExpsrKeyFigure reads from 1 data source(s): fxm_kf_def.

How many fields does I_BalSheetExpsrKeyFigure have?

I_BalSheetExpsrKeyFigure has 7 fields. Key fields: BalSheetExpsrKeyFigure.

I_BalSheetExpsrKeyFigure

DDL: I_BALSHEETEXPSRKEYFIGURE SQL: IBSEKF Type: view BASIC

Balance Sheet Exposure Key Figure

I_BalSheetExpsrKeyFigure is a Basic CDS View (Dimension) that provides data about "Balance Sheet Exposure Key Figure" in SAP S/4HANA. It reads from 1 data source (fxm_kf_def) and exposes 7 fields with key field BalSheetExpsrKeyFigure. It has 3 associations to related views.

Data Sources (1)

Source	Alias	Join Type
fxm_kf_def	fxm_kf_def	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..*]	I_BalExpsrKeyFigHierNode	_BalExpsrKeyFigHierNode	`$projection.BalSheetExpsrKeyFigure = _BalExpsrKeyFigHierNode.BalSheetExpsrKeyFigure`
[1..1]	I_BalShtExpsrKeyFigDataSource	_KeyFigureDataSource	`$projection.BalShtExpsrKeyFigureDataSource = _KeyFigureDataSource.BalShtExpsrKeyFigureDataSource`
[1..1]	I_BalSheetExpsrKeyFigureGroup	_KeyFigureGroup	`$projection.BalShtExpsrKeyFigGrp = _KeyFigureGroup.BalShtExpsrKeyFigGrp`

Annotations (13)

Name	Value	Level
AbapCatalog.sqlViewName	IBSEKF	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
EndUserText.label	Balance Sheet Exposure Key Figure	view
VDM.viewType	#BASIC	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
ObjectModel.representativeKey	BalSheetExpsrKeyFigure	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#CUSTOMIZING	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
Metadata.ignorePropagatedAnnotations	true	view
Search.searchable	true	view

Fields (7)

Key	Field	Source Table	Source Field	Description
KEY	BalSheetExpsrKeyFigure		kf
	BalShtExpsrKeyFigGrp		kf_group
	BalSheetExpsrKeyFigName		kf_text
	BalShtExpsrKeyFigureDataSource		datasource
	BalShtExpsrKeyFigDataSrceName	_KeyFigureDataSource	BalShtExpsrKeyFigDataSrceName	Data Source
	_BalExpsrKeyFigHierNode		_BalExpsrKeyFigHierNode
	_KeyFigureGroup		_KeyFigureGroup

@AbapCatalog.sqlViewName: 'IBSEKF'
@Analytics: { dataCategory: #DIMENSION, dataExtraction.enabled: true }
@EndUserText.label: 'Balance Sheet Exposure Key Figure'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel: { representativeKey: 'BalSheetExpsrKeyFigure',
                usageType.serviceQuality: #A,
                usageType.sizeCategory: #S,
                usageType.dataClass: #CUSTOMIZING }
@ClientHandling.algorithm: #SESSION_VARIABLE
--@AccessControl.privilegedAssociations:  [ '_BalExpsrKeyFigHierNode' ]
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true

/*+[hideWarning] { "IDS" : [ "CALCULATED_FIELD_CHECK" ]  } */
define view I_BalSheetExpsrKeyFigure
  as select from fxm_kf_def
  association [0..*] to I_BalExpsrKeyFigHierNode      as _BalExpsrKeyFigHierNode on $projection.BalSheetExpsrKeyFigure = _BalExpsrKeyFigHierNode.BalSheetExpsrKeyFigure
  //   association [0..*] to ZTF_I_KeyFigureText   as _Text                        on  $projection.BalSheetExpsrKeyFigure = _Text.BalSheetExpsrKeyFigure

  association [1..1] to I_BalShtExpsrKeyFigDataSource as _KeyFigureDataSource    on $projection.BalShtExpsrKeyFigureDataSource = _KeyFigureDataSource.BalShtExpsrKeyFigureDataSource

  association [1..1] to I_BalSheetExpsrKeyFigureGroup as _KeyFigureGroup         on $projection.BalShtExpsrKeyFigGrp = _KeyFigureGroup.BalShtExpsrKeyFigGrp
{
      @ObjectModel.text.element: 'BalSheetExpsrKeyFigName'
      @ObjectModel.hierarchy.association: '_BalExpsrKeyFigHierNode'
      @Search.defaultSearchElement: true
      @Search.ranking: #HIGH
      @Search.fuzzinessThreshold: 0.8
  key kf                                                 as BalSheetExpsrKeyFigure,
      @Search.defaultSearchElement: true
      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.7
      kf_group                                           as BalShtExpsrKeyFigGrp,
      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.7
      kf_text                                            as BalSheetExpsrKeyFigName,

      @UI.hidden: true
      @Search.defaultSearchElement: true
      @Search.ranking: #LOW
      @Search.fuzzinessThreshold: 0.7
      datasource                                         as BalShtExpsrKeyFigureDataSource,

      @Semantics.text: true
      @EndUserText.label: 'Data Source'
      @EndUserText.quickInfo: 'Key Figure Data Source'
      _KeyFigureDataSource.BalShtExpsrKeyFigDataSrceName as BalShtExpsrKeyFigDataSrceName,
      /* Assocations */
      _BalExpsrKeyFigHierNode,

      _KeyFigureGroup

      //      @Semantics.text: true

      //      _Text[1:Language = $session.system_language].ExposureKeyFigureName

      //      @Semantics.text: true

      //      _Text[1:Language = $session.system_language].BalSheetExpsrKeyFigName

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_BALSHTEXPSRKEYFIGDATASOURCE",
"FXM_KF_DEF"
],
"ASSOCIATED":
[
"I_BALEXPSRKEYFIGHIERNODE",
"I_BALSHEETEXPSRKEYFIGUREGROUP",
"I_BALSHTEXPSRKEYFIGDATASOURCE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_BalSheetExpsrKeyFigure view

fxm_kf_def