topic Spool table data retrieval date wise in Application Development and Automation Discussions

Spool table data retrieval date wise

Former Member — Fri, 15 Jan 2010 06:43:58 GMT

Dear All,

I want to count date wise spool request from table TSP01. but date field not exists in format.

How i will count spool request date wise.

If any other table exists or any date conversion method. Please provide.

Thanks

Narendra Jinger

Re: Spool table data retrieval date wise

Former Member — Fri, 15 Jan 2010 06:49:11 GMT

Hi narendra,

The date field is there with the time concatenated. the field name is RQCRETIME.

It contains the DATE + TIME in concatenated format.

YYYYMMDD HHMMSS

So you can do a select query from this table.

Then either take the first eight characters from this field (using abap syntax Variable(8)) into another field added in that itab, and use COLLECT to count the number of records date wise.

Its simple to do, nothing complicated.

regards,

amit m.

Re: Spool table data retrieval date wise

GauthamV — Fri, 15 Jan 2010 06:58:57 GMT

if you want it from table then follow above option.

You can also get the spool requests date wise from SP01 transaction.