Fclm_Bseg_Level

@AbapCatalog.sqlViewName: 'VFCLMBSEGLVL'
@EndUserText.label: 'BSEG level'
@ObjectModel.usageType.serviceQuality: #D 
@ObjectModel.usageType.sizeCategory: #XXL 
@ObjectModel.usageType.dataClass: #TRANSACTIONAL 
@ClientHandling.algorithm: #SESSION_VARIABLE
define view Fclm_Bseg_Level 
as
select from bseg as a inner join Fclm_Flow_Level as b 
on a.fqftype = b.flow_type and ( b.mandt = a.mandt or b.mandt = '000') 
{ lpad(a.bukrs, 4, ' ') as bukrs,a.gjahr,lpad(a.belnr, 10, ' ') as belnr,a.buzei,a.shkzg,
  a.wrbtr,a.h_waers,a.lqitem,a.prctr,a.fqftype,a.fdlev,
  a.kunnr,a.lifnr,a.segment,a.gsber,a.matnr,a.kostl,a.hbkid,a.hktid,a.augbl,
//  |    a.fdtag,a.valut,a.h_bldat,a.netdt,a.sk1dt,a.sk2dt,| &

   case a.valut 
    when '00000000' then 
        case  a.fdtag 
            when '00000000' then
                case when a.netdt = '00000000' then a.h_budat 
                    else a.netdt 
                end
            else a.fdtag 
        end 
    else a.valut 
   end  as valut,
   b.flow_level
}
 
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"FCLM_FLOW_LEVEL",
"BSEG"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/