Advertisement
Guest User

Untitled

a guest
Mar 20th, 2019
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.89 KB | None | 0 0
  1. +----------------------+-----------------+-------------------------+
  2. | Confirmation (RUECK) | Counter (RMZHL) | Finish Execution (IEDD) |
  3. +----------------------+-----------------+-------------------------+
  4. | 30116 | 1 | 08/26/2014 |
  5. | 30116 | 2 | 08/27/2014 |
  6. | 30116 | 3 | 09/27/2013 |
  7. +----------------------+-----------------+-------------------------+
  8.  
  9. SELECT MAX( rmzhl ), iedd FROM afru
  10. INTO (@DATA(lv_rmzhl), @DATA(lv_iedd))
  11. WHERE rueck = '0000030116'
  12. GROUP BY rmzhl, iedd.
  13. ...
  14. <some fancy code here>
  15. ...
  16. ENDSELECT.
  17.  
  18. SELECT SINGLE iedd
  19. FROM afru
  20. INTO @DATA(lv_iedd)
  21. WHERE rueck = '0000030116'
  22. AND rmzhl = ( SELECT MAX( rmzhl ) FROM afru WHERE rueck = '0000030116' ).
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement