SAP Central Finance - Pre-Initial Load activities |Checks, Mapping Test & Consistency Check

[nitin_gupta10]

This is the blog in continuation with Blog -1 – Introduction to Initial Load.

In this blog I will detail out some necessary activities which needs to be carried out before the initial load. Initial Load execution is the final step before which all preparation steps needs to be executed.

Here I am listing out some key activities. Please note that these activities are reflection of some standard steps and in case of a customer scenario where lot o custom tables and programs are built then this needs to be updated based on the enhancements in scope.

I will discuss about:

• Configuration Checks


• Master Data Checks


• Mapping Test/Checks


• Consistency Report

Configuration Checks:

This step asks for checking the basic configuration of the system in terms of configuration, RFC connectivity, periods opening and some key steps which are common and standard. Of course any Z steps/check needs to be performed based on need

Sr. No.	Activity	Transaction
1	Standard SAP configuration checks	SPRO
2	Logical systems defined and RFC connections test	SM59
3	Exchange Rate type are maintained	OBBS
4	Exchange Rates are maintained	OB08
5	Posting periods are Open	OB52
6	Company code clearing accounts are maintained	OBYA
7	Exchange rates difference accounts are maintained	OB09
8	Special GL defined for all account type and special GL indicator	FBKP
9	Any custom table(s) update	*Z*

 

Master Data Checks:

• Master Data Loads are Complete for:
  
  
  
  • Vendors
  
  
  • Customers
  
  
  • Materials
  
  
  • General Ledger Accounts
  
  
  • Cost Centre
  
  
  • Profit Centre
  
  
  • Plants
  
  
  • Trading Partner
  
  
  • Payment Terms
  
  
  • Any other master data….
  
  
  
  

Mapping Checks:

Mappings can be uploaded via transaction - FINS_CFIN_MAP_MANAGE in SAP Central Finance system

• Check Configuration settings for mapping via report - FINS_CFIN_MAPPING_STRUC


• Master Data mapping check


• Check mapping for single values


• Checks related to the mappings BAdIs if any is active

Also, if you want to be sure for particular data value you need not to run the whole data loads and apply filter rather you can use below standard program:

SE38 > RFINS_CFIN_MDG_MAPPING_TEST



Enter details



This will give the mapping result of the selected object.

Consistency Report Check:

This is one of the very important report before you start the initial load. This needs to be considered to run for several times and all errors in the report needs to be planned to be resolved.

• Transaction Code – FINS_CFIN_CC


• System – SAP S/4HANA Central Finance system

This is the initial screen which needs input:

• Company code(s)


• Source system


• Click on show errors and warnings only else whole data load will come and it impacts system performance


• Select the object which you need to check. Ideally it should be done for all.

I will explain each component of this report check – CLICK HERE!!!

Example of errors:



Keep on error resolution and running this again until all errors are cleared.

These are the key activities which needs to be planned before initial load planning and execution. Hope it helps you to understand what is needed to do before Initial Load and it’s quite a lot of work.

Next blog - Initial Load planning & Sequencing

Stay tuned, enjoy reading and let me know if you want any topic to be added.