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

Lesson 3 of 6

Org structure, chart of accounts and master data harmonization

8 min

Listen to this lesson

0:00 / 10:16

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

Company code 1910 inherits constraints from controlling area A000: the same operating chart of accounts and the same fiscal year variant.
The Sign-Off Table · thesignofftable.com/academy/sap-xpr-307

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.

ObjectSource (Alternadores)TargetMapping typeOwner
Company codeLegal entity Alternadores del Norte S.A. de C.V.1910 (MXN)1:1Dan
Controlling areaNone in the legacy ERPA000 (shared with 1710 and 1810)New assignmentControlling team
PlantMonterrey works1910 Monterrey1:1Supply chain lead
Sales areaOne sales channel1910 / 10 / 00n:1Lucía
G/L accountsLegacy chart of accountsContoso operating chart of accountsn:1 (no splits without a rule)Dan
LedgersMexican books only0L (US GAAP) and 2L (IFRS)Values per ledgerDan
Payment termsCR300004Value mappingLucí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.

SAP Master Data Governance consolidation runs standardize, match, best record, validate and activate; Hannah's team reviews matches before activation.
The Sign-Off Table · thesignofftable.com/academy/sap-xpr-307
  1. Does the record match an existing Contoso business partner?No → create a new BP with 1910 data · Yes → next question
  2. Is it the same legal entity (tax ID, registration)?No → create separately and record the false positive · Yes → next question
  3. 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
For each legacy customer and supplier: create, extend or treat as intercompany.
The Sign-Off Table · thesignofftable.com/academy/sap-xpr-307

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?

Key points
  • 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. 1. Company code 1910 joins controlling area A000. Which constraint follows?

  2. 2. One legacy revenue account must go to two Contoso accounts. What does that require?

  3. 3. Lakeside Components already supplies Contoso and also supplies Monterrey. What is the right master data action?

  4. 4. Contoso appears in Alternadores' legacy customer list. After the acquisition, what is this relationship?