How to get DDL descriptions of DDIC tables?

[H-D_Knoch]

Hi,

for a replication scenario of ERP data into BOBJ BI on Demand we have to define data schemas in the BI oD MS SQL Server. Instead of doing that manually, we could also import DDL (data definition language) descriptions of the ERP DDIC table to replicate into the SQL Server.

The question is: Is it possible to generate or extract DDL descriptions of database tables defined in the ERP DDIC and if yes, how (e.g. inside ABAP or using DB tools)?

Thanks for any assistance,

H-D

[Former Member]

Hi,

if you use SQL2005 or SQL2008 you can try SSMS to generate the DDL statements. Just expand your database <SID> and apply a filter on the tables tab. If you right click on a specific table you have the option to 'Script table as' -> 'Create to' -> 'New Query Editor Window'. That way you will get the CREATE TABLE statement.

Regards,

Sven