transport request delete

[Former Member]

Hi all,

Want to clarify one thing...

If we want to delete the data of a transport request in SAP, which way is clearer? Either deleting from SE01 or we have to delete it from usr/sap/trans/cofiles&datafiles ?

If we do so in both ways, full data related to that transport request will delete from our database for ever?

Awaiting your replies

Regards

Praveen

[Former Member · Accepted solution]

Hi Praveen,

Please try this,

The simplest way is to use the "Select block" feature in STMS. Go to the queue in question, select the first request you want to delete and use "Edit->Select->Select block" or hit F6. Then scroll to the last one you want to delete and again select block or F6. That will select everything in between. Finally "Request->Delete" will get rid of them all.

Reagrds,

Sajmal

[Former Member · Accepted solution]

Sajmal,

If we do like this, whole data regarding that particular #TP will be deleted ? i.e from OS level also ??

Regards

Praveen

[Former Member · Accepted solution]

Praveen,

Please check following wiki,

It might be the right one for your requirement.

Deletion of Old Transports - Basis Corner - SCN Wiki

Regards

Anand

[Former Member · Accepted solution]

Hi Praveen,

Please try it in one #TP, from there you will get idea how it is work... please go through it,

Regards,

Sajmal TS

[Former Member · Accepted solution]

Hi Praveen,

For deleting

1. Modifiable transports: Go to SE03 --> Find requests option from Right hand panel and paste all the request you wan to delete.

This will bring the list of all TR's and from Menu bar Edit --> selection --> select block and delete all the request. Perform  this in DEV system (Where the TR was created)

2. Released request

You need to delete the request from import queue of the target system (I mean where is TR is at present) select the block and delete. But this will not delete the TR permanently, to do so you have to delete the data files and cofiles from OS level present in trans/data and trans/cofiles directory.

Deletion of TR will not delete the actual objects present in database.

Un-fortunately SAP does note provide anything like MASS deletion.

Regards,

Prithviraj.

[Former Member · Accepted solution]

Prithviraj,

Hopes this was the reply i was looking for. The process of mass deleting the old #TPs is not performed by the SAP by a single step (both from stms and os level), Then if we want to then it should be a long process. Is there any other way to do that ??

Regards

Praveen

[Former Member · Accepted solution]

Hi Praveen,

As far as I know there isn't any such process.

Also though this process might sound lengthy but maintain the consistency of your database and transport system.

May be this is the reason why SAP does not support MASS deletion.

You can try deleting entries from E070 and E070L but I will strongly suggest not to as when you can do it from SAP and OS level why touch DB directly.

Regards,

Prithviraj.

[Former Member · Accepted solution]

Hi Prithviraj,

If we are able to delete from OS level, say one by one deleting the entries from data folder and co files folder, then it will be a lengthy process.

I will say, firstly we have to delete from SE03 , then go to data folder and co files foles and delete each file respectively.

You have any other steps to say, although it is a lengthy process ??

Because my management is pressurizing me to do that...Thats why...

Regards

Praveen

[Former Member · Accepted solution]

Hi Praveen,

If you're deleting un-released (modifiable) TR's than you have to just delete it from SAP ( t-code SE03) there's nothing to do at OS level.

If you're deleting released TR's than

Get the list of TR's,

Say SIDK123456 is the TR number than

Data file R123456.SID and

Cofile K123456.SID

Using excel you can easily get the data and cofile name with simple formulas on cell.

Now use this names in a script (bat for windows, shell or Unix/AIX) and delete the files at OS level.

You can simply this lengthy process.

Regards,

Prithviraj.

[Former Member · Accepted solution]

Prithviraj,

Still also lengthy process. I will convince my management about this

Also one doubt, in SAP where do we find the logs of #TP's of unix level ??

Regards

Praveen

[Former Member · Accepted solution]

Hi Praveen,

Tcode STMS_IMPORT --> GOTO --> TP SYSTEM LOG

Regards,

Prithviraj.

[Former Member · Accepted solution]

Prithviraj,

Thanks

Regards

Praveen