Table Information

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

To go to the structure use TC SE11.

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

Thanks

[Former Member]

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

[Former Member]

Hi,

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

Thanks once again.

Dhaval Shah.