I_FSItemMappingRevisionT

DDL: I_FSITEMMAPPINGREVISIONT SQL: IFSITEMMAPREVT Type: view BASIC Package: FIN_CS_MD_FSITEMMAPPING
10 Fields 1 Data Sources 4 Associations

Financial Statement Item Mapping Revision Text

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

Data Sources (1)

SourceAliasJoin Type
fincs_fsimaprvt fincs_fsimaprvt 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
[1..1] I_Language _Language $projection.Language = _Language.Language

Annotations (9)

NameValueLevelField
EndUserText.label Financial Statement Item Mapping Revision Text view
AbapCatalog.sqlViewName IFSITEMMAPREVT view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE 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 Language langu Primary lang.
KEY FSItemMappingRevision revision Revision Number
FSItemMappingRevisionText revision_text Revision Description
_ConsChartOfAccounts _ConsChartOfAccounts
_GLChartOfAccounts _GLChartOfAccounts
_Mapping _Mapping
_Language _Language

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_FSItemMappingRevisionT.
-- 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: IFSITEMMAPREVT

CREATE VIEW I_FSItemMappingRevisionT AS
SELECT
  ritclg AS ConsolidationChartOfAccounts,
  ktopl AS ChartOfAccounts,
  mapping_id AS FSItemMappingID,
  langu AS Language,
  revision AS FSItemMappingRevision,
  revision_text AS FSItemMappingRevisionText
FROM fincs_fsimaprvt
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_Language AS _Language ON Language = _Language.Language  -- association [1..1]
;

Learn More