P_BSEG_ADD_COM1

 @AbapCatalog.entityBuffer.definitionAllowed: false
 @VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
define view entity P_Bseg_Add_Com1
as select from bseg_add

association [1..1] to P_BKPF_COM       as _P_BKPF_COM       on $projection.bukrs    = _P_BKPF_COM.bukrs and 
                                                               $projection.belnr    = _P_BKPF_COM.belnr and 
                                                               $projection.gjahr    = _P_BKPF_COM.gjahr 

{
key bseg_add.bukrs,
key bseg_add.belnr,
key bseg_add.gjahr,
key bseg_add.buzei,

bseg_add.buzid,
bseg_add.augdt,
bseg_add.augcp,
bseg_add.augbl,
bseg_add.bschl,
bseg_add.koart,
bseg_add.shkzg,
bseg_add.gsber,
bseg_add.pargb,
bseg_add.mwskz,
bseg_add.qsskz,
bseg_add.ktosl,
bseg_add.valut,
bseg_add.zuonr,
bseg_add.sgtxt,
bseg_add.vbund,
bseg_add.bewar,
bseg_add.altkt,
bseg_add.vorgn,
bseg_add.fkont,
bseg_add.kokrs,
bseg_add.kostl,
bseg_add.projn,
bseg_add.aufnr,
bseg_add.anln1,
bseg_add.anln2,
bseg_add.anbwa,
bseg_add.xopvw,
bseg_add.xauto,
bseg_add.xncop,
bseg_add.hkont,
bseg_add.xbilk,
bseg_add.gvtyp,
bseg_add.zfbdt,
bseg_add.rebzg,
bseg_add.rebzj,
bseg_add.rebzz,
bseg_add.rebzt,
bseg_add.wverw,
bseg_add.matnr,
bseg_add.werks,
bseg_add.bwkey,
bseg_add.bwtar,
bseg_add.prctr,
bseg_add.vname,
bseg_add.recid,
bseg_add.egrup,
bseg_add.vptnr,
bseg_add.vertt,
bseg_add.vertn,
bseg_add.vbewa,
bseg_add.txjcd,
bseg_add.imkey,
bseg_add.dabrz,
bseg_add.fipos,
bseg_add.kstrg,
bseg_add.nplnr,
bseg_add.aufpl,
bseg_add.aplzl,
bseg_add.projk,
bseg_add.paobjnr,
bseg_add.pasubnr,
bseg_add.xragl,
bseg_add.uzawe,
bseg_add.lokkt,
bseg_add.fistl,
bseg_add.geber,
bseg_add.pprct,
bseg_add.xref1,
bseg_add.xref2,
bseg_add.kblnr,
bseg_add.kblpos,
bseg_add.fkber,
bseg_add.obzei,
bseg_add.xnegp,
bseg_add.rfzei,
bseg_add.ccbtc,
bseg_add.xref3,
bseg_add.kontt,
bseg_add.kontl,
bseg_add.agzei,
bseg_add.bupla,
bseg_add.secco,
bseg_add.lstar,
bseg_add.prznr,
bseg_add.grant_nbr,
bseg_add.intreno,
bseg_add.measure,
bseg_add.auggj,
bseg_add.segment,
bseg_add.psegment,
bseg_add.pfkber,
bseg_add.kstar,
bseg_add.xlgclr,
bseg_add.netdt,
bseg_add.gkont,
bseg_add.gkart,
bseg_add.ghkon,
bseg_add.pgeber,
bseg_add.pgrant_nbr,
bseg_add.budget_pd,
bseg_add.pbudget_pd,
bseg_add.prodper,

bseg_add.re_bukrs,
bseg_add.re_account,

bseg_add.bdgt_account_cocode,
bseg_add.bdgt_account,

_P_BKPF_COM.hwaer as h_hwaer,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.dmbtr as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.dmbtr as abap.curr( 23,2))
               else cast( bseg_add.dmbtr as abap.curr( 23,2))
   end as dmbtr_shl ,


@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.mwsts as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.mwsts as abap.curr( 23,2))
               else cast( bseg_add.mwsts as abap.curr( 23,2))
   end as mwsts_shl ,


