Spool table data retrieval date wise

[Former Member]

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

[Former Member]

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.

[GauthamV]

if you want it from table then follow above option.

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