Which tables does I_FSItemMappingItem use?

I_FSItemMappingItem reads from 1 data source(s): fincs_fsimapitm.

I_FSItemMappingItem

Q: How many fields does I_FSItemMappingItem have?

I_FSItemMappingItem has 12 fields. Key fields: ConsolidationChartOfAccounts, ChartOfAccounts, FSItemMappingID, FSItemMappingRevision, GLAccount.

DDL: I_FSITEMMAPPINGITEM SQL: IFSITEMMAPITM Type: view BASIC

Financial Statement Item Mapping Item

I_FSItemMappingItem is a Basic CDS View that provides data about "Financial Statement Item Mapping Item" in SAP S/4HANA. It reads from 1 data source (fincs_fsimapitm) and exposes 12 fields with key fields ConsolidationChartOfAccounts, ChartOfAccounts, FSItemMappingID, FSItemMappingRevision, GLAccount. It has 6 associations to related views.

Data Sources (1)

Source	Alias	Join Type
fincs_fsimapitm	fincs_fsimapitm	from

Associations (6)

Cardinality	Target	Alias	Condition
[1..1]	I_CnsldtnChartOfAccounts	_ConsChartOfAccounts	`$projection.ConsolidationChartOfAccounts = _ConsChartOfAccounts.ConsolidationChartOfAccounts`
[1..1]	I_ChartOfAccounts	_GLChartOfAccounts	`$projection.ChartOfAccounts = _GLChartOfAccounts.ChartOfAccounts`
[1..1]	I_FSItemMapping	_Mapping	`$projection.FSItemMappingID = _Mapping.FSItemMappingID`
[1..1]	I_FSItemMappingRevision	_MappingRevision	`$projection.ConsolidationChartOfAccounts = _MappingRevision.ConsolidationChartOfAccounts and $projection.FSItemMappingID = _MappingRevision.FSItemMappingID and $projection.ChartOfAccounts = _MappingRevision.ChartOfAccounts and $projection.FSItemMappingRevision = _MappingRevision.FSItemMappingRevision`
[1..1]	I_GLAccountInChartOfAccounts	_GLAccountInChartOfAccounts	`$projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts and $projection.GLAccount = _GLAccountInChartOfAccounts.GLAccount`
[1..1]	I_CnsldtnFinStmntItem	_FinStmntItem	`$projection.ConsolidationChartOfAccounts = _FinStmntItem.ConsolidationChartOfAccounts and $projection.FinancialStatementItem = _FinStmntItem.FinancialStatementItem`

Annotations (9)

Name	Value	Level
EndUserText.label	Financial Statement Item Mapping Item	view
AbapCatalog.sqlViewName	IFSITEMMAPITM	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#BASIC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#XL	view

Fields (12)

Key	Field	Source Field	Description
KEY	ConsolidationChartOfAccounts	ritclg
KEY	ChartOfAccounts	ktopl	G/L Chart of Accounts
KEY	FSItemMappingID	mapping_id
KEY	FSItemMappingRevision	revision
KEY	GLAccount	racct
	FinancialStatementItem	ritem
	_Mapping	_Mapping
	_MappingRevision	_MappingRevision
	_GLChartOfAccounts	_GLChartOfAccounts
	_GLAccountInChartOfAccounts	_GLAccountInChartOfAccounts
	_ConsChartOfAccounts	_ConsChartOfAccounts
	_FinStmntItem	_FinStmntItem

@EndUserText.label: 'Financial Statement Item Mapping Item'
@AbapCatalog.sqlViewName: 'IFSITEMMAPITM'
@AbapCatalog.preserveKey:true 
@VDM.viewType: #BASIC

//@Analytics: {

//  dataCategory: #DIMENSION

////  dataExtraction.enabled: true

//}


//@ObjectModel.representativeKey: ['FSItemMappingRevision']

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK

@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #B,
  sizeCategory: #XL
}

define view I_FSItemMappingItem
  as select from fincs_fsimapitm

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

  association [1..1] to I_ChartOfAccounts            as _GLChartOfAccounts          on  $projection.ChartOfAccounts = _GLChartOfAccounts.ChartOfAccounts

  association [1..1] to I_FSItemMapping              as _Mapping                    on  $projection.FSItemMappingID = _Mapping.FSItemMappingID

  association [1..1] to I_FSItemMappingRevision      as _MappingRevision            on  $projection.ConsolidationChartOfAccounts = _MappingRevision.ConsolidationChartOfAccounts
                                                                                    and $projection.FSItemMappingID              = _MappingRevision.FSItemMappingID
                                                                                    and $projection.ChartOfAccounts              = _MappingRevision.ChartOfAccounts
                                                                                    and $projection.FSItemMappingRevision        = _MappingRevision.FSItemMappingRevision

  association [1..1] to I_GLAccountInChartOfAccounts as _GLAccountInChartOfAccounts on  $projection.ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts
                                                                                    and $projection.GLAccount       = _GLAccountInChartOfAccounts.GLAccount


  association [1..1] to I_CnsldtnFinStmntItem        as _FinStmntItem               on  $projection.ConsolidationChartOfAccounts = _FinStmntItem.ConsolidationChartOfAccounts
                                                                                    and $projection.FinancialStatementItem       = _FinStmntItem.FinancialStatementItem
{

      @ObjectModel.foreignKey.association: '_ConsChartOfAccounts'
  key ritclg       as ConsolidationChartOfAccounts,

      @EndUserText.label: 'G/L Chart of Accounts'
      @ObjectModel.foreignKey.association: '_GLChartOfAccounts'
  key ktopl        as ChartOfAccounts,

      @ObjectModel.foreignKey.association: '_Mapping'
  key mapping_id   as FSItemMappingID,

      @ObjectModel.foreignKey.association: '_MappingRevision'
  key revision     as FSItemMappingRevision,

      @ObjectModel.foreignKey.association: '_GLAccountInChartOfAccounts'
  key racct        as GLAccount,

      @ObjectModel.foreignKey.association: '_FinStmntItem'
      ritem        as FinancialStatementItem,

      _Mapping,
      _MappingRevision,
      _GLChartOfAccounts,
      _GLAccountInChartOfAccounts,
      _ConsChartOfAccounts,
      _FinStmntItem
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINCS_FSIMAPITM"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTS",
"I_CNSLDTNCHARTOFACCOUNTS",
"I_CNSLDTNFINSTMNTITEM",
"I_FSITEMMAPPING",
"I_FSITEMMAPPINGREVISION",
"I_GLACCOUNTINCHARTOFACCOUNTS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_FSItemMappingItem view

fincs_fsimapitm