P_BSEG_COM

 @AbapCatalog.entityBuffer.definitionAllowed: false
 @VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
define view entity P_BSEG_COM as select from P_BSEG_COM1 as 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( P_BSEG_COM1.belnr as farp_belnr_d preserving type )          as belnr,
key cast( P_BSEG_COM1.gjahr as fis_gjahr_no_conv preserving type )     as gjahr,
key cast( P_BSEG_COM1.buzei as fis_buzei preserving type )             as buzei,

cast( t001.ktopl as fis_ktopl preserving type ) as ktopl,

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

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

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

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

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

cast( ( case P_BSEG_COM1.gkart
             when 'D' then ' '
             when 'K' then ' '
             else t001.ktopl
        end ) as fis_offsettingktopl preserving type ) as gktopl,
P_BSEG_COM1.ghkon,
cast( P_BSEG_COM1.pgeber as bp_p_geber preserving type ) as pgeber,
P_BSEG_COM1.pgrant_nbr,
P_BSEG_COM1.budget_pd,
P_BSEG_COM1.pbudget_pd,
P_BSEG_COM1.j_1tpbupl,
P_BSEG_COM1.perop_beg,
P_BSEG_COM1.perop_end,
P_BSEG_COM1.fastpay,
P_BSEG_COM1.ignr_ivref,
P_BSEG_COM1.fmfgus_key,
P_BSEG_COM1.fmxdocnr,
P_BSEG_COM1.fmxyear,
P_BSEG_COM1.fmxdocln,
P_BSEG_COM1.fmxzekkn,
P_BSEG_COM1.prodper,

P_BSEG_COM1.glo_ref1,
P_BSEG_COM1.payt_rsn,

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

P_BSEG_COM1.bdgt_account_cocode,
P_BSEG_COM1.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

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

P_BSEG_COM1.gst_part,
P_BSEG_COM1.plc_sup,
P_BSEG_COM1.hsn_sac,
cast( P_BSEG_COM1.irn as j_1ig_irnid preserving type ) as irn,

cast( P_BSEG_COM1.h_hwaer as fis_hwaer preserving type ) as h_hwaer,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } P_BSEG_COM1.kzbtr_shl ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( P_BSEG_COM1.txbhw_shl    as fis_txbhw    preserving type ) as txbhw_shl    ,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } cast( P_BSEG_COM1.hwbas_shl     as hwbas_shl    preserving type ) as hwbas_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } P_BSEG_COM1.hwzuz_shl    ,

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

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

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

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

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } P_BSEG_COM1.blnbt_shl    ,

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

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } P_BSEG_COM1.bonfb_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } P_BSEG_COM1.nprei_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } P_BSEG_COM1.rdiff_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } P_BSEG_COM1.ppdiff_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } P_BSEG_COM1.penlc1_shl    ,


cast( P_BSEG_COM1.h_waers as fis_rwcur preserving type ) as h_waers,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( P_BSEG_COM1.txbfw_shl     as txbfw_shl   preserving type ) as txbfw_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( P_BSEG_COM1.wmwst_shl     as wmwst_shl   preserving type ) as wmwst_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } cast( P_BSEG_COM1.fwbas_shl     as fwbas_shl   preserving type ) as fwbas_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } P_BSEG_COM1.fwzuz_shl    ,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } P_BSEG_COM1.gbetr_shl    ,

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

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

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

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

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

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

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

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

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

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

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } P_BSEG_COM1.bualt_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } P_BSEG_COM1.sctax_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } P_BSEG_COM1.sttax_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } P_BSEG_COM1.penfc_shl    ,


cast( P_BSEG_COM1.pswsl as fis_rtcur preserving type ) as pswsl,

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


