ICA_CONSJOURNALENTRIES_3

@AbapCatalog.sqlViewName: 'ICACONSJES3'
@AbapCatalog.compiler.compareFilter:true
@EndUserText.label: 'Match Consolidation Journal Entry Lines'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
define view ICA_CONSJOURNALENTRIES_3
  as select from acdocu 
  inner join fincs_ref_vers_r on acdocu.rvers = fincs_ref_vers_r.versionelement
  inner join tf200 on fincs_ref_vers_r.version = tf200.rvers
  left outer join ica_fs_item as _assignment on  tf200.iatvs   = _assignment.iatvs
                                                 and acdocu.ritclg = _assignment.itclg
                                                 and acdocu.ritem  = _assignment.item
                                                 and acdocu.fiscyearper between _assignment.fromyearper and _assignment.toyearper
{
  rclnt,
  cast ('' as ica_method_id)                                           as method_id,
  cast ('0000000000' as ica_docnr)                                     as DOCNR,
  cast (0 as ica_docln)                                                as DOCLN,
  cast ('000000000000' as ica_grref)                                   as GRREF,
  cast ('00' as ica_pstat)                                             as PSTAT,
  cast ('' as ica_cstat)                                               as CSTAT,
  cast ('00000000' as ica_due_date)                                    as DUE_DATE,
  cast ('0' as ica_clearing_status )                                   as CLEARING_STATUS,
  fiscyearper,
  rldnr,
  rdimen,
  ryear,
  ryear                                                                as gjahr,
  docnr                                                                as ref_belnr,
  docln                                                                as ref_docln,
  rrcty,
  fincs_ref_vers_r.version as rvers,
  @Semantics.currencyCode
  rtcur,
  @Semantics.currencyCode
  rhcur,
  @Semantics.currencyCode
  case when tf200.group_curr = acdocu.rkcur then rkcur else cast('' as gcurr)  end as rkcur,
  @Semantics.unitOfMeasure
  runit,
  poper,
  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  coalesce(_assignment.sa_role, '')                                    as sa_role,
  coalesce(_assignment.sa_elimination, '')                             as sa_elimination,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  --rpflg,
  rtflg,
  docty,
  --yracq,
  --pracq,
  --coicu,
  //  uppcu,

  @Semantics.amount.currencyCode: 'RTCUR'
  tsl,
  @Semantics.amount.currencyCode: 'RHCUR'
  hsl,
  @Semantics.amount.currencyCode: 'RKCUR'
  case when tf200.group_curr = acdocu.rkcur then ksl else cast(0 as vgcur12)  end as ksl,
  @Semantics.quantity.unitOfMeasure: 'RUNIT'
  msl,
  sgtxt,
  budat,
  timestamp,
  awtyp,
  aworg,
  ktopl,
  racct,
  zuonr,
  rcntr,
  prctr,
  rfarea,
  --rbusa,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  --sbusa,
  rassc,
  psegment,
  aufnr,
  kunnr,
  lifnr,
  matnr,
  matkl_mm,
  werks,
  rmvct,
  ps_psp_pnr,
  ps_posid,
  ps_pspid,
  fkart,
  vkorg,
  vtweg,
  spart,
  matnr_copa,
  matkl,
  kdgrp,
  land1,
  brsch,
  bzirk,
  kunre,
  kunwe,
  konzs,
  case when orndocnr <> ''
       then cast('X' as fins_xreversing)
       else cast('' as fins_xreversing)   end                          as XREVERSING,
  case when rvsdocnr <> ''
       then cast('X' as fins_xreversed)
       else cast('' as fins_xreversed)    end                          as XREVERSED,
  cast('' as awref)                                                    as awref,
  case when orndocnr <> ''
       then cast(orndocnr as awref_rev)
       else cast(rvsdocnr as awref_rev)    end                         as AWREF_REV

} where draft <> 'X'