P_BSEG_COM

@AbapCatalog.compiler.compareFilter: true
//@EndUserText.label: 'Operational Accounting Document Item'

@AbapCatalog.sqlViewName: 'PFIBSEGCOM'
@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_COM as select from P_BSEG_COM1 left outer to one join t001 on P_BSEG_COM1.bukrs = t001.bukrs
{
key cast( P_BSEG_COM1.bukrs as fis_bukrs preserving type ) as bukrs ,
key cast( belnr as farp_belnr_d preserving type )          as belnr,
key cast( gjahr as fis_gjahr_no_conv preserving type )     as gjahr,
key cast( buzei as fis_buzei preserving type )             as buzei,

cast( ktopl as fis_ktopl preserving type ) as ktopl,

buzid,
cast( augdt as fis_augdt preserving type ) as augdt,
cast( augcp as fis_augcp preserving type ) as augcp,
cast( augbl as fis_augbl preserving type ) as augbl,
cast( bschl as fis_bschl preserving type ) as bschl,
cast( koart as farp_koart preserving type ) as koart,
cast( umskz as fac_umskz preserving type ) as umskz,
cast( umsks as farp_umsks preserving type ) as umsks,
zumsk,
//shkzg,

cast( gsber as fis_rbusa preserving type ) as gsber,
cast(pargb as fis_pargb preserving type ) as pargb,
tax_country,
cast( mwskz as fis_mwskz preserving type ) as mwskz,
txdat_from,
cast( qsskz as fac_qsskz preserving type ) as qsskz,
shzuz,
stekz,
mwart,
txgrp,
cast( ktosl as fac_ktosl preserving type ) as ktosl,
kursr,
valut,
cast( zuonr as fis_zuonr preserving type ) as zuonr,
cast( sgtxt as farp_sgtxt preserving type ) as sgtxt,
zinkz,
cast( vbund as fis_rassc preserving type ) as vbund,
cast( bewar as fis_rmvct preserving type ) as bewar,
cast( altkt as fis_bilkt_ska1 preserving type ) as altkt,
vorgn,
fdlev,
fdgrp,
fdtag,
fkont,
cast( kokrs as fis_kokrs preserving type ) as kokrs,
cast( kostl as fis_kostl preserving type ) as kostl,
cast( projn as ps_pspid ) as projn,
cast( aufnr as fis_aufnr preserving type ) as aufnr,
vbeln,
vbel2,
cast( posn2 as fis_posnr_va preserving type ) as posn2,
cast( eten2 as fis_etenr preserving type ) as eten2,
service_doc_type,
service_doc_id,
service_doc_item_id,
cast( anln1 as fis_anln1 preserving type ) as anln1,
cast( anln2 as fis_anln2 preserving type ) as anln2,
anbwa,
bzdat,
pernr,
cast( xumsw as fis_xumsw preserving type ) as xumsw,
xhres,
cast( xkres as fis_xkres preserving type ) as xkres,
cast( xopvw as fis_xopvw preserving type ) as xopvw,
xcpdd,
xskst,
xsauf,
xspro,
xserg,
xfakt,
xuman,
xanet,
cast( xskrl as fis_xskrl preserving type ) as xskrl,
xinve,
xpanz,
cast( xauto as fis_xauto preserving type ) as xauto,
xncop,
cast( xzahl as fis_xzahl preserving type ) as xzahl,
cast( saknr as fis_op_saknr preserving type ) as saknr,
cast( hkont as fis_racct preserving type ) as hkont,
cast( kunnr as kunnr preserving type ) as kunnr,
cast( lifnr as md_supplier preserving type ) as lifnr,
cast( filkd as fis_filkd preserving type ) as filkd,
cast( xbilk as fis_xbilk preserving type ) as xbilk,
cast( gvtyp as fis_gvtyp preserving type ) as gvtyp,
cast( hzuon as fins_hzuon preserving type ) as hzuon,
cast( zfbdt as fis_dzfbdt preserving type ) as zfbdt,
cast( zterm as farp_dzterm preserving type ) as zterm,
cast( zbd1t as farp_dzbd1t preserving type ) as zbd1t,
cast( zbd2t as farp_dzbd2t preserving type ) as zbd2t,
cast( zbd3t as farp_dzbd3t preserving type ) as zbd3t,
cast( zbd1p as dzbd1p_farp preserving type ) as zbd1p,
cast( zbd2p as dzbd2p_farp preserving type ) as zbd2p,
cast( zlsch as farp_schzw_bseg preserving type ) as zlsch,
cast( zlspr as fis_dzlspr preserving type ) as zlspr,
cast( zbfix as fis_dzbfix preserving type ) as zbfix,
cast( hbkid as farp_hbkid preserving type ) as hbkid,
cast( bvtyp as farp_bvtyp preserving type ) as bvtyp,
cast( mwsk1 as fis_mwsk1 preserving type ) as mwsk1,
cast( mwsk2 as fis_mwsk2 preserving type ) as mwsk2,
cast( mwsk3 as fis_mwsk3 preserving type ) as mwsk3,
cast( rebzg as fis_rebzg preserving type ) as rebzg,
cast( rebzj as fis_rebzj_no_conv preserving type ) as rebzj,
cast( rebzz as fis_rebzz preserving type ) as rebzz,
cast( rebzt as farp_rebzt preserving type ) as rebzt,
zollt,
zolld,
lzbkz,
cast( landl as fac_landl preserving type ) as landl,
diekz,
cast( samnr as fis_samnr preserving type ) as samnr,
abper,
vrskz,
vrsdt,
cast( disbn as fis_disbn preserving type ) as disbn,
disbj,
disbz,
cast( wverw as farp_wverw preserving type ) as wverw,
anfbn,
anfbj,
anfbu,
anfae,
blnkz,
blnpz,
cast( mschl as farp_mschl preserving type ) as mschl,
cast( mansp as fis_mansp preserving type ) as mansp,
cast( madat as farp_madat preserving type ) as madat,
cast( manst as farp_mahns_d preserving type ) as manst,
cast( maber as farp_maber preserving type ) as maber,
cast( esrnr as fis_esrnr preserving type ) as esrnr,
cast( esrre as fis_esrre preserving type ) as esrre,
cast( esrpz as fis_esrpz preserving type ) as esrpz,
cast( qsznr as fis_wtcert preserving type ) as qsznr,
matnr,
werks,
cast( ebeln as fis_ebeln preserving type ) as ebeln,
cast( ebelp as fis_ebelp preserving type ) as ebelp,
zekkn,
cast( elikz as fis_elikz preserving type ) as elikz,
cast( vprsv as fis_vprsv preserving type ) as vprsv,
bwkey,
bwtar,
bustw,
psalt,
tbtkz,
spgrp,
spgrm,
spgrt,
spgrg,
spgrv,
spgrq,
cast(P_BSEG_COM1.stceg as fis_stceg preserving type ) as stceg,
egbld,
eglld,
cast( rstgr as fis_rstgr preserving type ) as rstgr,
ryacq,
rpacq,
cast( prctr as fis_prctr preserving type ) as prctr,
xhkom,
vname,
recid,
cast( egrup as jv_egroup_cds preserving type ) as egrup,
vptnr,
cast( vertt as fis_rantyp preserving type ) as vertt,
cast( vertn as fis_ranl preserving type ) as vertn,
cast( vbewa as farp_sbewart preserving type ) as vbewa,
depot,
cast( P_BSEG_COM1.txjcd as fis_txjcd preserving type ) as txjcd,
cast( imkey as fis_imkey preserving type ) as imkey,
cast( dabrz as farp_dabrbez preserving type ) as dabrz,
popts,
cast( fipos as fis_fipos preserving type ) as fipos,
kstrg,
nplnr,
cast( aufpl as fis_ordintbillofops preserving type ) as aufpl,
cast( aplzl as fis_ordintbillofopitm preserving type ) as aplzl,
cast( projk as ps_posnr preserving type ) as projk,
paobjnr,
pasubnr,
spgrs,
spgrc,
btype,
cast( etype as jv_etype_cds preserving type ) as etype,
cast( xegdr as fis_xegdr preserving type ) as xegdr,
lnran,
hrkft,
cast( hwmet as fac_hwmet preserving type ) as hwmet,
glupm,
cast( xragl as fis_xragl preserving type ) as xragl,
cast( uzawe as farp_uzawe preserving type ) as uzawe,
cast( lokkt as fis_altkt_skb1 preserving type ) as lokkt,
cast( fistl as farp_fistl preserving type ) as fistl,
geber,
stbuk,
cast( pprct as fis_pprctr preserving type ) as pprct,
cast( xref1 as fis_xref1 preserving type ) as xref1,
cast( xref2 as fis_xref2 preserving type ) as xref2,
kblnr,
kblpos,
cast( fkber as fm_farea ) as fkber,
obzei,
cast( P_BSEG_COM1.xnegp as fis_xnegp preserving type ) as xnegp,
cast( rfzei as fis_rfzei_cc preserving type ) as rfzei,
cast( ccbtc as fis_ccbtc preserving type ) as ccbtc,
cast( P_BSEG_COM1.kkber as farp_kkber preserving type ) as kkber,
cast( P_BSEG_COM1.empfb as fis_empfb preserving type ) as empfb,
cast( xref3 as fis_xref3 preserving type ) as xref3,
cast( dtws1 as fis_dtat16 preserving type ) as dtws1,
cast( dtws2 as fis_dtat17 preserving type ) as dtws2,
cast( dtws3 as fis_dtat18 preserving type ) as dtws3,
cast( dtws4 as fis_dtat19 preserving type ) as dtws4,
gricd,
grirg,
gityp,
cast( xpypr as farp_xpypr preserving type ) as xpypr,
cast( kidno as farp_kidno preserving type ) as kidno,
idxsp,
linfv,
kontt,
kontl,
//uebgdat,

cast( txdat as fis_txdat preserving type ) as txdat,
cast( agzei as fis_agzei preserving type ) as agzei,
cast( bupla as farp_bupla preserving type ) as bupla,
cast( secco as fis_secco preserving type ) as secco,
lstar,
cast( cession_kz as fis_cession_kz preserving type ) as cession_kz,
prznr,
pendays,
penrc,
grant_nbr,
cast( fkber_long as fm_farea preserving type ) as fkber_long,
cast( gmvkz as fis_gmvkzd preserving type ) as gmvkz,
srtype,
intreno,
measure,
cast( auggj as fis_auggj_no_conv preserving type ) as auggj,
ppa_ex_ind,
cast( docln as fis_docln preserving type ) as docln,
segment,
psegment,
cast(pfkber as fis_sfkber preserving type ) as pfkber,
cast( hktid as fac_hktid preserving type ) as hktid,
kstar,
xlgclr,
taxps,
cast( pays_prov as farp_payment_srv_provider preserving type ) as pays_prov,
cast( pays_tran as farp_fps_transaction preserving type ) as pays_tran,
cast( mndid as fis_sepa_mndid preserving type ) as mndid,
xfrge_bseg,
cast( awtyp as fis_awtyp preserving type ) as awtyp,
cast( awkey as fis_awkey preserving type ) as awkey,
cast( awsys as fis_awsys preserving type ) as awsys,
cast( posnr as fis_posnr_acc preserving type ) as posnr,
//buzei_sender,

cast( h_monat as fins_fiscalperiod preserving type ) as h_monat,
cast( h_bstat as fis_bstat preserving type ) as h_bstat,
cast( h_budat as fis_budat preserving type ) as h_budat,
cast( h_bldat as fis_bldat preserving type ) as h_bldat,
cast( h_blart as farp_blart preserving type ) as h_blart,
cast( netdt as farp_netdt preserving type ) as netdt,
cast( sk1dt as farp_sk1dt preserving type ) as sk1dt,
cast( sk2dt as farp_sk2dt preserving type ) as sk2dt,
//fqftype,

lqitem,
cast( gkont as fis_gkont preserving type ) as gkont,
cast( gkart as farp_gkoar preserving type ) as gkart,

cast( ( case gkart
             when 'D' then ' '
             when 'K' then ' '
             else ktopl
        end )
as fis_offsettingktopl ) as gktopl,
ghkon,
cast( pgeber as bp_p_geber preserving type ) as 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,

cast( re_bukrs as fis_re_bukrs preserving type ) as re_bukrs,
cast( re_account as fis_re_account preserving type ) as re_account,

bdgt_account_cocode,
bdgt_account,

cast(P_BSEG_COM1.fs_product_group as fis_ffs_product_group preserving type ) as FS_PRODUCT_GROUP,
cast(P_BSEG_COM1.branch_id as fis_ffs_branch_id preserving type ) as BRANCH_ID,
cast(P_BSEG_COM1.datasource_id as fis_ffs_datasource_id preserving type ) as DATASOURCE_ID, 
P_BSEG_COM1.kdgrp,
cast( P_BSEG_COM1.land1 as fis_land1_gp preserving type ) as land1,            
cast( P_BSEG_COM1.brsch as fis_brsch preserving type ) as brsch,

///////////////////////////////////////////////////////////////////////////////

//GST India BSEG Append

///////////////////////////////////////////////////////////////////////////////

gst_part,
plc_sup,
hsn_sac,

@Semantics.currencyCode:true
cast( h_hwaer as fis_hwaer preserving type ) as h_hwaer,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( dmbtr_shl as fis_hsl preserving type ) as dmbtr_shl ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } kzbtr_shl ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } txbhw_shl ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( mwsts_shl     as fis_mwsts    preserving type ) as mwsts_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( hwbas_shl     as hwbas_shl    preserving type ) as hwbas_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } hwzuz_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( bdiff_shl     as fis_bdiff    preserving type ) as bdiff_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( sknto_shl     as fis_sknto    preserving type ) as sknto_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( dmbt1_shl     as fis_txw_dmbt1 preserving type ) as dmbt1_shl   ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( dmbt2_shl     as fis_txw_dmbt2 preserving type ) as dmbt2_shl   ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( dmbt2_shl     as fis_txw_dmbt3 preserving type ) as dmbt3_shl   ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } blnbt_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( navhw_shl    as fis_navhw preserving type ) as navhw_shl,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( rewrt_shl     as fis_reewr    preserving type ) as rewrt_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } bonfb_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } nprei_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } rdiff_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } ppdiff_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } penlc1_shl    ,


