Show TOC

Background documentationMigration to SAP Accounting powered by SAP HANA

 

SAP Simple Finance, on-premise edition contains the product SAP Accounting powered by SAP HANA. SAP Accounting powered by SAP HANA contains General Ledger Accounting, Controlling, and Asset Accounting.

Purpose and Target Groups

If you want to implement and use SAP Accounting powered by SAP HANA, you have to migrate the existing user data from the G/L Accounting (FI-GL), Asset Accounting (FI-AA), Controlling (CO) and Material Ledger areas. Such a migration of data is necessary because SAP Accounting powered by SAP HANA rests on a uniform data model for all accounting areas. The universal data table ACDOCA contains all of the line item documents from FI, FI-AA and CO. All postings of these applications are written to the new table after the installation and migration are complete.

The following tables were replaced by SAP HANA views with the same names:

  • The line item, totals tables and application index tables of General Ledger Accounting (GLT0, BSIS, BSAS and FAGLFLEXA, FAGLFLEXT, FAGLBSIS, FAGLBSAS)

  • The totals tables and application index tables of Accounts Receivable and Accounts Payable (KNC1, KNC3, LFC1, LFC3, BSID, BSIK, BSAD, BSAK)

  • The line item and totals tables of Controlling (COEP for certain value types, COSP and COSS)

  • The material ledger tables for parallel valuations (MLIT, MLPP, MLPPF, MLCR, MLCD, CKMI1, BSIM)

  • The Asset Accounting tables (ANEK, ANEP, ANEA, ANLP, ANLC)

Replacing these tables with views with the same names ensures the continuation of all read accesses to the tables mentioned.

With the SAP Simple Finance, on-premise edition you are provided with universal data table ACDOCA which contains all of the line item documents from FI, FI-AA and CO. All postings of these applications are written to the new table after the installation and migration are complete.

Notes About Migration

SAP Accounting powered by SAP HANA is based on new General Ledger Accounting (FI-GL (New)) and uses functions such as ledgers to update a particular valuation, and the document splitting function. If you want to use SAP Accounting powered by SAP HANA, but were still using classic General Ledger Accounting until now, migrate the application data for General Ledger Accounting and the necessary settings for the new Customizing, for example ledgers and integration for Controlling.

However, none of the functions of new General Ledger Accounting, such as parallel ledgers and document splitting, are implemented.

For Asset Accounting purposes you use new Asset Accounting in SAP Accounting powered by SAP HANA. During the migration from classic Asset Accounting to new Asset Accounting in SAP Accounting powered by SAP HANA, you migrate Customizing settings and transaction data.

The Migration Process

The migration of existing system configurations, master data, and application data is closely connected to the process for installing the SAP Simple Finance, on-premise edition. You cannot consider the installation and migration in isolation from each other.

You have to perform preparatory steps before you install the on-premise edition. These include the following application-specific preparations:

  • Making a preliminary check that ascertains whether the on-premise edition can be installed with the current system settings, or whether additional activities are required.

  • Making consistency checks that check the correctness of the accounting data from a technical point of view, and list any inconsistencies

  • Performing reconciliation between the accounting applications, to enable the data to be merged correctly in the universal journal entry

  • Carrying out period-end closing including the storage of reporting key figures and closing the posting periods

Once you have carried out the preparatory steps, and have met the prerequisites for implementing the SAP Simple Finance add-on, you can proceed to install it.

In the course of installing the on-premise edition, the following steps to prepare for the migration are automatically executed by the system:

  • Creating backup tables for the totals tables and index tables in the Data Dictionary that are being done away with (*_BCK in FI and *_BAK in CO)

  • Saving the totals tables and index tables in backup tables

  • Deleting the original totals tables and index tables

  • Creating SAP HANA views (with the same names) for the totals, index, and line item tables

  • Creating the new table for the universal journal entry

You have to migrate the accounting and Controlling data immediately following the installation. To be able you to undertake this data migration, specific configuration steps are necessary that have been summarized in the implementation guide. There are specific migration and check programs for the migration that have been included in the SAP Reference IMG in their correct order. All of the migration steps are described in the relevant sections included there.

After the migration, you nonetheless have to reconcile the data and perform tests manually.

Constraints

If you want to use new Asset Accounting in SAP Accounting powered by SAP HANA, you are not allowed to use some components and functions at the same time. For more information, see Migration to New Asset Accounting (FI-AA (New)).