ICA_COMPANY_PROFITCENTER

@AbapCatalog.sqlViewName: 'ICACOMP_PC'
@AbapCatalog.compiler.compareFilter:true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.sizeCategory: #M
define view ICA_COMPANY_PROFITCENTER
  as select distinct from cepc       as A
    join                  cepc_bukrs as B on  A.kokrs = B.kokrs
                                          and A.prctr = B.prctr
    join                  t001       as C on B.bukrs = C.bukrs
    join                  t880       as D on C.rcomp = D.rcomp
    left outer join       cepct      as E on  A.prctr = E.prctr
                                          and A.kokrs = E.kokrs
                                          and A.datbi = E.datbi
                                          and E.spras = $session.system_language

{
  A.prctr,
  D.rcomp,
  case when E.ltext = '' then concat_with_space(concat(D.name1, ' /'), E.ktext, 1)
       else concat_with_space(concat(D.name1, ' /'), E.ltext, 1)
  end     as unitName,
  case when E.ltext = '' then E.ktext
       else E.ltext
  end     as prctr_unitName,
  D.name1 as rcomp_unitName
}
where
      A.mandt = $session.client
  and A.datbi >= $session.system_date
  and A.datab <= $session.system_date
union all select distinct from cepc       as A
  left outer join              cepc_bukrs as B on  A.kokrs = B.kokrs
                                               and A.prctr = B.prctr
  join                         tka02      as T on A.kokrs = T.kokrs
  join                         t001       as C on T.bukrs = C.bukrs
  join                         t880       as D on C.rcomp = D.rcomp
  left outer join              cepct      as E on  A.prctr = E.prctr
                                               and A.kokrs = E.kokrs
                                               and A.datbi = E.datbi
                                               and E.spras = $session.system_language
{
  A.prctr,
  D.rcomp,
  case when E.ltext = '' then concat_with_space(concat(D.name1, ' /'), E.ktext, 1)
       else concat_with_space(concat(D.name1, ' /'), E.ltext, 1)
  end as unitName,
  case when E.ltext = '' then E.ktext
       else E.ltext
  end     as prctr_unitName,
  D.name1 as rcomp_unitName    
}
where
      A.mandt = $session.client
  and A.datbi >= $session.system_date
  and A.datab <= $session.system_date
  and B.bukrs is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CEPC",
"CEPCT",
"CEPC_BUKRS",
"T001",
"T880",
"TKA02"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/