Transaction Name

[Former Member]

Hi

I am looking for the transaction using which we get mapping of two Table related fields..

I remember having seen this sometime back but dont remember it now...

The transaction gives us a diagram showing all the field names and arrows pointing out to related fields of each other... kind of custom control development

Please help me out with this...

[Former Member]

Hi

I am looking for the transaction using which we get mapping of two Table related fields..

I remember having seen this sometime back but dont remember it now...

The transaction gives us a diagram showing all the field names and arrows pointing out to related fields of each other... kind of custom control development

Please help me out with this...

[Former Member]

Tx SQVI.

by creating table joins.

Amit.

[naimesh_patel]

I think you are looking for the "Graphics" relation of the tables.

You can use SE11.

Enter the table name and display.

There is button of "Graphics" (just before the Table Contents.

Or you can use the CtrlShiftF11 to get the graphics representation of the table.

Regards,

Naimesh Patel

[Former Member]

Naimesh,

Grame Smith Wrote:

I am looking for the transaction using which we get mapping of two Table related fields..

I remember having seen this sometime back but dont remember it now...

The transaction gives us a diagram showing all the field names and arrows pointing out to related fields of each other... kind of custom control development

Naimesh wrote:
I think you are looking for the "Graphics" relation of the tables.

You can use SE11.
Enter the table name and display.
There is button of "Graphics" (just before the Table Contents.
Or you can use the Ctrl+Shift+F11 to get the graphics representation of the table

no i think he is asking about graphics relation between two table and you come with solution for graphics for only one table.

Edited by: Amit Gujargoud on Aug 19, 2008 4:56 PM

[naimesh_patel]

Open table MAKT and try to press the Graphics button.

You will see the relation between MAKT, MARA, T000 and T002.

There is a foreign key relationship of fields MANDT, MATNR, SPRAS in table MAKT with respective tables T000, MARA and T002.

Regards,

Naimesh Patel

[Former Member]

Naimesh Patel

You are 100% correct. it will show the Graphical relation between the tables which are associated with that table.

[Former Member]

Naimesh,

yes you are right if i want to see foreign key relationship.

but what if i want to see with MARC from MAKT it self?

Amit.

[naimesh_patel]

If you know the table relations than why to use SQVI. We can figure out the relation ourselves.

This graphics will be helpful when you don't know the table relations.

Check the graphics for the table MARC. It contains so many table relations, which we don't know when try to enter in SQVI.

Regards,

Naimesh Patel

[narin_nandivada3]

Hi,

You are asking about Quick Viewer --> SQVI

For further details on that please go through this link,,,

http://www.sapsecurityonline.com/tutorials/r3_sqvi_tutorial.htm

Hope this would help you.

Good luck

Narin

[Former Member]

Hi

your answers did not quite give me the solution but as of now SQVi works for my purpose even though it wasnt the transaction what I was looking for..

Just like you see Graphic diagram for SE11 tables I have seen graphic which point out the relation between the tables I want...

SE11 graphic only tells me about that particular table and its Foreign Key relations

[naimesh_patel]

If you are looking for FI-SL table relations, you can use the transaction GCD6.

Regards,

Naimesh Patel