ICA_P_CONSJOURNALENTRIES

@AbapCatalog.sqlViewName: 'ICAPCJES'
@AbapCatalog.compiler.compareFilter: true
@EndUserText.label: 'ICA: Consolidation Journal Entry Line Items from ACDOCA'
@ClientHandling.type: #CLIENT_DEPENDENT
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
define view ICA_P_CONSJOURNALENTRIES
  as select from          ICA_P_CONSJOURNALENTRIES_01 as source
//  TF103A: Breakdown info for subitem (SUBIT) depending on breakdown category (ITGRP)

  left outer to one join tf103a tf103a_subit  on  source.ritclg          = tf103a_subit.itclg
                                              and source.itbrkdwn        = tf103a_subit.itgrp
                                              and tf103a_subit.fieldname = 'SUBIT'

//  TF040: Default value for subitem (SUBIT)

  left outer join        tf040 tf040_subit    on  source.sityp          = tf040_subit.value
                                              and tf040_subit.fieldname = 'SUBIT'

//  TF103A: Breakdown info for partner (RBUPTR) depending on breakdown category (ITGRP)

  left outer to one join tf103a tf103a_rbuptr on  source.ritclg           = tf103a_rbuptr.itclg
                                              and source.itbrkdwn         = tf103a_rbuptr.itgrp
                                              and tf103a_rbuptr.fieldname = 'RBUPTR'

//  Table TF040: Default value for partner (RBUPTR)

  left outer to one join tf040 tf040_rbuptr   on  source.rdimen          = tf040_rbuptr.value
                                              and tf040_rbuptr.fieldname = 'RBUPTR'
{
  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,
  --0 N/A， 1   Open，2   Parked，3   Cleared
  case when xopvw = 'X'
       then ( case when augbl <> '' then cast ('3' as ica_clearing_status )
                                    else cast ('1' as ica_clearing_status )
             end  )
     else cast ('0' as ica_clearing_status )
     end                             as CLEARING_STATUS,
  rldnr,
  rdimen,
  ryear,
  gjahr,
  fiscyearper,
  ref_belnr,
  ref_docln,
  rrcty,
  bttype,
  drcrk,
  rvers,
  iatvs,
  @Semantics.currencyCode
  rwcur,  
  @Semantics.currencyCode
  rtcur,
  @Semantics.currencyCode
  rhcur,
  @Semantics.currencyCode
  rkcur,
  @Semantics.unitOfMeasure
  runit,
  poper,
  docct,
  rcomp,
  rbunit,
  ritclg,
  ritem,
  //Partner (RBUPTR): Evaluate breakdown type

  cast(case
    when tf103a_rbuptr.breakdown = '0'
      or tf103a_rbuptr.breakdown is null
  //      no breakdown

          then ''
    when tf103a_rbuptr.breakdown = '1'
  //      breakdown optional

      or tf103a_rbuptr.breakdown = '4'
  //      breakdown required, default not allowed

          then source.rbuptr // use even if initial

  //      Breakdown = '4': Wrong if RBUPTR is initial or default

  //      -> Mistake in FI posting cannot be corrected here, has to be detected by validation

    when tf103a_rbuptr.breakdown = '2'
  //      breakdown optional

      or tf103a_rbuptr.breakdown = '3'
  //      breakdown required, default allowed

      then
          case source.rbuptr
              when ''
  //              use default if initial

                  then coalesce(cast(tf040_rbuptr.defval as fincs_subassignment_value),'')
              else source.rbuptr
          end
  end as fc_buptr)                   as rbuptr,
  cast('' as fc_congr)               as rcongr,
  robukrs,
  cast(source.sityp as fc_sityp)     as sityp,
  // Subitem (SUBIT): Evaluate breakdown type

  cast( case
      when   tf103a_subit.breakdown = '0'
          or tf103a_subit.breakdown is null
  //      no breakdown

          then ''
      when tf103a_subit.breakdown = '1'
  //      breakdown optional

        or tf103a_subit.breakdown = '4'
  //      breakdown required, default not allowed

          then source.subit // use even if initial

  //      Breakdown = '4': Wrong if SUBIT is initial or default

  //      -> Mistake in FI posting cannot be corrected here, has to be detected by validation

      when tf103a_subit.breakdown = '2'
  //      breakdown optional

        or tf103a_subit.breakdown = '3'
  //      breakdown required, default allowed

          then
              case source.subit
                  when ''
  //                  use default if initial

                      then coalesce(cast(tf040_subit.defval as fincs_subassignment_value),'')
                  else source.subit
              end
  end as fc_sitem)                   as SubIt,
  plevl,
  rtflg,
  docty,
  blart,
  @Semantics.amount.currencyCode: 'RWCUR'
  wsl,  
  @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,
  kokrs,
  segment,
  scntr,
  pprctr,
  sfarea,
  --sbusa,
  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_01",
"TF040",
"TF103A"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/