Data_Model_ofS4HANA_Finance_Data_1715175340.pdf

Data model

1. Data Model ofS/4HANA FinanceData Migration
Attachment to note 2408083
December 2016
SAP S/4HANA, on-premise edition 1610

2. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 2CustomerEarly Knowledge Transfer
IdentificationofMigratedLine 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:
Status of line item (BSTAT):
Space and L: Line Items and ledger
specific line items
C: balance carry forward items or
entries from balance migration
Source of migrated line item (MIG_SOURCE):
Space: item created after migration
F, G, C, M, A: Line items or balance
information originating from classic GL,
New GL, CO, ML or AA
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

3. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 3CustomerEarly Knowledge Transfer
Example of Migration –CO Data Only
Table Account
Account
assignmentAmount
COEP – CO items600000 CC100 100 €
COSP – CO Total600000 CC100 100 €
Compatibility Reporting GL
Cost Center 100
Account 600000 100 €
Table Account
Account
assignmentAmount
BSEG – GL line item 0
GLT0 – GL total 0
Table Account
Account
Assignment Amount MIG_SOURCE
ACDOCA– line item 600000 CC100 100 € C: Migrated CO Line item
600000 -100 € R: GL Balance Correction
Compatibility Reporting CO
Before Simple Finance Migration:
After Simple Finance Migration:

4. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 4CustomerEarly Knowledge Transfer
Example of Migration -CO and GL Line Items
Table Account
Account
assignmentAmount
COEP – CO items800000 WBS element 100 €
COEP – CO items800000 WBS element 100 €
COSP – CO Total800000 WBS element 200 €
Account 800000 200 €
GL Compatibility Reporting
WBS element:
Account 800000 200 €
Table Account
Account
assignmentAmount
BSEG – GL line item800000 100 €
BSEG – GL line item800000 100 €
GLT0 – GL total800000 200 €
Table Account
Account
Assignment Amount MIG_SOURCE
ACDOCA– line item 800000WBS element 100 € F: Migrated CO/GL line item*
ACDOCA– line item 800000WBS element 100 € F: Migrated CO/GL line item*
CO Compatibility Reporting
FI document items and CO line items before Simple Finance Migration:
After Simple Finance Migration:
*CO relevance of ACDOCA items determined by CO_BELNR, CO_BUZEI etc, not by MIG_SOURCE

5. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 5CustomerEarly Knowledge Transfer
Example of Migration -CO and GL Line Items Not Linked
Table Account
Account
assignment Amount
COEP – CO items400000 CC100 120 €
COEP – CO items400000 CC200 180 €
COSP – CO Total400000 CC100 300 €
Account 400000 300 €
GL Compatibility Reporting
Cost Center 100:
Account 400000 120 €
Table Account
Account
assignment Amount
BSEG – GL line item400000 150 €
BSEG – GL line item400000 150 €
GLT0 – GL total 400000 300 €
Table Account
Account
Assignment Amount MIG_SOURCE
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
CO Compatibility Reporting
FI document items and CO line items before Simple Finance Migration:
After Simple Finance Migration:
Cost Center 200:
Account 400000 180 €

6. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 6CustomerEarly Knowledge Transfer
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).

7. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 7CustomerEarly Knowledge Transfer
Example –Archived GL Line Items and Totals
Table Account
Account
Assignment Amount
COEP 400000 CC100 100 CO line item
COSP 400000 CC100 100 CO totals
BSEG 400000 100Archived GL line item
GLT0 400000 100Archived GL total
MIG_SOURCE / BSTAT
ACDOCA 400000 CC100 100 C/‘‘: Migrated CO line item
ACDOCA 400000 -100 U/C: GL Correction item
CostCenter100
Account 400000 100 €
Account 400000 0 €
GL Reporting on ACDOCA CO Reporting on ACDOCA

8. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 8CustomerEarly Knowledge Transfer
Example –GL only postings and Archived GL line Item
Table Account
Account
Assignment Amount
COEP CO line Item
COSP CO Total
BSEG 400000 100 GL line item
BSEG 400000 200Archived 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 €
GL Reporting on ACDOCA CO Reporting on ACDOCA

9. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 9CustomerEarly Knowledge Transfer
Example –CO only posting with archived CO Line Items
Table Account
Account
Assignment Amount
COEP 900000 CC100 -100Archived CO line item
COEP 900000 OR200 100 CO line item
COSP 900000 CC100 -100 CO total
COSP 900000 OR200 100 CO total
BSEG 900000 0 GL lineitem
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
Account 900000 -100 €
Account 900000 0 €
Order 200
Account 900000 100 €
GL Reporting on ACDOCA CO Reporting on ACDOCA

10. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 10CustomerEarly Knowledge Transfer
Example -CO and GL Line Items -Mixture
Table Account
Account
Assignment Amount
COEP 400000 CC100 100Archived CO line item
COEP 400000 CC100 100 CO line item
COSP 400000 CC100 200 CO total
BSEG 400000 100 GL line item
BSEG 400000 100Archived GL line item
GLT0 400000 200 GL total
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 €
GL Reporting on ACDOCA CO Reporting on ACDOCA

11. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 11CustomerEarly Knowledge Transfer
Migration ofAsset 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.

12. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 12CustomerEarly Knowledge Transfer
Example of Migration –Asset Accounting
Table Asset
Normal de-
preciation
Special
depr.
Unplanned
depr.
ANEP 4711 -40.000 € -5.000 €
ANEP 4712 -30.000 € -5.000 €
ANEP 4713 -23.000 € 3.000 €
Table Item KOART Amount
BSEG – GL line item001 S 100.000 €
BSEG – GL line item002 A -75.000 €
BSEG – GL line item003 A -25.000 €
Table
FI item
(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 A4711 7205 (normal depr.) -40.000 €A: Migrated FI-AA item
ACDOCA 000 A4711 7206 (special depr.) -5.000 €A: Migrated FI-AA item
ACDOCA 000 A4712 7205 (normal depr.) -30.000 €A: Migrated FI-AA item
ACDOCA 000 A47127207 (unplanned depr.) -5.000 €A: Migrated FI-AA item
ACDOCA 000 A4713 7205 (normal depr.) -23.000 €A: Migrated FI-AA item
ACDOCA 000 A47137207 (unplanned depr.) 3.000 € A: Migrated FI-AA item
ACDOCA 000 A 100.000 € R: Revert AA to get correct GL
FI document items and FI-AA line items before Simple Finance Migration:
After Simple Finance Migration:

13. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 13CustomerEarly Knowledge Transfer
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
BSEG 11000 0 GL lineitem
GLT0 11000 0 GL total
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
Asset 4711
-5.000 €
Account 11000 0 €
Asset 4712
-3.000 €
GL Reporting on ACDOCA FI-AA Reporting on ACDOCA

14. © 2016 SAP SE or an SAP affiliate company. All rights reserved. 14CustomerEarly Knowledge Transfer
© 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 seehttp://global12.sap.com/corporate-en/legal/copyright/index.epxfor 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.