P_RTPCOrderCostDistrwthAwref

@AbapCatalog.sqlViewName: 'PFIRTPCORCSTDREF'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@AccessControl.authorizationCheck: #MANDATORY 
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #XL
@ObjectModel.usageType.dataClass: #TRANSACTIONAL

define view P_RTPCOrderCostDistrwthAwref
  as select from acdoca   as item
    inner join   I_Ledger as ledger on  ledger.Ledger     = item.rldnr
                                    and ledger.LedgerType = '' //standard ledger only

{
  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,

         autyp       as OrderCategory,
         ktosl       as TransactionTypeDetermination,
         co_beknz    as ControllingObjectDebitType,
         accasty     as AccountAssignmentType,
         paccasty    as PartnerAccountAssignmentType,
         bttype      as BusinessTransactionType
}
where
  (
       autyp  =  '10'
    or autyp  =  '40'
    or pautyp =  '10' //For other receiver distributed cost

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