FINCS_SEL_FSITEM

@AbapCatalog : {
  compiler : {
    compareFilter: true
  },
  preserveKey: true,
  sqlViewName: 'FINCSSELFSITM'
}
@AccessControl : {
  authorizationCheck: #MANDATORY
}
@ClientHandling : {
  algorithm: #SESSION_VARIABLE
}
@Metadata : {
  ignorePropagatedAnnotations: true
}
@ObjectModel : {
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #C,
    sizeCategory: #M
  }
}
define view FINCS_SEL_FSITEM
  as select from I_CnsldtnFSItem_2 as _FSItem

  //do not expose this association in the projection list of the view

  association [1..1] to E_CnsldtnFSItem as _Extension on  _FSItem.ConsolidationChartOfAccounts  = _Extension.ConsolidationChartOfAccounts
                                                      and _FSItem.CnsldtnFinancialStatementItem = _Extension.CnsldtnFinancialStatementItem

{
  key ConsolidationChartOfAccounts,

      @ObjectModel.text.association: '_Text' //required for text handling during resolution

  key CnsldtnFinancialStatementItem  as FinancialStatementItem, // old name must be stable since it is stored in selection expression tables of unified selection


      ConsolidationFSItemType        as FinancialStatementItemType,
      ConsolidationBreakdownCategory as BreakdownCategory,
      CnsldtnFSItemIsForCnsldtnOnly  as IsConsolidationItem,
      CnsldtnFSItemPostingIsBlocked  as FinancialStatementItemIsBlkd,

      /* Associations */
      _Text //required for text handling during resolution

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNFSITEM_2"
],
"ASSOCIATED":
[
"E_CNSLDTNFSITEM",
"I_CNSLDTNFSITEMTEXT_2"
],
"BASE":
[
"I_CNSLDTNFSITEM_2"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/