Delete Record from TVARV

[Former Member]

I've done this before but I can't remember how and I've searched for the answer with no luck.

I want to delete a record from TVARV in production by deleting the record in development and then transporting this delete to production.

Does anyone know how?

Thanks,

Clint

[Former Member]

Hi,

Please go to transaction STVARV to maintain table TVARV.

In here, you also got the possibility to transport entries.

Regards,

Ferry Lianto

[Former Member]

I know how to transport an entry.

My question is do I transport the DELETE of a record?

Thanks

[Former Member]

Hi,

I could not find any option either in transaction SE16 or SE01 to transport of a delete record.

I am not sure whether you need to transport the entire table (after deleting record) from DEV to QA and PROD in order to synchronize the data.

Regards,

Ferry Lianto

[Former Member]

I don't want to transport the entire table because the table in DEV is pretty messy because it gets treated like a sandbox.

I remember it going something like this:

1. changing the record to create a transport

2. delete the record

3. then going into SE01 and doing something to the transport, but I can't remember exactly what.

[naimesh_patel]

Have tried like this:

Go to Tcode: STVARV

Press change button

Select the check box "Include Changed Entries in transport request"

Select your record.

Press the delete button .. say yes in next pop up

Request Pop-up will come.. choose your request...

Now, go to SE09.. release that request and import into quality.

Regards,

Naimesh Patel

[Former Member]

It did not prompt for transport:

Caution: changes must be recorded (see help)

Message no. TB117

Diagnosis

You tried to access table data in change mode. In the current client, changes must be recorded in a change request. The current maintenance transaction, however, cannot do this for technical reasons. In this case you have to record the changes manually, or even better (if possible) maintain the table with Customizing (pushbutton 'Customizing' or 'View maintenance' in the initial screen).

Do you know of any other way?

[naimesh_patel]

Not much idea about the other option, because in my system it is asking for the transport when I delete any data.

Regards,

Naimesh Patel

[Former Member]

OK, I found out how to do this for others out there.

Make sure table maintenance is allowed in SE12

Create a config transport with SE01

Add the entries to the transport first with SE16 or SM30

Then delete the entries from the table with SE16 or SM30

Release transport. It will delete in TST, etc.

Transport looks exactly the same to me, but it works.

Happy deleting.

[Former Member]

Hii

can you please advise how you did the activate the maintenance in TVARV

[Former Member]

Hii

can you please advise how you did the activate the maintenance in TVARV