topic Re: table for SM36 in Application Development and Automation Discussions

table for SM36

Former Member — Mon, 31 Dec 2007 01:57:57 GMT

I had create a batch job using SM36. What is the tablename which this SM36 write to?

Thks

Re: table for SM36

daixiong_jiang3 — Mon, 31 Dec 2007 02:59:33 GMT

TBTCA Subsequent relationship in batch job sched

TBTCB Preceding relationship in batch job schedu

TBTCCNTXT Information for Assignment of Jobs to Comp

TBTCCTXTT Description of Reference Types for Backgro

TBTCCTXTTP Check Table: Valid Job Reference Types

TBTCI Usage counter for the job's internal repor

TBTCJSTEP Background Job Step Overview

TBTCO Job Status Overview Table

TBTCP Background Job Step Overview

TBTCR Batch scheduler execution time

TBTCS Background Processing: Time Schedule Table

Re: table for SM36

Former Member — Mon, 31 Dec 2007 05:12:15 GMT

Hi ,

Run the transaction SM36 , find the program name (in this case SAPLBTCH) , then run transaction SE80 put the program name , click on the Dictionary Structure , its display all the Table , Structure ,class and all dictionary Object used by the transaction . e.g.

Table : BTCCTL Control table for background processing

BTCH4430 After job definition

BTCH4440 After event definition

BTCJSTAT Run-time statistics for background jobs

BTCJN Table of the Job Name for Background Processing

BTCLOG_COD Job log entries in flexible (file) format without date/time

BTCSED Description of system event IDs for background processing

etc..

a long list of tables....

Another method is SQL Trace .. , run transaction ST05 , put the trace on , run the transaction , see the trace , find the table used and dont forget to OFF the trace .

Assign Points if helpful..

Regards

Deepak Rana.