How to export a table structure?

[Former Member]

I created a table in one system and want to export it to another table, is there a way we can do that?

Thanks and best regards,

Anders

[s_nnoorie]

You can write a small program to export data from one table to other table.

Try this likes, May be helpfull to you.

http://wiki.sdn.sap.com/wiki/display/Snippets/ImportandExporttoCluster+Databases

[Former Member]

Use SCC1 tcode to transport the data between clients.

You can also proceed as below :

SE11->Technical Settings->Press F8, From Menu select 'Transport Entry'.

Mention the TR and assign it to table .

Release the TR to copy table to another client .

Hope this helps you.

[Former Member]

Hi Anders,

one solution how to transport a table structure from one system to another is to put it to a transport request and than to copy datafile and cofile for this transport request from transport directory of source system to transport directory of target system and than import this transport via transaction STMS into target system.

Another way how to do it is using a function module DDIF_TABL_PUT in target system and provide it with data from source system (can be easy get by calling DDIF_TABL_GET in source system). Transfer of data between systems can be done in different ways. I would recommend to make a Z-copy of DDIF_TABL_PUT, which will be made as remote enabled function module, if RFC connectivity between systems can be configured.

Hope it helps.

Regards,

Adrian

[Former Member]

Hi Adrian,

For the first issue, does that means we will have to have the admin authority for the OS? Or can we do in the net weaver side?

Thanks and best regards,

Anders,

[Former Member]

Hi,

You need only read access to source transport system and write access to target transport directory. But You can copy files between these directories in SAP, so You do not log in to OS. Use transaction CG3Y to download file from source system and transaction CG3Z to upload file to target system. Relevant directories are

SAPTRANSHOST\sapmnt\trans\data

SAPTRANSHOST\sapmnt\trans\cofiles

You cen check content of directories via transaction AL11.

Filename will look very similar to transport request number.

Regards,

Adrian

[Former Member]

Also check following links:

http://wiki.sdn.sap.com/wiki/display/ABAP/HowtocopyRepositoryObjectsbetweennon-connectedSAPsystems

http://wiki.sdn.sap.com/wiki/display/Basis/CopyTransportRequeststolocalfilesystem

Adrian