Skip to Content
0

How to determine the score based on a tolerance value in CDS Views, S/4 HANA?

Apr 12, 2017 at 03:32 PM

64

avatar image
Former Member

I have a requirement in which we need to calculate the score based on a particular fill rate/tolerance value of supplier.

The score will be maintained in a custom table with the values. Based on the % difference of the fill rate which is calculated for every Purchase Order, can you please guide us how would we derive the score for that associated value?

Please let us know how would we achieve this using CDS Views in S/4 HANA.

Example is shown below for reference.

If Fill Rate : 0-20 %, Score is 20

If Fill Rate : 20-39%, Score is 40

If Fill Rate is 40-59%, Score is 60

If Fill Rate is 60-100%, Score is 100

It would be indeed helpful if you can help us in your suggestions.

Thanks,

Aditi

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sean Zhang
May 27, 2017 at 04:10 PM
1

you could use the case when statement in the CDS to calculate the score.

Share
10 |10000 characters needed characters left characters exceeded