topic Relationship between tables in Application Development and Automation Discussions

Relationship between tables

Former Member — Fri, 16 Nov 2007 12:41:55 GMT

I want to find the relation ship between tables is there any transaction code .

if available transaction code for relation ship between tables pls reply it..

Re: Relationship between tables

Former Member — Fri, 16 Nov 2007 12:46:05 GMT

Using SQVI transaction u can do that.

go to SQVI --> enter some name and press create. ~~> in data source select Table Join , give description press enter~~> gone blank screen will come. In that toolbar click 2nd button - a dialog will come to Enter table. CLick that as many times as you need and give table names. you will get images with relations between tables in the back end screen.

Re: Relationship between tables

Former Member — Fri, 16 Nov 2007 12:53:59 GMT

Hi Venkat,

Use this PDF file which will help you a lot

http://www.abap.es/Descargas/TAB%20-%20Relacion%20de%20las%20tablas%20por%20modulos.PDF

<b>Reward Points if this helps,</b>

Satish

Re: Relationship between tables

Former Member — Fri, 16 Nov 2007 13:03:21 GMT

hI,

GO TO SE11.TYPE TABLE NAME.DISPLAY.THEN PRESS CTRLSHIFTF11.yOU WILL GET GRAPHICAL REPRESENTATION

Re: Relationship between tables

Former Member — Sat, 17 Nov 2007 05:24:14 GMT

Go to SQVI transaction... Create a qucik view.. ztest.. give desc..etc

Select data source as table join.... enter

now one screen will come with blank data (blue scrren)

in that application toolbar second button .. click that.. enter VBAK..

click that again.. enter VBAP.. now an image will come with links b/w vbak and vbap.. you can use any no. of tables there....