Search Icon

Replacing excel templates with ECC tables in RDS for S/4HANA migration

07 April 2021

banner image
kavinraj-marimuthu

Kavinraj Marimuthu

SAP Data Migration Consultant

SAP Data Migration Consultant at Applexus Technologies with over 4 years of IT experience. Mainly worked on implementing ETL solutions (data integration) and S/4 HANA data...

Read More

SAP Rapid Deployment Solutions is a "PACKAGED SOLUTION" that includes pre-configured content, best practices, and fixed-scope implementation service, resulting in fast and predictable software deployments.
For faster and quicker adoption and implementation of various products, SAP delivers a Rapid deployment solution kit. RDS solutions provide you with a process framework and the tools, methods, and templates needed to execute complex migration tasks quickly, easily, and cost-effectively.
The rapid data migration to SAP S/4HANA, on-premise edition allows you to extract and analyze selected data from virtually any source system.
Key features of Rapid Deployment Solution:

  • Quick response to most urgent business needs, using ready-made accelerators and solution builder tools for faster deployment.
  • Solutions are based on SAP standard templates and tools, making solution adoption easier.
  • Faster time to value.
  • Pre-configured software with in-built validity checks, eliminating the need for unwanted speculation.

Software used:

  • SAP Data Services 4.2 SP11 or above
  • SAP S/4HANA on premise edition

In this blog, we will get to know how can we replace excel workbooks/templates with direct ECC tables as in RDS by default excel workbooks are used as the source. In case if we are unable to get the source data in an excel file and ECC is the source, this method will be helpful in Rapid migration. For downloading the RDS package, importing the ATLs, and setup in BODS, check the blog (Material Master Migration to S/4HANA using RDS) to do the same as all the details were explained.
If you check any one of the sources of the object once you download the content and setup in BODS will be excel only.

SAP S4HANA Data Migration

Establish connection in SAP Data Services

Datastore connection to the source system

Create a new datastore called DS_ECC in the local repo. Establish datastore connection to ECC source system with server details, RFC destination, and working directory on SAP server by clicking the advanced tab.

SAP S4HANA Data Migration

SAP S4HANA Data Migration

Replacing Excel templates with ECC tables:

Screenshot before adding ECC tables extraction step

SAP S4HANA Data Migration

Screenshot after adding ECC tables extraction step

SAP S4HANA Data Migration

Add a new conditional block after the SCR_Initialise script. And declare a global variable $G_Tables_Extraction in job level.

SAP S4HANA Data Migration

For GL Account, source tables are SKA1, SKB1, SKAT, and SKAS. Import these 4 tables under DS_ECC datastore. Add 4 data flows to extract data from these tables. We are going to use the direct extract method for this.

SAP S4HANA Data Migration

SAP S4HANA Data Migration

SAP S4HANA Data Migration

In a data flow, add the source table by drag and drop, query transform, and a template table to stage the source data. In the query transform, map required fields and you can apply a filter if there is any data extraction filter.

In each segment, there will be 3 data flows.

  • Mapping
  • Validation
  • Enrichment

SAP S4HANA Data Migration

We have made changes only in the Mapping section after the ECC tables’ extraction flow. Open the mapping data flow, remove the excel template, drag and drop the staging table as a source.

SAP S4HANA Data Migration

Map the fields properly as technical names and column names are different. Due to this, fields will not be auto-mapped. Repeat these steps for other segments. We don't need to make any changes in the validation and enrichment flows unless any new fields addition. You can follow the same steps and replace excel templates with ECC tables for other RDS jobs.

SAP S4HANA Data Migration

How to extend the segments, field mappings, and validation rules for these questions, SAP has provided the extension guide which helps us to do these. Even we can follow the extension guide to create a new object which is not part of RDS content.

Other than the direct extract (this will be helpful for a small amount of data in ECC) from SAP standard tables, we can use ABAP data flows or SAP SLT to replicate the tables into the database.

References

Related Blogs

performance-optimization-in-sap-business-objects-data-services_Banner

20 December 2024

Performance Optimization in BODS

intelligent-customer-experience

19 December 2024

Intelligent Customer Experience

intelligent_customer_analytics

19 December 2024

Intelligent Customer Analytics – The Future is Here!

Blog-retail-supply-chain-process.webp

11 November 2024

How SAP S/4HANA is Transforming Grocery Retail

bods-vs-slt-vs-sdi-blog_banner

04 September 2024

Seamlessly Unifying Data: Applexus Perspective on Data Integration and Management Tools

sap-data-integration-banner

26 August 2024

Efficient SAP Data Integration Using Ingestion Frameworks

sac-planning-blog-banner3

04 February 2024

The Essential Guide to "Disaggregate by Measure" in SAP Analytics Cloud

SAP-Data-Intelligence-Cloud_blog-banner

06 November 2023

Unlocking business insights by integrating Machine Learning in SAP Data Intelligence Cloud