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

Lesson 2 of 5

Migration objects and sequence

8 min

Listen to this lesson

0:00 / 9:30

Data migration is organized into migration objects. A migration object is one type of business data that is loaded as a unit, with its own template, fields, rules and checks: for example banks, customers, suppliers, products, purchasing info records, open purchase orders, material inventory balances or accounts receivable open items. The SAP S/4HANA Migration Cockpit provides a library of predefined migration objects; the exact list and names vary by release and deployment, so always check the object list in your own system.

Why sequence matters

Objects depend on each other. An open sales order refers to a customer and a product. A purchasing info record refers to a supplier and a product. An inventory balance refers to a product, a plant and a storage location. If you load the order before the customer exists, the load fails, or worse, someone creates a quick workaround that leaves broken data behind. The load sequence is therefore driven by dependencies: an object can be loaded only after everything it references exists.

4. Balances and open itemsInventory balances, open receivables and payables, G/L balances, fixed assets with values
3. Open transactional documentsOpen purchase orders, open sales orders, contracts
2. Dependent master dataBills of material, routings, purchasing info records, source lists, pricing conditions
1. Core master dataBanks, business partners (customers and suppliers), products
0. Organization and configurationCompany code, plants, storage locations, document types: built and transported, not migrated
Typical dependency layers, loaded from the bottom up. Your project's exact sequence comes from its own object list.
The Sign-Off Table · thesignofftable.com/academy/sap-dmg-101

A worked sequence for Alternadores del Norte

OrderObjectDepends onAlternadores del Norte example
1BanksConfiguration onlyMexican banks used by its local suppliers and fleet customers
2Business partners: customers and suppliersBanks, configurationFlotillas Monterrey S.A. de C.V. as customer; its local rotor supplier
3ProductsPlants, storage locations, valuation settingsADN-200 and its rotor in plant 1910 Monterrey
4Bills of material and routingsProducts, work centersBOM of ADN-200 containing the rotor
5Purchasing info records and pricing conditionsSuppliers, customers, productsRotor price from the local supplier; fleet price in MXN for Flotillas Monterrey
6Open purchase orders and open sales ordersBusiness partners, products, conditionsOpen PO for 500 rotors; open order for 50 alternators
7Inventory balancesProducts, plants, storage locationsADN-200 stock in plant 1910 Monterrey
8Financial open items and balancesBusiness partners, G/L accounts, and stock values for reconciliationOpen receivables of Flotillas Monterrey; open payables to suppliers; G/L balances in company code 1910 (MXN)

An illustrative load sequence. Real projects have many more objects and some parallel streams.

Finance has its own logic

Financial objects are usually loaded last and need special care. Inventory balances post stock values; open receivables and payables post customer and supplier items; G/L balances must then be loaded so that the totals in the new system match the old one, without double counting the values already posted by stock and open items. Migration projects typically use dedicated migration clearing accounts that must net to zero when everything is loaded. Dan's team agrees the approach with the migration specialist early, because getting it wrong produces balance sheets that do not tie out.

  1. Inventory balancesStock values posted for plant 1910 Monterrey
  2. Open receivables and payablesAlternadores del Norte's customer and supplier items posted in MXN
  3. G/L balancesRemaining balances for company code 1910, without double counting
  4. Clearing checkMigration clearing accounts net to zero; totals match the legacy ERP
The usual order for financial loads; when everything is in, the migration clearing accounts must net to zero.
The Sign-Off Table · thesignofftable.com/academy/sap-dmg-101

What would you do?

During the first Alternadores del Norte mock load, 300 open sales orders fail with errors saying the sold-to party does not exist. The customer object was scheduled to load in parallel with sales orders to save time. What should the migration team change?

Parallel streams and the critical path

Not everything has to wait for everything else. Objects without a dependency between them can be loaded in parallel: banks and products, for example, do not depend on each other. The longest chain of dependent loads is the critical path of the migration, and it largely decides how long the cutover window must be. Luis builds the cutover plan around that chain and uses each mock load to find out how long every step really takes.

  1. Does object B reference anything in object A?Yes → load B after A; the pair sits on a dependency chain · No → they can load in parallel
  2. Is this chain the longest one in the plan?Yes → it is the critical path; it sets the cutover window · No → schedule it around the critical path
  3. Did the last mock show this step taking longer than planned?Yes → update the cutover plan and tune the step · No → keep the timing
Deciding what can load in parallel and what sits on the critical path of the cutover window.
The Sign-Off Table · thesignofftable.com/academy/sap-dmg-101
Key points
  • A migration object is one type of business data loaded as a unit, with its own template, fields and checks.
  • Dependencies drive the load sequence: referenced objects first.
  • Typical layers: core master data, dependent master data, open documents, balances and open items.
  • Financial balances need a planned approach and clearing accounts that net to zero.

Check your understanding · not graded

Lesson check

  1. 1. Why must business partners usually be loaded before open sales orders?

  2. 2. What is a migration object?

  3. 3. Which objects are usually loaded last?

  4. 4. What must migration clearing accounts do once all financial objects are loaded?