@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'PFIBSEGADDCOM1'
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
define view 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 bukrs,
key belnr,
key gjahr,
key buzei,
buzid,
augdt,
augcp,
augbl,
bschl,
koart,
shkzg,
gsber,
pargb,
mwskz,
qsskz,
ktosl,
valut,
zuonr,
sgtxt,
vbund,
bewar,
altkt,
vorgn,
fkont,
kokrs,
kostl,
projn,
aufnr,
anln1,
anln2,
anbwa,
xopvw,
xauto,
xncop,
hkont,
xbilk,
gvtyp,
zfbdt,
rebzg,
rebzj,
rebzz,
rebzt,
wverw,
matnr,
werks,
bwkey,
bwtar,
prctr,
vname,
recid,
egrup,
vptnr,
vertt,
vertn,
vbewa,
txjcd,
imkey,
dabrz,
fipos,
kstrg,
nplnr,
aufpl,
aplzl,
projk,
paobjnr,
pasubnr,
xragl,
uzawe,
lokkt,
fistl,
geber,
pprct,
xref1,
xref2,
kblnr,
kblpos,
fkber,
obzei,
xnegp,
rfzei,
ccbtc,
xref3,
kontt,
kontl,
agzei,
bupla,
secco,
lstar,
prznr,
grant_nbr,
intreno,
measure,
auggj,
segment,
psegment,
pfkber,
kstar,
xlgclr,
netdt,
gkont,
gkart,
ghkon,
pgeber,
pgrant_nbr,
budget_pd,
pbudget_pd,
prodper,
re_bukrs,
re_account,
bdgt_account_cocode,
bdgt_account,
@Semantics.currencyCode:true
_P_BKPF_COM.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(-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(-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(-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 ,
@Semantics.currencyCode:true
_P_BKPF_COM.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(-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 ,
@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
_P_BKPF_COM.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(-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(-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 ,
@Semantics.currencyCode:true
_P_BKPF_COM.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(-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(-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(-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 ,
// 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.unitOfMeasure:true
meins as meins,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'meins'} } menge,
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,
bstat,
//DMBTR,
//WRBTR,
//DMBE2,
//DMBE3,
//PSWBT,
//RDIFF,
//RDIF2,
//RDIF3,
buzei_sender
//BDIF2,
//BDIF3,
//BDIFF,
//MWST2,
//MWST3,
//MWSTS,
//PPDIF2,
//PPDIF3,
//PPDIFF,
//WMWST
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_BKPF_COM",
"BSEG_ADD"
],
"ASSOCIATED":
[
"P_BKPF_COM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/