2007 Jan 24 6:34 AM
Hi Experts,
I got a requirement to write a program which can track and compare the Transport Request between the servers(Development ,Test and Production) .
If in case is there any descrepancy between the versions (In the server) it should throw an error saying that particular thing is missing or not synchronized.
For ex: If the program which is in Development server has some structure dependent to the code which is address to single TR.
where as same version of the program in Test don't have structure ,it has to throw an mismatch error.
If you guys have any clue on this please throw some light.
Higher points will be rewarded for every useful inputs.
Thanks in Advance,
Dharani
Hi Experts,
I got a requirement to write a program which can track and compare the Transport Request between the servers(Development ,Test and Production) .
If in case is there any descrepancy between the versions (In the server) it should throw an error saying that particular thing is missing or not synchronized.
For ex: If the program which is in Development server has some structure dependent to the code which is address to single TR.
where as same version of the program in Test don't have structure ,it has to throw an mismatch error.
If you guys have any clue on this please throw some light.
Higher points will be rewarded for every useful inputs.
Thanks in Advance,
Dharani
2007 Jan 24 11:35 AM
I wrote a program to check to see if a transport has been moved to either QA, PROD etc. I wrote it in a way that the system ID, client etc is dynamic so we could use it for any SAP system we wanted.
The actual transport log is stored as a file on the SAP server. You need to find out how the standard SE10 works and which directory these files are stored. From there you can access the relevant files for each transport and take out the parts which state whether it was moved to another system or not.
If you want to see what related transports are missing due to missing structures for example, then this is virtually impossible to do. You would need to read the objects in each transport then find out what structures were used, then find out what transports these are assigned to. Then read the transport log for those also.
2007 Jan 24 11:56 AM
Hi,
look at the Below Blog, this was explained with an example also ..
/people/community.user/blog/2007/01/19/checking-transport-request-from-dev-system--moved-to-other-systems
Regards
Sudheer
2007 Jan 25 4:59 AM
Hi,
For a program or any object, u can track its transport using the table E071...
In the field 'OBJ NAME', provide the report name (if u have ), or in field 'TRKORR', give the transport req number..
So for any particular program , u can get all the transport requests and vice versa..
The field 'LOCKFLAG' , indicates the import status.. If the flag is checked (i.e 'X'),
it means that the transport is not yet released ..
Using this conditions u can get all the released object details..., to compare with the other server..
I hope u can proceed with this details...
Revert if any issues
Thanks
Rajiv.
2007 Feb 19 12:31 PM
I have also written a program for a three tier system (Development, Acceptance and Production).
It is very difficult to prevent ALL dangers/pitfalls... It is not really the transports, but the transports for the objects <i>within</i> those transports that need to be checked. I am probably not making much sense now...
The program checks transports that have been released and moved to EEA, to see it moving them to EEP is safe:
1. Are there objects in the transport that have a newer version in EEP? Danger: overwriting newer objects.
2. Are there objects in the transport for which an earlier transport exist, that have NOT been moved to EEP yet? Danger: These might be transported later, and then overwrite your newer version.
The program runs quite long because of these checks. It returns an ALV, with warning messages, the objects in the transport(s), and information on the conflicting transports.
Drawback: The systems are hardcoded. EET, EEA and EEP. That would need to be changed. There might of course still be room for improvement too.
2007 Mar 09 12:26 PM
Edwin,
funny, I developed exactly such a program a few years ago. I had to use a recursive architecture, because transports found for a particular object might contain additional objects which in turn might be conflicting with objects in yet other transports in the way you described, and so on...
I wonder how many more developers came up with a solution for this complex problem and why SAP isn't offering such a check by standard (as far as I know).
Cheers
Thomas
2007 Mar 16 7:33 AM
I bet there's quite a bunch of these around... And none of them 'perfect'.
It could be quite an interesting project to create a good one, that could be used by more than one company. We are still working on 46C, but will be upgrading soon (hopefully) to 640. Then, I may re-create it and try to make it more flexible and in OO. But that will take a while... And maybe it never will... Depends on the time I have/get in the new system. Would be fun to do though!
2007 Feb 19 5:28 PM
Hi Dharani,
I think i got a clear picture of your <b>PROBLEM STATEMENT</b>. Correct me if i am wrong. Mainly you need to create a <b>COMPARISION FUNCTION MODULE</b>, which should compare the two objects in different systems based on the <i>TRANSPORT REQUEST</i> they are present in.
If this is the case then you can easily use the <b>SAP's STANDARD PROGRAMS</b> to compare the different OBJECTS in different transport requests.
The observed naming conventions that these <i><b>VERSION COMPARISION SAP STANDARD PROGRAMS</b></i> follow is <b>RSVRS***</b>.
Thus you can create a function module which would take the various ABAP <i>Objects from the Various Transport Requests</i>, and compare them and throw an error saying that particular thing is missing or not synchronized.
<i>NOTE: Hope the above solution satisfies your requirement. I can provide you more
information about Version Comparision if you wish. Please award relevent
points, if you query is sloved :).</i>
Thanks and regards,
Ravi .
2007 Mar 09 9:14 AM
hi,
check out E070 and E071 tables .check for TRSTATUS field .
hope it helps
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |