TechnicalDetailsMigrationDataModel S4HANA Finance

Data Model of S/4HANA Finance Data Migration
Attachment to note 2408083
December 2016
SAP S/4HANA, on-premise edition 1610
Identification of Migrated Line Items
During the migration of data into ACDOCA it is necessary to store the type and
the origin of the entry for reconciliation purposes.
The following two attributes have been introduced for additional identification of line
items:
Source of migrated line item (MIG_SOURCE): Status of line item (BSTAT):
• Space: item created after migration • Space and L: Line Items and ledger
• F, G, C, M, A: Line items or balance specific line items
information originating from classic GL, • C: balance carry forward items or
New GL, CO, ML or AA entries from balance migration
• R: Correction item on document level
• S, U: Correction item on balance level
based on CO or GL
Examples:
• Space / Space: Line item posted after migration
• G / Space: Line item migrated from NewGL line item (and potentially CO)
• C / C: Correction of balance in CO to compensate for archived CO line items
• U / C: Correction of GL balance to compensate for CO or AA balance items
© 2016 SAP SE or an SAP affiliate company. All rights reserved. Early Knowledge Transfer Customer 2
Example of Migration – CO Data Only
Before Simple Finance Migration:

Account Account
Table Account assignment Amount Table Account assignment Amount
BSEG – GL line item 0 COEP – CO items 600000 CC100 100 €
GLT0 – GL total 0 COSP – CO Total 600000 CC100 100 €
After Simple Finance Migration:

Account
Table Account Assignment Amount MIG_SOURCE
ACDOCA – line item 600000 CC100 100 € C: Migrated CO Line item
600000 -100 € R: GL Balance Correction
Compatibility Reporting GL Compatibility Reporting CO

Cost Center 100
Account 600000 100 €
Example of Migration - CO and GL Line Items
FI document items and CO line items before Simple Finance Migration:

Account Account
BSEG – GL line item 800000 100 € COEP – CO items 800000 WBS element 100 €
BSEG – GL line item 800000 100 € COEP – CO items 800000 WBS element 100 €
GLT0 – GL total 800000 200 € COSP – CO Total 800000 WBS element 200 €

Account
ACDOCA – line item 800000 WBS element 100 € F: Migrated CO/GL line item*
ACDOCA – line item 800000 WBS element 100 € F: Migrated CO/GL line item*
*CO relevance of ACDOCA items determined by CO_BELNR, CO_BUZEI etc, not by MIG_SOURCE
GL Compatibility Reporting CO Compatibility Reporting

WBS element:
Account 800000 200 €
Account 800000 200 €
Example of Migration - CO and GL Line Items Not Linked
FI document items and CO line items before Simple Finance Migration:

Account Account
BSEG – GL line item 400000 150 € COEP – CO items 400000 CC100 120 €
BSEG – GL line item 400000 150 € COEP – CO items 400000 CC200 180 €
GLT0 – GL total 400000 300 € COSP – CO Total 400000 CC100 300 €
Account
ACDOCA – line item 400000 CC100 120 € C: Migrated CO item
ACDOCA – line item 400000 CC200 180 € C: Migrated CO item
ACDOCA – line item 400000 150 € F: Migrated GL item
ACDOCA – line item 400000 150 € F: Migrated GL item
ACDOCA – correction item 400000 - 300 € R: Revert CO to get correct GL
GL Compatibility Reporting CO Compatibility Reporting

Cost Center 100:
Account 400000 300 € Account 400000 120 €
Cost Center 200:
Account 400000 180 €
Why Do we Need the Migration of Balances?
Published financial statements had been based on total reporting in the

past (EHP7 / without Simple Finance)
Reporting based on ACDOCA has to bring up the same results as the old
total based reporting
Migration of Balances ensures that the aggregation on ACDOCA

shows the same results as the old totals
In case of any differences the migration creates correction items in

