P_DMVCGLAccItemProfitCenter

@AbapCatalog.sqlViewName: 'PDMVCGLACCPRCTR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ClientHandling.algorithm: #SESSION_VARIABLE

@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #COMPOSITE
@VDM.private:true
define view P_DMVCGLAccItemProfitCenter
  as select from           P_ACDOCA as _acdoca
    left outer to one join I_ProfitCenter   as _ProfitCenter on _acdoca.prctr = _ProfitCenter.ProfitCenter

{
  key _acdoca.awtyp     as awtyp,
  key _acdoca.aworg     as aworg,
  key _acdoca.awref     as awref,
  key _acdoca.awitem    as awitem,
      _acdoca.matnr     as matnr,
      _acdoca.belnr     as belnr,
      _acdoca.kalnr     as kalnr,
      _acdoca.qsprocess as qsprocess,
      _acdoca.prctr     as prctr,
      _acdoca.ktosl     as ktosl,
      _acdoca.bwkey     as bwkey,
      _acdoca.paobjnr   as paobjnr,
      _acdoca.budat     as budat,
      _acdoca.rldnr     as rldnr,
      _acdoca.rbukrs    as rbukrs,
      _acdoca.gjahr     as gjahr,
      _acdoca.docln     as docln,
      _acdoca.mlptyp    as mlptyp,
      _acdoca.timestamp as timestamp
//      _cepc.zbu         as zbu,

//      _cepc.zod         as zod

}
where
//

//         =  '0L'

//  and(

//       _acdoca.mlptyp =  'BB'

//    or _acdoca.mlptyp =  'B+'

//    or _acdoca.mlptyp =  'V+'

//    or _acdoca.mlptyp =  'VK'

//    or _acdoca.mlptyp =  'BF'

//    or _acdoca.mlptyp =  'VF'

//  )

//  and   _acdoca.ktosl                    <> 'PRD'

_acdoca.kalnr <> '000000000000'
and _ProfitCenter.ValidityEndDate    =  '99991231'
//  and  _ProfitCenter.ControllingArea    =  'A000'

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROFITCENTER",
"P_ACDOCA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/