Ansicht
Dokumentation

RIWP_HANA_VIEW_REPLICATOR - HANA View Replicator for ILM

Purpose

You can use this report to replicate or generate the HANA views (attribute view or calculation view) of the archives of the decommissioned system, based on the existing HANA view or Virtual Data Model (VDM) delivered by SAP. For example, BKPF and BSEG are the VDMs already delivered by SAP.

Prerequisites

• You have established a connection with the HANA database using transaction DBCO

• You have assigned the IWP_MAN_WP to your ABAP user

• You have defined the following authorizations for the HANA DB connection user in transaction DBCO

• Authorization Select for the _SYS_REPO user to access the schema under which the tables are generated (GRANT SELECT ON SCHEMA TO _SYS_REPO WITH GRANT OPTION)

• Authorization to generate tables under the schema

• View creation authorizations to generate views under a package

• You have the necessary VDMs delivered by SAP in the HANA system

Features

The report searches for the database tables corresponding to the VDM you provide. Based on the database table, the report searches for the existence of the archiving objects and the metadata for the tables. Only if both the tables and its metadata are available in the archive files does the report replicate or generate the new HANA views.

Note: If any of the tables or their metadata are not found in the archive files, then the report does not generate any views.

The report creates the database tables in the schema you specify. It also generates the corresponding attribute view or calculation view under the package you specify. In addition, a view is replicated in the new sub package available under the package.

If a table is included in one or more VDMs, the report reuses the already generated tables and does not generate a new table in the schema. However, the corresponding views are generated for every reporting package.

Note: If the structure of the tables in the legacy system does not match the VDM tables, the view replicated under the subpackage may not be in an active state. However, you can manually activate the view after referring to the log.

Selection

You can enter the following parameters:

• Name of the reporting package

• Audit package or audit package template: The tables are generated in HANA for the audit package or the audit package template specified

• SAP System ID and Client ID

• Note: If you have opted to specify the audit package, the legacy system details are automatically retrieved and you do not need to enter the system ID and the client ID.

• Authorization Group: Group of users with a specific set of authorization

• HDB Connection Name: The connection you have defined in the transaction DBCO

• Schema: The tables are generated under this schema in HANA

• Package: The views for the tables are generated under this package in HANA

• Prefix: The system uses this prefix for the tables generated in HANA. The format of the table name is _ _. If you do not specify a prefix, ILM is used as the prefix. For example, if the prefix is not specified for the legacy system XYZ and its table ABC, the name of the generated table looks like ILM_XYZ_ABC.
  • Source Package: The package in the HANA system where the VDMs are available, for example sap.hba.ecc
  • HANA View Name: The list of VDMs or view names based on the source package. You select the view name you want to replicate. BKPF and BSEG are few examples of VDMs delivered by SAP and they are available in the source package sap.hba.ecc.
  • Note: If you are running the report for replicating a different HANA view or VDM for the same legacy system, the values for the HDB connection name, schema, package, and prefix are automatically retrieved from the previous execution and you do not need to enter them.

  Output

  The tables are generated in HANA and the log displays the list of tables generated under the schema and the list of views generated under the package. The report also displays the URIs considered for generating the views. In addition, the view is also replicated under a new subpackage that is created under the package you specified in the selection screen. The name of the subpackage is same as the name of the reporting package. The name of the attribute view or calculation view that is generated is the same as the name of the HANA view or VDM you select during the generation process.

  
  
  
  
  
  rdisp/max_wprun_time - Maximum work process run time   PERFORM Short Reference  
  This documentation is copyright by SAP AG.
  
  Length: 5608 Date: 20240520 Time: 081441     sap01-206 ( 102 ms )