topic Re: Indicator. in Application Development and Automation Discussions

Indicator.

Former Member — Wed, 12 Jan 2011 05:08:35 GMT

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

Re: Indicator.

Former Member — Wed, 12 Jan 2011 05:56:56 GMT

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.

Re: Indicator.

Former Member — Wed, 12 Jan 2011 07:33:57 GMT

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.

the Invoce Numbers which are having Status X are downloaded Invoices

Remaining are not downloaded.

With Regards,

Murthy