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.