ICA_ConsJournalEntries

@AbapCatalog.sqlViewName: 'ICACONSJES'
@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
  as select from acdocu
{
  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,
  rldnr,
  rdimen,
  ryear,
  ryear                                        as gjahr,
  docnr                                        as ref_belnr,
  docln                                        as ref_docln,
  rrcty,
  cast('' as fins_bttype)                      as BTTYPE,
  cast('' as shkzg)                            as drcrk,
  rvers,
  @Semantics.currencyCode
  rtcur,
  @Semantics.currencyCode
  rhcur,
  @Semantics.currencyCode
  rkcur,
  @Semantics.unitOfMeasure
  runit,
  poper,
  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  subit,
  plevl,
  --rpflg,
  rtflg,
  docty,
  cast('' as blart)                            as blart,
  --yracq,
  --pracq,
  --coicu,
  //  uppcu,

  @Semantics.amount.currencyCode: 'RTCUR'
  tsl,
  @Semantics.amount.currencyCode: 'RHCUR'
  hsl,
  @Semantics.amount.currencyCode: 'RKCUR'
  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,
  cast('' as koart)                            as koart,
  cast('' as umskz)                            as umskz,
  cast('' as mwskz)                            as mwskz,
  cast('' as xopvw)                            as xopvw,
  cast('00000000' as augdt)                    as augdt,
  cast('' as augbl)                            as augbl,
  cast('' as auggj)                            as auggj,
  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
       rrcty = '0'
  and(
       plevl = ''
    or plevl = '00'
    or plevl = '01'
    or plevl = '0C'
    or plevl = '10' )
  and  draft <> 'X' 
union all select from    ICA_P_CONSJOURNALENTRIES
{
  rclnt,
  method_id,
  DOCNR,
  DOCLN,
  GRREF,
  PSTAT,
  CSTAT,
  DUE_DATE,
  CLEARING_STATUS,
  rldnr,
  rdimen,
  ryear,
  gjahr,
  ref_belnr,
  ref_docln,
  rrcty,
  bttype,
  drcrk,
  rvers,
  @Semantics.currencyCode
  rwcur                                        as rtcur,
  @Semantics.currencyCode
  rhcur,
  @Semantics.currencyCode
  rkcur,
  @Semantics.unitOfMeasure
  runit,
  poper,
  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  rbuptr,
  rcongr,
  robukrs,
  sityp,
  SubIt,
  plevl,
  rtflg,
  docty,
  blart,
  @Semantics.amount.currencyCode: 'RTCUR'
  wsl                                         as tsl,
  @Semantics.amount.currencyCode: 'RHCUR'
  hsl,
  @Semantics.amount.currencyCode: 'RKCUR'
  ksl,
  @Semantics.quantity.unitOfMeasure: 'RUNIT'
  msl,
  sgtxt,
  budat,
  timestamp,
  awtyp,
  aworg,
  ktopl,
  racct,
  zuonr,
  rcntr,
  prctr,
  rfarea,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  rassc,
  psegment,
  aufnr,
  kunnr,
  koart,
  umskz,
  mwskz,
  xopvw,
  augdt,
  augbl,
  auggj,
  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,
  xreversing,
  xreversed,
  awref,
  awref_rev
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ICA_P_CONSJOURNALENTRIES",
"ACDOCU"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/