Skip to Content
avatar image
Former Member

CDS Views: How to determine the score based on a tolerance value?

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.

% DifferenceScore80% - 100%10060% - 79% 8040% - 59%6020% - 39%400% - 19%20

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 13, 2017 at 08:27 AM

    Hello Aditi,

    use CASE and BETWEEN.

    Check "abap channel" on youtube
    for more info check scn.sap.com/community/abap/hana

    Mateusz.

    Add comment
    10|10000 characters needed characters exceeded