CDS_prctr_v

DDL: PROFITCENTERSET SQL: CDS_V_PRCTR Type: view Package: ODATA_SEGMENT

Profit Center Set

CDS_prctr_v is a CDS View that provides data about "Profit Center Set" in SAP S/4HANA. It reads from 2 data sources (cepc, cepct) and exposes 12 fields. Part of development package ODATA_SEGMENT.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
cepc prctrset from
cepct prctrtext left_outer

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName CDS_V_PRCTR view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (12)

KeyFieldSource TableSource FieldDescription
Client cepc mandt
Profitcenterarea cepc khinr
Validfromdate cepc datab
Segment cepc segment
Validtodate cepc datbi
Personresponsible cepc verak
Profitcenter cepc prctr
Controlarea cepc kokrs
OriginalLanguage cepc spras
Language cepct spras
Generalname cepct ktext
Lockindicator cepc lock_ind 
@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     
   }

Learn More