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