Hi, I was trying to get the latest BELNR number from the EKBE table. However, there were multiple BELNR values and I'm getting the first one instead of the latest. In the example below, I was able to get the EBELNR 0001 instead of the 0003.
Here's my code:
SELECT ebeln ebelp zekkn vgabe gjahr belnr buzei bewtp budat menge dmbtr wrbtr waers shkzg hswae FROM ekbe INTO TABLE t_ekbe
ORDER BY ... DESCENDING ?