P_ACDOCA

 @AbapCatalog.entityBuffer.definitionAllowed: false
 @VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
define view entity P_ACDOCA
  as select from acdoca
    
  //            inner join finsc_ld_cmp      on acdoca.rldnr = finsc_ld_cmp.rldnr and acdoca.rbukrs = finsc_ld_cmp.bukrs

{
  key cast(acdoca.rldnr       as fins_ledger_pers preserving type)  as rldnr,
  key cast(acdoca.rbukrs      as fis_bukrs preserving type)         as rbukrs,
  key cast(acdoca.gjahr       as fis_gjahr_no_conv preserving type) as gjahr,
  key cast(acdoca.belnr       as fis_belnr preserving type)         as belnr,
  key cast(acdoca.docln       as fis_docln preserving type)         as docln,
  

      cast(acdoca.ryear       as fis_ryear_no_conv preserving type) as ryear,
      acdoca.rrcty,
      cast(acdoca.docnr_ld    as fis_docnr_ld preserving type)      as DOCNR_LD,

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

      // .INCLUDE ACDOC_SI_00  Unified Journal Entry: Transaction, Currencies, Units

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

      cast(rmvct as fis_rmvct preserving type)                     as rmvct,
      cast(vorgn as fis_vorgn preserving type )                    as vorgn,
      vrgng,
      cast(bttype as fis_bttype preserving type) as bttype,
      cast(cbttype as fis_custbttype preserving type) as cbttype,
      cast(closingstep as fis_closingstep preserving type) as closingstep,
      cast(awtyp as fis_awtyp preserving type)                     as awtyp,
      cast(awsys as logsystem preserving type)                     as awsys,
      cast(aworg as fis_aworg preserving type)                     as aworg,
      awref,
      awitem,
      awitgrp,
      subta,
      cast( acctg_notif_uuid as fis_hdr_technical_id preserving type ) as ACCTG_NOTIF_UUID,
      cast( offstg_docln as fis_offsetting_docln preserving type ) as offstg_docln,
      xreversing,
      xreversed,
      xtruerev,
      cast(awtyp_rev as fis_awtyp_rev preserving type ) as awtyp_rev,
      aworg_rev,
      awref_rev,
      cast( subta_rev as fis_subta_rev preserving type ) as subta_rev,
      xsettling,
      xsettled,
      prec_awtyp,
      prec_aworg,
      prec_awref,
      prec_awitem,
      prec_subta,
      prec_bukrs,
      cast( prec_gjahr as fins_prec_gjahr_gfc_no_conv preserving type ) as prec_gjahr,
      prec_belnr,
      prec_docln,

      src_awtyp,
      src_awsys,
      src_aworg,
      src_awref,
      src_awitem,
      src_awsubit,
      xcommitment,
      cast( obs_reason as fis_obsolete_item_reason preserving type ) as obs_reason,
      cast( xsecondary as journalentryissecondaryentry ) as XSECONDARY,
      closing_run_id,
      orgl_change,
      
      cast(racct as fis_racct preserving type)                     as racct,


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

      // .INCLUDE  ACDOC_SI_GL_ACCAS Unified Journal Entry: G/L additional account assignments

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

      cast(rcntr as fis_kostl preserving type)                     as rcntr,
      cast(prctr as fis_prctr preserving type)                     as prctr,
      cast(rfarea as fm_farea preserving type)                     as rfarea,
      cast(rbusa as fis_rbusa preserving type)                     as rbusa,
      cast(kokrs as fis_kokrs preserving type)                     as kokrs,
      segment,
      cast(scntr as fis_skost preserving type)                     as scntr,
      cast(pprctr as fis_pprctr preserving type)                   as pprctr,
      cast(sfarea as fis_sfkber preserving type)                   as sfarea,
      cast(sbusa as fis_pargb preserving type)                     as sbusa,
      cast(rassc as fis_rassc preserving type)                     as rassc,
      psegment,


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

      // .INCLUDE ACDOC_SI_VALUE_DATA Unified Journal Entry: Value Fields

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


      cast(rtcur as fis_rtcur preserving type)                     as rtcur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rtcur'} }
      cast(tsl as fis_tsl preserving type)                         as tsl,

      cast(rwcur as fis_rwcur preserving type)                     as rwcur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rwcur'} }
      cast(wsl as fis_wsl preserving type)                         as wsl,

      cast(rhcur as fis_hwaer preserving type)                     as rhcur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rhcur'} }
      cast(hsl as fis_hsl preserving type)                         as hsl,
      @Semantics: { amount : {currencyCode: 'rhcur'} }
      hvkwrt,

      cast(rkcur as fis_rkcur preserving type)                     as rkcur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      cast(ksl as fis_ksl preserving type)                         as ksl,

      // Functional Currency

      rfccur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rfccur'} }
      cast(fcsl as fis_vfccur12 preserving type)                   as fcsl,

      // Freely Defined Currency 1

      cast(rocur as fis_rocur preserving type)                     as rocur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rocur'} }
      cast(osl as fis_osl preserving type)                         as osl,

      // Freely Defined Currency 2

      cast(rvcur as fis_rvcur preserving type)                     as rvcur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rvcur'} }
      cast(vsl as fis_vsl preserving type)                         as vsl,

      // Freely Defined Currency 3

      rbcur                                                        as rbcur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rbcur'} }
      cast(bsl as fis_bsl preserving type)                         as bsl,

      // Freely Defined Currency 4

      rccur                                                        as rccur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rccur'} }
      cast(csl as fis_csl preserving type)                         as csl,

      // Freely Defined Currency 5

      rdcur                                                        as rdcur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rdcur'} }
      cast(dsl as fis_dsl preserving type)                         as dsl,

      // Freely Defined Currency 6

      recur                                                        as recur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'recur'} }
      cast(esl as fis_esl preserving type)                         as esl,

      // Freely Defined Currency 7

      cast(rfcur as fis_rfcur preserving type)                     as rfcur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rfcur'} }
      cast(fsl as fis_fsl preserving type)                         as fsl,

      // Freely Defined Currency 8

      rgcur                                                        as rgcur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rgcur'} }
      cast(gsl as fis_gsl preserving type)                         as gsl,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      cast(kfsl as fis_kfsl preserving type)                       as kfsl,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      kfsl2                                                        as kfsl2,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      kfsl3                                                        as kfsl3,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rhcur'} }
      case when ksl = 0 or kfsl = 0 then cast('0' as fis_hfsl) else 
        cast( 
          cast(
            cast( cast( hsl as abap.dec(23,2) ) as abap.d34n ) * 
      //CAST(CURR AS D34N) not allowed, use detour through fixed point DEC

            cast( cast( kfsl as abap.dec(23,2) ) as abap.d34n ) /  
            cast( cast( ksl as abap.dec(23,2) ) as abap.d34n ) 
           as abap.dec(23,2) )  
         as fis_hfsl ) 
         end as hfsl,
         
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rwcur'} }         
      case when ksl = 0 or kfsl = 0 then cast('0' as fis_wfsl) else 
        cast( 
          cast(
            cast( cast( wsl as abap.dec(23,2) ) as abap.d34n ) * 
      //CAST(CURR AS D34N) not allowed, use detour through fixed point DEC

            cast( cast( kfsl as abap.dec(23,2) ) as abap.d34n ) /  
            cast( cast( ksl as abap.dec(23,2) ) as abap.d34n ) 
           as abap.dec(23,2) )  
         as fis_wfsl ) 
         end as wfsl,         
                      
