I_FSItemMappingRevision

DDL: I_FSITEMMAPPINGREVISION SQL: IFSITEMMAPREV Type: view BASIC Package: FIN_CS_MD_FSITEMMAPPING
10 Fields 1 Data Sources 4 Associations

Financial Statement Item Mapping Revision

I_FSItemMappingRevision is a Basic CDS View that provides data about "Financial Statement Item Mapping Revision" in SAP S/4HANA. It reads from 1 data source (fincs_fsimaprv) and exposes 10 fields with key fields ConsolidationChartOfAccounts, ChartOfAccounts, FSItemMappingID, FSItemMappingRevision. It has 4 associations to related views. Part of development package FIN_CS_MD_FSITEMMAPPING.

Data Sources (1)

SourceAliasJoin Type
fincs_fsimaprv fincs_fsimaprv from

Associations (4)

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
[0..*] I_FSItemMappingRevisionT _Text $projection.ConsolidationChartOfAccounts = _Text.ConsolidationChartOfAccounts and $projection.ChartOfAccounts = _Text.ChartOfAccounts and $projection.FSItemMappingID = _Text.FSItemMappingID and $projection.FSItemMappingRevision = _Text.FSItemMappingRevision

Annotations (9)

NameValueLevelField
EndUserText.label Financial Statement Item Mapping Revision view
AbapCatalog.sqlViewName IFSITEMMAPREV view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey FSItemMappingRevision view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view

Fields (10)

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
CreatedByUser created_by Version Created By
LastChangeByUser last_changed_by Username
_ConsChartOfAccounts _ConsChartOfAccounts
_GLChartOfAccounts _GLChartOfAccounts
_Mapping _Mapping
_Text _Text

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_FSItemMappingRevision.
-- 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: IFSITEMMAPREV

CREATE VIEW I_FSItemMappingRevision AS
SELECT
  ritclg AS ConsolidationChartOfAccounts,
  ktopl AS ChartOfAccounts,
  mapping_id AS FSItemMappingID,
  revision AS FSItemMappingRevision,
  created_by AS CreatedByUser,
  last_changed_by AS LastChangeByUser
FROM fincs_fsimaprv
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_FSItemMappingRevisionT AS _Text ON ConsolidationChartOfAccounts = _Text.ConsolidationChartOfAccounts AND ChartOfAccounts = _Text.ChartOfAccounts AND FSItemMappingID = _Text.FSItemMappingID AND FSItemMappingRevision = _Text.FSItemMappingRevision  -- association [0..*]
;

Learn More