CEPC_CMDT_PC_VIEW

DDL: PROFITECENTERSOFSEGMENT SQL: CEPC_CMDT_PC Type: view

CEPC_CMDT_PC_VIEW is a CDS View in SAP S/4HANA. It reads from 2 data sources (cepc, segment_desc) and exposes 2 fields.

2 data source(s) 2 fields

Data Sources (2)

SourceAliasJoin Type
cepc pc left_outer
segment_desc segm from

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName CEPC_CMDT_PC view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #P view

Fields (2)

KeyFieldSource TableSource FieldDescription
segmentID segment_desc segmentid
PCCount 
@AbapCatalog.sqlViewName: 'CEPC_CMDT_PC'

@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.serviceQuality: #P

define view CEPC_CMDT_PC_VIEW as
   select from segment_desc as segm
   left outer join cepc as pc
   on segm.segmentid = pc.segment
   and pc.kokrs = '1000'
   { 
       segm.segmentid as segmentID,
       count( distinct prctr ) as PCCount
   }
   group by segm.segmentid 
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"CEPC",
"SEGMENT_DESC"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More