topic Re: tranporting tables through workbench requests in Application Development and Automation Discussions

tranporting tables through workbench requests

Former Member — Wed, 14 Sep 2011 20:44:29 GMT

Hi Gurus,

We have made some modifications in to two tables which are used for storing Statistical records(IT0176) in SAP HR.

Tables are : V_T57HA and T57HB(both tables are dependent).

Now the problem is when we are transporting the modified entries from development system to quality system.,Quality system doesnot reflect the correct entries.For E.g : Development system tables contain 500(V_T5H7A) and 2500(T5H7B) entries respectively and Quality system tables contain 750(V_T5H7A) and 3500(T57HB) respectively.Now the entries in development system need to be transported to quality system by overwriting the entries in Q system.

We tried to transport all the entries from both the tables in correct sequence,but still the result remains same.

Could anyone suggest how can we achieve the above result.

Thanking you in anticipation

Sushil

Re: tranporting tables through workbench requests

Former Member — Wed, 14 Sep 2011 21:24:42 GMT

Dear Sushil,

not sure if this will help you, but have you checked this post ?

[http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26141] [original link is broken] [original link is broken] [original link is broken];

Kind Regards

/Ricardo Quintas

Re: tranporting tables through workbench requests

Former Member — Wed, 14 Sep 2011 21:51:56 GMT

Hi.

Please have a look into the below link

<link to blocked site removed by moderator>

Shiva

Edited by: Thomas Zloch on Sep 21, 2011 1:43 PM

Re: tranporting tables through workbench requests

raviahuja — Thu, 15 Sep 2011 02:09:13 GMT

Hi,

I don't know if you need to keep entries of in Quality System as it is and update only those entries coming from Development System or you want to refresh table on Quality and then add only entries from Development System.

Because with current approach you are using, it will only update entries coming from Dev Client but any other entry in table in Quality will remain as it is. For that, you need to first refresh the table Quality. (You can ask Basis for that), and the transport entries from Development Client.

Thanks.

Ravi

Re: tranporting tables through workbench requests

kumud — Thu, 15 Sep 2011 06:43:52 GMT

Can you please tell if the table are of type application or customizing?

Regards,

Kumud

Re: tranporting tables through workbench requests

Former Member — Thu, 15 Sep 2011 07:00:23 GMT

The delivery class of the table has to be C, G, E, S in order to transport the data from one client to the target client.

Re: tranporting tables through workbench requests

VEPS — Thu, 15 Sep 2011 12:52:17 GMT

Hi Sushil,

Transporting a table via workbench is as follows;

SE09 ->

R3TR TABL will transport technical settings for the table.

R3TR TABU will transport table contents.

Br, Derrick

Re: tranporting tables through workbench requests

RaymondGiuseppi — Wed, 21 Sep 2011 12:17:39 GMT

Look at the keys list associated to the R3TR TABU in the transport request, they should be " * " (or mandt + " * ") to transport the whole data in a copy/replace function.

Regards,

Raymond

Re: tranporting tables through workbench requests

Former Member — Mon, 03 Oct 2011 04:59:48 GMT

This message was moderated.

Re: tranporting tables through workbench requests

Former Member — Mon, 03 Oct 2011 06:49:37 GMT

Hi,

In se03 give object selection as 'tabu' and press enter.

Now press the request status as modifiable and execute.

Release the request in se09 which you got and transport it to quality by stms.

Regards,