cast( P_BSEG_COM1.h_hwae2 as fis_hwae2 preserving type ) as h_hwae2,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } P_BSEG_COM1.rdif2_shl    ,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } P_BSEG_COM1.dmb21_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } P_BSEG_COM1.dmb22_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } P_BSEG_COM1.dmb23_shl    ,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } P_BSEG_COM1.navh2_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } P_BSEG_COM1.sknt2_shl   ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } cast( P_BSEG_COM1.txbh2_shl    as fis_txbh2    preserving type ) as txbh2_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } P_BSEG_COM1.ppdif2_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } P_BSEG_COM1.penlc2_shl    ,


cast( P_BSEG_COM1.h_hwae3 as fis_hwae3 preserving type ) as h_hwae3,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } P_BSEG_COM1.dmb31_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } P_BSEG_COM1.dmb32_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } P_BSEG_COM1.dmb33_shl    ,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } P_BSEG_COM1.navh3_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } P_BSEG_COM1.sknt3_shl    ,

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } P_BSEG_COM1.rdif3_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } cast( P_BSEG_COM1.txbh3_shl    as fis_txbh3    preserving type ) as txbh3_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } P_BSEG_COM1.ppdif3_shl    ,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } P_BSEG_COM1.penlc3_shl    ,

// Functional Currency

P_BSEG_COM1.rfccur as rfccur,

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

cast( P_BSEG_COM1.t014_waers as fis_kkbwr preserving type ) as t014_waers,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 't014_waers'} } P_BSEG_COM1.klibt_shl    ,

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

P_BSEG_COM1.meins as meins,
@Aggregation.default: #SUM
@Semantics: { quantity : {unitOfMeasure: 'meins'} } cast( cast( P_BSEG_COM1.menge as abap.quan(23,3) ) as  quan1_12 preserving type ) as menge,

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

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

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

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

cast( P_BSEG_COM1.peinh as fis_peinh preserving type ) as peinh,

cast( P_BSEG_COM1.shkzg_calc as fis_shkzg preserving type ) as shkzg,

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

//Absolute Amount (Original BSEG Amounts)

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

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
cast( P_BSEG_COM1.dmbtr as fis_abs_hsl preserving type ) as dmbtr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.wrbtr as fis_abs_wsl preserving type ) as wrbtr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
cast( P_BSEG_COM1.dmbe2 as fis_abs_dmbe2 preserving type ) as dmbe2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
cast( P_BSEG_COM1.dmbe3 as fis_abs_dmbe3 preserving type ) as dmbe3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'pswsl'} } 
cast( P_BSEG_COM1.pswbt as fis_abs_tsl preserving type ) as pswbt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'rfccur'} }
cast( P_BSEG_COM1.fcsl as fis_abs_vfccur12 preserving type ) as fcsl,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'pycur'} } 
cast( P_BSEG_COM1.pyamt as fis_abs_pyamt preserving type ) as pyamt,

