Don't use all CAPITALS in your subject
suppose 15 entries in the z table exist and i want to add next one through dialog programming.
so what i am doing is that, i want max id of the table field customer_code that storing the value like
so i need a function module or select query so that customer_code 003 should return.
so that i can add another record by id 004.
data: w_comp_code type zfn_co_master-company_code.
SELECT MAX(COMPANY_CODE) w_comp_code from zfn_co_master.
i am using this code but this is not working.
well any suggestion will be much appreciated.
Thanks in advance
Edited by: Matt on May 25, 2009 1:37 PM