‎2011 Jan 12 5:08 AM
Hello friends,
I have written a code in ALV to convert internal table into XML and i have provided an option to Download it. Once they download , the invoice no and date should store in a newly created table.
The Requirement is:
I need to put a indicator column as a status that should indicate that this has been downloaded(it may be a star, hypen).
Please somebody help me out.
Regards,
Vijay Vikram
‎2011 Jan 12 5:56 AM
Hi,
Create Z program with invoice no. , Date and a check box (it will be updated once the file is downloaded).
so there are 2 methods either you dislay the check box of the custom table in ALV which shows that file is downloaded to the user.
secondly have you done the coding to download internal table to excel.
if yes,
then where the user command is getting triggered.
first check the cuztom table for the invoice no. and corresponding check box, if it is already marked that means file has been downloaded and you can display a message to user.
if it is not marked
download the file and then update the custom table.
‎2011 Jan 12 5:56 AM
Hi,
Create Z program with invoice no. , Date and a check box (it will be updated once the file is downloaded).
so there are 2 methods either you dislay the check box of the custom table in ALV which shows that file is downloaded to the user.
secondly have you done the coding to download internal table to excel.
if yes,
then where the user command is getting triggered.
first check the cuztom table for the invoice no. and corresponding check box, if it is already marked that means file has been downloaded and you can display a message to user.
if it is not marked
download the file and then update the custom table.
‎2011 Jan 12 7:33 AM
hai naidu,
In Your Z Table add a field Status.
at the top of the down loading function module give sql statement as :
select single * from ztable where inv_no = inv_no and status = ' '.
if sy-subrc = 0.
" Downloading Function Module
if sy-surc = 0.
update ztable set status = 'X" where inv_no = inv_no.
endif.
endif.
the Invoce Numbers which are having Status X are downloaded Invoices
Remaining are not downloaded.
With Regards,
Murthy