Skip to Content
avatar image
Former Member

How to get DDL descriptions of DDIC tables?

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Aug 30, 2010 at 08:50 AM

    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

    Add comment
    10|10000 characters needed characters exceeded