tool to find the common fields between std tables.

[Former Member]

Hi everyone,

Im working on standardtables like mara , kna1 , vbak, vbrk etc, when ever im in need of any common column between these

tables im looking for entires fields present in each table.

i want to that whether is their any tool to find the common columns between two or more standard tables.

[Former Member]

Hi everyone,

Im working on standardtables like mara , kna1 , vbak, vbrk etc, when ever im in need of any common column between these

tables im looking for entires fields present in each table.

i want to that whether is their any tool to find the common columns between two or more standard tables.

[kesavadas_thekkillath]

There is no need of any special tool for this.. You can use the where used list functionality.

Click on the data element of the particular table field. Then choose the data element and hit the where used list button, then mark the check box database tables and hit enter.

[Former Member]

Hi !

And Also you can click on foreign Key relationship on field and check the table names.

[;

[Former Member]

You can use the Where Used Functionality as well you can go for Check table, Foreign Key concepts and Value table too from Data Element than Domain.

Thanks

Arbind

[RaymondGiuseppi]

There is such a tool in wiki ([Tool to display common fields between 2 database tables|http://wiki.sdn.sap.com/wiki/display/Snippets/Tooltodisplaycommonfieldsbetween2databasetables])

But a common data element/field name is not always a join criteria. (e.g. ERSDA)

There are other ways to find such join criteria.

- Foreign keys and check tables (Try the "Graphic" icon in SE11)

- Logical database (SE36) using a table

Regards,

Raymond

[Former Member]

Hi Ramchander ,

1) Go to tcode sq02 and enter a test infotype name and click on create.

2) A pop up window will open ...enter the name and select table join basis table   then Ok.

3) Now in the next window....click on "Insert table". Enter your table name and click Ok.

4) It will show the same fields in two different tables.

Plz reward if helpful.