@Semantics.currencyCode:true
cast( h_waers as fis_rwcur ) as h_waers,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( wrbtr_shl     as fis_wsl     preserving type ) as wrbtr_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( txbfw_shl     as txbfw_shl   preserving type ) as txbfw_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( wmwst_shl     as wmwst_shl   preserving type ) as wmwst_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( fwbas_shl     as fwbas_shl   preserving type ) as fwbas_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } fwzuz_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( qsshb_shl     as fis_qsshb   preserving type ) as qsshb_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } gbetr_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( fdwbt_shl     as fis_fdwbt   preserving type ) as fdwbt_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( skfbt_shl     as fis_skfbt   preserving type ) as skfbt_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( wskto_shl     as fis_wskto   preserving type ) as wskto_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( nebtr_shl     as fis_nebtr   preserving type ) as nebtr_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( wrbt1_shl     as fis_txw_wrbt1 preserving type ) as wrbt1_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( wrbt2_shl     as fis_txw_wrbt2 preserving type ) as wrbt2_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( wrbt3_shl     as fis_txw_wrbt3 preserving type ) as wrbt3_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( qbshb_shl     as fis_qbshb   preserving type ) as qbshb_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( qsfbt_shl     as fis_qsfbt   preserving type ) as qsfbt_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( navfw_shl    as fis_navfw  preserving type ) as navfw_shl,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( rewwr_shl     as fis_refwr   preserving type ) as rewwr_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } bualt_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } sctax_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } sttax_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } penfc_shl    ,


