tables needed

Former Member — Wed, 14 Nov 2007 03:53:15 GMT

Hi Experts

I have to develop a report on production side, regarding how much parent component is produced and child component is consumed on a particular date.

Whats the relationship of tables for this ,please give me the techinical spec.

can we use AFRU, RESB, MSEG tables, if so whats the relationship among all.

pls help me on this.

Thanks in advance.

Regards

Rajaram

Re: tables needed

Former Member — Wed, 14 Nov 2007 06:26:36 GMT

Hi Raja,

you can find the relationship among tables using transaction SQVI.

1) Go to SQVI transaction.

2) Create a qucik view.. ztest.. give desc..etc

3) Select data source as table join.... enter

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

5) enter <table name1>

6) click that again.. enter <table name 2>

7) now an image will come with links b/w these 2 tables.

😎 you can use any no. of tables there.

hope this helps.

reward if usefull.

Thanks,

Swati