How to use value help when a field has over 200 statuses?

[YABAPER]

I have a requirement to setup a report that needs a value help. however, this status field (ekbe-bwart) does not have an associated cds view and has over 200 options. What would be the best way to go about doing this?

[junwu · Accepted solution]

if cds is not there, can't you create it?

tell us what you are stuck with.....

[YABAPER · Accepted solution]

@junwu I have tried that but not all 200+ statuses are displayed. Hence I asked what is a possible workaround for creating a value help with large amounts of data

[junwu · Accepted solution]

what do you mean "not all 200+ statuses are displayed"? they paged, and you don't like it?

[YABAPER · Accepted solution]

@junwuthe cds code 

define view ZMSTATUS_VH as select distinct from ekbe as mt
{
  key mt.bwart as mstatus
}
group by mt.bwart

Displays as such:

 As you can see, not all the statuses are showing up as the values in the SAP system are such:

[junwu · Accepted solution]

please show the full picture..... that list is a dropdown or something..... what's the point to hide????

[YABAPER · Accepted solution]

@junwu Which picture are you referring to??? The first picture is all the results I am getting back, there is nothing else after the last entry which is 122. The second picture has over 322 entries as highlighted

[ulrich_mhrke · Accepted solution]

@YABAPER: At your CDS view you select the status which occur at table EKBE. The possible values come from table T156.