Lesson 3 of 6
Org structure, chart of accounts and master data harmonization
8 min
Listen to this lesson
Once the target state is fixed, the integration becomes a long list of mapping decisions. Which company code, which controlling area, which chart of accounts, which profit centers, which number ranges, and which of the target's customers and suppliers are already the buyer's business partners? SAP enforces some of these choices through hard constraints; others are design decisions that finance and the process owners must make on purpose. This lesson walks through both, using Contoso's company code 1910.
Fitting the target into the organizational structure
Contoso's controlling team assigned 1910 to controlling area A000, alongside 1710 and 1810. That decision brings two constraints. All company codes in a controlling area use the same operating chart of accounts, so 1910 posts to Contoso's accounts, not to Alternadores' legacy accounts. And the fiscal year variant of 1910 must match A000's; in SAP S/4HANA, finance and controlling share the Universal Journal (table ACDOCA), so the variants must be identical. Alternadores closes on the calendar year, so it fits. A target with a different year-end would need either a fiscal year change before the load or its own controlling area, and SAP's fiscal year conversion for a live system is a DMLT scenario, not a setting.
| Object | Source (Alternadores) | Target | Mapping type | Owner |
|---|---|---|---|---|
| Company code | Legal entity Alternadores del Norte S.A. de C.V. | 1910 (MXN) | 1:1 | Dan |
| Controlling area | None in the legacy ERP | A000 (shared with 1710 and 1810) | New assignment | Controlling team |
| Plant | Monterrey works | 1910 Monterrey | 1:1 | Supply chain lead |
| Sales area | One sales channel | 1910 / 10 / 00 | n:1 | Lucía |
| G/L accounts | Legacy chart of accounts | Contoso operating chart of accounts | n:1 (no splits without a rule) | Dan |
| Ledgers | Mexican books only | 0L (US GAAP) and 2L (IFRS) | Values per ledger | Dan |
| Payment terms | CR30 | 0004 | Value mapping | Lucía with finance |
An extract from the org and mapping workbook for company code 1910 (illustrative course data).
Chart of accounts and statutory needs
Mapping a target's accounts to the buyer's chart is normally n:1: several legacy accounts land on one Contoso account. A 1:n split, where one legacy account must spread across several target accounts, cannot be done by a simple mapping table. It needs a rule on another attribute, such as splitting legacy sales by customer group into domestic and export revenue, and the rule must be written, tested and reconciled. SAP LT's chart of accounts conversion follows the same logic: rename and n:1 merge are possible, splitting is not.
Local requirements sit beside the group chart. Mexico expects electronic accounting files that map each account to the tax authority's grouping code; check SAP's Mexico localization for your release to see how that mapping is maintained, and include it in the mapping workbook rather than in a spreadsheet on someone's laptop. Contoso already runs document splitting by profit center and segment, so every 1910 line item also needs a profit center: decide early whether Monterrey gets its own profit centers or derives into existing ones, because that decision changes segment reporting.
Business partners: merge, extend or create
Alternadores has 3,180 customers in its legacy ERP, of which 1,946 are in scope. Some suppliers overlap with Contoso's: if Lakeside Components also supplies Monterrey, the right answer is to extend the existing business partner 17300001 with company code 1910 and purchasing data, not to create a second Lakeside. Contoso itself appears in Alternadores' customer list, and Alternadores appears as a supplier in 1710; after the deal those relationships are intercompany, so the business partners need the trading partner set to the right company. Customers that look identical can still be separate legal entities, such as two fleet operators sharing an address in an industrial park, so duplicate matching needs human review.
- Does the record match an existing Contoso business partner?No → create a new BP with 1910 data · Yes → next question
- Is it the same legal entity (tax ID, registration)?No → create separately and record the false positive · Yes → next question
- Is the partner now part of the Contoso group?Yes → intercompany: set the trading partner · No → extend the existing BP with 1910 company code and sales or purchasing data
Keep the legacy number traceable. Migrated customers and suppliers get Contoso business partner numbers, so store the legacy number in the customer's and supplier's company code data (the previous account number field) or another agreed reference, and make it searchable. Finance and auditors will ask "what happened to legacy customer 40112?" for years.
What would you do?
Hannah's MDG match finds that 62 Alternadores suppliers match existing Contoso business partners. For 9 of them the tax ID differs although name and address are the same. What should happen to those 9 before W2 Mock 2?
- A company code in a controlling area shares its operating chart of accounts and fiscal year variant.
- Account mappings are n:1; any split needs a written, tested rule.
- Overlapping partners are created, extended or treated as intercompany, decided record by record with human review of matches.
- Keep legacy numbers traceable and test mappings with edge cases from the first mock.
Check your understanding · not graded
Lesson check
1. Company code 1910 joins controlling area A000. Which constraint follows?
2. One legacy revenue account must go to two Contoso accounts. What does that require?
3. Lakeside Components already supplies Contoso and also supplies Monterrey. What is the right master data action?
4. Contoso appears in Alternadores' legacy customer list. After the acquisition, what is this relationship?