@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.bdiff as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.bdiff as abap.curr( 23,2))
               else cast( bseg_add.bdiff as abap.curr( 23,2))
   end as bdiff_shl ,
   

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.rdiff as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.rdiff as abap.curr( 23,2))
               else cast( bseg_add.rdiff as abap.curr( 23,2))
   end as rdiff_shl ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.ppdiff as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.ppdiff as abap.curr( 23,2))
               else cast( bseg_add.ppdiff as abap.curr( 23,2))
   end as ppdiff_shl ,


_P_BKPF_COM.waers as h_waers,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.wrbtr as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.wrbtr as abap.curr( 23,2))
               else cast( bseg_add.wrbtr as abap.curr( 23,2))
   end as wrbtr_shl ,


@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.wmwst as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.wmwst as abap.curr( 23,2))
               else cast( bseg_add.wmwst as abap.curr( 23,2))
   end as wmwst_shl ,
   

bseg_add.pswsl as pswsl,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'pswsl'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.pswbt as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.pswbt as abap.curr( 23,2))
               else cast( bseg_add.pswbt as abap.curr( 23,2))
   end as pswbt_shl ,


_P_BKPF_COM.hwae2 as h_hwae2,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.bdif2 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.bdif2 as abap.curr( 23,2))
               else cast( bseg_add.bdif2 as abap.curr( 23,2))
   end as bdif2_shl ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.rdif2 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.rdif2 as abap.curr( 23,2))
               else cast( bseg_add.rdif2 as abap.curr( 23,2))
   end as rdif2_shl ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.dmbe2 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.dmbe2 as abap.curr( 23,2))
               else cast( bseg_add.dmbe2 as abap.curr( 23,2))
   end as dmbe2_shl ,


@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.mwst2 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.mwst2 as abap.curr( 23,2))
               else cast( bseg_add.mwst2 as abap.curr( 23,2))
   end as mwst2_shl ,


@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.ppdif2 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.ppdif2 as abap.curr( 23,2))
               else cast( bseg_add.ppdif2 as abap.curr( 23,2))
   end as ppdif2_shl ,


_P_BKPF_COM.hwae3 as h_hwae3,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.dmbe3 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.dmbe3 as abap.curr( 23,2))
               else cast( bseg_add.dmbe3 as abap.curr( 23,2))
   end as dmbe3_shl ,


@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.mwst3 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.mwst3 as abap.curr( 23,2))
               else cast( bseg_add.mwst3 as abap.curr( 23,2))
   end as mwst3_shl ,

   
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.bdif3 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.bdif3 as abap.curr( 23,2))
               else cast( bseg_add.bdif3 as abap.curr( 23,2))
   end as bdif3_shl ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.rdif3 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.rdif3 as abap.curr( 23,2))
               else cast( bseg_add.rdif3 as abap.curr( 23,2))
   end as rdif3_shl ,


@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
   case bseg_add.shkzg  when 'H' then   cast(-bseg_add.ppdif3 as abap.curr( 23,2))
                        when 'S' then   cast( bseg_add.ppdif3 as abap.curr( 23,2))
               else cast( bseg_add.ppdif3 as abap.curr( 23,2))
   end as ppdif3_shl ,
   
   
// Functional Currency

bseg_add.rfccur as rfccur,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'rfccur'} }
   case bseg_add.shkzg  when 'H' then   -bseg_add.fcsl 
                        when 'S' then    bseg_add.fcsl 
               else             bseg_add.fcsl 
   end as fcsl_shl ,   

   
bseg_add.meins as meins,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'meins'} } bseg_add.menge,


case bseg_add.xnegp  when 'X' then  case bseg_add.shkzg  when 'S' then 'H' 
                                                         when 'H' then 'S'
                     end    
                     when ' ' then  shkzg           
            else bseg_add.shkzg
end as shkzg_calc,

@Aggregation.default: #SUM
cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm ) as nbritm,


bseg_add.bstat,
//DMBTR,

//WRBTR,

//DMBE2,

//DMBE3,

//PSWBT,

//RDIFF,

//RDIF2,

//RDIF3,

bseg_add.buzei_sender
//BDIF2,

//BDIF3,

//BDIFF,

//MWST2,

//MWST3,

//MWSTS,

//PPDIF2,

//PPDIF3,

//PPDIFF,

//WMWST


}