topic Re: Transport Data from Table in Application Development and Automation Discussions

Transport Data from Table

Former Member — Wed, 30 Aug 2006 09:35:23 GMT

Hi,

I am encountering problems with transporting data from different clients.

1. Create button per row is possible And Transport link in SE16 are visible thus encountering an error.

Transport is not possible for the specified data

Message no. SV142

Diagnosis

You want to copy data from a table or a view into a change request manually. This function is not intended for these data.

The data are either purely local, so that they can not be transported, or they are copied into the change request by a separate function. This can e.g. be the case for components of a more complex transport object.

System Response

The requested function can not be carried out. Processing is terminated.

Procedure

Please contact your system manager.

2. Generated a Maintenance Dialog in SE54

Result: transport entries is already disabled.

Please help..

points will be rewarded of course!

Thanks

Cindy Sy

Re: Transport Data from Table

Former Member — Wed, 30 Aug 2006 09:50:12 GMT

Hi,

In se11->table maintainence->select radio button

standard routine.

Regards

Amole

Re: Transport Data from Table

Former Member — Wed, 30 Aug 2006 09:50:33 GMT

Hi,

you can put the data manually in a transport request:

1) Create a transport request.

2) Start the editor in the transport request and enter the following: R3TR TABU <table name>

3) Press F2 with the cursor on the table name to call up the screen for specifying the table entries to transport.

4) Save and release the transport request to transport in to the target system.

Regards,

Stefan

Re: Transport Data from Table

Former Member — Wed, 30 Aug 2006 09:54:22 GMT

Hi Cindy,

did you try these options?

go to SE10 and create request.

in that give,

Program ID : R3TR

Obj : TABU

Object name : you table name.

double click on the table name and give key filed values. If you want to transport entire table entries

give * .

Cheers

Re: Transport Data from Table

uwe_schieferstein — Wed, 30 Aug 2006 09:56:26 GMT

Hello Cindy

I cannot judge why the system does not allow to transport these data.

However, you can transport any tables entries with a simple trick:

(1) Create a workbench request

(2) Change the request (or its task) and add the following entry: R3TR TABU <name of table> =>

(3) Enter the key values you want to transport, e.g.:

- <client>* for all entries of the current client

- add additional restrictions for the table entry (<client><bukrs>* for all entries of a given company code)

Note that you cannot export data from another client because CTS will correct a foreign client key with the current client key.

Pre-Cautions: when you import these table entries in another client already existing values will be overwritten!!!

<b>So be very careful.</b>

Regards

Uwe

Re: Transport Data from Table

Former Member — Wed, 30 Aug 2006 10:15:24 GMT

I tried to create a transport request in SE10

but the OBJ TYPE does not have TABU.

BTW, what type of transport request should I choose?

Thanks

Cindy Sy

Re: Transport Data from Table

uwe_schieferstein — Wed, 30 Aug 2006 10:28:19 GMT

Hello Cindy

Of which table do you want to transport entries?

Regards

Uwe

Re: Transport Data from Table

Former Member — Wed, 30 Aug 2006 10:57:18 GMT

Hi Cindy,

Take a look at the OSS notes

Note 116998 - V_TPMP_A automatic transport not possible

The details of the same given below.

ymptom
After maintaining the view, the transport is not possible.

The system generates message SV142."Transport is not possible for the specified data".

Additional key words
Default values for maintenance task list data, maintaining profile assignments

Cause and prerequisites
The maintenance view has incorrect attributes.

Solution
You can allow the automatic transport without program changes.


During maintenance, you must do the following:
1. Call Transaction SE54: Enter V_TPMP_A.
2. Field: Select Generated objects and function: Change.
3. Next screen:Change field 'Recording routine' to the value 'Standard recording routine'.
4. Ignore message SV352 by pressing Enter.
5. Release 4.5/4.6 only: Set field "Compare flag" to the value "Adjustable in dialog".
6. Function: Save.
               The system must generate success message: Entry in table/view catalog changed with & (message SV410).Next step

1. Call Transaction SOBJ: Function "Maintain".
2. Next screen, press pushbutton "Position.." and enter V_TPMP_A in field "Object", field "Type" can remain empty.
3. Double-click on entry "V_TPMP_A".
4. Next screen:in field "Transport", select value "Automatic transport" using the input help and save the entry.
5.

Hope this helps to resolve your problem.

Cheers

Re: Transport Data from Table

Former Member — Thu, 31 Aug 2006 02:03:28 GMT

To Uwe

A Customized table

Re: Transport Data from Table

Former Member — Thu, 31 Aug 2006 02:23:50 GMT

Hi Cindy,

1. Goto SE01.

2. Click New and create a New Work Bench Request.

3. Then place the cursor on the TR and click on Display Object List ( Shift + F11 )

4. Enter PGMID as R3TR

5. Enter OBJ as TABU

6. Enter OBJECT NAME as Z<TABLE NAME>

7. Again in the menu, select 'Extras~~>Change object function~~>Key according to key list'.

Now go to the menu, 'Goto-->Key list'. In the subsequent screen, click on 'Insert line' icon(with a + sign).

For more information pls refer thread :

Best regards,

Prashant