P_RTPC_REM_ACTLCOST_FOR_STTLLD

@AbapCatalog.sqlViewName: 'PFIRTPCREMACTSLD'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label      : 'REM Order Actual Cost For Settlement with Parallel Ledgers'

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.viewType: #BASIC
@VDM.private:true
define view P_RTPC_REM_ACTLCOST_FOR_STTLLD
  as select from           acdoca           
{

  rldnr  as lednr,
  objnr,
  ryear  as gjahr,
  rbukrs,
  fiscyearper,
  co_beknz  as beknz,
  bttype,
  awtyp,
  awref,
  awitem,
  aworg,
  awsys,
  subta 
 }

where
  ( accasty  =  'OR' or accasty  =  'OP' )
  and  autyp    =  '05'
  and  xsettled =  ''
  and  bttype   <> 'TBCS' --ignore Transaction-Based Split
  and  bttype   <> 'EBVP' --ignore variance postings after migration
  and  bttype   <> 'EBWP' --ignore WIP postings after migration
  and  bttype   <> 'KOAE' --ignore wip & variance posting
  and  co_beknz <> 'A'    //exclude settlement line items

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