@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
}