Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Indicator.

Former Member
0 Likes
716

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

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
546

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.

2 REPLIES 2
Read only

Former Member
0 Likes
547

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.

Read only

Former Member
0 Likes
546

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