In this blog we will discuss about the features, need and key aspects of the consistency check report in SAP Central Finance.
What is Consistency Check Report?
Consistency Check report helps in identifying the configuration inconsistencies between the source system & the Central Finance system before initial load is planned to be started or before documents are replicated from source to Central Finance system. This ensures that postings are transferred without errors.
It issues success messages as well as failure. It is advised to ignore successes as it puts performance load on system to display all data. Idea is to get errors and warnings and resolve the same so it make sense to just focus on errors.
System, transaction, timings & run frequency:
- System – SAP S/4HANA Central System
- Transaction – FINS_CFIN_CC
- Timings – Before initial load and after configurations, master data & mappings upload
- Frequency of Run – Multiple time. Run it, fix errors, re run in and keep on doing until all errors are resolved.
Components/Inputs
- Choose Action – Select Execute
- Source Logical System – Select the source system from which you need to run the initial load
- Check Group – Click on icon and window will come with objects (see screenshot). Select the objects for which you want to run the report. Please see next section for detail of each object
- Selection Criteria – select Company code for which initial load is planned
- Other Controls – ALWAYS check show errors and warnings only
Output format:
All errors highlighted should be resolved unless there is an exception based on business requirement or project design.
Select Group components:
- Currency
- GL Account – It checks whether the currency field is has same value for a mapped GL in both systems. Like source GL Account 11001 (currency USD) mapped to CFIN GL Account 11991 (currency EUR) will show error.
- Company Code – Checks the consistency of local currency & additional currencies for the company code between the source ECC system & the S/4HANA Central Finance system
- Decimal – It checks whether the currencies have same decimal settings in both source and Central Finance system
- Document Splitting
- Checks the consistency of document splitting activation between the source ECC system & the S/4HANA Central system
- GL Account
- This checks the consistency of open-item-management indicator for the G/L account between the source ECC system and the S/4HANA Central Finance system
- Multi Mapping
- SAP Central Finance supports N: 1 mapping for master data but not fully support for company codes. In summary N: 1 mapping of company codes is not allowed as it creates issue in cross company code posting. This check is to verify N: 1 mapping of company codes.
- Loans Management
- Central Payment does not supports Loans Management. This check ensures that in source system the Loans Management component FS-CML is not active.
- SEPA
- Checks the consistency of SEPA activation between the source ECC system & the S/4HANA Central system
- Value Added Tax
- Below checks are performed
| Company Code: Country |
| Company Code: VAT Registration Number |
| Company Code: Tax Jurisdiction Code |
| Company Code: Discount Base Amount is Net Value Indicator |
| Company Code: Tax Base Amount is Net of Discount Indicator |
| Company Code: Country ISO Code |
| Company Code: Country is European Union Member |
| Company Code: Country Tax Calculation Procedure |
| Company Code: Country Exchange Rate Type |
| Company Code: Length of First Part of the Tax Jurisdiction Code |
| Company Code: Length of Second Part of the Tax Jurisdiction Code |
| Company Code: Length of Third Part of the Tax Jurisdiction Code |
| Company Code: Length of Fourth Part of the Tax Jurisdiction Code |
| Company Code: External Tax System Active Indicator |
| Company Code: Determine Taxes Line-by-Line Indicator |
| Company Code: Re-determine Wrong Jurisdiction Code Indicator |
| Company Code: Plants Abroad Active |
| Company Code: Tax Base Amount Changeable Indicator |
| Company Code: Tax Conversion Local to Document Currency Indicator |
| Company Code: Extended WHT Active |
| Tax Code: Error Message for Invalid Tax Amount Indicator |
| Tax Code: Tax Type |
| Tax Code: Target Tax Code (for Deferred Tax) |
| Tax Code: EU Code |
| Tax Code: Tax Code for Sales Taxes Indicator |
| Tax Code: Tax Category When Using External Tax Systems |
| Tax Code: Relevant When Using External Tax System Indicator |
| Tax Code: Tax Reporting Country |
| Tax Code: New Deferred Tax Code Indicator |
| Tax Code: MOSS Tax Reporting Country for Electronic Service |
| Tax Code: Discount Base Amount is Net Value Indicator |
| Tax Code: Tax Base Amount is Net of Discount Indicator |
| Internal Processing Key: Tax Type |
| Internal Processing Key: Tax Not Deductible Indicator |
| Internal Processing Key: Posting Indicator |
| Internal Processing Key: Tax Not Relevant to Cash Discount Indicator |
- Withholding Tax
- Below checks are performed
| Exchange Rate Type |
| Unit to Which to Round To |
| For the time of invoice posting and payment posting the following checks are carried out: |
| Posting Time |
| Determines the posting time for withholding tax, such as invoice or payment. |
| Withholding Tax Type |
| Type of Withholding Tax Base Amount |
| Post Withholding Tax Amount |
| Rounding Rule |
| Accumulation Type |
| Determines how withholding tax is accumulated, for example no accumulation, per calendar year, quarter, month. |
| Accumulation Period |
| Combined Accumulation Indicator |
| Determines, whether several customers or suppliers and company codes are accumulated together. |
| Withhold Accumulation Withholding Tax to Maximum Indicator |
| Allow Manual Entry of Withholding Tax Base Amount Indicator |
| Allow Manual Entry of Withholding Tax Amount Indicator |
| Type Not Relevant for Certificate Numbering Indicator |
| Region (State, Province, County) |
| Maintenance of Minimum Withholding Tax Base Amount |
| Maintenance of Minimum/Maximum Withholding Tax Amount |
| For the time of invoice posting the following check is carried out: |
| Reduce Base Amount by Withholding Tax Amount Indicator |
| For the time of payment posting the following checks are carried out: |
| Central Invoice |
| Determines how withholding tax is distributed for central invoice. |
| Cash Discount Indicator |
| Determines, whether withholding tax is calculated before or after cash discount deduction. |
| Self-Withholding Possible |
| Withholding Tax Already Withheld Indicator |
| Enter Withholding Tax Amount Manually for Payments Indicator |
| Minimum Check at Document Level |
| Withholding Tax Code |
| Official Withholding Tax Key |
| Percentage Subject to Withholding Tax |
| Posting Indicator |
| Determines, whether for example this is a standard posting for withholding tax or the offsetting entry should be posted to the G/L account for grossing up. |
| Withholding Tax Rate |
| Reduced Withholding Tax Rate |
| Withholding Tax Rate Numerator (Part of a Fraction) |
| Withholding Tax Rate Denominator (Part of a Fraction) |
| Calculate Withholding Tax According to Formula Indicator |
| Region |
| Provincial Tax Code |
| Income Type |
| Reduced Withholding Tax Rate |
| Reduction of Base Amount |
| Decreased Reduction of Base Amount |
| Withholding Tax Code in Supplier Mater Record |
| Withholding Tax Code in Customer Master Record |
| Internal Processing Key |
| Withholding Tax Type Number on Which This Withholding Tax Type Depends |
| Minimum Withholding Tax Amount (During Posting) |
| Maximum Withholding Tax Amount (During Posting) |
| Minimum Withholding Tax Base Amount (During Posting) |
| Withholding Tax Base Exemption Amount |
| Assignment of Withholding Tax Type to Company Code |
| Type of Recipient |
| Indicator: Withholding Tax Agent |
| Obligated to Withhold Tax From |
| Determines the start date to withhold tax |
| Obligated to Withhold Tax Until |
| Determines the end date to withhold tax |
| Withholding Tax Identification Number |
| Indicator: Subject to Withholding Tax |
| Indicator: Self-Withholding Tax Agent |
| Exemption Certificate Number |
| Exemption Rate |
| Date on Which Exemption Begins |
| Date on Which Exemption Ends |
| Reason for Exemption |
| Extended Withholding Tax Active |
| G/L Account for Withholding Tax to be Paid Over (Debit) |
| G/L Account for Withholding Tax to be Paid Over (Credit) |
| G/L Account for Withholding Tax for Grossing Up Offsetting Entry (Debit) |
| G/L Account for Withholding Tax for Grossing Up Offsetting Entry (Credit) |
| G/L Account for Self-Withholding Tax (Debit) |
| G/L Account for Self-Withholding Tax (Credit) |
| G/L Account for Withholding Tax Offsetting Entry (Debit) |
| G/L Account for Withholding Tax Offsetting Entry (Credit) |
| Withholding Tax Certificate Numbering Concept |
| Country Key |
| Company Code |
- Account Category
- Account Type – Checks the consistency of account type B/S, P/L & Primary Cost Element between the systems
- Cost Object Controlling data
- Checks the statistical Order indicator between systems for a cost object
- Checks the Integrated Planning Order indicator between systems for a cost object
- Profit Centre Assignment
- Checks the Profit Centre assignment to the cost centre between systems
- Profitability Analysis
- Checks the consistency of CO-PA characteristics between systems
Hope it gives fair idea about this check which is very important for any Central Finance project during execution phase
Happy reading…
Okumaya devam et...