topic Re: Database tables used by Solution Manager? in Application Development and Automation Discussions

Database tables used by Solution Manager?

Former Member — Tue, 22 Jul 2008 08:19:47 GMT

Hi,

I have to create an ALV fetching the data from solution manager related to SIR details.

There is an ALV report program CRM_DNO_SERVICE_MONITOR

I have to create a similar sort of ALV with 5-6 fields information related to SIRs but not getting from where the report is fetching the data.

Please resolve the issue soon.

Its very very urgent....

Thanks & regards

Amit Kumar Singh

Re: Database tables used by Solution Manager?

naveen_inuganti2 — Tue, 22 Jul 2008 09:04:42 GMT

Hi....

I am nto having that program in my system....

any way ... Try with SQL Trace...

>1. Activate SQL trace in ST05

>2. Goto that program and excute with some selection criteria

>3. Now deactivate the Trace and Display!

>4. You can get all the tables and technical information about that Program

Try this..,

Thanks,

Naveen.I

Re: Database tables used by Solution Manager?

Former Member — Tue, 22 Jul 2008 09:18:20 GMT

I have tried with SQL trace also, every where only program name gets displayed in place of table name and also in the from the program i understood that they are using LDB's but i don't know about how to use LDB's & not getting the source table names.

Please help...

Re: Database tables used by Solution Manager?

Former Member — Tue, 22 Jul 2008 15:16:36 GMT

Hi Amit,

Using T. Code ST05, u can find out all the table, fields used for the perticular transaction.

By activating the trace, you get all detailed about that transaction

Kindly Reward Points If You Found The Reply Helpfull

Cheers,

Chaitanya.