Showing results for 
Search instead for 
Did you mean: 

Entity Set Not Available for KPI modeler for Custom CDS view

0 Kudos

Hi Experts,

I have created a CDS view and the service got created based on @Odata.publish: true. I am able to see the CDS view in the Create KPI tile and also the service but not the Entity Set.

I have gone through the blog and it is mentioned how to get the CDS view but it did not mention whether we have to perform any activity in SEGW or any specific coding in CDS view. there are similar questions on this subject but there are no specific answers.

Do we have to create the Entity set separately in SEGW. or how is the KPI modeler identify the entity set.

i have checked standard CDS views(example C_OVERDUEPO) and they donot have any configuration in SEGW. but the entity set C_OverduePOResult is available.

The following are the screen shots or the CDS view created.

the following is the screen shot of the service. as shown below in the metadata i am able to see the entity Set Z_CDZ_PODISPLAY but not in KPI modeler.

Accepted Solutions (0)

Answers (2)

Answers (2)

0 Kudos


when i add this below default Aggregation , then Entityset is showing in KPI Design(DataSource). - Working fine.

@DefaultAggregation: #SUM

Sample CDS Below:

@AbapCatalog.sqlViewName: 'ZPODISPLAY'

@AbapCatalog.compiler.compareFilter: true

@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #NOT_REQUIRED

@EndUserText.label: 'PO DISPLAY'


@OData.publish: true

define view Z_CDS_PODISPLAY as select from ekko as Poh

inner join ekpo as poi on Poh.ebeln = poi.ebeln {

key Poh.ebeln as ponumber,

poi.werks as plant,

Poh.bukrs as companycode,

poi.mtart as MaterialType,

poi.matkl as MaterialGrp,

@DefaultAggregation: #SUM

poi.netwr as Value


0 Kudos

See the CDS view creation given here

If you follow these directions Entity Set is generated as well.

Former Member

I can see entity set in APF, but not in KPI modeler. What could be the reason? Do I have to implement class in the Entity set separately in SEGW?

0 Kudos

I also can't see entity set in KPI builder, why?