Moving table definition between SAP systems

[former_member416443]

Hello.

I have following problem.

How in easy way transport  Z-table definition (with all subordinate data elements, domains, defined indexes and technical settings)

from one sap system to another?

Is it any program that automate this task?

I have to cases:

- only definition of the table,

- the definition and data.

Regards

Bogdan

[former_member416443]

Hello.

I have following problem.

How in easy way transport  Z-table definition (with all subordinate data elements, domains, defined indexes and technical settings)

from one sap system to another?

Is it any program that automate this task?

I have to cases:

- only definition of the table,

- the definition and data.

Regards

Bogdan

[manukapur]

For Table definition, data elements, domians and indexes- You have create a workbench request that can be transported across.

For data- if you have declared your table as type c,then every entry is stored in a transport whenever changed.

Or you can explicitly create transport for entries and move across.

Regards,

Manu

[former_member416443]

Hello.

At this moment I have created this Z-tables in DEV / QAS / PRD systems.

This Z-tables have data already and are working more than year.

I don't have any open workbench request.

Now we create completly newly external SAP system.

I want to move some additional functionality to this external SAP system.

So I have to copy structure of this Z-tables (maybe the data also) from DEV system to this external SAP system.

I am looking for the easiest way how to do it.

How to export Z-table definition (with all subordinate data elements, domains, defined indexes and technical settings) to a file or transport request?

Is it any program that automate this task?

I have to cases:

- only definition of the table,

- the definition and data.

Regards

Bogdan

[arindam_m]

Hi,

Attaching these structures to a transport request and then connecting your new system and transporting in STMS is the easiest way. For data you can do uploads via excels or flat files with or without any validation as you find suitable.

Cheers,

Arindam

[manukapur]

Do you have a transport route configured between the two systems?

If yes,  goto se03 and list out all the transports of the object and simply import them in the new system in the order.

If no,

then I am afraid it won't be easy. You will have to use data services or some other tool which sap supports or may be do it manually.

There is a Z program which download all programs and FM's .
Re: Z program to download all Z programs

Check out this.

http://scn.sap.com/message/1789752

But I don't this would help you completely.

Regards,

Manu

[RaymondGiuseppi]

You forget the foreign key relations, which may require transport of other tables. don't forget that  those foreign relation can be related to unit of measure and currency attached to some of the fields.

As already written, you may use the history of transport of the object, but some data element or domain may have been previously created and never transported with the database tables, so you could write your own report (and share it on scn ?) to analyze table definition

- look for FM like DDIF_*_GET to generate list of objects

- look for FM like TR_OBJECT_JUMP_TO_TOOL or RS_TOOL_ACCESS (action 'TRANSPORT') to ask for transport

(or manually via SE11 and SE03)

Regards,

Raymond

[marcin_cholewczuk]

Hi,

The most obvious solution that came to my head is SAPLink, but you would still have to dig through your tables for domains and data elements.

Best Regards

Marcin Cholewczuk