Table with Background Job log

[thomas_gaberthel]

Hi,

can anybody tell me, which table is used to store the Background Job log Details?

many thanks, Thomas

[former_member220624 · Accepted solution]

HI,

the tables that stores job detials..

is TBTCO and TBTCP..

TBTCO contains the details of the job start date ,enddate status sheduled person name and full header details..

TBTCP table contains the details of all related if any person calcels the job sheduled by another person all the details regarding job stored in this table

Regards,

Amit

[thomas_gaberthel · Accepted solution]

If I restrict both tables with key = Job Count, I get one result row in TBTCO and TBTCP. Some informations like start- / end-time, Variant etc are available.

But I don't see the Detail-Rows like:

LOCK TABLE "TESTDATRNRPART0" in exclusive mod

or

SQL: 01.12.2015 01:41:41 BWREMOTE

[Former Member · Accepted solution]

I'm afraid you will not find this in any readable format in the SAP tables.

If you want to know more: open the log of the process chain (do not open the log of the step yet), then activate an SQL trace in ST05 in parallel window, open the log of the step, double click on a row and then deactivate the trace, and look at the log of the trace. You will have a a nice overview of the tables he accessed in which way he gets the info (basically het gets the log id from the RSPC* tables and then goes through BALHDR/BALDAT)