0% found this document useful (0 votes)

313 views65 pages

Source Data For FI - Accounts Receivable Open Item

LTMC- Source data for FI - Accounts receivable open item

Uploaded by

sapficosvr

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

313 views65 pages

Source Data For FI - Accounts Receivable Open Item

LTMC- Source data for FI - Accounts receivable open item

Uploaded by

sapficosvr

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as XLSX, PDF, TXT or read online on Scribd

Introduction to Data Migration Templates

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 'Product', 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 currencies with more than 3 decimal places are not supported.

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: FI - Accounts receivable open item
Version S4CORE 106 - 14.03.2024 © Copyright SAP SE. All rights reserved.

Sheet Name Group Name Field Description Importance Type Length Decimal
Customer Open Items (mandatory)
Key Company Code mandatory for sheet Text 60
Reference Document Number mandatory for sheet Text 16
Line Item Number Number 6
Customer mandatory for sheet Text 80
Basic Data Alternative Reconciliation Account Text 80
Offsetting Account mandatory for sheet Text 80
Document Type mandatory for sheet Text 80
Special G/L Indicator Text 80
Document Date mandatory for sheet Date
Header Text Text 25
Item Text Text 50
Transaction Currency Currency Text 80
Amount Number 23 2
Company Code Currency Text 80
Currency Amount Number 23 2
Group Currency Currency Text 80
Amount Number 23 2
Freely Defined Currency Currency Text 80
Amount Number 23 2
Tax Tax Code Text 80
Business Place Text 80
Tax Reporting Date Date
Date for Defining Tax Rates Date
Payment Payment Terms Text 80
Baseline Date Date
Payment Method Text 80
Payment Block Text 80
Dunning Key Text 80
Dunning Block Text 80
Payment Reference Text 30
Payment - Discount Cash Discount Days 1 Number 3
Cash Discount Percentage 1 Number 5 3
Cash Discount Days 2 Number 3
Cash Discount Percentage 2 Number 5 3
Net Due Days Number 3
Amount Eligible for Cash Disc. (Doc.Cur) Number 23 2
Cash Discount Amount in Document Curr. Number 23 2
Payment - Bank Short Key for a House Bank Text 80
ID for Account Details Text 80
Partner Bank Type Text 80
Additional Details Credit Control Area Text 80
State Central Bank Indicator Text 80
Supplying Country/Region Text 80
Reference Key 1 Text 12
Reference Key 2 Text 12
Reference Key 3 Text 20
Assignment Profit Center Text 80
Functional Area Text 80
Cost Center (only for JVA) Text 80
WBS Element (only for JVA) Text 80
Billing Indicator (only for JVA) Text 80
Assignment Number Text 18

One-Time Account Data

Key Company Code mandatory for sheet Text 60
Reference Document Number mandatory for sheet Text 16
Line Item Number Number 6
Customer mandatory for sheet Text 80
Address Data Title Text 15
Name 1 mandatory for sheet Text 35
Name 2 Text 35
Name 3 Text 35
Name 4 Text 35
Street and House Number Text 35
Postal Code Text 10
City mandatory for sheet Text 35
Region (State, Province, County) Text 80
Country/Region Text 80
PO Box Text 10
P.O. Box Postal Code Text 10
Bank Account SWIFT/BIC for International Payments Text 11
IBAN (International Bank Account Number) Text 34
(OBSOLETE) Account Numb. of Bank Account Text 16
Bank Account Number Text 18
Bank Number Text 15
Bank Country/Region Key Text 3
Bank Control Key Text 2
BP Subject to Equalization Tax? Text 1
Instruction Key Text 80
Tax Tax Number 1 Text 16
Tax Number 2 Text 11
Tax

Tax Number 3 Text 18

Tax Number 4 Text 18
Liable for VAT Text 1

Deferred Tax Items

Key Company Code mandatory for sheet Text 60
Reference Document Number mandatory for sheet Text 16
Line Item Number Number 6
Customer mandatory for sheet Text 80
Number of Tax Line Item mandatory for sheet Number 3
Account Tax Account mandatory for sheet Text 80
Offsetting G/L Account mandatory for sheet Text 80
Tax Tax Code mandatory for sheet Text 80
Tax Jurisdiction Text 15
Transaction Currency Tax Base Amount Number 23 2
Tax Amount Number 23 2
Company Code Tax Base Amount Number 23 2
Currency Tax Amount Number 23 2
Group Currency Tax Base Amount Number 23 2
Tax Amount Number 23 2
Freely Defined Currency Tax Base Amount Number 23 2
Tax Amount Number 23 2

