I_FSItemMappingItem

DDL: I_FSITEMMAPPINGITEM SQL: IFSITEMMAPITM Type: view BASIC
12 Fields 1 Data Sources 6 Associations

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)

SourceAliasJoin Type
fincs_fsimapitm fincs_fsimapitm from

Associations (6)

CardinalityTargetAliasCondition
[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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
KEY ConsolidationChartOfAccounts ritclg Consolidation COA
KEY ChartOfAccounts ktopl G/L Chart of Accounts
KEY FSItemMappingID mapping_id Mapping ID
KEY FSItemMappingRevision revision Revision Number
KEY GLAccount racct GL Account From
FinancialStatementItem ritem Reporting Item
_Mapping _Mapping
_MappingRevision _MappingRevision
_GLChartOfAccounts _GLChartOfAccounts
_GLAccountInChartOfAccounts _GLAccountInChartOfAccounts
_ConsChartOfAccounts _ConsChartOfAccounts
_FinStmntItem _FinStmntItem

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_FSItemMappingItem.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IFSITEMMAPITM

CREATE VIEW I_FSItemMappingItem AS
SELECT
  ritclg AS ConsolidationChartOfAccounts,
  ktopl AS ChartOfAccounts,
  mapping_id AS FSItemMappingID,
  revision AS FSItemMappingRevision,
  racct AS GLAccount,
  ritem AS FinancialStatementItem
FROM fincs_fsimapitm
LEFT OUTER JOIN I_CnsldtnChartOfAccounts AS _ConsChartOfAccounts ON ConsolidationChartOfAccounts = _ConsChartOfAccounts.ConsolidationChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_ChartOfAccounts AS _GLChartOfAccounts ON ChartOfAccounts = _GLChartOfAccounts.ChartOfAccounts  -- association [1..1]
LEFT OUTER JOIN I_FSItemMapping AS _Mapping ON FSItemMappingID = _Mapping.FSItemMappingID  -- association [1..1]
LEFT OUTER JOIN I_FSItemMappingRevision AS _MappingRevision ON ConsolidationChartOfAccounts = _MappingRevision.ConsolidationChartOfAccounts AND FSItemMappingID = _MappingRevision.FSItemMappingID AND ChartOfAccounts = _MappingRevision.ChartOfAccounts AND FSItemMappingRevision = _MappingRevision.FSItemMappingRevision  -- association [1..1]
LEFT OUTER JOIN I_GLAccountInChartOfAccounts AS _GLAccountInChartOfAccounts ON ChartOfAccounts = _GLAccountInChartOfAccounts.ChartOfAccounts AND GLAccount = _GLAccountInChartOfAccounts.GLAccount  -- association [1..1]
LEFT OUTER JOIN I_CnsldtnFinStmntItem AS _FinStmntItem ON ConsolidationChartOfAccounts = _FinStmntItem.ConsolidationChartOfAccounts AND FinancialStatementItem = _FinStmntItem.FinancialStatementItem  -- association [1..1]
;

Learn More