SAP S/4 HANA Customer Engagement is a simplified version of SAP CRM embedded in SAP S/4 HANA. It was initially available as an add-on under the name “customer management". For a better understanding of the SAP S/4 HANA Customer Engagement data model, please refer to the content below
CRM One Order model redesign in SAP S/4 HANA for Customer Management
Here in this blog, we only discuss in detail about the migration steps we followed for migrating SAP CRM one-order transactions to the SAP S/4 HANA customer engagement system. This process is exclusively designed for migrating the SAP CRM one-order transactions. By following this procedure, we have successfully migrated the below CRM one-order transactions
We have also migrated the change processing log for the above CRM one-order transactions. The challenges faced while we migrated the data is all about the address number, person number, and SMTP address transformation. We also had some complexities in migrating the attachments. I shall detail more about this in my next blog. Let us get into the details of the framework we built for carrying out the CRM one-order migration from SAP CRM to SAP S/4 HANA.
Our approach is one of the several approaches used to carry out the migration. In this approach, we followed a migration of table-to-table. Transactional data is extracted and transformed from the SAP CRM standard tables and loaded into SAP S/4 HANA standard application tables with the help of ABAP reports, SAP Landscape Transformation(SLT) server, and custom staging area both in the source and in the target systems.
Prerequisites:
System requirements:
Minimum requirement is SAP S/4 Hana runtime licence, SAP Landscape Transformation(SLT) Server – This comes as a free product with the SAP S/4 HANA runtime licence
Best suits for:
Migration Framework
Our Source system is SAP CRM 7.0, and the target system is SAP S/4 Hana Customer engagement. SAP Landscape Transformation server replicates the data from the source system to the target system. This approach is best suited for migrating the CRM one-order transactions like Service requests and Interaction records.
Though we follow a table-to-table migration approach, it is not pretty straightforward. The data undergoes a lot of transformation. The reason is - The one Order Model from SAP CRM 7.0 has undergone a redesign in SAP S/4 HANA for Customer Engagement.
Below are the building blocks of this migration approach:
1. Creation of Staging area in source and the target systemTo handle high data volumes, we need to create an exclusive staging area in the source and the target system.
Staging area
1.1. Creation of staging tables in SAP CRM 7.0
The Source system staging area involves the creation of custom tables in SAP CRM, which are identical to the standard tables in the SAP S/4 HANA customer engagement system. SAP S/4 HANA standard tables are identified based on the segments involved in the CRM one-order object.
1.2. Creation of Staging schema in SAP S/4 HANA system
Building the staging area in the SAP S/4 HANA system is much simpler when compared to the process in the SAP CRM system. All we need to do here is to create a custom schema in the SAP HANA database . Configure The SLT server to load the Staging area data extracted from the source system into the custom schema created in the target system. The custom schema in the SAP S/4 HANA system is inevitable because they serve as a two-step verification of the data before we write the data into the application tables. Moreover, the ETL tools like the SLT server are refrained from writing directly into the SAP S/4 HANA application schema.
2. Creation of ABAP ETL program in the Source system
Custom programs are developed in SAP ABAP to extract the required SAP CRM standard table. The data is then transformed to SAP S/4 HANA format and loaded into the Staging tables in the SAP CRM source system. This process requires a detailed understanding of the CRM one-order framework both in the source and in the target systems. It’s a two-step process where each SAP CRM standard table gets mapped to the respective SAP S/4 HANA standard table, and in turn, each field in the SAP CRM source table gets mapped with that of the SAP S/4 HANA target table.
When we migrate service requests from SAP CRM to SAP S/4 HANA Customer engagement, our mapping sheet will look like the below image. The Same logic goes into the ABAP program.
Table/Field mapping
3. Configure the SLT server between the SAP CRM system and SAP S/4 Hana system
SAP Landscape Transformation server is the SAP first ETL (Extract, Transform, Load) tool that allows you to load and replicate data in real-time from the SAP/Non-SAP source system into SAP HANA Database. Establish the connection between the SLT server and the SAP CRM 7.0 using an RFC connection. Establish a DB connection between The SLT server and the SAP S/4 HANA. When the replication starts, the system loads the data into the target staging schema. Once the entire data is loaded, the system goes into the replicate mode.
Having an SLT server in the architecture is of great advantage.
4. Creation of ETL Programs in the target system
The data loaded from the SAP CRM staging area into the SAP S/4 Hana staging area, must be extracted, transformed, and loaded into the SAP S/4 HANA application tables.
4.1. Extracting data from SAP S/4 Hana custom schema
There are several ways to expose the SAP HANA database tables into the application layer. One approach is to create attribute views out of the tables in the custom schema and then to create an external database view on top of the attribute view so that the table is made accessible by the programs in the application layer.
External view
The other approach is the creation of AMDP (ABAP Managed Database Procedures) to read from the staging tables of the custom schema.
AMDP
The advantage of the AMDP over the creation of external views is that,
We can write most of our transformation logic for required tables within the AMDP and have a generic ABAP Program to load data into the application tables. For example, the Business Partner address numbers in the SAP CRM one-order transactions will have to be transformed following the address numbers in the SAP S/4 HANA. The transformation logic conveniently gets placed inside the AMDP.
We faced a scenario where The SAP data type NUMC gets represented as NVARCHAR in SAP HANA database. The same gets reflected in the SAP HANA external view as well. Due to this reason, an additional data type conversion is required when it is read by the ABAP programs. Whereas, In the AMDP approach, the framework takes care of the data type conversions between SAP HANA database and SAP ABAP layer.
4.2. Loading data into SAP Standard tables in SAP S/4 HANA
If we can push most of the transformation logic into the AMDP methods, we can create a generic SAP ABAP program for loading the data into the application tables.
The generic program calls AMDP methods for the respective tables and loads the data extracted from the staging area into the application tables in the SAP S/4 HANA customer engagement system.
We can parameterize the program to take the table name, Package size of data (Say limit and offset) and pass it to the AMDP methods. This technique avoids memory dumps.
Hence, this approach can seamlessly achieve a table-to-table migration of SAP CRM one-order transactions into the SAP S/4 HANA customer engagement system.
Cheers,
Santhosini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 | |
1 |