@Semantics: { amount : {currencyCode: 't014_waers'} }                                                                                                       
cast( P_BSEG_COM1.absbt as fis_abs_absbt_farp preserving type ) as absbt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.fdwbt as fis_abs_fdwbt preserving type ) as fdwbt,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
cast( P_BSEG_COM1.sknto as fis_abs_sknto preserving type ) as sknto,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.wskto as fis_abs_wskto preserving type ) as wskto,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.skfbt as fis_abs_skfbt preserving type ) as skfbt,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
cast( P_BSEG_COM1.rewrt as fis_abs_reewr )                 as rewrt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.rewwr as fis_abs_refwr preserving type ) as rewwr,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.nebtr as fis_abs_nebtr preserving type ) as nebtr,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
cast( P_BSEG_COM1.navhw as fis_abs_navhw preserving type ) as navhw,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.navfw as fis_abs_navfw preserving type ) as navfw,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} }
cast( P_BSEG_COM1.mwsts as fis_abs_mwsts preserving type ) as mwsts,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.wmwst as fis_abs_wmwst preserving type ) as wmwst,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
cast( P_BSEG_COM1.mwst2 as fis_abs_mwst2 preserving type ) as mwst2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
cast( P_BSEG_COM1.mwst3 as fis_abs_mwst3 preserving type ) as mwst3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
cast( P_BSEG_COM1.hwbas as fis_abs_hwbas preserving type ) as hwbas,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.fwbas as fis_abs_fwbas preserving type ) as fwbas,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
cast( P_BSEG_COM1.txbhw as fis_abs_txbhw preserving type ) as txbhw,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.txbfw as fis_abs_txbfw preserving type ) as txbfw,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
cast( P_BSEG_COM1.txbh2 as fis_abs_txbh2 preserving type ) as txbh2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
cast( P_BSEG_COM1.txbh3 as fis_abs_txbh3 preserving type ) as txbh3,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
cast( P_BSEG_COM1.dmbt1 as fis_abs_txw_dmbt1 preserving type ) as dmbt1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
cast( P_BSEG_COM1.dmbt2 as fis_abs_txw_dmbt2 preserving type ) as dmbt2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
cast( P_BSEG_COM1.dmbt3 as fis_abs_txw_dmbt3 preserving type ) as dmbt3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
cast( P_BSEG_COM1.wrbt1 as fis_abs_txw_wrbt1 preserving type ) as wrbt1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
cast( P_BSEG_COM1.wrbt2 as fis_abs_txw_wrbt2 preserving type ) as wrbt2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
cast( P_BSEG_COM1.wrbt3 as fis_abs_txw_wrbt3 preserving type ) as wrbt3,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.qsfbt as fis_abs_qsfbt preserving type ) as qsfbt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.qbshb as fis_abs_qbshb preserving type ) as qbshb,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
cast( P_BSEG_COM1.qsshb as fis_abs_qsshb preserving type ) as qsshb,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
cast( P_BSEG_COM1.bdiff as fis_abs_bdiff preserving type ) as bdiff,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
cast( P_BSEG_COM1.bdif2 as fis_abs_bdif2 preserving type ) as bdif2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
cast( P_BSEG_COM1.bdif3 as fis_abs_bdif3 preserving type ) as bdif3,

@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
P_BSEG_COM1.kzbtr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
P_BSEG_COM1.hwzuz,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} }
P_BSEG_COM1.fwzuz,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
P_BSEG_COM1.gbetr,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
P_BSEG_COM1.blnbt,
@Semantics: { amount : {currencyCode: 't014_waers'} }                                                                                                       
P_BSEG_COM1.klibt,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
P_BSEG_COM1.bonfb,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
P_BSEG_COM1.rdiff,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
P_BSEG_COM1.rdif2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
P_BSEG_COM1.dmb21,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
P_BSEG_COM1.dmb22,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
P_BSEG_COM1.dmb23,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
P_BSEG_COM1.dmb31,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
P_BSEG_COM1.dmb32,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
P_BSEG_COM1.dmb33,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
P_BSEG_COM1.navh2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
P_BSEG_COM1.navh3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
P_BSEG_COM1.sknt2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
P_BSEG_COM1.sknt3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
P_BSEG_COM1.rdif3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
P_BSEG_COM1.ppdiff,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
P_BSEG_COM1.ppdif2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
P_BSEG_COM1.ppdif3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwaer'} } 
P_BSEG_COM1.penlc1,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae2'} } 
P_BSEG_COM1.penlc2,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_hwae3'} } 
P_BSEG_COM1.penlc3,
@Aggregation.default: #SUM
@Semantics: { amount : {currencyCode: 'h_waers'} } 
P_BSEG_COM1.penfc,

cast( P_BSEG_COM1.shkzg_unadjusted as fis_abs_shkzg preserving type ) as shkzg_unadjusted,

P_BSEG_COM1.rbl_fincg_status,

P_BSEG_COM1.dp_payment_type,
P_BSEG_COM1.dp_trans_id,

P_BSEG_COM1.nbritm

}
where
  (
    P_BSEG_COM1.h_bstat <> 'D'
  )
  and(
    P_BSEG_COM1.h_bstat <> 'M'
  )