Skip to Content
0
Former Member
Apr 27, 2009 at 06:11 AM

how will i select data w.r.t. maximum date

4440 Views

my code is as below : here i have to select data according to latest date/maximum date in internal table

SELECT mandt werks zpdate zlabor zn_material zyield_norm_prev crnam crdat ctime auser aedat atime FROM zppnorm078

INTO TABLE git_zppnorm078

WHERE werks = zppcokebf078-werks

AND zlabor = zppcokebf078-zlabor.

  • AND zpdate MAX(zpdate).

please help.