Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Lesson 1 of 5

The Migrate Your Data app: projects and objects

11 min

The data migration fundamentals course introduced the SAP S/4HANA Migration Cockpit as SAP's tool of choice for loading data into a new SAP S/4HANA system. This course gets hands-on with its most widely used approach: migrating data using staging tables, filled either from the cockpit's file templates or by your own extraction tools. We follow Contoso Motor Co.'s Wave 2. Contoso's own move from SAP ECC was a system conversion, so its existing data never needed loading. Right after the conversion, Contoso acquired Alternadores del Norte S.A. de C.V. in Monterrey, Mexico, which runs a non-SAP legacy ERP. Its data is loaded into the converted SAP S/4HANA system as new company code 1910 (currency MXN) with plant 1910 Monterrey: suppliers, products, purchasing info records and open purchase orders. That is a new-implementation-style load into an existing system, and exactly what the staging table approach is for.

Where you work

You work in the SAP Fiori app Migrate Your Data – Migration Cockpit. Access needs the authorization for the app plus authorizations for the business data each migration object creates. In older on-premise releases the cockpit was transaction LTMC; in current releases the Fiori app replaces it, and projects created in LTMC are not opened in the new app. Everything in this course applies to SAP S/4HANA 2025 on-premise and Private Edition; Public Edition uses the same app with a smaller, cloud-specific set of objects and settings.

Creating a migration project

Work is organized into migration projects. A project holds the migration objects you need, their staging tables, mapping values, run history and messages. When you create a project with the staging table approach, you decide:

  • Project name: Contoso uses one project per load wave, for example W2 1910 Mock 2 Master Data, so that runs and messages are not mixed between mocks.
  • Database connection: the staging tables live either in the local SAP S/4HANA database schema, or in a remote SAP HANA schema reached through a database connection. Local is the default; remote suits teams whose own ETL tooling fills the tables.
  • Migration objects: chosen from the list of predefined objects, such as Bank, Supplier, Customer, Product, Purchasing info record and Purchase order (open items). Object names vary by release; read them in your system.
  1. Open the appMigrate Your Data – Migration Cockpit on the launchpad
  2. Create projectChoose "Migrate Data Using Staging Tables", name it, choose local or remote schema
  3. Select objectsPick the migration objects for this wave; review the dependencies the cockpit shows
  4. Read object documentationFields, prerequisites, validation apps and known restrictions per object
  5. Open each objectDownload the template or fill the staging tables; then work through the steps
Setting up a staging-table migration project.
The Sign-Off Table · thesignofftable.com/academy/sap-dmg-201

What a migration object is

A migration object is SAP's predefined package for one type of business data: its source structures (what you provide), its target structures and the standard SAP interface it uses to create the data, with the same checks as the normal application. Each object has documentation in the app that explains the required fields, the prerequisites (configuration and predecessor objects), how to validate the result in the business apps, and any restrictions. Read it before you build anything; it answers most "why did this fail?" questions in advance.

Business resultAn Alternadores supplier exists as a business partner with its roles, Mexican tax number and bank data for company code 1910
Standard interfaceThe object calls SAP's API for the business object, with the normal application checks
MappingValue mappings and fixed values convert source values to target values
Staging tablesOne or more tables per object, generated by the cockpit, holding your source data
Your dataTemplates uploaded as files, or tables filled by your extraction tools
The layers inside a migration object, from your data to the business result.
The Sign-Off Table · thesignofftable.com/academy/sap-dmg-201

Dependencies drive the object list

Objects depend on each other. A purchasing info record needs the supplier and the product; an open purchase order needs both plus the info record if prices come from it. The cockpit shows predecessor objects, and the load must respect them. The Wave 2 Mock 2 master data project contains Bank, Supplier, Customer and Product; a second project for dependent master data contains Purchasing info record and Source list; a third, for open items, follows later in the cutover sequence.

Contoso projectObjectsLoads after
W2 1910 Mock 2 Master DataBank, Supplier, Customer, ProductConfiguration transported
W2 1910 Mock 2 Dependent MasterPurchasing info record, Source listMaster data project complete
W2 1910 Mock 2 Open ItemsPurchase order (open), Material inventory balance, AP and AR open itemsAll master data complete

How Contoso splits Wave 2 Mock 2 into projects by load step.

What would you do?

A new migration analyst creates one project for "everything for Alternadores" and adds all 25 objects, so that mock 2 and mock 3 can share it. What is the main problem?

Key points
  • Use the Migrate Your Data – Migration Cockpit app; LTMC is replaced in current releases.
  • A project holds objects, staging tables, mapping values, runs and messages; staging tables are local or remote.
  • Each migration object has documentation: required fields, prerequisites, validation apps, restrictions.
  • Split projects by load wave and mock so results can be reconciled.

Check your understanding · not graded

Lesson check

  1. 1. Which app is used for staging-table migrations in current SAP S/4HANA releases?

  2. 2. Where can the staging tables of a project live?

  3. 3. Where do you find a migration object's required fields and validation apps?

  4. 4. Why load purchasing info records after suppliers and products?