cancel
Showing results for 
Search instead for 
Did you mean: 

如何剔除CDS中的不活动的数据

yiqiangWang
Participant
0 Kudos
149

(ES系统)我自定了一个CDS,但是这个CDS中存在两条数据(价格数据)。据反馈,这两条数据其中一条应该是不活动的,但是在CDS中还是有记录。导致我已这个CDS做数据表的时候,显示的数据会翻倍。请问,怎样剔除CDS中存在但实际在价格数据底表中可能不激活的数据?

yiqiangWang_0-1723619451934.png

 

OwenLiu
Product and Topic Expert
Product and Topic Expert
0 Kudos
Add Extensibility tag.

Accepted Solutions (0)

Answers (1)

Answers (1)

AndreasMuno
Product and Topic Expert
Product and Topic Expert
0 Kudos

Thank you for your question, @yiqiangWang.

I will respond in English as I had you question machine-translated to English like follows:

How to Lift Inactive Data in CDS
ES system) I customized a CDS, but there are two data (price data) in this CDS. According to feedback, one of these two data should be inactive, but there are still records in CDS. As a result of the fact that I have this CDS as a data table, the displayed data is doubled. Q. How do I remove data that exists in CDS that may not actually be active in the price data base table? 

With the image provided I conclude, it is not a duplication of line items but of columns you are concerned about, right? Because the line items show different values, therefore it is correct for the view to show different entries in the list.

  • As an end user, you can always filter for data you don't want to consider using the filters on the UI.
  • As a developer, you can exclude values by filtering with a narrower select statement over the same data entity. 

As I understand the table columns YY1_SD_21 and _22 as duplicative it should be in your power to eliminate one of them from this custom CDS View.     

if this helped, please mark the answer accordingly. Thank you.