@AbapCatalog.entityBuffer.definitionAllowed: false
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
define view entity P_BSEG_COM1
as select from bseg left outer to one join t014 on bseg.kkber = t014.kkber
{
key bseg.bukrs,
key bseg.belnr,
key bseg.gjahr,
key bseg.buzei,
bseg.buzid,
bseg.augdt,
bseg.augcp,
bseg.augbl,
bseg.bschl,
bseg.koart,
bseg.umskz,
bseg.umsks,
bseg.zumsk,
bseg.shkzg,
bseg.gsber,
bseg.pargb,
bseg.tax_country,
bseg.mwskz,
cast( bseg.txdat_from as fis_txdat_from preserving type ) as txdat_from,
bseg.qsskz,
bseg.shzuz,
bseg.stekz,
bseg.mwart,
bseg.txgrp,
bseg.ktosl,
bseg.kursr,
bseg.valut,
bseg.zuonr,
bseg.sgtxt,
bseg.zinkz,
bseg.vbund,
bseg.bewar,
bseg.altkt,
bseg.vorgn,
bseg.fdlev,
bseg.fdgrp,
bseg.fdtag,
bseg.fkont,
bseg.kokrs,
bseg.kostl,
bseg.projn,
bseg.aufnr,
bseg.vbeln,
bseg.vbel2,
bseg.posn2,
bseg.eten2,
bseg.service_doc_type,
bseg.service_doc_id,
bseg.service_doc_item_id,
bseg.anln1,
bseg.anln2,
bseg.anbwa,
bseg.bzdat,
bseg.pernr,
bseg.xumsw,
bseg.xhres,
bseg.xkres,
bseg.xopvw,
bseg.xcpdd,
bseg.xskst,
bseg.xsauf,
bseg.xspro,
bseg.xserg,
bseg.xfakt,
bseg.xuman,
bseg.xanet,
bseg.xskrl,
cast(bseg.xinve as fis_xinve preserving type ) as xinve,
bseg.xpanz,
bseg.xauto,
bseg.xncop,
bseg.xzahl,
bseg.saknr,
bseg.hkont,
bseg.kunnr,
bseg.lifnr,
bseg.filkd,
bseg.xbilk,
bseg.gvtyp,
bseg.hzuon,
bseg.zfbdt,
bseg.zterm,
bseg.zbd1t,
bseg.zbd2t,
bseg.zbd3t,
bseg.zbd1p,
bseg.zbd2p,
bseg.zlsch,
bseg.zlspr,
bseg.zbfix,
bseg.hbkid,
bseg.bvtyp,
bseg.mwsk1,
bseg.mwsk2,
bseg.mwsk3,
bseg.rebzg,
bseg.rebzj,
bseg.rebzz,
bseg.rebzt,
cast(bseg.zollt as fis_dzollt preserving type ) as zollt,
cast(bseg.zolld as fis_dzolld preserving type ) as zolld,
bseg.lzbkz,
bseg.landl,
cast( bseg.diekz as fis_diekz preserving type ) as diekz,
bseg.samnr,
bseg.abper,
bseg.vrskz,
bseg.vrsdt,
bseg.disbn,
bseg.disbj,
bseg.disbz,
bseg.wverw,
bseg.anfbn,
bseg.anfbj,
bseg.anfbu,
bseg.anfae,
bseg.blnkz,
bseg.blnpz,
bseg.mschl,
bseg.mansp,
bseg.madat,
bseg.manst,
bseg.maber,
bseg.esrnr,
bseg.esrre,
bseg.esrpz,
bseg.qsznr,
bseg.matnr,
bseg.werks,
bseg.ebeln,
bseg.ebelp,
bseg.zekkn,
bseg.elikz,
bseg.vprsv,
bseg.bwkey,
bseg.bwtar,
bseg.bustw,
bseg.psalt,
bseg.tbtkz,
bseg.spgrp,
bseg.spgrm,
bseg.spgrt,
bseg.spgrg,
bseg.spgrv,
bseg.spgrq,
bseg.stceg,
bseg.egbld,
cast( bseg.eglld as fis_eglld preserving type ) as eglld,
bseg.rstgr,
bseg.ryacq,
bseg.rpacq,
bseg.prctr,
bseg.xhkom,
bseg.vname,
bseg.recid,
bseg.egrup,
bseg.vptnr,
bseg.vertt,
bseg.vertn,
bseg.vbewa,
bseg.depot,
bseg.txjcd,
bseg.imkey,
bseg.dabrz,
bseg.popts,
bseg.fipos,
bseg.kstrg,
bseg.nplnr,
bseg.aufpl,
bseg.aplzl,
bseg.projk,
bseg.paobjnr,
bseg.pasubnr,
bseg.spgrs,
bseg.spgrc,
bseg.btype,
bseg.etype,
bseg.xegdr,
bseg.lnran,
bseg.hrkft,
bseg.hwmet,
bseg.glupm,
bseg.xragl,
bseg.uzawe,
bseg.lokkt,
bseg.fistl,
bseg.geber,
cast( bseg.stbuk as fis_stbuk preserving type ) as stbuk,
bseg.pprct,
bseg.xref1,
bseg.xref2,
bseg.kblnr,
bseg.kblpos,
bseg.fkber,
bseg.obzei,
bseg.xnegp,
bseg.rfzei,
bseg.ccbtc,
bseg.kkber as kkber,
bseg.empfb,
bseg.xref3,
bseg.dtws1,
bseg.dtws2,
bseg.dtws3,
bseg.dtws4,
bseg.gricd,
bseg.grirg,
bseg.gityp,
bseg.xpypr,
bseg.kidno,
bseg.idxsp,
bseg.linfv,
bseg.kontt,
bseg.kontl,
//bseg.uebgdat,
bseg.txdat,
bseg.agzei,
bseg.bupla,
bseg.secco,
bseg.lstar,
bseg.cession_kz,
bseg.prznr,
bseg.pendays,
bseg.penrc,
bseg.grant_nbr,
bseg.fkber_long,
bseg.gmvkz,
bseg.srtype,
bseg.intreno,
bseg.measure,
bseg.auggj,
cast(bseg.ppa_ex_ind as fis_exclude_flg preserving type ) as ppa_ex_ind,
bseg.docln,
bseg.segment,
bseg.psegment,
bseg.pfkber,
bseg.hktid,
bseg.kstar,
cast(bseg.xlgclr as fis_xlgclr_new preserving type ) as xlgclr,
bseg.taxps,
bseg.pays_prov,
bseg.pays_tran,
bseg.mndid,
bseg.xfrge_bseg,
bseg.awtyp,
bseg.awkey,
bseg.awsys,
bseg.posnr,
//bseg.buzei_sender,
cast( concat( '0', bseg.h_monat ) as abap.numc( 3 ) ) as h_monat,
bseg.h_bstat,
bseg.h_budat,
bseg.h_bldat,
bseg.h_blart,
bseg.netdt,
bseg.sk1dt,
bseg.sk2dt,
//bseg.fqftype,
bseg.lqitem,
bseg.gkont,
bseg.gkart,
bseg.ghkon,
bseg.pgeber,
bseg.pgrant_nbr,
bseg.budget_pd,
bseg.pbudget_pd,
bseg.j_1tpbupl,
cast(bseg.perop_beg as fis_fm_perop_fi_low_new preserving type ) as perop_beg,
cast(bseg.perop_end as fis_fm_perop_fi_high_new preserving type ) as perop_end,
bseg.fastpay,
bseg.ignr_ivref,
bseg.fmfgus_key,
bseg.fmxdocnr,
bseg.fmxyear,
bseg.fmxdocln,
bseg.fmxzekkn,
bseg.prodper,
bseg.glo_ref1,
bseg.payt_rsn,
bseg.re_bukrs,
bseg.re_account,
bseg.bdgt_account_cocode,
bseg.bdgt_account,
bseg.fs_product_group,
bseg.branch_id,
bseg.datasource_id,
bseg.kdgrp,
bseg.land1,
bseg.brsch,
bseg.h_hwaer as h_hwaer,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.dmbtr as abap.curr( 23,2))
when 'S' then cast( bseg.dmbtr as abap.curr( 23,2))
else cast( bseg.dmbtr as abap.curr( 23,2))
end as dmbtr_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.kzbtr as abap.curr( 23,2))
when 'S' then cast( bseg.kzbtr as abap.curr( 23,2))
else cast( bseg.kzbtr as abap.curr( 23,2))
end as kzbtr_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.txbhw as abap.curr( 23,2))
when 'S' then cast( bseg.txbhw as abap.curr( 23,2))
else cast( bseg.txbhw as abap.curr( 23,2))
end as txbhw_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.mwsts as abap.curr( 23,2))
when 'S' then cast( bseg.mwsts as abap.curr( 23,2))
else cast( bseg.mwsts as abap.curr( 23,2))
end as mwsts_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.hwbas as abap.curr( 23,2))
when 'S' then cast( bseg.hwbas as abap.curr( 23,2))
else cast( bseg.hwbas as abap.curr( 23,2))
end as hwbas_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.hwzuz as abap.curr( 23,2))
when 'S' then cast( bseg.hwzuz as abap.curr( 23,2))
else cast( bseg.hwzuz as abap.curr( 23,2))
end as hwzuz_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.bdiff as abap.curr( 23,2))
when 'S' then cast( bseg.bdiff as abap.curr( 23,2))
else cast( bseg.bdiff as abap.curr( 23,2))
end as bdiff_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.sknto as abap.curr( 23,2))
when 'S' then cast( bseg.sknto as abap.curr( 23,2))
else cast( bseg.sknto as abap.curr( 23,2))
end as sknto_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.dmbt1 as abap.curr( 23,2))
when 'S' then cast( bseg.dmbt1 as abap.curr( 23,2))
else cast( bseg.dmbt1 as abap.curr( 23,2))
end as dmbt1_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.dmbt2 as abap.curr( 23,2))
when 'S' then cast( bseg.dmbt2 as abap.curr( 23,2))
else cast( bseg.dmbt2 as abap.curr( 23,2))
end as dmbt2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.dmbt3 as abap.curr( 23,2))
when 'S' then cast( bseg.dmbt3 as abap.curr( 23,2))
else cast( bseg.dmbt3 as abap.curr( 23,2))
end as dmbt3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.blnbt as abap.curr( 23,2))
when 'S' then cast( bseg.blnbt as abap.curr( 23,2))
else cast( bseg.blnbt as abap.curr( 23,2))
end as blnbt_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.navhw as abap.curr( 23,2))
when 'S' then cast( bseg.navhw as abap.curr( 23,2))
else cast( bseg.navhw as abap.curr( 23,2))
end as navhw_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.rewrt as abap.curr( 23,2))
when 'S' then cast( bseg.rewrt as abap.curr( 23,2))
else cast( bseg.rewrt as abap.curr( 23,2))
end as rewrt_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.bonfb as abap.curr( 23,2))
when 'S' then cast( bseg.bonfb as abap.curr( 23,2))
else cast( bseg.bonfb as abap.curr( 23,2))
end as bonfb_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.nprei as abap.curr( 23,2))
when 'S' then cast( bseg.nprei as abap.curr( 23,2))
else cast( bseg.nprei as abap.curr( 23,2))
end as nprei_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.rdiff as abap.curr( 23,2))
when 'S' then cast( bseg.rdiff as abap.curr( 23,2))
else cast( bseg.rdiff as abap.curr( 23,2))
end as rdiff_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.ppdiff as abap.curr( 23,2))
when 'S' then cast( bseg.ppdiff as abap.curr( 23,2))
else cast( bseg.ppdiff as abap.curr( 23,2))
end as ppdiff_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
case bseg.shkzg when 'H' then cast(-bseg.penlc1 as abap.curr( 23,2))
when 'S' then cast( bseg.penlc1 as abap.curr( 23,2))
else cast( bseg.penlc1 as abap.curr( 23,2))
end as penlc1_shl ,
bseg.h_waers as h_waers,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.wrbtr as abap.curr( 23,2))
when 'S' then cast( bseg.wrbtr as abap.curr( 23,2))
else cast( bseg.wrbtr as abap.curr( 23,2))
end as wrbtr_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.txbfw as abap.curr( 23,2))
when 'S' then cast( bseg.txbfw as abap.curr( 23,2))
else cast( bseg.txbfw as abap.curr( 23,2))
end as txbfw_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.wmwst as abap.curr( 23,2))
when 'S' then cast( bseg.wmwst as abap.curr( 23,2))
else cast( bseg.wmwst as abap.curr( 23,2))
end as wmwst_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.fwbas as abap.curr( 23,2))
when 'S' then cast( bseg.fwbas as abap.curr( 23,2))
else cast( bseg.fwbas as abap.curr( 23,2))
end as fwbas_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.fwzuz as abap.curr( 23,2))
when 'S' then cast( bseg.fwzuz as abap.curr( 23,2))
else cast( bseg.fwzuz as abap.curr( 23,2))
end as fwzuz_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.qsshb as abap.curr( 23,2))
when 'S' then cast( bseg.qsshb as abap.curr( 23,2))
else cast( bseg.qsshb as abap.curr( 23,2))
end as qsshb_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.gbetr as abap.curr( 23,2))
when 'S' then cast( bseg.gbetr as abap.curr( 23,2))
else cast( bseg.gbetr as abap.curr( 23,2))
end as gbetr_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.fdwbt as abap.curr( 23,2))
when 'S' then cast( bseg.fdwbt as abap.curr( 23,2))
else cast( bseg.fdwbt as abap.curr( 23,2))
end as fdwbt_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.skfbt as abap.curr( 23,2))
when 'S' then cast( bseg.skfbt as abap.curr( 23,2))
else cast( bseg.skfbt as abap.curr( 23,2))
end as skfbt_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.wskto as abap.curr( 23,2))
when 'S' then cast( bseg.wskto as abap.curr( 23,2))
else cast( bseg.wskto as abap.curr( 23,2))
end as wskto_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.nebtr as abap.curr( 23,2))
when 'S' then cast( bseg.nebtr as abap.curr( 23,2))
else cast( bseg.nebtr as abap.curr( 23,2))
end as nebtr_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.wrbt1 as abap.curr( 23,2))
when 'S' then cast( bseg.wrbt1 as abap.curr( 23,2))
else cast( bseg.wrbt1 as abap.curr( 23,2))
end as wrbt1_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.wrbt2 as abap.curr( 23,2))
when 'S' then cast( bseg.wrbt2 as abap.curr( 23,2))
else cast( bseg.wrbt2 as abap.curr( 23,2))
end as wrbt2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.wrbt3 as abap.curr( 23,2))
when 'S' then cast( bseg.wrbt3 as abap.curr( 23,2))
else cast( bseg.wrbt3 as abap.curr( 23,2))
end as wrbt3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.qbshb as abap.curr( 23,2))
when 'S' then cast( bseg.qbshb as abap.curr( 23,2))
else cast( bseg.qbshb as abap.curr( 23,2))
end as qbshb_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.qsfbt as abap.curr( 23,2))
when 'S' then cast( bseg.qsfbt as abap.curr( 23,2))
else cast( bseg.qsfbt as abap.curr( 23,2))
end as qsfbt_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.navfw as abap.curr( 23,2))
when 'S' then cast( bseg.navfw as abap.curr( 23,2))
else cast( bseg.navfw as abap.curr( 23,2))
end as navfw_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.rewwr as abap.curr( 23,2))
when 'S' then cast( bseg.rewwr as abap.curr( 23,2))
else cast( bseg.rewwr as abap.curr( 23,2))
end as rewwr_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.bualt as abap.curr( 23,2))
when 'S' then cast( bseg.bualt as abap.curr( 23,2))
else cast( bseg.bualt as abap.curr( 23,2))
end as bualt_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.sctax as abap.curr( 23,2))
when 'S' then cast( bseg.sctax as abap.curr( 23,2))
else cast( bseg.sctax as abap.curr( 23,2))
end as sctax_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.sttax as abap.curr( 23,2))
when 'S' then cast( bseg.sttax as abap.curr( 23,2))
else cast( bseg.sttax as abap.curr( 23,2))
end as sttax_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.penfc as abap.curr( 23,2))
when 'S' then cast( bseg.penfc as abap.curr( 23,2))
else cast( bseg.penfc as abap.curr( 23,2))
end as penfc_shl ,
bseg.pswsl as pswsl,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'pswsl'} }
case bseg.shkzg when 'H' then cast(-bseg.pswbt as abap.curr( 23,2))
when 'S' then cast( bseg.pswbt as abap.curr( 23,2))
else cast( bseg.pswbt as abap.curr( 23,2))
end as pswbt_shl ,
bseg.h_hwae2 as h_hwae2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.bdif2 as abap.curr( 23,2))
when 'S' then cast( bseg.bdif2 as abap.curr( 23,2))
else cast( bseg.bdif2 as abap.curr( 23,2))
end as bdif2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.rdif2 as abap.curr( 23,2))
when 'S' then cast( bseg.rdif2 as abap.curr( 23,2))
else cast( bseg.rdif2 as abap.curr( 23,2))
end as rdif2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.dmbe2 as abap.curr( 23,2))
when 'S' then cast( bseg.dmbe2 as abap.curr( 23,2))
else cast( bseg.dmbe2 as abap.curr( 23,2))
end as dmbe2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.dmb21 as abap.curr( 23,2))
when 'S' then cast( bseg.dmb21 as abap.curr( 23,2))
else cast( bseg.dmb21 as abap.curr( 23,2))
end as dmb21_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.dmb22 as abap.curr( 23,2))
when 'S' then cast( bseg.dmb22 as abap.curr( 23,2))
else cast( bseg.dmb22 as abap.curr( 23,2))
end as dmb22_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.dmb23 as abap.curr( 23,2))
when 'S' then cast( bseg.dmb23 as abap.curr( 23,2))
else cast( bseg.dmb23 as abap.curr( 23,2))
end as dmb23_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.mwst2 as abap.curr( 23,2))
when 'S' then cast( bseg.mwst2 as abap.curr( 23,2))
else cast( bseg.mwst2 as abap.curr( 23,2))
end as mwst2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.navh2 as abap.curr( 23,2))
when 'S' then cast( bseg.navh2 as abap.curr( 23,2))
else cast( bseg.navh2 as abap.curr( 23,2))
end as navh2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.sknt2 as abap.curr( 23,2))
when 'S' then cast( bseg.sknt2 as abap.curr( 23,2))
else cast( bseg.sknt2 as abap.curr( 23,2))
end as sknt2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.txbh2 as abap.curr( 23,2))
when 'S' then cast( bseg.txbh2 as abap.curr( 23,2))
else cast( bseg.txbh2 as abap.curr( 23,2))
end as txbh2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.ppdif2 as abap.curr( 23,2))
when 'S' then cast( bseg.ppdif2 as abap.curr( 23,2))
else cast( bseg.ppdif2 as abap.curr( 23,2))
end as ppdif2_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
case bseg.shkzg when 'H' then cast(-bseg.penlc2 as abap.curr( 23,2))
when 'S' then cast( bseg.penlc2 as abap.curr( 23,2))
else cast( bseg.penlc2 as abap.curr( 23,2))
end as penlc2_shl ,
bseg.h_hwae3 as h_hwae3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.dmbe3 as abap.curr( 23,2))
when 'S' then cast( bseg.dmbe3 as abap.curr( 23,2))
else cast( bseg.dmbe3 as abap.curr( 23,2))
end as dmbe3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.dmb31 as abap.curr( 23,2))
when 'S' then cast( bseg.dmb31 as abap.curr( 23,2))
else cast( bseg.dmb31 as abap.curr( 23,2))
end as dmb31_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.dmb32 as abap.curr( 23,2))
when 'S' then cast( bseg.dmb32 as abap.curr( 23,2))
else cast( bseg.dmb32 as abap.curr( 23,2))
end as dmb32_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.dmb33 as abap.curr( 23,2))
when 'S' then cast( bseg.dmb33 as abap.curr( 23,2))
else cast( bseg.dmb33 as abap.curr( 23,2))
end as dmb33_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.mwst3 as abap.curr( 23,2))
when 'S' then cast( bseg.mwst3 as abap.curr( 23,2))
else cast( bseg.mwst3 as abap.curr( 23,2))
end as mwst3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.navh3 as abap.curr( 23,2))
when 'S' then cast( bseg.navh3 as abap.curr( 23,2))
else cast( bseg.navh3 as abap.curr( 23,2))
end as navh3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.sknt3 as abap.curr( 23,2))
when 'S' then cast( bseg.sknt3 as abap.curr( 23,2))
else cast( bseg.sknt3 as abap.curr( 23,2))
end as sknt3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.bdif3 as abap.curr( 23,2))
when 'S' then cast( bseg.bdif3 as abap.curr( 23,2))
else cast( bseg.bdif3 as abap.curr( 23,2))
end as bdif3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.rdif3 as abap.curr( 23,2))
when 'S' then cast( bseg.rdif3 as abap.curr( 23,2))
else cast( bseg.rdif3 as abap.curr( 23,2))
end as rdif3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.txbh3 as abap.curr( 23,2))
when 'S' then cast( bseg.txbh3 as abap.curr( 23,2))
else cast( bseg.txbh3 as abap.curr( 23,2))
end as txbh3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.ppdif3 as abap.curr( 23,2))
when 'S' then cast( bseg.ppdif3 as abap.curr( 23,2))
else cast( bseg.ppdif3 as abap.curr( 23,2))
end as ppdif3_shl ,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
case bseg.shkzg when 'H' then cast(-bseg.penlc3 as abap.curr( 23,2))
when 'S' then cast( bseg.penlc3 as abap.curr( 23,2))
else cast( bseg.penlc3 as abap.curr( 23,2))
end as penlc3_shl ,
// Functional Currency
bseg.rfccur as rfccur,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'rfccur'} }
case bseg.shkzg when 'H' then -bseg.fcsl
when 'S' then bseg.fcsl
else bseg.fcsl
end as fcsl_shl ,
bseg.pycur as pycur,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'pycur'} }
case bseg.shkzg when 'H' then cast(-bseg.pyamt as abap.curr( 23,2))
when 'S' then cast( bseg.pyamt as abap.curr( 23,2))
else cast( bseg.pyamt as abap.curr( 23,2))
end as pyamt_shl ,
t014.waers as t014_waers,
@Semantics: { amount : {currencyCode: 't014_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.klibt as abap.curr( 23,2))
when 'S' then cast( bseg.klibt as abap.curr( 23,2))
else cast( bseg.klibt as abap.curr( 23,2))
end as klibt_shl ,
@Semantics: { amount : {currencyCode: 't014_waers'} }
case bseg.shkzg when 'H' then cast(-bseg.absbt as abap.curr( 23,2))
when 'S' then cast( bseg.absbt as abap.curr( 23,2))
else cast( bseg.absbt as abap.curr( 23,2))
end as absbt_shl ,
bseg.meins as meins,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'meins'} } bseg.menge,
bseg.erfme as erfme,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'erfme'} } bseg.erfmg,
bseg.bprme as bprme,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'bprme'} } bseg.bpmng,
bseg.peinh as peinh,
case bseg.xnegp when 'X' then case bseg.shkzg when 'S' then 'H'
when 'H' then 'S'
end
when ' ' then bseg.shkzg
else bseg.shkzg
end as shkzg_calc,
///////////////////////////////////////////////////////////////////////////////
//Absolute Amount (Original BSEG Amounts)
///////////////////////////////////////////////////////////////////////////////
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.dmbtr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.wrbtr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.dmbe2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.dmbe3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'pswsl'} }
bseg.pswbt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'rfccur'} }
bseg.fcsl,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'pycur'} }
bseg.pyamt,
@Semantics: { amount : {currencyCode: 't014_waers'} }
bseg.absbt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.fdwbt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.sknto,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.wskto,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.skfbt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.rewrt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.rewwr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.nebtr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.navhw,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.navfw,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.mwsts,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.wmwst,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.mwst2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.mwst3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.hwbas,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.fwbas,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.txbhw,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.txbfw,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.txbh2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.txbh3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.dmbt1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.dmbt2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.dmbt3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.wrbt1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.wrbt2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.wrbt3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.qsfbt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.qbshb,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.qsshb,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.bdiff,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.bdif2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.bdif3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.kzbtr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.hwzuz,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.fwzuz,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.gbetr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.blnbt,
@Semantics: { amount : {currencyCode: 't014_waers'} }
bseg.klibt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.bonfb,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.rdiff,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.rdif2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.dmb21,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.dmb22,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.dmb23,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.dmb31,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.dmb32,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.dmb33,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.navh2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.navh3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.sknt2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.sknt3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.rdif3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.ppdiff,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.ppdif2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.ppdif3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
bseg.penlc1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} }
bseg.penlc2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} }
bseg.penlc3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
bseg.penfc,
bseg.shkzg as shkzg_unadjusted,
bseg.rbl_fincg_status,
@Aggregation.default: #SUM
cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm preserving type ) as nbritm,
///////////////////////////////////////////////////////////////////////////////
//GST India BSEG Append
///////////////////////////////////////////////////////////////////////////////
bseg.gst_part,
bseg.plc_sup,
bseg.hsn_sac,
bseg.irn,
cast(bseg.dp_payment_type as fis_dp_payment_type preserving type ) as dp_payment_type,
cast(bseg.dp_trans_id as fis_dp_transid preserving type ) as dp_trans_id
}