Filetype Excel XLSX | Posted on 14 Aug 2022 | 4 years ago
Authentication
digital resources
365x Filetype XLSX File size 0.14 MB Source: usercontent.one
Introduction to Data Migration Templates
Version S4CORE 104 - 06.03.2021 © Copyright SAP SE. All rights reserved.
Overview
A migration template (Microsoft Excel XML Spreadsheet 2003 file) consists of different sheets which are visible at the bottom of the migration template. You use the
different sheets to specify the data that belongs to different data structures. For example the migration template for the migration object 'Material', contains a sheet
for basic data, a sheet for plant data, and so on. Some sheets are mandatory, and some are optional.
A migration template is based on the active view of the relevant migration object. You can find information about the active view in the Microsoft Excel XML file. In
the file, navigate to File -> Info. You can find the active view name under Properties -> Tags.
Prerequisites
In the Microsoft Excel XML Spreadsheet 2003 file, navigate to 'File' -> 'Options' -> 'Advanced'. Under the option 'When calculating this workbook:', ensure that the
option 'Set precision as displayed' is selected.
Information about File Sizes
SAP S/4HANA Cloud
If you are migrating data to SAP S/4HANA Cloud, the default size limit for each uploaded XML file is 100MB. If required, you can zip several files together. Note that
the combined size of all the XML files you want to add to the zip file must not exceed 160MB. The limit for zip file is still 100MB.
SAP S/4HANA On-Premise
If you are migrating data to SAP S/4HANA, the default size limit for each uploaded XML file is 100MB.
You can increase the size limit for each uploaded XML file to 160MB by changing the system parameter (icm/HTTP/max_request_size_KB). If required, you can zip
several files together. Note that the combined size of all the XML files you want to add to the zip file must not exceed 160MB. The limit for the zip file is still 160 MB
with the adjusted system parameter.
The Field List Sheet
The 'Field List' sheet is one of the first sheets in the migration template. You use this sheet to get an overview of the expected data in one central location.
It contains information about the mandatory and optional sheets, as well as detailed information for each sheet (for example the expected data type and length for
the fields in each sheet).
On the 'Field List' sheet, you can view the following information for each field in the migration template:
• The name of the sheet, and whether it is mandatory or optional. Only mandatory sheets have the suffix 'Mandatory', for example 'Basic Data (Mandatory)'. All
other sheets are optional.
Note:
You can quickly get an overview of the mandatory and optional sheets by looking at the color of the sheet names at the bottom of the migration template. The name
of the mandatory sheets have the color orange, while the optional sheets have the color blue.
• The group name for the fields in a sheet.
• The individual fields in each sheet, as well as whether fields are mandatory for a sheet.
• Information about the expected format of the individual fields, for example the data type and length.
Note:
In the field list sheet, certain technical information about the fields is hidden by default. The columns 'SAP Structure' and 'SAP Field' (columns 8 and 9) are hidden
by default. The column 'SAP Structure' is the technical name of the structure that the field belongs to. The column 'SAP Field' is the technical name of the field. To
unhide these columns, select the columns adjacent to either side of the columns that you want to unhide. Right-click your selection, and choose 'Unhide'.
If you want to extract data from SAP ERP, the technical name of structure and the technical name of the field often corresponds to the SAP ERP table name and
field name. Also, the SAP Release Note (2568909) for SAP S/4HANA Cloud data migration content uses the technical names of the structures and fields.
Working with Sheets
For each migration template, you need to specify data for the mandatory sheets, and for the optional sheets that are relevant for your project:
• Mandatory sheets (orange)
Mandatory sheets represent the minimum set of data you must provide for data migration. Fill in all mandatory fields.
• Optional sheets (blue)
Use optional sheets depending on your migration scope and available legacy data.
Viewing Additional Information for Each Column
In row 8, you can view the field names in SAP S/4HANA, as well as additional information such as the expected format (for example the data type and length). Note
that you must expand the row to view this additional information.
Some fields are mandatory, and some are optional. The wildcard character (‘*’) beside the name of a field indicates that the field is mandatory.
Note:
Although an optional sheet may contain mandatory columns, if the sheet is not relevant for your project, there is no need to fill the mandatory columns in the sheet
with data.
Note:
Rows 4, 5, and 6 are hidden by default. Row 4 is the technical name of the structure (corresponds to the sheet name). Row 5 is the technical name of the field
(corresponds to row 8 - the field description). Row 6 contains technical information such as the data type and length.
To unhide these rows, select the rows adjacent to either side of the rows that you want to unhide. Right-click your selection, and choose 'Unhide'.
Working with Different Data Types
You can view the data type for a field in row 8 (see 'Viewing Additional Information for Each Column' above). Depending on the field, one of the following data types
may be required:
• Text
Letters, numbers, and special characters are permitted. In the SAP S/4HANA migration cockpit, you can map the values of certain fields with the data type text
(usually those fields with Length: 80) to their correct SAP S/4HANA target values. You can do this value mapping in the SAP S/4HANA migration cockpit when you
start the transfer (in the step 'Convert Values').
• Number
Enter numbers with decimals in the relevant country-specific format, for example 12.34 (United States) or 12,34 (Germany). For fields with decimals, the declared
length includes decimals (if required), for example if the information for the column states: Length: 8, Decimals: 3, then a number such as 12345.678 is permitted.
Note that decimal places are not mandatory. In this example, you can specify a whole number up to length 8 without decimal places, for example ‘1’. This number
would be set to ‘1.000’ internally. For negative numbers, ensure that a minus sign ('-') directly precedes the number, for example '-100'.
Note that the maximum field length supported by Microsoft Excel is 15 digits (including decimals). If you have longer numbers, use the option for transferring data to
S/4HANA using staging tables.
• Date
Enter the date in your country-specific format, for example 12/31/1998 (United States) or 31.12.1998 (Germany). Note that Microsoft Excel automatically recognizes
different date formats and transforms them automatically to the correct XML format.
• Time
Enter the time in the format HH:MM:SS, for example 02:52:40
Copying Data to a Sheet
When copying data to a sheet from Microsoft Excel, always right-click the relevant cell and choose the paste option 'Values (V)'. Avoid pasting data that includes
formatting and formulas into the migration template, as this will corrupt the structure of the XML migration template.
Using the Find and Replace Function
Do not use the Microsoft Excel function 'Find and Replace'. If you change data by using this function, you may also unintentionally change the field names and
corrupt the structure of the XML migration template.
Saving the Migration Template
Ensure that you only save the migration template as a Microsoft Excel XML Spreadsheet 2003 file. Other file types are not supported by the SAP S/4HANA
migration cockpit.
Important Information
Do not make any changes to the structure of the migration template, specifically:
• Do not delete, rename or change the order of any sheet in the migration template.
• Do not change the formatting of any cells.
• Do not use formulas.
• Do not hide, remove, or change the order of any of the columns in the migration template.
Note:
Any changes to the sheets will result in a corrupted XML structure. Such modified migration templates are not supported by the SAP S/4HANA migration cockpit.
Field List for Migration Object: G/L account
Version S4CORE 104 - 06.03.2021 © Copyright SAP SE. All rights reserved.
Sheet Name Group Name Field Description Importance Type Length Decimal
General data (mandatory)
Key Chart of Account mandatory for sheet Text 80
G/L Account mandatory for sheet Text 80
Control in Chart of G/L Account Type mandatory for sheet Text 80
Account P&L Statement Account Type Text 80
G/L Account Group mandatory for sheet Text 80
Functional Area Text 80
Trading Partner Text 80
Group Account Number Text 80
Account Settings in Controlling Area Text 80
CO Area Cost Element Category Text 80
Valid from Date Date
Valid to Date Date
Company code data (mandatory)
Key Chart of Account mandatory for sheet Text 80
G/L Account mandatory for sheet Text 80
Company Code mandatory for sheet Text 80
Account Control Account Currency mandatory for sheet Text 80
Balances in Loc. Currency Only (Indic.) Text 1
Exchange Rate Difference Key Text 4
Valuation Group Text 10
Tax Category Text 80
Posting w/o Tax Allowed (Indicator) Text 1
Reconciliation Account (Indicator) Text 80
Alternative Account Text 80
Account Managed in External System Text 1
Inflation Key Text 80
Tolerance Group for G/L Accounts Text 4
Account Open Item Management (Indicator) Text 1
Management Clearing Specific to Ledger Groups Text 1
Sort Key Text 80
Authorization Group Text 4
Accounting Clerk Abbreviation Text 80
Multi Currency MCA Key Text 80
Accounting Recovery Indicator Text 80
Joint venture data in
company code
Control of document Field Status Group mandatory for sheet Text 80
creation Post Automatically Only (Indicator) Text 1
Supplement for Atuo.posting(Indicator) Text 1
Recon.Acc Ready for Input(Indicator) Text 1
Bank/financial Planning Level Text 80
details in company Relevant to Cash Flow Text 1
code
Commitment Item Text 14
House bank Text 80
Account ID Text 80
Interest calculation Interest indicator Text 80
infomation in Interest Calc. Frequency Text 80
company code
Key Date of Last Int.Calc. Date
Date of Last Interest Calc. Date
Account names (mandatory)
Key Chart of Account mandatory for sheet Text 80
G/L Account mandatory for sheet Text 80
Language Key mandatory for sheet Text 40
Description Short Text mandatory for sheet Text 20
Long Text Text 50
Account keywords
Key word Chart of Account mandatory for sheet Text 80
G/L Account mandatory for sheet Text 80
Language Key mandatory for sheet Text 40
Key Word for G/L Accounts mandatory for sheet Text 30
Source Data for Migration Object: G/L account
Version S4CORE 104 - 06.03.2021 © Copyright SAP SE. All rights reserved.
S_GENERAL
KTOPL SAKNR GLACCOUNT_TYPE
ETE;80;0;C;80;0 ETE;80;0;C;80;0 ETE;80;0;C;80;0
Key Control in Chart of Account
Chart of Account* G/L Account* G/L Account Type*
Type: Text The G/L account number identifies The general ledger account type
PPIN 10010000 X
Length: 80 the G/L account in a chart of determines how the general ledger
PPIN 10020000 accounts. Xaccount can be used in financial
PPIN 10090000 X accounting
Type: Text (FI) and controlling (CO).
PPIN 11001000 Length: 80 X
The following values are possible:
PPIN 11001010 X • X - Balance Sheet Account
PPIN 11001020 X Balance sheet account
• N - Nonoperating Expense or
Income Profit and loss account that
PPIN 11001030 X
is used in FI only
PPIN 11001040 X• P - Primary Costs or Revenue
Profit and loss account that is used
PPIN 11001045 X in FI and CO
PPIN 11001050 X• S - Secondary Costs Profit and
loss account that is used in CO
PPIN 11001056 X only
PPIN 11001060 X Type: Text
PPIN 11001070 X Length: 80
PPIN 11001080 X
PPIN 11001090 X
PPIN 11001091 X
PPIN 11001092 X
PPIN 11001099 X
PPIN 11001100 X
PPIN 11001200 X
PPIN 11002000 X
PPIN 11002010 X
PPIN 11002020 X
PPIN 11002030 X
PPIN 11002040 X
PPIN 11002045 X
PPIN 11002050 X
PPIN 11002060 X
PPIN 11002070 X
PPIN 11002080 X
PPIN 11002090 X
PPIN 11002091 X
PPIN 11002092 X
PPIN 11002099 X
PPIN 11008000 X
PPIN 11008030 X
PPIN 11008070 X
PPIN 11008099 X
PPIN 11999000 X
PPIN 11999030 X
no reviews yet
Please Login to review.
