topic Re: Table updation using reports. in Application Development and Automation Discussions

Table updation using reports.

Former Member — Fri, 07 Jan 2011 05:09:06 GMT

Hello friends,

I have written a code to convert internal table into XML and i have provided an option to Download it.

1. Once they download , the invoice no and date should store in a newly created table.

2. If they try to download it again it should show an error like "This has been Downloaded".

How to update by using reports.

Please someone help me on this.

Regards,

Vijay Vikram

Re: Table updation using reports.

Former Member — Fri, 07 Jan 2011 05:58:51 GMT

Hi Naidu

Find whether Download is successfull or not. Using SY-SUBRC.

if it is success then check whether the values are already inserted there in the table by select statement

Ex: select single Inv_No from table where INV_No = INV_No.

if sy-subrc = 0.

message 'already inserted' type 'S'.

else.

insert required fieds into the table using INSERT statement.

endif.

with Regards,

Murthy

Re: Table updation using reports.

Former Member — Fri, 07 Jan 2011 06:17:15 GMT

Thanx Murty,

suppose if they have downloaded it ten days before then there should be an indication for them no...

Then how to provide an indication????

regards Vijay

Re: Table updation using reports.

Former Member — Fri, 07 Jan 2011 06:17:53 GMT

Hi Naidu,

Hope you have created a database table ('Z') to maintain the downloaded invoice number and date.

If then you can update the invoice number and date to that table when download was successful, if sy-subrc equals 0. If again user prompts to download the invoice number should be same. So you can write a select query to find whether the same invoice exists or not. if it finds the you can show the error message.

select inv_no from zdown where inv_no = lv_inv_no.

if sy-subrc <> 0.

call function 'GUI_DOWNLOAD'

....

if sy-subrc <>0.

message e...

else.

update table zdown ...

else.

message e...

endif.

Re: Table updation using reports.

Former Member — Fri, 07 Jan 2011 06:26:05 GMT

@pnkarthi Thank you Very Much, Thats a Very helpful answer.

I need to give them an indicator to show them that its downloaded like checkbox someting...

Regards,

Vijay Vikram