I_FSItemMappingRevision

DDL: I_FSITEMMAPPINGREVISION SQL: IFSITEMMAPREV Type: view BASIC

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.

1 data source(s) 10 fields

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
KEY ChartOfAccounts ktopl G/L Chart of Accounts
KEY FSItemMappingID mapping_id
KEY FSItemMappingRevision revision
CreatedByUser created_by
LastChangeByUser last_changed_by
_ConsChartOfAccounts _ConsChartOfAccounts
_GLChartOfAccounts _GLChartOfAccounts
_Mapping _Mapping
_Text _Text 
@EndUserText.label: 'Financial Statement Item Mapping Revision'
@AbapCatalog.sqlViewName: 'IFSITEMMAPREV'
@VDM.viewType: #BASIC

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'FSItemMappingRevision'

@AccessControl.authorizationCheck: #CHECK

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

define view I_FSItemMappingRevision
  as select from fincs_fsimaprv
  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 [0..*] to I_FSItemMappingRevisionT as _Text                on  $projection.ConsolidationChartOfAccounts = _Text.ConsolidationChartOfAccounts
                                                                         and $projection.ChartOfAccounts              = _Text.ChartOfAccounts
                                                                         and $projection.FSItemMappingID              = _Text.FSItemMappingID
                                                                         and $projection.FSItemMappingRevision        = _Text.FSItemMappingRevision

{

      @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.text.association: '_Text'
  key revision                                                as    FSItemMappingRevision,


      created_by                                              as    CreatedByUser,
      case when created_at = 0 then dats_tims_to_tstmp( cast('20180801' as abap.dats), 
                          cast('010000' as abap.tims), 
                          abap_system_timezone( $session.client,'NULL' ), 
                          $session.client, 
                         'NULL' ) else created_at end as    CreationDateTime,
      last_changed_by                                         as    LastChangeByUser,
      case when last_changed_at = 0 then dats_tims_to_tstmp( cast('20180801' as abap.dats), 
                          cast('010000' as abap.tims), 
                          abap_system_timezone( $session.client,'NULL' ), 
                          $session.client, 
                         'NULL' ) else last_changed_at end as    LastChangeDateTime,

      _ConsChartOfAccounts,

      _GLChartOfAccounts,

      _Mapping,

      _Text

}

Learn More