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........
2 Answers
-
Best AnswerPosted 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
-
Former MemberPosted on Feb 26, 2007 at 08:17 PMHi 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
Add a comment