This website is not affiliated with, sponsored by, or approved by SAP AG.

R3trans to Delete Selected Rows

Basis (Basis Technology Modules: Basis Component/System Administration, GUIs)

Moderators: Snowy, thx4allthefish

R3trans to Delete Selected Rows

Postby QZ » Fri Jan 10, 2014 10:18 am

Hi,

I understand using R3trans to delete all of the data in a table.
However, I cannot get it to delete only selected row(s).

For example, suppose that there is a table named ZTEST with the fields MANDT and Field1.

I want to export the table entries with all of the row(s) of ZTEST with Field1 = 'Hello' from
system AAA to BBB.

In AAA, I want to do something along the lines of the following, but the syntax does
not work..it fails on the delete

How would I do this?


Export
client = <client number>
file '/usr/sap/trans/bin/ZTestData'
delete from ztest with field1 = 'Hello'
export * from ztest with field1 = 'Hello'
QZ
 
Posts: 221
Joined: Wed Nov 14, 2007 11:02 am

Re: R3trans to Delete Selected Rows

Postby Snowy » Wed Feb 12, 2014 11:54 am

you will need to test, I am not sure it ios supported

read SAP note 1942 - "How does R3trans work? "
SapFans Moderator

Search: http://www.sapfans.com/forums/search.php
Notes: http://service.sap.com/notes
Help: http://help.sap.com
Rules: http://www.sapfans.com/forums/viewtopic.php?t=344127
Snowy
 
Posts: 28767
Joined: Mon Oct 21, 2002 2:33 pm
Location: 3.1415926535


Return to Basis

Who is online

Users browsing this forum: No registered users and 6 guests



cron


loading...


This website is not affiliated with, sponsored by, or approved by SAP AG.