@Semantics.currencyCode:true
cast( pswsl as fis_rtcur ) as pswsl,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'pswsl'} } cast( pswbt_shl     as fis_tsl       preserving type ) as pswbt_shl    ,


@Semantics.currencyCode:true
cast( h_hwae2 as fis_hwae2 ) as h_hwae2,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } cast( bdif2_shl     as fis_bdif2   preserving type ) as bdif2_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } rdif2_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } cast( dmbe2_shl     as fis_dmbe2   preserving type ) as dmbe2_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } dmb21_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } dmb22_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } dmb23_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } cast( mwst2_shl     as fis_mwst2    preserving type ) as mwst2_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } navh2_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } sknt2_shl   ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } txbh2_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } ppdif2_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } penlc2_shl    ,


@Semantics.currencyCode:true
cast( h_hwae3 as fis_hwae3 ) as h_hwae3,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } cast( dmbe3_shl     as fis_dmbe3     preserving type ) as dmbe3_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } dmb31_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } dmb32_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } dmb33_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } cast( mwst3_shl     as fis_mwst3    preserving type ) as mwst3_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } navh3_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } sknt3_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } cast( bdif3_shl     as fis_bdif3    preserving type ) as bdif3_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } rdif3_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } txbh3_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } ppdif3_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } penlc3_shl    ,