ACDOCA. These are identified by BSTAT C and MIG_SOURCE <> space.
Differences arise if line items are archived or line items resulting from the
same business transaction cannot be linked inside a single document
(inside a document, such differences would be corrected with
MIG_SOURCE R items).
Example – Archived GL Line Items and Totals
Account
Table Account Assignment Amount
COEP 400000 CC100 100 CO line item
COSP 400000 CC100 100 CO totals
BSEG 400000 100 Archived GL line item

GLT0 400000 100 Archived GL total
MIG_SOURCE / BSTAT
ACDOCA 400000 CC100 100 C/‘‘: Migrated CO line item
ACDOCA 400000 -100 U/C: GL Correction item
GL Reporting on ACDOCA CO Reporting on ACDOCA

CostCenter100
Account 400000 0€
Account 400000 100 €
Example – GL only postings and Archived GL line Item
Account
COEP CO line Item
COSP CO Total
BSEG 400000 100 GL line item

BSEG 400000 200 Archived GL Line Item
GLT0 400000 300 GL total (including archived items)
MIG_SOURCE / BSTAT
ACDOCA 400000 100 F/‘‘: Migrated GL Line item
ACDOCA 400000 200 F/C: Correction entry for GL balances

Account 400000 300 €
Example – CO only posting with archived CO Line Items
Account
COEP 900000 CC100 -100 Archived CO line item
COEP 900000 OR200 100 CO line item
COSP 900000 CC100 -100 CO total
COSP 900000 OR200 100 CO total

GLT0 900000 0 GL total
MIG_SOURCE / BSTAT
ACDOCA 900000 OR200 100 C/‘‘: Migrated CO line item
ACDOCA 900000 CC100 -100 C/C: CO Balance Correction

CostCenter100 Order 200
Account 900000 0€
Account 900000 -100 € Account 900000 100 €
Example - CO and GL Line Items - Mixture
Account
COEP 400000 CC100 100 Archived CO line item
COEP 400000 CC100 100 CO line item
COSP 400000 CC100 200 CO total

BSEG 400000 100 Archived GL line item
MIG_SOURCE / BSTAT
ACDOCA 400000 CC100 100 F/‘‘: Migrated CO/GL line item
400000 CC100 100 C/C: CO Correction
400000 100 F/C: GL Correction
400000 -100 U/C: GL Correction

CostCenter 100
Account 400000 200 €
Account 400000 200 €
Migration of Asset Accounting Data
During the migration of line items, Asset Accounting line items are transferred or
converted from tables ANEK, ANEP, ANEA and ANLP (posted values only) to the new
data structure ACDOCA & FAAT_DOC_IT
Values of parallel currency depreciation areas are transferred to KSL/OSL.
The reference type of the columns of table ANEP is converted to SLALITTYPE (line item type)
of table ACDOCA.
The G/L account (ACDOCA-RACCT) is derived from the asset + SLALITTYPE
The asset line items normally refer to a FI document, but – e.g. for depreciation
postings, retirements etc. – do not refer to a single FI line item
Therefore, all FI-AA line items (mapped to SLALITTYPE) will be added to the document with
MIG_SOURCE ‘A’ additionally to the FI-lines of MIG_SOURCE ‘F’ or ‘G’. To correct the
duplicate balance of the document, these lines will get reversal lines (MIG_SOURCE ‘R’).
For missing FI documents (RABUCH postings, AS91 line items or archived FI documents),
only FI-AA data will be migrated as MIG_SOURCE ‘A’ items. If needed, G/L balances will be
corrected by the migration of balances.
Example of Migration – Asset Accounting
FI document items and FI-AA line items before Simple Finance Migration:
Normal de- Special Unplanned
Table Item KOART Amount Table Asset preciation depr. depr.
BSEG – GL line item 001 S 100.000 € ANEP 4711 -40.000 € -5.000 €
BSEG – GL line item 002 A -75.000 € ANEP 4712 -30.000 € -5.000 €
BSEG – GL line item 003 A -25.000 € ANEP 4713 -23.000 € 3.000 €
FI item
Table (BUZEI) KOART Asset SLALITTYPE Amount MIG_SOURCE
ACDOCA 001 S 100.000 € F: Migrated GL item
ACDOCA 002 A -75.000 € F: Migrated GL item
ACDOCA 003 A -25.000 € F: Migrated GL item
ACDOCA 000 A 4711 7205 (normal depr.) -40.000 € A: Migrated FI-AA item
ACDOCA 000 A 4711 7206 (special depr.) -5.000 € A: Migrated FI-AA item
ACDOCA 000 A 4712 7207 (unplanned depr.) -5.000 € A: Migrated FI-AA item
ACDOCA 000 A 4713 7207 (unplanned depr.) 3.000 € A: Migrated FI-AA item
ACDOCA 000 A 100.000 € R: Revert AA to get correct GL
Example of Migration – Asset Accounting without FI data
Table Account Asset Amount