//

//      @Aggregation.default: #SUM

//      @Semantics: { amount : {currencyCode: 'rhcur'} }

//      case when ksl = 0 then ksl else

//        cast( hsl * cast( kfsl2 as abap.d34n ) / cast( ksl as abap.d34n ) as fis_hfsl2 ) end as hfsl2,

//

//      @Aggregation.default: #SUM

//      @Semantics: { amount : {currencyCode: 'rhcur'} }

//      case when ksl = 0 then ksl else

//        cast( hsl * cast( kfsl3 as abap.d34n ) / cast( ksl as abap.d34n ) as fis_hfsl3 ) end as hfsl3,        


      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      cast(psl as fis_psl preserving type)                         as psl,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      psl2                                                         as psl2,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      psl3                                                         as psl3,


      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      cast(pfsl as fis_pfsl preserving type)                       as pfsl,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      pfsl2                                                        as pfsl2,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rkcur'} }
      pfsl3                                                        as pfsl3,


      rco_ocur                                                     as rco_ocur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rco_ocur'} }
      co_osl,
      
      rgm_ocur                                                     as rgm_ocur,
      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rgm_ocur'} }
      gm_osl,
      

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rhcur'} }
      hstprs,

      @Aggregation.default: #SUM
      @Semantics: { amount : {currencyCode: 'rhcur'} }
      hpvprs,


      runit                                              as runit,
      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'runit'} }
      msl,

      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'runit'} }
      mfsl,

      cast(rvunit as fis_co_meinh preserving type)                 as rvunit,
      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'rvunit'} }
      vmsl,

      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'rvunit'} }
      vmfsl,
      
      cast( rrunit as fis_ref_qty_uom preserving type )  as rrunit,
      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'rrunit'} }
      rmsl,      

      qunit1                                             as qunit1,
      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'qunit1'} }
      quant1,

      qunit2                                             as qunit2,
      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'qunit2'} }
      quant2,

      qunit3                                             as qunit3,
      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'qunit3'} }
      quant3,

      cast( co_meinh as fis_fco_meinh preserving type ) as CO_MEINH,
      
      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'co_meinh'} }
      cast( co_megbtr as fis_fco_megbtr preserving type )  as CO_MEGBTR,
      
      @Aggregation.default: #SUM
      @Semantics: { quantity : {unitOfMeasure: 'co_meinh'} }
      cast( co_mefbtr as fis_fco_mefbtr preserving type )  as CO_MEFBTR,      

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

      // .INCLUDE ACDOC_SI_FIX  Unified Journal Entry: Mandatory fields for G/L

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

      cast(drcrk as fis_shkzg preserving type)           as drcrk,
      // cast(poper as FIS_POPER) as poper,

      cast(poper as fins_fiscalperiod preserving type)   as poper,
      cast(acdoca.periv as fis_periv preserving type)    as periv,
      cast(fiscyearper as fis_jahrper_conv preserving type ) as fiscyearper,
      cast(budat as fis_budat preserving type)           as budat,
      cast(bldat as fis_bldat preserving type)           as bldat,
      cast(blart as fis_blart preserving type)           as blart,
      // cast(blart as farp_blart) as blart,

      cast(buzei as fis_buzei preserving type)           as buzei,
      // cast(buzei as farp_buzei) as buzei,

      cast(zuonr as fis_zuonr preserving type)           as zuonr,
      cast(bschl as fis_bschl preserving type)           as bschl,
      cast(bstat as fis_bstat preserving type)           as bstat,
      // cast(bstat as farp_bstat_d) as bstat,

      cast(linetype as fis_linetype preserving type ) as linetype,
      cast(ktosl as fac_ktosl preserving type)           as ktosl,
      slalittype,
      xsplitmod,
      cast(usnam as fis_usnam preserving type)           as usnam,
      timestamp,
      last_change_datetime,
      eprctr,
      cast(rhoart as fis_hoart preserving type)          as rhoart,
      glaccount_type,
      cast(ktopl as fis_ktopl preserving type)           as ktopl,
      cast(lokkt as fis_altkt_skb1 preserving type)      as lokkt,
      cast(ktop2 as fis_ktop2 preserving type)           as ktop2,
      
      
      /////////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_FINCS   Universal Journal Entry: Fields for Group Reporting

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

      cast( rbunit as fis_md_bunit preserving type )     as rbunit,
      cast( rbuptr as fis_md_buptr preserving type )     as rbuptr,
      cast( rcomp  as fis_rcomp    preserving type )     as rcomp,
      cast( ritclg as fis_itclg    preserving type )     as ritclg,
      cast( ritem  as fis_fsi_item preserving type )     as ritem,
      cast( sityp  as fis_fc_sityp preserving type )     as sityp,
      cast( subit  as fis_fc_sitem preserving type )     as subit,     
            

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

      // .INCLUDE ACDOC_SI_GEN  Unified Journal Entry: Fields for several subledgers

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

      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,
      cast(rbest as fis_refbtyp preserving type)                         as rbest,
      cast(ebeln as fis_ebeln preserving type)                           as ebeln,
      cast(ebelp as fis_ebelp preserving type)                           as ebelp,
      zekkn,
      // cast(sgtxt as FIS_SGTXT) as sgtxt,

      cast(sgtxt as farp_sgtxt preserving type)                          as sgtxt,
      cast(kdauf as vdm_sales_order preserving type)                     as kdauf,
      cast(kdpos as sales_order_item preserving type)                    as kdpos,
      matnr,
      werks,
      cast(lifnr as md_supplier preserving type)                         as lifnr,
      cast(kunnr as kunnr preserving type)                               as kunnr,
      fbuda,
      perop_beg,
      perop_end,
      coco_num,
      wwert                                                              as wwert,
      ucb_id,
      ucb_scale_numerator,
      
      /////////////////////////////////////////////////////////////////////////

      // .INCLUDE ACDOC_SI_FI  Unified Journal Entry: Fields for FI subledgers

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

      cast(koart as farp_koart preserving type)                          as koart,
      cast(umskz as fac_umskz preserving type)                           as umskz,
      cast(mwskz as fis_mwskz preserving type)                           as mwskz,
      tax_country,
      cast(hbkid as farp_hbkid preserving type)                          as hbkid,
      cast(hktid as fac_hktid preserving type)                           as hktid,
      cast(xopvw as fis_xopvw preserving type)                           as xopvw,
      cast(augdt as fis_augdt preserving type)                           as augdt,
      // cast(augbl as farp_augbl) as augbl,

      cast(augbl as fis_augbl preserving type)                           as augbl,
      cast(auggj as fis_auggj_no_conv preserving type)                   as auggj,

      cast( case augdt when '00000000' then cast( ' ' as xaugp  preserving type)
                                       else cast( 'X' as xaugp  preserving type)
            end  as xaugp  preserving type)                              as XAUGP,
      valut,     
      cast(aging as fis_aging preserving type)                           as AGING,
      cast(aging_incrmnt as fis_incrmnt preserving type)                 as AGING_INCRMNT,

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

      // .INCLUDE ACDOC_SI_FAA  Unified Journal Entry: Fields for Asset Accounting

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

      cast(afabe as fis_afabe_d preserving type)                         as afabe,
      cast(anln1 as fis_anln1 preserving type)                           as anln1,
      cast(anln2 as fis_anln2 preserving type)                           as anln2,
      bzdat,
      cast(anbwa as fis_anbwa_vdm preserving type ) as anbwa,
      movcat,
      cast(depr_period as fis_peraf preserving type)                     as depr_period,
      cast(anlgr as fis_anlgr preserving type)                           as anlgr,
      cast(anlgr2 as fis_anlgr2 preserving type)                         as anlgr2,
      settlement_rule,
