topic Re: STMS - import queue in Application Development and Automation Discussions

STMS - import queue

Former Member — Sat, 10 Sep 2011 06:45:55 GMT

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,

Re: STMS - import queue

jitendra_it — Sat, 10 Sep 2011 07:54:02 GMT

Hi Jordy_tof,

Please check these links.

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

Thanks

Jitendra

Re: STMS - import queue

madhu_vadlamani — Sat, 10 Sep 2011 08:07:08 GMT

Hi Jordy,

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

Regards,

Madhu.

Re: STMS - import queue

sjeevan — Sat, 10 Sep 2011 08:18:41 GMT

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.

Re: STMS - import queue

Former Member — Sun, 11 Sep 2011 08:33:35 GMT

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,

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

Re: STMS - import queue

ThomasZloch — Sun, 11 Sep 2011 14:06:03 GMT

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

Re: STMS - import queue

sjeevan — Sun, 11 Sep 2011 19:43:18 GMT

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.

Re: STMS - import queue

Former Member — Sun, 11 Sep 2011 19:47:51 GMT

Thanks Jeevan

I just finished it.

Thanks to Thomas too.

Have a great day all.

A+