Introduction

In this blog post I describe the steps I followed to prepare an SAP S/4HANA 1909 system for SAP Geographical Enablement Framework (SAP GEF) functional configuration. This blog post only addresses the technical pre-requisites to be able to handover to an EAM consultant for GEF configuration.

References

Geographical Enablement Framework 1909 FPS02 (May 2020)

https://help.sap.com/viewer/86dbe289f813483abd78de6a52458bff/1909.002/en-US/e77eb156aad9cf4fe10000000a44147b.html

Creating a Connection Between Enterprise Search and SAP HANA

https://help.sap.com/viewer/90b263323d0a4976bcda415e6bd20ea4/1909.001/en-US/293306da169b43aba7cd712b3883011c.html

Reference Note (requires a access to SAP ONE Support Launchpad):

2878649 – HANA Update to 1909 Fix for Data Type Date Fields Update

Software Installation

ABAP Layer

Addon

SAP HANA

HCO_GEF_DATA 100 Deployment Unit

SAP Notes

Install the following notes using transaction SNOTE ensuring manual actions are also performed where necessary:

SAP HANA User Provisioning

User: GEF_USER

Roles: sap.gef.data::gef_user AND sap.gef.data::gef_admin

Help Page:

Service Roles and Authorizations in SAP HANA Platform

https://help.sap.com/viewer/86dbe289f813483abd78de6a52458bff/1909.001/en-US/06545f50bdbc4f5cb0b04549ed6811a3.html

User: ESH_USER

Role: This user must be assigned the object authorizations sys.trexviadbsl and sys.trexviadbslwithparameter. The database user also needs authorization to execute the following SQL commands on the SAP database schema (SAPSID): SELECT, INDEX, ALTER

NOTE: Set passwords to never expire, once created can you please email me with the passwords

Create DBCO Entries

GEF Connector

DB Connection: <SID>_GEF

DBMS: HDB

User Name: GEF_USER

DB Password: xxxxxxxxxx

Conn Info.: <FQHN of the DB Server>:<HANA Port> (eg ob7db.myorg.com:30015)

Permanent: Checked

ESH Connector

DB Connection: <SID>_ESH

DBMS: HDB

User Name: ESH_USER

DB Password: xxxxxxxxxx

Conn Info.: <FQHN of the DB Server>:<HANA Port> (eg ob7db.myorg.com:30015)

Permanent: Checked

Testing

SE38 -> ADBC_TEST_CONNECTION

IMG Configuration

Fix for 1909 Upgrade Defect

Reference Note (requires a access to SAP ONE Support Launchpad):

2878649 – HANA Update to 1909 Fix for Data Type Date Fields Update

/nGEF_CRT_TAB

1. Run transaction GEF_CRT_TAB
2. Use the default values or change to match the custom values used in a prior execution of the report (when creating tables/view for local SRID deployment)
3. Set a new value for the View Suffix if view already exists
4. Set the Create View Only parameter value to “X” and execute. A new view will have been created in the SAP_GEF schema
5. Run transaction GEF_FRW_CONFIG and select the “System Settings” Node
6. Replace the GDB View Name entry with the name entered in the View Suffix of step 3
7. Save configuration changes

GEF Configuration Check

Before handing over to the functional team it’s worth checking the following. Success means that the ‘Supports History’ flag is checked in the below screen

/nGEF_FRW_CONFIG

GIS Providers

/nGEF_GIS_CONFIG

SICF Activations

NOTE: This needs to be done manually as the build migrates through the landscape:

ESRI & Rest Services

GEF UI Services

Enterprise Search Setup

/nesh_cockpit

Equipment

Functional Location

Locator Search

SM30 -> GEFV_LOCATOR

Ensure the following entries are inside this view:

Summary

Upon completion of all the technical setup activities above you will be able to handover to the EAM functional consultants to complete GEF configuration. There is also some work for the UX team to setup a Fiori tile which will include odata activation, group assignment and security role assignments.

Please don’t hesitate to share feedback or thoughts in a comment or ask questions.