Skip to Content
0
Jun 29, 2015 at 04:21 PM

Extracting the latest status from JCDS

165 Views

Hi All,

I have a requirement of extracting a single row for each OBJNR field in the status table JCDS based on

  • - Highest value in UDATE
  • - Highest value in UTIME
  • - Highest value in ISTAT
  • - Highest CHANGENR
  • - INACT = ‘’

Since this is a big table, the approaches I tried aren't really performing well. I assume the best way to do this is by SQL considering the number of self joins that would be needed to achieve this via graphical. Correct me if I am wrong on that point please.

A plain order by on these records or a nested select for millions of entries also is not a viable solution.

Please let me know of a suitable approach.

Thanks,

Shyam