ICA_GR_FSIASSGMT

DDL: ICA_GR_FSIASSGMT SQL: ICAGRFSIASSGMT Type: view

ICA_GR_FSIASSGMT is a CDS View in SAP S/4HANA. It reads from 2 data sources (ICA_FS_ITEM, tf200) and exposes 8 fields with key fields itclg, item, vers.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
ICA_FS_ITEM ICA_FS_ITEM from
tf200 tf200 inner

Parameters (4)

NameTypeDefault
P_RYEAR fc_ryear
P_POPER fc_perid
P_RVERS fc_rvers
P_ITCLG fc_itclg

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName ICAGRFSIASSGMT view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.preserveKey true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY itclg ICA_FS_ITEM itclg
KEY item ICA_FS_ITEM item
KEY vers tf200 rvers
sa_role sa_role
sa_cash_flow sa_cash_flow
sa_scope sa_scope
ta_nci ta_nci
ta_planning ta_planning 
@AbapCatalog.sqlViewName: 'ICAGRFSIASSGMT'
@AbapCatalog.compiler.compareFilter:true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
@AbapCatalog.preserveKey:true
define view ICA_GR_FSIASSGMT
  with parameters
    P_RYEAR : fc_ryear,
    P_POPER : fc_perid,
    P_RVERS : fc_rvers,
    P_ITCLG : fc_itclg
  as select from ICA_FS_ITEM
    inner join   tf200 on  tf200.iatvs = ICA_FS_ITEM.iatvs
                       and tf200.rvers = $parameters.P_RVERS
{
      //fincs_fsiassgmt

  key ICA_FS_ITEM.itclg,
  key ICA_FS_ITEM.item,
  key tf200.rvers as vers,
      sa_role,
      sa_data_collection,
      sa_currency_translation,
      sa_elimination,
      sa_cash_flow,
      sa_scope,
      sa_customer_specific,
      ta_elimination,
      ta_nci,
      ta_planning
}
where
      itclg       = $parameters.P_ITCLG
  and fromyearper <= concat(
    $parameters.P_RYEAR, $parameters.P_POPER
  )
  and toyearper   >= concat(
    $parameters.P_RYEAR, $parameters.P_POPER
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ICA_FS_ITEM",
"TF200"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More