This blog is intended for project members responsible for implementing Central Finance. This blog explains the various options for Initial Load and the special Considerations for Initial Load along with pre-requisites.
What Is Initial load
: The initial load is used to transfer postings from a period, for example the current fiscal year, from your source systems to your Central Finance system.
Central Finance Splits the process of data Replication into 2 parts:
-
The first part is initial load -This step loads existing data only in the source system
-
The second part is the real time replication -This step replicates all newly created data and changes existing data in the source data.
Postings Excluded from Transfer :
Below postings cannot be transferred as part of the initial load and ongoing replication.
-
Postings to CO-FI reconciliation ledger (GL Reconciliation Postings).
-
Year-end closing postings where the reference transaction (AWTYP) is GLYEC
-
Clearings are not transferred as part of the initial load, but you can activate the transfer of clearings via ongoing replication. For more information see Handling of Open Items
-
Clearing resets are not transferred as part of the initial load but you can activate the transfer of clearing resets via ongoing replication. For more information see Handling of Open Items
-
Recurring entries
-
Sample documents
-
Noted items (apart from down payment requests and payment requests)
-
Parked documents
-
Balance carryforward items
-
Closing operations
Configuration in the source systems:
A. In the source system go to transaction SM30and call the view
VCFIN_SOURCE_SET
(or transaction
CFINIMG
, if it is available in your system).
In this activity, you make the settings necessary for both the initial load of data from your SAP ERP system to your Central Finance system and for the continued replication of this data once the initial load is complete. This activity is a prerequisite for transferring data from your system to Central Finance and is where you specify the company codes for which data is transferred
To transfer balances only:
In the “Start – Balances” field, fill fiscal year from which you want the system to start transfer balances.
To transfer documents only
: In the “Start – Documents” field, Fill the year from which you want the system to start transfer line items and in the “Period – Documents” field, fill the first period of that year.
Start – Balances
: field, fill the year from which you want the system to start transferring balances.
Start – Documents
: field, fill the year from which you want to start transferring documents.
Period – Documents
: field, provide first period of that year
Replicate GL reconciliation postings:
Select the GL Reconciliation Postings Transferred checkbox.
When the initial load has been completed:
Select the Initial Load Finished checkbox.
B. Empty Initial Load:
If you want to perform an empty initial load as part of a proof-of-concept, carry out the following steps. Make the following entries in the view VCFIN_SOURCE_SET.
-
Company Code – Enter the relevant company code
-
Start - Balances– Leave this field empty
-
Start - Documents– Choose a year in the future for which nothing has been posted so far
-
Period - Documents– Choose a period in the future for which nothing has been posted so far
-
Documents Period– Enter 12
-
Leave all other fields empty
Configuration in the Target system:
-
Choose Logical System:
In this Customizing activity, you choose the active logical source systems for the initial load. Central Finance uses the logical systems defined in this activity to upload data from the corresponding source systems. The initial load of financial postings (in contrast to the initial load of cost objects and CO postings) does not use SAP System Landscape Transformation Server to transfer data; instead the data is retrieved using RFC calls to the source system.
In addition, you can specify for each logical system which package size is used during the initial load.
2. Define Clearing and Substitution Accounts
In the first step of the initial load, all balances related to reconciliation accounts are transferred to their assigned substitution accounts. In a second step, open items are posted to the reconciliation accounts, while the offsetting entries are posted to the substitution account. Once the initial load is complete, the balances of the substitution accounts should automatically be zero.
In this activity, you define the migration clearing account and the substitution accounts to be used for postings during the initial load:
-
You must define one migration clearing account for each company code for which postings are to be loaded into the Central Finance system. While balances are being posted, this account is used for offsetting postings. Once the initial load is complete, the balance should automatically be zero.