How to view Table relations in a report ?

[former_member225225]

Hai Guru's

I want to view table relations in a report.

How ?

where i should pass the tcode..?

For exam:

In SQVI tcode we can see the table relation by inserting tables

like this if i can insert report name can i view the table relations which present in that report

how?

any tcode is there to view the info?

plz help me

Thanks in advance,

syam.

[james_wong]

Hi Syam,

You may want to refer to

Best regards,

James

[former_member225225]

Hi James,

Thanks for the reply,

i referred your link,

But actual thing i am not getting,

plz see above example.

Regards,

Syam.

[Former Member]

Hi

your post is old, but I can help you. Can you update your request ?

[former_member225225]

Hi Laurent,

Thanks for the reply.

If u want to see the individual table relation we are using SQVI tcode in that we are inserting tables and we are identifying the relationship of tables. like this

In the same way i want to know the table relations in one particular ALV report etc

it means if we given input as report name means i want to see the table relation like this

is it possible ?

any tcode is there to view like this means ?

plz help me

[sunil_yadav2]

Hi Syam,

if you want to know table linkage than check below link:

if you want to see standard setting from which table fetch data in reports than check TCODE:-CJE6 &CJE2. these tcode display different setting. if you require new report for customer based on business requirement than you can use these and create a new report.

other options are SQVI and SQ01,SQ02 & SQ03 where you can join tables and extract required fields based on business requirement.

thanks

Sunil

[former_member225225]

Hi Sunil,

Thanks for the reply,

Your stuff is helpful in creating new ecc reports,

But i want to see the existing ecc reports table relations.

Regards,

Syam.

[MTerence]

Hi Syam,

Below is the SAP PS Tables and its linkage

You can get the tables involved in a program. Go to SE80 - Enter the program and CLick display - expand dictionary structures to get the list of tables involved, but you will not be able to see similar to SQVI.

Else you need to ask your abaper to debug the flow and let you know how it was coded.

Regards

Terence

[former_member225225]

Hi Maria,

Thanks for the reply.

and thanqs allot for the  technic..

Regards,

Syam.