Withholding Tax Items

Key Company Code mandatory for sheet Text 60
Reference Document Number mandatory for sheet Text 16
Line Item Number Number 6
Customer mandatory for sheet Text 80
Withholding Tax Type mandatory for sheet Text 80
Tax Details Withholding Tax Code Text 80
Transaction Currency Withholding Tax Base Amount Number 23 2
Withholding Tax Amount entered manually Number 23 2
Withholding Tax Amount already withheld Number 23 2
Company Code Withholding Tax Base Amount Number 23 2
Currency Withholding Tax Amount entered manually Number 23 2
Withholding Tax Amount already withheld Number 23 2
Group Currency Withholding Tax Base Amount Number 23 2
Withholding Tax Amount entered manually Number 23 2
Withholding Tax Amount already withheld Number 23 2
Freely Defined Currency Withholding Tax Base Amount Number 23 2
Withholding Tax Amount entered manually Number 23 2
Withholding Tax Amount already withheld Number 23 2

Italy Specific
Key Company Code mandatory for sheet Text 60
Reference Document Number mandatory for sheet Text 16
Line Item Number Number 6
Customer mandatory for sheet Text 80
Local Fields for Italy CUP Code Text 15
CIG Code Text 10

Russia Specific
Key Company Code mandatory for sheet Text 60
Reference Document Number mandatory for sheet Text 16
Line Item Number Number 6
Customer mandatory for sheet Text 80
Local Fields for Russia Invoice External Number Text 50
Invoice External Date Date
Revision Invoice Number Text 10
Revision Invoice Date Date
Revision Number Number 3
Tax Reporting Date of Revision Document Date
Payment Order Number Text 30
Payment Order Date Date
Commission Trade: Incoming Invoice Numb. Text 50
Commission Trade: Incoming Invoice Date Date
Real Seller Code Text 80
Real Buyer Code Text 80

South Korea Specific

Key Company Code mandatory for sheet Text 60
Reference Document Number mandatory for sheet Text 16
Line Item Number Number 6
Customer mandatory for sheet Text 80
Local Fields for South Approval ID for Tax Invoice Text 27
Korea Transfer Date of Tax Invoice Date

Mexico Specific
Key Company Code mandatory for sheet Text 60
Reference Document Number mandatory for sheet Text 16
Line Item Number Number 6
Customer mandatory for sheet Text 80
Local Fields for Mexico UUID for Electronic Account on Header Text 36
UUID for Electronic Account on Line Item Text 36

Slovakia Specific
Key Company Code mandatory for sheet Text 60
Key
Reference Document Number mandatory for sheet Text 16
Line Item Number Number 6
Customer mandatory for sheet Text 80
Local Fields for Slovakia Reference Invoice Text 32
Source Data for Migration Object: FI - Accounts receivabl
Version S4CORE 106 - 14.03.2024 © Copyright SAP SE. All rights reserved.

Key
Company Code* Reference Document Number* Line Item Number

The company code is the smallest The reference document number may Note: This field will not be migrated. It will
INA1
organizational unit of Financial Accounting 1000005/2024
contain the document number of the just be using for migration as an additional
INA1 for which a complete self- Business Partner (Customer or Vendor)
1000006/2024 key field to

INA1 1000007/2024
INA1 1000008/2024
INA1 1000009/2024
INA1 1000004/ 2024
ounts receivable open item

Customer* Alternative Reconciliation Account Offsetting Account*