anlkl,
ktogr,
      cast(panl1 as fis_panl1 preserving type )                          as panl1,
      cast(panl2 as fis_panl2 preserving type )                          as panl2,

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

      // .INCLUDE ACDOC_SI_ML Unified Journal Entry: Fields for Material Ledger

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

      cast(kalnr as fis_kalnr preserving type)                           as kalnr,
      vprsv,
      mlast,
      cast(kzbws as inventoryspecialstockvalntype preserving type)       as kzbws,
      xobew,
      cast(sobkz as inventoryspecialstocktype preserving type)           as sobkz,
      // VTSTAMP, 

      mat_kdauf,
      mat_kdpos,
      mat_pspnr,
      mat_ps_posid,
      cast(mat_lifnr as fis_mlmat_lifnr preserving type)                 as mat_lifnr,
      bwtar,
      bwkey,
      hpeinh,
      // KPEINH,

      // OPEINH,

      // VPEINH,

      mlptyp,
      mlcateg,
      qsbvalt,
      qsprocess,
      perart,  

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

      // .INCLUDE ACDOC_SI_CFIN   Unified Journal Entry: Fields for Central Finance

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

      bukrs_sender,
      cast(racct_sender as fis_racct_sender preserving type)             as racct_sender,
      accas_sender,
      accasty_sender,

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

      //  .INCLUDE  ACDOC_SI_CO  Unified Journal Entry: CO fields

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

      objnr,
      hrkft,
      hkgrp,
      parob1,
      parobsrc,
      cast( uspob as fis_uspob preserving type)          as uspob,
      co_belkz,
      beltp,
      muvflg,
      cast(gkont as fis_gkont preserving type)           as gkont,
      cast(gkoar as farp_gkoar preserving type)          as gkoar,
      cast(erlkz as fis_kblerlkz preserving type)        as erlkz,
      pernr,
      paobjnr,
      xpaobjnr_co_rel,
      cast(scope as fis_scope_cv_conv_co preserving type)   as scope,
      logsyso,
      pbukrs,
      cast(pscope as fis_pscope_cv_conv_co preserving type)   as pscope,
      logsysp,
      bwstrat,
      objnr_hk,
      cast( aufnr_org as fco_aufnr_org preserving type)   as aufnr_org,
      
      cast(ukostl as fis_usp_kostl    preserving type)     as ukostl,
      cast(ulstar as fins_usp_lstar    preserving type)    as ulstar,
      cast(umatnr as fis_origin_matnr preserving type)     as UMATNR,
      cast(varc_uacct as fis_varc_origin_acct preserving type) as VARC_UACCT,     

      uprctr,
      accas,
      cast(accasty as fis_accasty preserving type) as accasty,
      lstar,
      cast(aufnr as fis_aufnr preserving type)           as aufnr,
      autyp,
      cast(ps_psp_pnr as ps_posnr preserving type)       as ps_psp_pnr,
      ps_posid,
      ps_prj_pnr,
      ps_pspid,
      nplnr,
      cast( nplnr_vorgn as fis_npvrg_no_conv preserving type ) as nplnr_vorgn,
      prznr,
      kstrg,
      cast(bemot as fis_bemot preserving type)           as bemot,
      cast(rsrce as fis_co_resource preserving type)     as rsrce,
      qmnum,
      service_doc_type,
      service_doc_id,
      service_doc_item_id,
      service_contract_type,
      service_contract_id,
      service_contract_item_id,
      cast(solution_order_id as crms4_solo_object_id preserving type ) as solution_order_id,
      cast(solution_order_item_id as crms4_solo_number_int preserving type ) as solution_order_item_id,
      
      cast( vtkey as fis_vtkey_kk preserving type ) as vtkey,
      cast( vtpos as fis_vtpos_kk preserving type ) as vtpos,
      
      cast( ra_contract_id as fis_contract_id preserving type ) as ra_contract_id,
      cast( ra_pob_id as fis_pob_id preserving type ) as ra_pob_id,      
      
      erkrs,
      cast(paccas as fis_paccas preserving type)         as paccas,
      cast(paccasty as fins_paccasty preserving type)    as paccasty,
      cast(plstar as fis_par_lstar preserving type)      as plstar,
      cast(paufnr as fis_par_aufnr preserving type)      as paufnr,
      cast(pautyp as fis_par_auftyp preserving type)     as pautyp,
      cast(pps_posid as fis_par_posid preserving type)   as pps_posid,
      cast(pps_pspid as fis_par_pspid preserving type)   as pps_pspid,
      cast(pkdauf as fis_par_kdauf preserving type)      as pkdauf,
      cast(pkdpos as fis_par_kdpos preserving type)      as pkdpos,
      ppaobjnr,
      pnplnr,
      cast( pnplnr_vorgn as fis_par_vornr_auf_no_conv preserving type ) as pnplnr_vorgn,
      pprznr,
      pkstrg,
      cast(co_accasty_n1 as fis_accasty_n1 preserving type)         as co_accasty_n1,
      cast(co_accasty_n2 as fis_accasty_n2 preserving type)         as co_accasty_n2,
      cast(co_accasty_n3 as fis_accasty_n3 preserving type)         as co_accasty_n3,      
      co_zlenr,
      co_belnr,
      co_buzei,
      co_refbz,
      overtimecat,
      work_item_id,      
