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

Relationship between unknown SAP-TABLES

Hi Folks,

Lets take a scenario of populating an ouput internal table with fields from 4 unknown sap tables(relation between the tables is unknown). How can we check the relationship between those tables to populate the internal table..? What are the possible ways to check the relationship between tables..?

Can u please help me on this.

Thanks n regards,

ram.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 26, 2007 at 09:51 AM

    Hi

    you can check the relationship between those tables using abapquery

    t code SQ02. crete a new one and enter the tables from that u can find the realtion ships.

    M Kalpana

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 26, 2007 at 10:05 AM

    hi,

    go to sqvi ,in creation mode, in table join area if u enter all four tables system would suggest what is the relationship between all the tables and fields

    reward if this helps !!!!!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 28, 2007 at 05:45 AM

    Hi <b>Ram</b>,

    I tried the following method to find relation between tables and i think it is quite useful. I hope this will be of some use to you.

    -> Goto SE11 and display one of the tables.

    -> Click on the <b>Graphic</b> icon on the toolbar or use shortcut ctrlshiftF11

    -> It displays all the related tables by foreign key and even gives you all check tables involved. If the list is a long one, you can even use <u>Find</u> option to check if the other tables you are trying to find relation with, exist in the screen.

    Hope this Helps!! Do get back!!

    Regards,

    <b>Naveenan</b>.

    Add a comment
    10|10000 characters needed characters exceeded

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.