Generate SAP HANA Calculation Views from SAP BW/4HANA objects

In SAP BW/4HANA, you can automatically generate SAP HANA Calculation Views for SAP BW/4HANA objects. If the setting in the property External SAP HANA Views is enabled, the automatic generation of SAP HANA calculation views occurs during the activation of the SAP BW/4HANA object.

The following SAP BW/4HANA objects can be used:

• DataStore Object (advanced)

  Note

  For a DataStore Object (advanced), this may not always be necessary because a view /BIC/A<ADSOname>8 exists for external access.

• CompositeProvider

• InfoObject Characteristic

• Query

• Local CompositeProvider of BW Workspace

The generated calculation views point directly to the same data and tables of the corresponding SAP BW/4HANA object. These tables are located in the BW-managed SAP HANA schema. Therefore, SAP BW/4HANA data can be consumed directly in SAP HANA and its interfaces.

When SAP HANA views are generated, no SAP BW/4HANA data is moved. The generated SAP HANA views directly consume data from tables that are managed by the SAP BW/4HANA. This also provides a clear interface between the schema managed by the SAP BW/4HANA and an area outside the SAP BW/4HANA schema. This interface makes clear where the services in the SAP BW/4HANA system end, and where the manual enhancements or enhancements through third-party tools begin.

When a query is executed on the SAP HANA View, the data is requested directly from SAP HANA, without the SAP BW/4HANA system being addressed.

These SAP HANA views are part of the SAP BW/4HANA InfoProvider lifecycle. They are transported with the corresponding SAP BW/4HANA objects. The target system must have an SAP HANA database.

When an SAP BW/4HANA object is activated with the SAP HANA view, all the dependent SAP HANA views are also activated. If an error occurs with an SAP HANA view that you created, this only leads to a warning, and the SAP BW/4HANA object is activated.

You use SAP HANA Studio to display the generated calculation views, because SAP HANA views are not deployed in HDI, but still in the SAP HANA XS classic environment.

The transaction RS2HANA_ADMIN lists all existing generated SAP HANA views and the corresponding SAP BW/4HANA objects. The view in fact, combines the corresponding fact, master data, and text tables in the SAP BW/4HANA schema. It contains filters for the key date and logon language.

The SAP BW/4HANA Cockpit function, Manage Views, provides an overview of SAP BW/4HANA objects, with an external SAP HANA view of the entire system. It also provides the following administration and check functions:

• Check the external view.

• Repair external view.

• Log for repair jobs.

• Consistency check tool, mainly for authorization setup (transaction RS2HANA_CHECK).

In Customizing (or GUI transaction RS2HANA_VIEW), you can perform the following functions:

• Define the default SAP HANA content package.
• View properties such as the execution engine.
• Make settings for the generated authorizations.