tables needed

[Former Member]

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

[Former Member]

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