How can I find released non imported requests?

[former_member537489]

Hello,

The situation is as follows. We needed to refresh our dev system with new updated data from our production system. Before we do that, we released all our dev-requests in order to put them back again in the new environment. Is there a tool we can use to see all the non imported requests? The only one i could find is from

se01->display->Logs which takes a parameter, so you have to know the request id to see it and import it. We happen to have missed some requests so we are trying to find a way to search by comment or text or date....

What can we do?

Thank you in advance,

Roxani

[Former Member · Accepted solution]

Hi Roxani,

1. There is no direct way nor any direct FM.

2. Its tricky.

3. Use this code (just copy paste in new program)

IT will give all request details

which are NOT TRANSPORTED.

eg.(NOT transported to production server,

but released and transprted to QA server)

(on selection screen enter the

Destination name (sm59 name)

of the SERVER which u want to check for

not transported)

4.

REPORT abc.

*----

---

Data

DATA :e070 LIKE TABLE OF e070 WITH HEADER LINE.

DATA :e07t LIKE TABLE OF e07t WITH HEADER LINE.

DATA : tabentry LIKE TABLE OF bdi_entry WITH HEADER LINE.

DATA : sel_tab LIKE bdsel_stat OCCURS 0 WITH HEADER LINE.

DATA : nametab LIKE bdi_mfgrp OCCURS 0 WITH HEADER LINE.

DATA : BEGIN OF itab OCCURS 0,

trkorr LIKE e070-trkorr,

END OF itab.

*----

---

Screen

PARAMETERS: rfcdest LIKE rfcdes-rfcdest LOWER CASE.

*----

---

Start of Selection

START-OF-SELECTION.

SELECT * FROM e070 INTO TABLE e070

WHERE trstatus = 'R'

.

LOOP AT e070.

IF e070-strkorr IS NOT INITIAL.

DELETE e070.

ENDIF.

ENDLOOP.

CALL FUNCTION 'TABLE_ENTRIES_GET_VIA_RFC' DESTINATION rfcdest

EXPORTING

tabname = 'E070'

TABLES

sel_tab = sel_tab

nametab = nametab

tabentry = tabentry

EXCEPTIONS

internal_error = 1

table_has_no_fields = 2

table_not_activ = 3

not_authorized = 4

OTHERS = 5.

*----

---

Get Requests

REFRESH itab.

LOOP AT tabentry.

itab-trkorr = tabentry-entry(20).

APPEND itab.

ENDLOOP.

*----

---

Check

LOOP AT e070 .

READ TABLE itab WITH KEY trkorr = e070-trkorr.

IF sy-subrc <> 0.

CLEAR e07t.

SELECT SINGLE * INTO e07t

FROM e07t WHERE trkorr = e070-trkorr

AND langu = sy-langu.

WRITE 😕 e070-trkorr , e070-as4user , e070-tarsystem ,

e070-as4date , e07t-as4text.

ENDIF.

ENDLOOP.

regards,

amit m.

[former_member537489 · Accepted solution]

Dear Amit,

Thanks your sending this program, I tried it but the problem persists because this request does not exist in any server, at this time. It used to belong to development server, but after we copied the production to the development, the old development ceased to exist. That is the reason we released our dev requests before hand. so I believe there is somewhere outside SAP, in a file or something, and we have to retrieve it from there.

The question is how?

Message was edited by: Roxani Athousaki

[former_member181966 · Accepted solution]

Well at OS level , There’s SAP folders, in which its keeps the record of all transports , as matter of fact that basis team also can transport using "TP" command at OS .. I’m not sure , if that request is there or not for the reason , when they usually do client copy , as a common practice they ask all users in system to release the transport so when they overwrite they’ll not come across any problem like the one you’re having . Because during client copy it almost overwrite each and every folder in SAP. If There’s some backup of your development system then you can import that request to specific folder and after that you can see it .

Otherwise I don’t see that you’ll find it .

Hope this’ll give you some help.

Thanks

[Former Member · Accepted solution]

Request when released and when to be imported are stored in COFILES and DATA folders in /usr/sap/trans.

The sap might be reading the requests from there and shows u the request description.

Thanks & Regards,

Ankur

[former_member537489 · Accepted solution]

