1847953 - EHP7 for SAP ERP 6.0 - HANA Content

Symptom

You have installed EHP7 for SAP ERP 6.0 on a SAP HANA database (or you just have migrated your system to this database). After deploying HANA Content you want to check whether it is activated.

HANA Content Activation may not work properly for EHP7 for SAP ERP 6.0, on SAP HANA.

Other Terms

HANA Content, Activation, EHP7 for SAP ERP 6.0, SAP HANA, sap.erp.sappl, sap.erp.eappl, sap.erp.sfin, sap.erp.efin, sap.erp.dimp

Reason and Prerequisites

SAP HANA Database
You have installed at least SAP HANA version 1.0 SP6 revision 60.
Local Development Environment
You have the SAP HANA Studio installed locally. You may find the Installation Guide for the SAP HANA Studio at http://help.sap.com/hana -> SAP HANA Appliance Software. You find documentation for the SAP HANA Studio at http://help.sap.com/hana/hana_dev_en.pdf (Chapter 6).
You should have installed the ABAP Development Tools for SAP Netweaver. The installation Guide for ABAP Development Tools is attached to SAP Note 1718399.

Solution

HANA Content is automatically activated as one of the last phases in the lifecycle management procedure (installation, system copy import, update). Nevertheless, you want to check whether all content is there as expected.

For that, you may do the following checks in the SAP HANA Studio and in the SAP system.

1. Check permissions

              If you do the system copy using Software Provisioning Manager (SWPM) 1.0 SP03 or lower, you have to set the roles and permissions manually as described in the Administrators' Guide for Enhancement Package 6 for SAP ERP 6.0, Version for SAP HANA.

2. Check SNHI_DUP_PREWORK

              SNHI_DUP_PREWORK is an ABAP table which contains information about software components for which HANA Content shall be activated automatically. To check whether this table is populated, you logon to the SAP system via SAP GUI. Start the Data Browser (Transaction SE16) and display the content of the SNHI_DUP_PREWORK table. Check whether the PREWORK_DONE flag is set for all software components in charge (this is at least: SAP_APPL, EA-APPL, SAP_FIN, EA-FIN, ECC-DIMP). If the flag is not set unexpectedly, follow SAP Note 1785057 to set the flag.

3. Check Schema Mapping

a) Start the SAP HANA Studio

b) Open the Modeler perspective

c) On the Quick Launch page, select the system in charge

d) Choose "Schema Mapping" in the Setup area

e) Ensure that the table contains the entry (SAP_ECC -- SAP<sid> (where SAP<sid> is the schema assigned to your SAP system

4. Check whether all required content is active

a) In the SAP HANA Studio open the Modeler perspective

b) In the System Explorer go to the system you want to check

c) Choose SQL Console from the context menu

d) Enter the following SQL statement.

                       select * from "_SYS_REPO"."INACTIVE_OBJECT" where package_id like 'sap.erp.%';

e) If the result list contains entries you have inactive objects in the HANA Repository. If there is no entry in the results list, you may still check whether all objects have been activated successfully. For that, you may execute the following SQL statement:

                       select * from "_SYS_REPO"."ACTIVE_OBJECT" where package_id like 'sap.erp.%' and object_status = 1;

f) The results list should be empty as well.

Manual Activation of HANA Content
In order to activate HANA Content objects manually, you have to use the Modeler perspective in the SAP HANA Studio. With that there is a node beneath the HANA database called Content which contains all content objects. Depending on the status of an object you have to activate the object by right clicking on that and either choosing Activate or Redeploy.
Possible Errors during LM Procedure
If you have the software component ECC-DIMP on a version higher than 600, it will be updated each time you apply a new enhancement package version, even if you have not switched on the industry business function set. With this update, also HANA Content for DIMP will be imported and the system tries to deploy it. See SAP Note 1879987 for information on how to handle errors related to DIMP HANA Content.
Further Remarks
In case a view cannot be called from out of an ABAP program, you have to re-generate the external view in your ABAP system. Please follow the instruction in note 1813099.

Header Data

Released On	13.08.2013 14:43:24
Release Status	Released for Customer
Component	XX-SER-REL Business Suite Release Information
Other Components	HAN-DB SAP HANA Database
Priority	Recommendations / Additional Info
Category	Upgrade information