topic Re: Combining database tables in Application Development and Automation Discussions

Combining database tables

Former Member — Thu, 22 Jun 2006 04:31:26 GMT

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 — Thu, 22 Jun 2006 04:40:13 GMT

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 — Thu, 22 Jun 2006 04:42:54 GMT

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 — Thu, 22 Jun 2006 04:45:27 GMT

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