ON WHAT FIELDS WE CAN JOIN BUTOOO AND ADDR2_DATA DATBLES

[Former Member]

IS THERE ANY WAY BY WHICH WE CAN SEARCH WHAT WILL BE THE COMMON FIELDS FOR TWO TABLES TO APPLY THE JOIN CONDITION.

[Former Member]

Hi,

U can go to SQVI .

U find the relation between 2 talbes.

Assign points if useful.

[Former Member]

Hi

Go to SE11 and create a database view. Put the names of database table and then click on relationship you will get the list of common fields.

Aditya

[Former Member]

hi aditya

thanks for your reply can you tell where to click after creating the view

[Former Member]

Hi

After creating the view you need to put table names below the Tables (left most side of screen) then click on relationship button.

Aditya

[Former Member]

i am not getting .. where is the relationship button..

what i did is used the view option in se11 and put my table name there

after that diplay button.I am write up to here , then what shalli do

[Former Member]

Hi

First clcik on view in se11 then give any name like ztest_view then click on create button. After that you need to choose database view and click on ok. After that next screen appears and here on the left side below to Tables you need to put table names then click on relationship button below that .

Aditya

[Former Member]

YA I GOT IT THANKS A LOT ADITYA