STMS - import queue

[Former Member]

Hello friends,

is it possible to have a list of all TRs that have been deleted from the import queue on a SAP instance, on SAP or OS level (AIX) ?

Thanks in advance,

J.

[jitendra_it]

Hi Jordy_tof,

Please check these links.

http://sap.ittoolbox.com/groups/technical-functional/sap-basis/stms-import-queue-delete-284697

Thanks

Jitendra

[madhu_vadlamani]

Hi Jordy,

1.go to STMS_IMPORT, select your TR by and Menu:Request->Delete.

Regards,

Madhu.

[sjeevan]

Jordy,

The only solution seems to be getting a list of all the released (field TRSTATUS = 'R') from table E070 ( or E071 et. al. if you wanna look at item level) from DEV box prepare list 1. And getting a list of all transports regardless of status from table E070 from PRD and prepare list 2.

Now use an excel sheet (vlook up function or something) compare list 1 and list 2, look for all the requests NOT present in list 2 but present in list 1. This should give you the deleted transports from PRD.

I noticed, once you delete a transport request from import queue in production it permanently deletes the entry in all the E07* tables.

[Former Member]

Hello Jeevan,

Your answer is the most logic of all. Thank you,

May I still ask for some advice ?

I need to check the deleted requests from both quality and production systems.

So , how can I do it most easily ? DEV- QUA - PROD

Compare the lists like this ?

DEV - QUA -> compare lists

DEV - PROD -> compare lists ?

Thanks,

J.

Edited by: Jordy_tof on Sep 11, 2011 11:25 AM

[ThomasZloch]

DEV should still have the entries in E07* tables after deletion from the import queues of QA and PRD.

The deletion from the import queue is logged in the transport control files, which you can read e.g. with function module STRF_READ_COFILE. This way you should be able to write a small program in DEV that gives you the desired information, it worked for me at least.

Run STRF_READ_COFILE from SE37 for a few requests that you know were deleted to understand the output of this function.

Thomas

[sjeevan]

If you're into ABAP programming you can write a simple program using the FM mentioned by the above poster. It outputs a status table for every transport request with details like it's status and time and date stamp and host.

The output table is TT_COFI_LINES and it has field called FUNCTION (third one) which will tell you if the particular transport request has been imported into production, the field value meaning which you are concerned is as follows.

V	Version Management: Set I Flags at Import

The table entry which would tell you if an import has been deleted is the one with value '>' in the FUNCTION field. IF it is imported you can see it as 'I' in one line with client number in the box and an extra V for the entire production box.

Now coming to your question:

DEV - QUA -> compare lists

DEV - PROD -> compare lists

Should suffice cuz a TR would arrive to PRD only if it's not deleted from QUA, technically.

But I would suggest you to do the third combination also QUA-PRD for the sake of completeness.

[Former Member]

Thanks Jeevan

I just finished it.

Thanks to Thomas too.

Have a great day all.

A+