Question Re: Which secure options exist for version compare of workbench objects between DEV and PROD? in Technology Q&A

Which secure options exist for version compare of workbench objects between DEV and PROD?

BaerbelWinkler — Tue, 19 Feb 2019 07:38:11 GMT

A while ago, I asked a question related to the different behaviour of version compare in SE38 after we had upgraded from NW750 SP07 to NW750 SP13 (EHP8). The RFC-connections needed for version compare have been closed off to generally prevent RFC-access from dev to prod for security reasons.

I looked through the security information provided in this guide, but didn't find specific enough recommendations there. And earlier questions in SAP Community don't quite match our current situation.

We have the rule in our development guidelines that version comparison between DEV and PROD should be done before new development gets started for an object. This obviously needs to be possible to do as easily and quickly as possible as it otherwise just won't get done.

I therefore have the following questions:

Do you routinely use version compare from DEV to PROD for workbench objects to e.g. ensure that all earlier changes have already made it into PROD or are there other/better options to do this?
How large is the risk of unauthorized activities in PROD if version compare is done via the standard functionality offered by the ABAP Workbench i.e. via SE38/SE80/SE39/SE11 for which RFC-connections need to be set up?
How can this risk be eliminated?
Are there recommendations of how RFC-connections and authorizations for version compares between DEV and QA/PROD should be defined or should they just not be defined at all?
Would setting up a separate client in PROD which then only contains client independent workbench-objects be helpful and could it be used for version compares?
Is there a means to do this easily and safely via Eclipse? (* see footnote below)

Thanks for any feedback - or even additional questions I haven't thought of yet!

Cheers

Bärbel

(*) Footnote: As of right now, Eclipse is not yet used much if at all and most development work happens via SAP GUI and the workbench transactions. When I tried a remote compare between the program versions in DEV and QA it sort of worked but several false hits where reported where e.g. the German Umlaut "ä" in my name was "butchered" in the displayed QA-code (as if the retrieval had a Unicode-issue). The fact, that Eclipse is in edit-mode by default is also a bit of an issue (I think).

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

matt — Tue, 19 Feb 2019 08:14:29 GMT

Do you routinely use version compare from DEV to PROD for workbench objects to e.g. ensure that all earlier changes have already made it into PROD or are there other/better options to do this?

No. Probably because we don't release our dev transports until it's time to go to production.

Is there a means to do this easily and safely via Eclipse? (* see footnote below)

I use Eclipse for version compare for preference. With classes it's especially useful as you can compare them nearly all at once - whereas in SAPGui, you can only do method by method. I've never had an issue. We also have umlauts and other special characters. (Off topic: Eclipse also keeps local versions, so you can easily revert to the version of an object you saved three hours earlier. Saved my life a couple of times!).

For comparison within SAPGui, the userid specified for the RFC should have its authorisations locked down as much as possible. This can be done via the authorisation trace. SAP offer a service for this note 1682316 if you don't want to do it yourself.

I like your idea concerning a configuration-less client for comparisons.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

matt — Tue, 19 Feb 2019 08:15:17 GMT

You should add the security tag. Possible Netweaver Administration.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

BaerbelWinkler — Tue, 19 Feb 2019 08:21:35 GMT

Thanks for your comment, Matt! I'd like to add more tags but don't see an option to actually do that under "Actions". Some missing auths perhaps or is it because there's already your answer and the question can therefore no longer be edited?

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

matt — Tue, 19 Feb 2019 09:39:32 GMT

Just edit, I think. Or notify a helpful moderator.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

BaerbelWinkler — Tue, 19 Feb 2019 09:46:19 GMT

Not sure why, but all of a sudden, the edit option was available under "Actions" and I could add tags.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

BaerbelWinkler — Tue, 19 Feb 2019 12:49:09 GMT

matthew.billingham

Thanks for your feedback, Matt!

You mention comparison of classes, but what about enhancements? We have one particularly large enhancement where developers very often rely on version comparisons across systems to avoid overtaking each others changes or to find out what went wrong with a recent change (I had a question related to that a while ago). When I try to open the enhancement in Eclipse all it does is to open it in a GUI-window. So, at a guess and corroborated by this thread from 2015 and nothing newer, enhancements cannot yet be really handled via Eclipse.

Are there other options to do version comparisons for enhancements apart from e.g. SE84 with RFC-connections?

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

matt — Tue, 19 Feb 2019 13:44:04 GMT

Sorry. I don't have wide experience of enhancements.

