‎2006 Nov 16 1:17 PM
Hi there. I'm using ADA logical database to perform data selection. After I select data from certain table, I have to restrict the result with another selection. How can I select the max value from table ANEP?
‎2006 Nov 16 1:22 PM
Select max(Fieldname here) from ANEP into WORK_AREA where MENTION_CONDITION
I hope it helps.
Best Regards,
Vibha
*Please mark all the helpful answers
‎2006 Nov 16 1:19 PM
u get data to variable/internal table. now loop this and using another data selection u can restrict the values.
‎2006 Nov 16 1:22 PM
Select max(Fieldname here) from ANEP into WORK_AREA where MENTION_CONDITION
I hope it helps.
Best Regards,
Vibha
*Please mark all the helpful answers
‎2006 Nov 16 1:22 PM
Hi,
You may go like this -
Get <struct/tab>.
.
.
if tab-field <= v_value. (to select values greater than v_value.
reject.
End-of-selection.
Regards,
Amit
‎2006 Nov 16 1:31 PM