P_BSEG_ADD_COM1

@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":""
}
}*/