ICA_FS_ITEM

CDS View

ICA_FS_ITEM is a CDS View in S/4HANA. It contains 2 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 2 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
ICA_CONSJOURNALENTRIES_2 view left_outer Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_3 view left_outer Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_4 view left_outer Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_5 view left_outer Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_6 view_entity left_outer ICA: Consolidation Journal Entry Line Items
ICA_CONSJOURNALENTRIES_7 view_entity left_outer ICA: Consolidation Journal Entry Line Items
ICA_GR_FSIASSGMT view from

Fields (2)

KeyField CDS FieldsUsed in Views
KEY itclg itclg 1
KEY item item 1 
@AbapCatalog.sqlViewName: 'ICAFSITEM'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view ICA_FS_ITEM
  as select from fincs_fsiassgmt
{

  key itclg,
  key item,
  key iatvs,
  key cast(concat(left(fromyearper,4), replace(right(fromyearper,3), '001', '000')) as fincs_fiscalyearper preserving type ) as fromyearper,
      toyearper,
      sa_role,
      sa_elimination,
      sa_data_collection,
      sa_currency_translation,
      sa_cash_flow,
      sa_scope,
      sa_customer_specific,
      ta_elimination,
      ta_nci,
      ta_planning
      
} where mandt = $session.client

Learn More