segments_pc_view

DDL: SEGMENTSWITHPCCOUNT SQL: SEGMENTS_PC Type: view Package: ODATA_SEGMENT

Segments with Porfitcenters' count

segments_pc_view is a CDS View that provides data about "Segments with Porfitcenters' count" in SAP S/4HANA. It reads from 2 data sources (cepc_cmdt_pc, segment_desc) and exposes 4 fields. Part of development package ODATA_SEGMENT.

2 data source(s) 4 fields

Data Sources (2)

SourceAliasJoin Type
cepc_cmdt_pc pc left_outer
segment_desc segm from

Annotations (4)

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

Fields (4)

KeyFieldSource TableSource FieldDescription
segmentID segment_desc segmentid
description segment_desc description
PCCount cepc_cmdt_pc pccount
langu segment_desc langu 
@AbapCatalog.sqlViewName: 'SEGMENTS_PC'
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #XL
}
define view segments_pc_view as
   select from segment_desc as segm
   left outer join cepc_cmdt_pc as pc
   on segm.segmentid = pc.segmentid
   { 
       segm.segmentid as segmentID,
       segm.description as description,
       pc.pccount as PCCount,
       segm.langu as langu
   }

Learn More