topic Re: Table definitions in Application Development and Automation Discussions

Table definitions

Former Member — Mon, 23 Aug 2004 15:41:05 GMT

Hi,

How to save table definitions into a local file?

Advance thanks.

Regards,

V Balaji.

Re: Table definitions

thomas_jung — Mon, 23 Aug 2004 19:56:07 GMT

There is program RDDSRCG0. It generates programming langauge structure descriptions. But given the languages it generates for (Cobol, PL/1, C, and RPG) this program is a little dated.

If you want something more recent (like MS Excel), you might want to look at the type Desccriptor classes (cl_abap_typedescr and its children). I have used them before to build a simple download to Excel utility.

Re: Table definitions

nablan_umar — Mon, 23 Aug 2004 19:56:16 GMT

Hello Balaji,

You might want to write a program that use function module DDIF_TABL_GET or run this function directly using SE37. Then download the content of internal table DD03P_TAB.

Re: Table definitions

Former Member — Tue, 24 Aug 2004 03:36:06 GMT

Thanks.

Can I upload the downloaded file into other production system, whether domains & other properties are copied. It's advisable to create a "Z" table in this manner?

Regards,

Balaji Viswanath.

Re: Table definitions

ssimsekler — Tue, 24 Aug 2004 10:16:42 GMT

This (trying to upload table definitions and change table structure/definition in the production system) is not a suitable way to interfere database definitions at production system. You should use standard transport mechanism instead. If you want to create table definitions dynamically, that will be another issue.

*--Serdar

Re: Table definitions

thomas_jung — Tue, 24 Aug 2004 12:13:09 GMT

I certainly wouldn't recommend it. Why not just create the table in development and transport it? You wouldn't want your systems to become out of sync.

Re: Table definitions

nablan_umar — Tue, 24 Aug 2004 15:20:51 GMT

You should not upload DDIC definition into production using a custom program although the DDIC is a custom one. However in development system, you can look at function group SIFD that has function modules to read and maintain DDIC.