topic Re: Table Information in Application Development and Automation Discussions

Table Information

Former Member — Thu, 08 Feb 2007 17:59:41 GMT

Hi,

Can anybody please let me know the the data flow coming from which TABLES in ACTUAL LINE ITEM REPORT?

There is a structure name RKPLN and report & Programme name is RKAEP000. I can't be able to see the Table from which i get the Data.

It's really very urgent and your help will really appreciate.

Thanks,

Dhaval shah.

Re: Table Information

Former Member — Thu, 08 Feb 2007 18:02:31 GMT

Hi Dhaval,

Switch on the SQL trace and run your report. Use transaction ST05 to switch on the SQL trace. Once you are done executing the report deactivate the SQL trace and see the log. There in you can see all the accessed tables with their Selection Query.

Please try and this should definitely help.

Thanks

Re: Table Information

Former Member — Thu, 08 Feb 2007 18:10:05 GMT

Just go to structure and then click on the field which you feel very improtant to you or you think can be a key field. then clieck on where used list. It will give you list of tables which are using this field. Open them one by one and you will find your needed table.

I don't have TCODE : RKAEP000 on my system other wise I may have given you table name straighaway.

Hope this will help.

Darshan Patel

Re: Table Information

Former Member — Thu, 08 Feb 2007 18:21:41 GMT

Hi Darshan,

Thanks for the quick reply. How i can go to Structure? can you please let me know the TC for that? I am a Functional Guy and not a Technical guy.

your help would really appreciate.

Thanks,

Dhaval Shah.

Re: Table Information

Former Member — Thu, 08 Feb 2007 18:23:47 GMT

To go to the structure use TC SE11.

And then by clicking on structure name press Where used list.

Thanks

Re: Table Information

Former Member — Thu, 08 Feb 2007 18:35:46 GMT

Hi Dhaval,

Go to transaction code SE11 to view structure/table.

Give your structure name against Database table entry and Click on Display button. This will show the fields in the strucure. As strucure can not hold data, but it can hold data in the run time of the report only.

Thanks,

Vinay

Re: Table Information

Former Member — Thu, 08 Feb 2007 19:50:56 GMT

Hi,

Thanks a ton to everyone. i'll really appreciate your help.

Thanks once again.

Dhaval Shah.