tranporting tables through workbench requests

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[raviahuja]

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

[kumud]

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

Regards,

Kumud

[Former Member]

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.

[VEPS]

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

[RaymondGiuseppi]

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

[Former Member]

This message was moderated.

[Former Member]

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,

kk