maintaining program last run date

[Former Member]

Hi Experts,

The program will be run on a daily basis. To avoid duplication of data the extract should store the last run date. Every time it runs it should check the last run date and return only records subsequent to that run date. Can anyone please give the solution.

Regards,

venkatesh

[h_senden2]

what you can do is add a record to the TVARV table with the last run date of the program.

At the beginning of the program you check this record.

At the end you have to update this record with the current date.

regards,

hans

[Former Member]

Since the job runs daily only once. When you extract the data use sy-datum to extact the data.

If it runs more than once, then create a table to store the program name , last run date and last run time.

regards,

Advait

[kesavadas_thekkillath]

Create a Z table and do that.

[Former Member]

Dear Venkatesh,

You need to create custom table for the same.Wherein you will be storing the date and time,at the end of your program.At the start of your program ,you can select the record with max date and time from this table.This way scenario can be easily handled.

Hope it helps you.

[Former Member]

Dear Venkates,

u can do this by maintaining the last run date in some ztable

ztimestamp

when u execute the program check whether ur current date is greater thna the value stored in the ztimestamp.

but remember u nedd to use locking mechanism for this

after the execution update the Ztimestamp with the current value

use the enqueu and deque functionality

u need to do this to avoid simultameous update to ur timestamp.

hope it solves ur problem.

thanks sushant

[Former Member]

Hi,

Thanks for your valuable solution.

regards,

venkatesh