Skip to Content
author's profile photo Former Member
Former Member

How to find Table Names

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........

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Feb 23, 2007 at 08:21 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2007 at 08:17 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.