How to set the querrys run daily in batch and variable input is current dat

[Former Member]

Hi ,

i have two Problems.

i need to run query daily in batch jobs

1. while running querrys by autosys it has to take reporting date is current date automatically. How to set this current date in variable.

2. The out put of the querrys have to save in files where the file name will be XXXXXXX_date of reporting.

how to do that.

if we need to wright abap program please give the syntax for that.

Any kind of help is Appreciated.

[Former Member]

For question 1, the way this is done us ising variable 0DAT which is the current calendar day (SAP Exit) variable. The relies on using 0CALDAY in your cube. If you have anything else other than 0CALDAY you may need to use a customer exit variable

Don't know about question 2.