Customer account to be posted This field contains the number of the G/L The offsetting (transfer booking) accounts
1733774 account on which transaction figures are T900000000
which should be used in the migration.
updated. Note: Alternative Reconciliation The BH5 document describes the initial
1760999 Accounts must be predefined (more
T900000000
G/L offsetting accounts for Open Items
1764584 T900000000
1764585 T900000000
1764584 T900000000
1764585 T900000000
Basic Data
Document Type* Special G/L Indicator Document Date*

The document type classifies the With this indicator, you let the system The document date must be the same
IF
accounting documents, and is saved in the know that a special G/L transaction is to 30.06.2024
date as in the original data record
IF document header when you post a
document. Each document type is
be posted and which
30.04.2024
IF 30.06.2024
IF 30.05.2024
IF A 30.06.2024
IF A 30.06.2024
Transaction Currency
Header Text Item Text Currency

The document header text contains Contains an explanatory text on the line The currency in which a document is
Legacy upload
explanations or notes which apply to the Legacy upload item. INR posted.
document as a whole, that is, not
Legacy upload Legacy upload INR
Legacy upload Legacy upload INR
Legacy upload Legacy upload INR
Legacy upload Legacy upload INR
Legacy upload Legacy upload INR
Transaction Currency Company Code Currency
Amount Currency Amount

The value should be in correct number The currency which is defined for the The value should be in correct number
format. Be careful to set right50000.00
delimiter, INR company code. format. Be careful to set right50000.00
delimiter,
e.g. 1.000,50. The sign for negative values e.g. 1.000,50. The sign for
60000.00
must be put at the beginning, e.g. -
INR 60000.00
70000.00 INR 70000.00
50000.00 INR 50000.00
10000.00- INR 10000.00-
70000.00- INR 70000.00
Group Currency Freely Defined Currency
Currency Amount Currency

The currency which is defined as the The value should be in correct number The currency is used for parallel valuation.
group currency. format. Be careful to set right delimiter,
e.g. 1.000,50. The sign for negative values
must be put at the beginning, e.g. -
reely Defined Currency Tax
Amount Tax Code Business Place

The value should be in correct number The tax code represents a tax category An organizational unit below company
format. Be careful to set right delimiter, which must be taken into consideration code level that is primarily used for
e.g. 1.000,50. The sign for negative values when making a tax return to the reporting taxes on sales/purchases.
must be put at the beginning, e.g. -
Tax
Tax Reporting Date Date for Defining Tax Rates Payment Terms

Date on which the tax on sales and This field is significant when determining Key for defining payment terms composed
purchase tax is due, or the date on which tax rates. Immediate PT percentages and
of cash discount
that tax must be reported to the tax payment periods.
authority.
Payment
Baseline Date Payment Method Payment Block

Date to which the periods for the cash Payment method with which this item is to Specifies why a document is blocked for
discount deadline and the due date for net be paid. payment:
payment refer.
Dunning Key Dunning Block Payment Reference

A pre-defined procedure specifying how An indicator that (through the allocation of For customer items the payment reference
customers or vendors are dunned. a dunning block reason) enables you to is given a key that is sent to the customer
prevent (block) accounts and items from with the invoice. The customer should take
being dunned. the payment reference into account when
Payment - D
Cash Discount Days 1 Cash Discount Percentage 1 Cash Discount Days 2

Period within which a payment must be Cash discount percentage rate applied to Period within which a payment must be
made in order to take advantage of the the shortest payment period made in order to take advantage of the
first cash discount terms second cash discount terms
Payment - Discount
Cash Discount Percentage 2 Net Due Days Amount Eligible for Cash Disc. (Doc.Cur)

Cash discount percentage rate applied to Standard settlement period (in days) Part of the invoiced amount for which cash
the second payment period discount is granted. The amount is always
in document currency.
Payment - Bank
Cash Discount Amount in Document Curr. Short Key for a House Bank ID for Account Details

Note: "Cash discount" overrules the This key together with the ID for account This ID together with the key for the house
"Amount Eligible for Cash Discount", i.e. if details uniquely defines a bank account. bank uniquely defines a bank account.
both fields are supplied, "Cash discount" is
taken.
nk
Partner Bank Type Credit Control Area State Central Bank Indicator

To use a particular bank of the business The credit control area is an organizational Use Germany: In foreign payment
partner for the payment of an item, enter entity which grants and monitors a credit transactions, information concerning the
the appropriate key in the limit for customers. A reason for payment is needed for the
report according to German foreign trade
Additional Details
Supplying Country/Region Reference Key 1 Reference Key 2

Use Germany: This field contains the In this field, you can enter In this field, you can enter
country/region key of the purchasing Synergy / non-synergy
customer/supplier details for the customer/supplier details for the
country/region in the case of imports or accounting transaction. accounting transaction.
transits or that of the country/region of
Reference Key 3 Profit Center Functional Area

Reference key for line item. In this field, An organizational unit in Financial Structure criterion for an enterprise or
you can enter customer/supplier details for Equipment / Service
Accounting that reflects aPC)
management- government based on functional aspects.
the accounting transaction. oriented structure of the
1699
1699
1699
1699
1699
Assignment
Cost Center (only for JVA) WBS Element (only for JVA) Billing Indicator (only for JVA)

Key uniquely identifying a cost center. Individual structural element in a work The billing indicator is used to classify
breakdown structure (WBS) representing postings for customers and vendors for
the hierarchical organization Joint Venture accounting.
Assignment Number

The assignment number is an additional

(Customer PO no)field in the line item.
information reference
2
3
4
5
9
Source Data for Migration Object: FI - Accounts receivabl
Version S4CORE 106 - 14.03.2024 © Copyright SAP SE. All rights reserved.