co_beknz,
uprznr,
pps_psp_pnr,
pps_prj_pnr,
pservice_doc_type,
pservice_doc_id,
pservice_doc_item_id,  

varc_hkgrp,    

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

      //  .INCLUDE  ACDOC_SI_COPA  Unified Journal Entry: CO-PA fields

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

      fkart,
      vkorg,
      vtweg,
      spart,
      matnr_copa,
      matkl,
      kdgrp,
      land1,
      brsch,
      bzirk,
      kunre,
      kunwe,
      konzs,

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

 // .INCLUDE ACDOC_SI_PS  Unified Journal Entry: Fields for Public Sector

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

re_bukrs,
re_account,
fikrs,
fipex,
cast(fistl as farp_fistl preserving type)  as fistl,
measure,
rfund,
rgrant_nbr,
rbudget_pd,
sfund,
sgrant_nbr,
sbudget_pd,
bdgt_account,
bdgt_account_cocode,
bdgt_cnsmpn_date,
bdgt_cnsmpn_period,
cast( bdgt_cnsmpn_year as psm_bdgt_cnsmpn_year_no_conv preserving type ) as bdgt_cnsmpn_year,
bdgt_relevant,
bdgt_cnsmpn_type,
bdgt_cnsmpn_amount_type,
rsponsored_prog,
rsponsored_class,
rbdgt_vldty_nbr,
cast(kblnr as fis_kblnr_fi preserving type ) as kblnr,
cast(kblpos as fis_kblpos preserving type ) as kblpos,


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

      // .INCLUDE ACDOC_SI_JVA  Universal Journal Entry: Fields for Financial Services

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

