P_RTPCORDERWIPRLVTACTCSTWTHREF

@AbapCatalog.sqlViewName: 'PFIEBORACTCSTREF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck:  #MANDATORY 
@ClientHandling.algorithm: #SESSION_VARIABLE
//@EndUserText.label: 'RTPC Order WIP Relevant Actual Cost with Reference Document'

@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
define view P_RTPCORDERWIPRLVTACTCSTWTHREF
  as select from           acdoca                        as _item
    inner join             I_Ledger                      as _ledger               on  _ledger.Ledger     = _item.rldnr
                                                                                  and _ledger.LedgerType = '' //standard ledger only

    left outer to one join I_RealTimeMfgOrderWIPSrceAcct as _AccountDetermination on  _item.rbukrs =  _AccountDetermination.CompanyCode
                                                                                  and _item.racct  >= _AccountDetermination.WIPSourceAccountFrom
                                                                                  and _item.racct  <= _AccountDetermination.WIPSourceAccountTo
{
  key    objnr       as ControllingObject,
  key    aufnr       as OrderID,
  key    aufps       as OrderItem,
  key    rbukrs      as CompanyCode,
  key    rldnr       as Ledger,
  key    fiscyearper as FiscalYearPeriod,
  key    belnr       as DocNumber,
  key    awtyp       as RefType,
  key    awref       as RefDoc,
  key    aworg       as RefOrg,
  key    awsys       as RefSys
}
where
  (
        accasty                  =  'OR'
    or  accasty                  =  'OP'
  )
  and   bttype                   <> 'TBCS' --ignore Transaction-Based Split
  and   bttype                   <> 'EBWP' --ignore Event-Based WIP posting
  and(
        autyp                    =  '10'
    or  autyp                    =  '40'
  )
  and   objnr                    <> ''
  and(
        co_beknz                 <> 'A' //To avoid interactionof WIP and Variance posting in the same time,

    //we should exlde the settlement from WIP relevant costs

    and aufnr                    <> paufnr
  )
  or(
        aufnr                    =  paufnr
  )
  and(
        WIPSourceAccountCategory is not null
    and WIPSourceAccountCategory <> ''
    and WIPSourceAccountCategory <> 'N'
  )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LEDGER",
"I_REALTIMEMFGORDERWIPSRCEACCT",
"ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/