topic Re: Transaction Name in Application Development and Automation Discussions

Transaction Name

Former Member — Tue, 19 Aug 2008 14:46:22 GMT

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...

Re: Transaction Name

Former Member — Tue, 19 Aug 2008 14:48:07 GMT

Tx SQVI.

by creating table joins.

Amit.

Re: Transaction Name

naimesh_patel — Tue, 19 Aug 2008 14:49:44 GMT

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

Re: Transaction Name

Former Member — Tue, 19 Aug 2008 14:55:59 GMT

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

Re: Transaction Name

naimesh_patel — Tue, 19 Aug 2008 15:03:51 GMT

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

Re: Transaction Name

Former Member — Tue, 19 Aug 2008 15:09:39 GMT

Naimesh Patel

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

Re: Transaction Name

Former Member — Tue, 19 Aug 2008 15:14:11 GMT

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.

Re: Transaction Name

narin_nandivada3 — Tue, 19 Aug 2008 15:18:59 GMT

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

Re: Transaction Name

naimesh_patel — Tue, 19 Aug 2008 15:20:57 GMT

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

Re: Transaction Name

Former Member — Thu, 21 Aug 2008 07:07:07 GMT

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

Re: Transaction Name

naimesh_patel — Thu, 21 Aug 2008 13:03:39 GMT

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

Regards,

Naimesh Patel