I_FSITEMMAPPINGASSGMTWITHVERS

CDS View

Financial Statement Item Mapping Assignment With Version

I_FSITEMMAPPINGASSGMTWITHVERS is a CDS View in S/4HANA. Financial Statement Item Mapping Assignment With Version. It contains 2 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 2 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
ICA_CONSJOURNALENTRIES_5 view inner Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_7 view_entity inner ICA: Consolidation Journal Entry Line Items
ICA_P_CONSJOURNALENTRIES_01 view inner ICA: Consolidation Journal Entry Line Items from ACDOCA
P_ReportedFinancialData_RT_03 view left_outer COMPOSITE

Fields (2)

KeyField CDS FieldsUsed in Views
ConsolidationChartOfAccounts ConsolidationChartOfAccounts 11
FinancialStatementItem FinancialStatementItem,ritem 11 
@EndUserText.label: 'Financial Statement Item Mapping Assignment With Version'
@AbapCatalog.sqlViewName: 'IFSIMAPASSGVERS'
@AbapCatalog.preserveKey:true
@VDM.viewType: #COMPOSITE


@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #NOT_REQUIRED

@ObjectModel.usageType: {
  dataClass: #CUSTOMIZING,
  serviceQuality: #B,
  sizeCategory: #XL
}

define view I_FSItemMappingAssgmtWithVers
  as select from I_FSItemMappingAssignment
{

  key FSItemMappingVersion,

      @ObjectModel.foreignKey.association: '_ConsChartOfAccounts'
  key ConsolidationChartOfAccounts,

      @ObjectModel.foreignKey.association: '_GLChartOfAccounts'
  key ChartOfAccounts,


  key ValidityStartFiscalYearPeriod,

      ValidityEndFiscalYearPeriod,

     @Semantics.businessDate.to: true
      cast ('99991231' as dats)                  as ValidityEndDate,          //for compatibility, do not use


      @Semantics.businessDate.from: true
      cast ('19000101' as dats)                  as ValidityStartDate,       //for compatibility, do not use


      @ObjectModel.foreignKey.association: '_Mapping'
      FSItemMappingID,

      @ObjectModel.foreignKey.association: '_MappingRevision'
      FSItemMappingRevision,

      _MappingItem.GLAccount,

      _MappingItem.FinancialStatementItem,    

      _ConsChartOfAccounts,
      
      _GLChartOfAccounts,

      _Mapping,

      _MappingRevision

}

Learn More