Load table structure definition from Sql server and mirroring

[Former Member]

Hi, we have to replicate some tables from sql server

into SAP dictionary.

Is there a tool/transaction for import the table structure

from a DBRMS like sql/oracle ?

Adn is there some third part solution for replicate data

from/to sql server and Sap ?

Thanks in advance.

Riccardo Galli.

[Former Member]

Hi,

Dont know if there are any tools for this but onething is sure you will need to create the table thru SE11.

I had done something similar, created a BDC to create table and it works.

Provide the BDC with list of fields, datatype, len, key fields and the BDC will create the table.

You will need to activate the table once its created, for some reason sap put the table in "partial active" status after creation .

Good luck.

Ravi

[Former Member]

Thanks for the answer.

[andreas_mann3]

Hi Riccardo,

have a look to that thread:

Andreas

[Former Member]

Thanks in advance,is there also the possibility to

read from Sql server/Oracle external database (i think from DB2).