// Functional Currency

@Semantics.currencyCode:true
rfccur as rfccur,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'rfccur'} }
cast( fcsl_shl as fis_vfccur12 preserving type) as fcsl_shl,
   
@Semantics.currencyCode:true
cast( pycur as farp_pycur ) as pycur,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 'pycur'} } cast( pyamt_shl     as fis_pyamt    preserving type ) as pyamt_shl    ,

@Semantics.currencyCode:true
cast( t014_waers as fis_kkbwr ) as t014_waers,
@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 't014_waers'} } klibt_shl    ,

@DefaultAggregation: #SUM
@Semantics: { amount : {currencyCode: 't014_waers'} } cast( absbt_shl     as absbt_farp    preserving type ) as absbt_shl    ,

@Semantics.unitOfMeasure:true
meins as meins,
@DefaultAggregation: #SUM
@Semantics: { quantity : {unitOfMeasure: 'meins'} } cast( cast( menge as abap.quan(23,3) ) as  quan1_12 ) as menge,

@Semantics.unitOfMeasure:true
erfme as erfme,
@DefaultAggregation: #SUM
// @Semantics: { quantity : {unitOfMeasure: 'erfme'} }    cast( erfmg as quantityinentryunit ) as erfmg,

@Semantics: { quantity : {unitOfMeasure: 'meins'} } cast( cast( erfmg as abap.quan(23,3) ) as  fis_quantityinentryunit ) as erfmg,

@Semantics.unitOfMeasure:true
cast( bprme as fis_bprme preserving type ) as bprme,
@DefaultAggregation: #SUM
//@Semantics: { quantity : {unitOfMeasure: 'bprme'} }    cast ( bpmng as fis_bpmng ) as bpmng,

@Semantics: { quantity : {unitOfMeasure: 'meins'} } cast( cast( bpmng as abap.quan(23,3) ) as  fis_bpmng_long ) as bpmng,

cast( peinh as fis_peinh preserving type ) as peinh,

cast( shkzg_calc as fis_shkzg preserving type ) as shkzg,


nbritm

}
where
  (
    h_bstat <> 'D'
  )
  and(
    h_bstat <> 'M'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_BSEG_COM1",
"T001"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/