P_FinancialStatementLeafItem

@AbapCatalog.sqlViewName: 'PFISTMTLFITM'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private:true
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true 
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_FinancialStatementLeafItem
  as select from ska1

{
  key    cast(concat(ktopl,concat(saknr,'0A')) as hrynode) as FinancialStatementLeafItem,
  cast( concat(ktopl,concat('/',saknr) ) as fins_fsleaf_externalid ) as FinancialStmntLeafItemExtID
} 

union all select from ska1
{
  key    cast(concat(ktopl,concat(saknr,'1A')) as hrynode) as FinancialStatementLeafItem,
  cast( concat(ktopl,concat('/',saknr) ) as fins_fsleaf_externalid ) as FinancialStmntLeafItemExtID
} 

union all select from ska1
{
  key    cast(concat(ktopl,concat(saknr,'2A')) as hrynode) as FinancialStatementLeafItem,
  cast( concat(ktopl,concat('/',saknr) ) as fins_fsleaf_externalid ) as FinancialStmntLeafItemExtID
} 

union all select from tfkb
{
  key cast(concat(tfkb.fkber,'F') as hrynode)             as FinancialStatementLeafItem,
  cast( tfkb.fkber as fins_fsleaf_externalid ) as FinancialStmntLeafItemExtID
}
union all select from dd07l
  left outer join     t000 on(
    t000.mandt = $session.client
  )
{

  key t000.mandt as mandt,
  key cast(case(dd07l.domvalue_l)
  when 'LOSS' then '0COA0BSRESULT1A'
  when 'PROFIT' then '0COA0BSRESULT2A'
  when 'P+L RESULT' then '0COA0PLRESULTA' end as hrynode)
                 as FinancialStatementLeafItem,
  cast( dd07l.domvalue_l as fins_fsleaf_externalid ) as FinancialStmntLeafItemExtID
}
where
  dd07l.domname = 'FSVSPECIALNODET'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L",
"SKA1",
"T000",
"TFKB"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/