ddl statements via report "smigr_create_ddl" well in advance

[Former Member]

Hello

I wander if before performing export of an system I can create ddl statements via report "smigr_create_ddl" well in advance ( i.e. during worktime).

Namely execution takes pritty long time (and if I move it to service window I risk the export will not be finished in time)

What actually means ddl statemants?

Thank you in advance

Jan

[AtulKumarJain · Accepted solution]

Hi Jan,

The report SMIGR_CREATE_DDL generates DDL statements for non-standard

database objects and writes it into <TABART>.SQL files. The <TABART>.SQL

file is used by R3LOAD to create the non-standard DB objects in the target

database, bypassing the information in <PACKAGE>.STR files. Non-standard

objects are using DB specific features/storage parameters, which are not part of the

ABAP dictionary (mainly BW objects). Since NetWeaver '04, BW functionality is

an integral part of the standard.

The report SMIGR_CREATE_DDL is mandatory for all systems using

non-standard database objects (mainly BW objects).

The execution of report “SMIGR_CREATE_DDL” is mandatory for all SAP

systems using non-standard database objects (BI/BW, SCM/APO). For NetWeaver

04 and later, the execution of “SMIGR_CREATE_DDL” is a must! Make sure not

to make any changes to the non-standard objects after “SMIGR_CREATE_DDL”

has been called!

You can excute it just before the downtime of export , it wont take much time.

BR

Atul

[JPReyes]

Hi Jan,

This report export required non-standard database objects, this is mainly required for BW but its mandatory for all system copies. If your source system is not a BW/BI then you can safely run it in advance, if it is then documentation mentions:

You must ensure that no more changes, such as activations or field changes, are made in the BW system after you call the SMIGR_CREATE_DDL report and before you export the data.

Regards, Juan

[ashish_vikas]

No, you should not run smigr_create_ddl" well in advance.

It should be started just before going downtime after locking all users.

It generates database specific DDL statements for non-standard database objects of the ABAP Dictionary (mainly BW objects). The generated DDL statements of SMIGR_CREATE_DDL are used to tell R3LOAD how to create non-standard objects in the target database.

Check : 2. Tasks before the export

771209  - NetWeaver 04: System copy (supplementary note)

best regards

ashish