But using the factory pattern and multiple interface implementations you can usually remove dependencies between transports and not have to worry about any overtaking transports.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

BaerbelWinkler — Tue, 19 Feb 2019 15:20:03 GMT

matthew.billingham

Hi Matt,

well, to put it mildly, we are lightyears away from "... using the factory pattern and multiple interface implementations...." when it comes to that particular enhancement (last I checked it had ~35,000 lines of code). 🙂

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

matt — Tue, 19 Feb 2019 16:06:54 GMT

Well to summarise... With objects you can decouple the different functionality, so they don't interfere. You can do the same with function modules, so long as they're in seperate fn groups.

You maintain a dB table with the fm you want to run, and use that to call them dynamically. Probably too late now, but you could do it for future requirements.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

Jelena_Perfiljeva — Tue, 19 Feb 2019 19:08:22 GMT

We don't do DEV to PROD version comparison in current environment and didn't do in my old job either. We simply check the preceding transport's log in the version control. I think 1-2 times we had to do the version comparison but there was some technical issue with a transport or upgrade. Some exceptional situation, routinely we don't do that.

I honestly don't understand at all what's all that broohaha is about RFC access from DEV to PROD. RFC has specific user ID, just give that user limited authorization. Although I'm neither a security expert nor a clever criminal, so must be missing something. 🙂

I also like your idea about a separate client, at least in theory. This might make some things more difficult for Basis folks, so YMMV.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

Jelena_Perfiljeva — Tue, 19 Feb 2019 19:30:26 GMT

As someone also "light years away" I'd actually be curious to read more how the factory pattern and stuff can help with the transport conflicts. A blog, perhaps? 🙂

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

BaerbelWinkler — Tue, 19 Feb 2019 20:16:24 GMT

Thanks, Jelena! The idea with a separate client actually came from our basis team so it's not me potentially making more work for them!

We have users who only can access DEV and QA but not PROD, but in order to do comparisons with PROD e.g. via Eclipse, they'd need to have access there as well. So, if we had a client which doesn't have any transactional but only client-independent data in it, they could get access to that.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

Jelena_Perfiljeva — Tue, 19 Feb 2019 20:54:20 GMT

You might want to pimp this post on Twitter or in CC. It's a good question and I'm sure others could chime in as well. But the way the "unanswered questions" filter has been changed to include only questions with 0 answers I feel is actually hurting good questions that merit a longer discussion. As soon as any answer is given they drop from the radar. I just stumbled upon it by accident.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

matt — Wed, 20 Feb 2019 08:34:21 GMT

It's how badis work. Each implementation is independent.

Actually you can just create your own multiple use Badi.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

matt — Wed, 20 Feb 2019 08:41:51 GMT

I believe its a single transaction to do a client copy without configuration or data. And quite quick.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

matt — Wed, 20 Feb 2019 08:46:05 GMT

If the system isn't open, then eclipse is read only. Same as with a dev system and sap objects.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

SimoneMilesi — Wed, 20 Feb 2019 09:17:15 GMT

In a former customer's system, we implemented a routine/exit (i do not remember which one is, sorry!) that, if you are editing an object (class/FM,report) without an open TR, invokes an rfc read to check if the last cr is already in PROD.

We need it because there were a lot of different consultants managed by different teams so the risk to bring in PROD something still in QA was high.

I do not understand which kind of security issue you see in doing a comparision between enviroment 🙂

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

BaerbelWinkler — Wed, 20 Feb 2019 11:03:57 GMT

Thanks, Simone!

The fear is that any defined RFC-connection between DEV and PROD could be misused for other activities than version compares. Which is why at the moment (and different to earlier) no such connections are available for us.

Re: Which secure options exist for version compare of workbench objects between DEV and PROD?

chaouki_akir — Sat, 23 Feb 2019 17:56:41 GMT

"Do you routinely use version compare from DEV to PROD for workbench objects to e.g. ensure that all earlier changes have already made it into PROD or are there other/better options to do this?"

Yes I do it, now and before. For me it is normal to have this possibility because as you said : "version comparison between DEV and PROD should be done before new development gets started for an object."

"The RFC-connections needed for version compare have been closed off"

What is the name of these RFC-connections ? I debugged and in my system and the is like TMSADM@sysname.domname

"How large is the risk of unauthorized activities in PROD if version compare is done via the standard functionality offered by the ABAP Workbench i.e. via SE38/SE80/SE39/SE11 for which RFC-connections need to be set up?"

For me, the risk is that the developer is able to call from DEV, RFC enabled function modules. But user in PROD, should have lesser authorized objects.