Thanks everyone for your responce.

Ankur, does this folder (/usr/sap/trans) contain only the non imported requests or all the released requests.

after some tests, i discovered that i have to upload the request first to see its description which is the opposite of what Im trying to do.

Is there any way to look into that file for a description in addition to the request-id?

Thanks very much.

Roxani

[Former Member · Accepted solution]

Hi rosxni,

1. u will get everything

(from description, to original server,

to transport logs)

in the file.

2. But these files will be in the folder

/usr/sap/trans

again there is a subfolder = log

3. U can use tcode AL11

to see the contents of this files.

regards,

amit m.

[Former Member · Accepted solution]

Hi Roxani,

The cofiles and data folders contains all the released requests.

If you want to import some request then also you have to put the 2 files in these folders.

Thanks & Regards,

Ankur

[former_member537489 · Accepted solution]

Hello Amit,

Thanks for your help, everything I need is in there. I could not find description of the request but in doing double-click in the log for every request i can see a lot of helpful things. Dates are also available, so maybe I will use them to restrict my search.

Thanks to everyone.

Roxani

[laxmanakumar_appana]

Hi

in SE09 data display, SAP uses the following tables e070,e070c,e07t . e070c table tells about into which target client the request is transported.

select statement from SE09 transaction.

SELECT e070_{trkorr e070}trfunction e070_{trstatus e070}tarsystem

e070_{korrdev e070}as4user e070_{as4date e070}as4time

e070_{strkorr e070c}client e070c_{tarclient e07t}as4text

INTO TABLE i_request

FROM ( e070 LEFT JOIN e070c ON e070_{trkorr = e070c}trkorr )

LEFT JOIN e07t ON e070_{trkorr = e07t}trkorr

WHERE e070~trkorr IN s_trkorr

AND e070~trfunction IN s_trfun

AND e070~trstatus IN s_trstat

AND e070~tarsystem IN s_tarsys

AND e070~as4user IN s_as4usr

AND e070~as4date IN s_as4dt

AND e070~korrdev IN s_korr .

use this select and create selection screen variables for the where condition fields.

with this you can check different combinations of the requests

Laxman

[Former Member]

If you are refreshing the DEV system from production, you are going to overwrite all the data tables including the transport tables. I don't know how the copy is done in your case but if you are doing a complete delete client and recreate from production copy, then you will end up losing them. I am not sure if there is a way.

[Former Member]

Hi Roxani,

Use report RDDACLOG. It will do the work for you.

When u see the code u will find FM TRINT_READ_COMM_HEADER

Try playing with this.

Hope it'll help.

Thanks & Regards,

Ankur

[former_member537489]

Unfortunatelly, it did not work either.

when I enter my request as a parameter it gives me the message "no gog entries found". As I see in the function, it still tries to access table e070, which dos not contain the request.

Please help,

Roxani

[Former Member]

The report fetches the same log which u see in SE01->display->action log.

Are u sure u can see logs in Se01->action logs .

Thanks & Regards,

Ankur

[former_member537489]

Yes I am sure. I did some debugging in

se01 -> display tab -> logs and I found that first of all it looks for entries in e070. if it does not find any it goes to function 'TR_LOG_OVERVIEW_REQUEST'. In there, it calls 'TRINT_READ_REQUEST_HEADER' which ends with subrc = 1. after that it calls 'TRINT_DISPLAY_LOG_OVERVIEW' and 'TR_READ_GLOBAL_INFO_OF_REQUEST' with the request ID and outputs a report.

so I guess it finds the request outside SAP and shows it. But is there a way to see the description of the request when it not yet imported???

thank you

Roxani

[former_member188685]

Hi,

you can find the info in table <b>E070</b>

check it.

regards

vijay

[former_member537489]

Thanks for your responce,

I tried looking in e070 but it is not there, maybe because it's not in the system any more. I believe when the requests are released they get archived or something somewhere outside sap. And because we copied the prod system to the old dev, the old dev does not exist any more and neither the requests. I can only see this request in se01, display logs, where it searches somewhere else.

thanks

roxani

[Former Member]

U can find all released request in table E070.

specify TRSTATUS as "R".

Thanks & Regards,

Ankur