@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
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"FINCS_FSIASSGMT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/