P_RTPC_REM_ACTLCST_FOR_STTLD

@AbapCatalog.sqlViewName: 'PFIRTPCREMFSLD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Actual cost items for settle to COPA'
@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_RTPC_REM_ACTLCST_FOR_STTLD
  as select from acdoca as a
{
  a.rldnr                                          as lednr,
  a.aufnr,
  objnr,
  ryear                                            as gjahr,
  rbukrs,
  fiscyearper,
  belnr,
  docln,
  budat,
  '04'                                             as wrttp,
  racct                                            as kstar,
  ukostl                                           as kostl,
  ulstar                                           as lstar,
  hrkft,
  vrgng,
  case when parobsrc = '1' then parob1     else case
       when parobsrc = '2' then paccasty
       else ''                             end end as parob, // COSS only

  uspob,                                                     // COSS only

  rassc                                            as vbund, // COSP only

  sbusa                                            as pargb, // COSP only

  co_beknz                                         as beknz,
  rwcur                                            as twaer,
  rvunit                                           as meinh,
  bemot,
  beltp,

  bttype,

  awtyp,
  awref,
  awitem,
  aworg,
  awsys,
  subta,

  hkgrp,

  wsl,
  wsl2,
  wsl3,
  hsl,
  ksl,
  osl,
  vsl,
  bsl,
  csl,
  dsl,
  esl,
  fsl,
  gsl,
  kfsl,
  kfsl2,
  kfsl3,
  psl,
  pfsl2,
  pfsl3,
  vmsl,
  vmfsl,
  co_osl,
  timestamp
}

where
  (
       accasty  =  'OR'
    or accasty  =  'OP'
  )
  and(
       autyp    =  '05'
  )
  and  xsettled =  ''
  //  and  bttype   <> 'TBCS' --ignore Transaction-Based Split

  // and  bttype   <> 'EBWP' --ignore Event-Based WIP posting

  and  co_beknz <> 'A' //exclude settlement line items

  // and  co_beknz <> 'L' // exclude the goods receipt items TBD

  //  and  aufnr    <> paufnr //exclude pre-settlement

  //and  co_belnr <> ''

  and  objnr    <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/