cast(fs_product_group as fis_ffs_product_group preserving type ) as FS_PRODUCT_GROUP,
cast(branch_id as fis_ffs_branch_id preserving type ) as BRANCH_ID,
cast(datasource_id as fis_ffs_datasource_id preserving type ) as DATASOURCE_ID,     

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

      // .INCLUDE ACDOC_SI_JVA  Unified Journal Entry: Fields for Joint Venture Accounting

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

vname,
egrup,
recid,
vptnr,
btype,
etype,
prodper,
billm,
pom,
cbrunid,
jvactivity,
pvname,
pegrup,
s_recind,
cbracct,
cbobjnr,     

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

      // .INCLUDE ACDOC_SI_RE STRU  0 0 Unified Journal Entry: Fields for Real Estate

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

      cast(swenr as rebdvdmbeno preserving type ) as SWENR,
      cast(sgenr as rebdvdmbuno preserving type ) as SGENR,
      cast(sgrnr as rebdvdmprno preserving type ) as SGRNR,
      cast(smenr as rebdvdmrono preserving type ) as SMENR,
      cast(recnnr as recnvdmcnnr preserving type ) as RECNNR,      
cast(snksl as rescvdmsckey preserving type ) as snksl ,
cast(sempsl as rescvdmsuid preserving type ) as sempsl,
cast(dabrz as farp_dabrbez preserving type)  as dabrz,