ANEP 4711 -5.000 FI-AA item from AS91
ANEP 4712 -3.000 FI-AA item from AS91

MIG_SOURCE / BSTAT
ACDOCA 11000 4711 -5.000 A/‘‘: Migrated FI-AA line item
ACDOCA 11000 4712 -3.000 A/‘‘: Migrated FI-AA line item
ACDOCA 11000 8.000 U/C: G/L Correction
GL Reporting on ACDOCA FI-AA Reporting on ACDOCA

Asset 4711 Asset 4712
Account 11000 0€
-5.000 € -3.000 €
© 2016 SAP SE or an SAP affiliate company.
All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an
SAP affiliate company.
SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE
(or an SAP affiliate company) in Germany and other countries. Please see http://global12.sap.com/corporate-en/legal/copyright/index.epx for additional
trademark information and notices.
Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors.
National product specifications may vary.
These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind,
and SAP SE or its affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or
SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and
services, if any. Nothing herein should be construed as constituting an additional warranty.
In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related
presentation, or to develop or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated
companies’ strategy and possible future developments, products, and/or platform directions and functionality are all subject to change and may be
changed by SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment,
promise, or legal obligation to deliver any material, code, or functionality. All forward-looking statements are subject to various risks and uncertainties
that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking
statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.

TechnicalDetailsMigrationDataModel S4HANA Finance

Uploaded by

Copyright:

Available Formats

TechnicalDetailsMigrationDataModel S4HANA Finance

Uploaded by

Document Information

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

TechnicalDetailsMigrationDataModel S4HANA Finance

Uploaded by

Copyright:

Available Formats

Data Model of S/4HANA Finance Data Migration

Attachment to note 2408083

Before Simple Finance Migration:

After Simple Finance Migration:

Compatibility Reporting GL Compatibility Reporting CO

FI document items and CO line items before Simple Finance Migration:

After Simple Finance Migration:

GL Compatibility Reporting CO Compatibility Reporting

FI document items and CO line items before Simple Finance Migration:

GL Compatibility Reporting CO Compatibility Reporting

Published financial statements had been based on total reporting in the

Migration of Balances ensures that the aggregation on ACDOCA

In case of any differences the migration creates correction items in

BSEG 400000 100 Archived GL line item

GL Reporting on ACDOCA CO Reporting on ACDOCA

BSEG 400000 100 GL line item

GL Reporting on ACDOCA CO Reporting on ACDOCA

BSEG 900000 0 GL line item

GL Reporting on ACDOCA CO Reporting on ACDOCA

BSEG 400000 100 GL line item

GL Reporting on ACDOCA CO Reporting on ACDOCA

Table Account Asset Amount

BSEG 11000 0 GL line item

GL Reporting on ACDOCA FI-AA Reporting on ACDOCA

National product specifications may vary.

You might also like