CDS_prctr_v

@AbapCatalog.sqlViewName: 'CDS_V_PRCTR'
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #XL
}
define view CDS_prctr_v as
  select from cepc as prctrset
   left outer join cepct as prctrtext 
   on prctrset.kokrs = prctrtext.kokrs
   and prctrset.prctr = prctrtext.prctr
   and prctrset.datbi = prctrtext.datbi   
   {
      prctrset.mandt as Client,
      prctrset.khinr as Profitcenterarea,
      prctrset.datab as Validfromdate,
      prctrset.segment as Segment,
      prctrset.datbi as Validtodate,
      prctrset.verak as Personresponsible,
      prctrset.prctr as Profitcenter,
      prctrset.kokrs as Controlarea,
      prctrset.spras as OriginalLanguage,     
      prctrtext.spras as Language,     
      prctrtext.ktext as Generalname,
      prctrset.lock_ind as Lockindicator     
   }