I_FSItemMappingRevisionT

DDL: I_FSITEMMAPPINGREVISIONT SQL: IFSITEMMAPREVT Type: view BASIC

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.

1 data source(s) 10 fields

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
KEY ChartOfAccounts ktopl
KEY FSItemMappingID mapping_id
KEY Language langu
KEY FSItemMappingRevision revision
FSItemMappingRevisionText revision_text
_ConsChartOfAccounts _ConsChartOfAccounts
_GLChartOfAccounts _GLChartOfAccounts
_Mapping _Mapping
_Language _Language 
@EndUserText.label: 'Financial Statement Item Mapping Revision Text'
@AbapCatalog.sqlViewName: 'IFSITEMMAPREVT'

@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC

@AccessControl.authorizationCheck: #CHECK
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.representativeKey: ['FSItemMappingRevision']

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

define view I_FSItemMappingRevisionT
  as select from fincs_fsimaprvt
  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_Language        as _Language          on $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_ConsChartOfAccounts'
  key ritclg       as ConsolidationChartOfAccounts,
 
      @ObjectModel.foreignKey.association: '_GLChartOfAccounts'
  key ktopl         as ChartOfAccounts,

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

     @Semantics.language
     @ObjectModel.foreignKey.association: '_Language'
  key langu         as Language,

  key revision      as FSItemMappingRevision,

      @Semantics.text
      revision_text as FSItemMappingRevisionText,

      _ConsChartOfAccounts,

      _GLChartOfAccounts,

      _Mapping,

      _Language

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINCS_FSIMAPRVT"
],
"ASSOCIATED":
[
"I_CHARTOFACCOUNTS",
"I_CNSLDTNCHARTOFACCOUNTS",
"I_FSITEMMAPPING",
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More