last data upload date

[Former Member]

Dear Friends,

How can we print last data load date on our report.

regards,

Malik

[Former Member · Accepted solution]

Hi Malik,

In WAD you can use info Field -> General Text Element -> Last Data Update

Regards

Erwin

[Former Member · Accepted solution]

is it possible in query designer

regarfds,

Malik

[Former Member · Accepted solution]

Hi,

Once execute your query and follow the above procedure. You cant execute query it in Query Designer.

Regards

Pcrao.

[Former Member]

i did as you suggest ERWin

but its giving me wrong time of last

data load.

my last data load was 17.01.2009 08:01:23

But its giving me the time 17.01.2009 02:05:42

regards,

Malik

[Former Member]

Hi,

you can use the following parameters in text web item:

- Last Data Update (ROLLUPTIME)

- Last Refresh (LAST_REFRESHED)

- Last Data Refresh (ROLLUPTIME_MAX)

Check them I think you do not use "Last data update".

http://help.sap.com/saphelp_nw04s/helpdata/en/8c/d9413a3ace7022e10000000a11402f/frameset.htm

Regards

Andreas

[Former Member]

Hi Andreas,

Do you know what to do to get the desired font size for the output of the parameter ROLLUPTIME_MAX. Currently I am using it but the font size is big and I need a small font. Thanks for your help.

Regards,

Abhi

[Former Member]

thanks for the help friends,

[Former Member]

Hi,

Open your query in Bex Analyzer -->select Layout tab >Goto Display Text Elements>Select General--> it will display Status of Data (last load) & Last Refreshed .

Regards

Pcrao.