Transport SAP Gateway OData service system alias

Published by Tobias Hofmann on

7 min read

A developer creates a new OData service (code, definition, implementation) in the backend and adds everything to a transport package. After transporting an OData service from DEV to QA in the backend, the service is not usable in QA as the system alias for the OData service is missing. While the service definition and implementation were transported, the important piece that enables to call the service is not part of the transport package. The developer publishes and creates the service and system alias LOCAL in SEGW using an SAP wizard. In QA the system alias LOCAL is not attributed to the new OData service.

This (partly) makes sense as the system alias might differ in each environment. In almost all cases the system alias needed here is LOCAL, as it is the GW backend. You might want to add the system alias manually. Depending on the system configuration, this is not possible as the system is closed. Basis can open the system and add the alias, yet, it is better to transport this configuration.

Ein Bild, das Text enthält.

Automatisch generierte Beschreibung

To transport the LOCAL system alias for the OData service from DEV to QA, it is needed to

  1. Create a transport request
  2. Add table entry for system alias configuration
  3. Transport

Sorry for the German language in the screenshots, I forgot to change the logon language. I hope you can still figure out where to click in your SAPGui.

Create a transport request

Create a new workbench request.

Transaction: SE01
Ein Bild, das Tisch enthält.

Automatisch generierte Beschreibung

Provide the necessary transport information.

Description: GW alias
Target: QA

Add the table entry to the transport. Select the transport request (double click).

Ein Bild, das Text enthält.

Automatisch generierte Beschreibung

The details of the selected transport request are shown. As nothing was yet done, it is empty.

Ein Bild, das Tisch enthält.

Automatisch generierte Beschreibung

Add table entry for system alias configuration

In the detail view of the transport request, manually add the table entry for the system alias. Click on edit.

Ein Bild, das Tisch enthält.

Automatisch generierte Beschreibung

Add a new table entry. Click the add row button.

Add the following values for the columns / parameters:

Program ID: R3TR
Object type: TABU
Object name: /IWFND/C_MGDEAM

The table entry for the transport should look like this:

Ein Bild, das Tisch enthält.

Automatisch generierte Beschreibung

Click on the button in column Function. A new dialog opens. It is not very intuitive to know what to do here. The intent is to enter the table entry that should be added to the transport.

Double click on the first empty line. Add the entries for the table entry.

Ein Bild, das Tisch enthält.

Automatisch generierte Beschreibung

The values depend on your OData service.

Client: Your client, e.g. 100
Service ID: Technical service ID of the OData service
Ein Bild, das Tisch enthält.

Automatisch generierte Beschreibung

Note

The values can be looked ab in the table /IWFND/C_MGDEAM. Look at the table entries via transaction SE16. Open the details for the OData service entry. These are the same values that have to go in the above form.

Click OK and the entry is added to the list of objects.

Ein Bild, das Text enthält.

Automatisch generierte Beschreibung

In the transport organizer (SE01, SE09, SE10) the transport lists now the table entry.

Transport

Transport into your QA system. Go to the services maintenance transaction and validate if the alias is transported.

You might still have to activate the ICF node for the service to work.

ICF Node not activated (icon yellow)

Ein Bild, das Tisch enthält.

Automatisch generierte Beschreibung

Activate ICF node for selected OData service

Ein Bild, das Text enthält.

Automatisch generierte Beschreibung

ICF node activated (icon green).

Ein Bild, das Tisch enthält.

Automatisch generierte Beschreibung

Test

After transporting the system alias and activating the ICF node, the OData service is ready to be used. A simple test can be done via the Gateway client. Call the service definition and some information must be returned.

Ein Bild, das Text enthält.

Automatisch generierte Beschreibung
Let the world know

Tobias Hofmann

Doing stuff with SAP since 1998. Open, web, UX, cloud. I am not a Basis guy, but very knowledgeable about Basis stuff, as it's the foundation of everything I do (DevOps). Performance is king, and unit tests is something I actually do. Developing HTML5 apps when HTML5 wasn't around. HCP/SCP user since 2012, NetWeaver since 2002, ABAP since 1998.

5 Comments

Ralf · August 26, 2021 at 08:24

Danke für die super Beschreibung

pradeep · March 22, 2022 at 11:00

Thank you for the post!

X. Z. · August 4, 2022 at 13:02

The easier solution is: When the service was created in the development system delete the system alias and add it again. Then you are asked to select a transport request for the system alias.

    Tobias Hofmann · August 8, 2022 at 12:06

    This only works when the SAP system is asking to provide a transport request

Siva · August 29, 2022 at 14:21

Hello Tobias,

Thank you very much for this post. I have a query regarding ‘User Role’ in your Transport Entry. Why are you specifying ‘User Role’ as ‘*’ instead of blank as shown in the table ‘/IWFND/C_MGDEAM’? May be I am wrong, you can correct me here.

Thank you!!

Regards,
Siva

Leave a Reply

Avatar placeholder

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.