CEPC_CMDT_PC_VIEW

DDL: PROFITECENTERSOFSEGMENT SQL: CEPC_CMDT_PC Type: view Package: ODATA_SEGMENT

Calculate the assigned profitcenters of segment

CEPC_CMDT_PC_VIEW is a CDS View that provides data about "Calculate the assigned profitcenters of segment" in SAP S/4HANA. It reads from 2 data sources (cepc, segment_desc) and exposes 2 fields. Part of development package ODATA_SEGMENT.

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

Learn More