Combining database tables

[Former Member]

Hi friends,

In se11 we created two database tables with say some 1000 fields each. now if we want both table to be combined into one table. how do we do that.

Thanks

Venkat

[Former Member]

I guess you will have to manually do that in SE11 transaction.

You might end up loosing data.

Regards,

Ravi

Note : Please mark the helpful answers

[Former Member]

Venkat,

Go to SE11.

Enter the name of the table1 and go change mode.

Then add all fields of table2 in to table1 and activate.

Thanks,

[Former Member]

If you really want to combine you will have to do it manually as ravi suggested.

but if you want a combined view then you can create a view combining those tables.

<a href="http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ecab446011d189700000e8322d00/frameset.htm">Database View</a>

Hope this helps

Regards,

Kinshuk