i'm doing a select for a max-value in a column of a table. i'm getting the highest value exists twice (in two rows) and the rc that i get is 4. how can i get both rows in an internal table? or can i specify more tahn 1 column to find only one max-value.
the first column is a date, the second i could use would be a time-field.
SELECT * FROM yvtebstg
INTO CORRESPONDING FIELDS OF TABLE lt_ebstg
WHERE polnr = ls_vermitt-polnr
AND temudat = ( select MAX( temudat ) FROM yvtebstg ).
many thanks, martin.