How to import table from Production to Development system??

[Former Member]

Hello,

I need to import a table from System PRD (production) to System DEV(Development).

The transport route is DEV -> PRD.

Thus I cannot create a request for the table on PRD to be moved to DEV system.

Kindly let me know some alternative to do the same.

Thanks&Regards,

Sumit

[markus_doehr2]

You can create a transport request with a "virtual" system as target system (you need to change your STMS setup). Release the transport request on PRD and use STMS in the DEV system:

STMS

--> Import Queue

--> Extras - Other requests - Add

Then you can import the request.

--

Markus

[Former Member]

Hello Markus,

I do not really want to change the transport route in the system landscape.

Is it not possible to transfer the table from PRD system to DEV on OS level using BRTOOLS.

Kindly suggest,

Regards,

Sumit

[markus_doehr2]

You don´t need to CHANGE the transport route, you just need to add another virtual system.

To copy the full table you can use the standard Oracle exp/imp tools. Do that only, if it´s not a SAP standard table.

--

Markus

[Former Member]

Hello Markus,

Well, it is a standard table only, /ASU/SCMATASKLST.

Why should it not be imported ??

Kindly suggest.

Thanks&Regards,

Sumit

[markus_doehr2]

And you know the underlying data model? I mean, you're sure that no other tables are affected (speaking of referential integrity and dependent tables)?

--

Markus

[Former Member]

Hello Markus,

Kindly let me know how it matters, whether I use Export/Import tools

or System landscape TSM to transport the table.

Kindly explain and suggest me finally the method I should adopt.

Also send the steps.

Thanks & Regards,

Sumit

[markus_doehr2]

Sumit,

technically the result will be same. The quickest way would be to use exp/imp - but again - if you don't know if there are dependent tables, that also need to be transported, I'd avoid copying over tables manually.

What's the content of that table? Is that the ASU-Toolbox? You wanna transport variants?

--

Markus