cast(pswenr as rebdvdmpbeno preserving type ) as pswenr,
cast(psgenr as rebdvdmpbuno preserving type ) as psgenr,
cast(psgrnr as rebdvdmpprno preserving type ) as psgrnr,
cast(psmenr as rebdvdmprono preserving type ) as psmenr,
cast(precnnr as recnvdmpcnnr preserving type ) as precnnr,
cast(psnksl as rescvdmpsckey preserving type ) as psnksl,
cast(psempsl as rescvdmpsuid preserving type ) as psempsl,
cast(pdabrz as fins_par_dabrbez preserving type ) as pdabrz,     

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

 // .INCLUDE ACDOC_SI_ACR STRU  0 0 Universal Journal Entry: Fields for Accrual object

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

acrobjtype,
acrlogsys,
acrobj_id,
acrsobj_id,
acritmtype,
cast( acrrefobj_id as fis_acr_refobj_id preserving type ) as acrrefobj_id, 
acrvaldat,


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

 // .INCLUDE ACDOC_SI_VAL STRU  0 0 Universal Journal Entry: Fields for Fin. Valuation Object

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

valobjtype,
valobj_id,
valsobj_id,
cast(netdt as faedt_fpos preserving type) as netdt,
cast(risk_class as credit_risk_class preserving type) as risk_class,
      
      //////////////////////////////////////////////////////////////////////

      //  .INCLUDE  ACDOC_SI_LOG  Universal Journal Entry: Fields for Logistics

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


      arbid,
      cast( vornr as fis_vornr_no_conv preserving type ) as vornr,
      aufps,
      paufps,
      
      //////////////////////////////////////////////////

      // .INCLUDE  ACDOC_SI_LOG_ACT:  New Fields  PM  //

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

cast( uvorn as fis_uvorn_no_conv preserving type ) as uvorn,
equnr,
tplnr, 
istru, 
ilart,
plknz,
artpr,
priok,
maufnr,        
matkl_mm,   
planned_parts_work,
cast( vornr_org as fis_origin_order_operation preserving type)   as vornr_org,

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

      // .INCLUDE  ACDOC_SI_TECH:  Universal Journal Entry: Technical Fields  //

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

cast(mig_source as fis_acdoc_mig_source preserving type) as mig_source 
              
           
//      @Aggregation.default: #SUM

//      cast( cast(1 as abap.dec( 12, 0 )) as fis_nbritm preserving type ) as nbritm


}
/* Filter for BSTAT not required as these are not written to ACDOCA */
//where

//  (

//    bstat <> 'D'

//  )

//  and(

//    bstat <> 'M'

//  )