How to find Table Names

[Former Member]

HI folks,

I am not a CRM person, but a BI guy. I have a hard time finding the tables in CRM where the data is physically stored since F1 on a field mostly leads to a structure. Can any one tell me if there is an easy way to find the table names? For example, i am tring to find out the name of the table where the Marketing attribues are stored for a particular BP. F1 took me to a structure from the BP transaction code. Any help will be greatly rewarded........

[former_member195032 · Accepted solution]

Hi,

It is easy to do.

I will tell you tricks.

You need to ST05 transaction access.

Open two SAP screens in CRM system. In one screen open ST05 and check box should be as SQL trace.Activate the trace by clicking Activate.

Open another CRM transaction in other screen,when CRM screen will be called ,it must be calling some CRM table.

Deactivate Trace in other screen.

Display trace,it will open a new window which will show you details of all select statements.

Generally if you have SAP experience you will be in position to differntiate in System tables and CRM tables.

If you are running any CRM program,see it's package name,generally CRM tables will start with that package name as initial.

Suppose Some package is ABC_EFG

then generally SAP sets rules as table name will ABC.

You can activate Trace N number to time to see from where all these data are picked.Just activate and deactive after doing any execution in screen and you will get the table name.

The output report is little tough to understand.Just spend some time,u will get the needed.

I hope this helps..

regards,Nishant

Message was edited by:

Nishant Rajan

[Former Member]

Hi sendmeinfo,

Nishant had given you a very nice explanation on what you have asked. I think you must appreciate him by rewarding some points. It generates more interest among the forum members. Keep it to the good habit of rewarding members.

Regards.

Paul Kondaveeti

[Former Member]

Thanks Nishant.....that was pretty good. I have given you full points. Kondaveeti, sorry for the delay, i hadnt checked the forum in 4 days...was sick u know.....and hence the delay. Hope you dont mind it.....

[Former Member]

Hi,

Appreciated your comments. My intention is not to hurt you. I am personally spending lot of time in solving members issues. I will be very happy to see that someone's issue is got solved because of my response. More than that, if someone rewards me, I feel very nice about it. I just tried to be in Nishanth's shoes.

Anyway thanks for not misunderstanding my commnets.

Get well soon

Regards,

Paul Kondaveeti

[Former Member]

My intention is not to hurt you either....before you make a comment asking people to do something, you should either be in a position of power over the people who you command or you should have done some research over wheteher i have given points or not before. U didnt do either. U made a statement which is not appreciated.....I have never not rewarded anyone for answering my questions. And i expect the same..... sorry if i sound rude, but you totally sounded rude making that comment...God Bless!!!!!! Keep up the good work!

[Former Member]

My sincere apologies

[Former Member]

Apology accepted....and thank you for keepig this forum active....i am not a CRM person, but i notice that u have a lot of points which means u are active.

[Former Member]

After looking into my reply one more time, I understood what went wrong. I have copied and pasted the response from one of my previous threads, where I have appreciated another member for rewarding for my answer. So in this reply the same message sounded in a very negative manner. I hope you can understand the situation and do not embryos me anymore.