FI-CA serves as a subledger as well as an integrator of accounting data that originates for the most part from various upstream applications and systems. These applications transfer their posting data to FI-CA for further processing. Instead of individually posting each document created in the subledger to the general ledger and controlling, totals records are transferred. This summarization technique greatly reduces the volume of postings in the general ledger and results in a tremendous performance advantage.
The summarization with other items can be avoided by using the Single Document indicator. If this indicator is set when posting a FI-CA document, a separate item is created in the transfer record for general ledger accounting.
You can use posting area 0100 to determine the document type of the FI-GL document, which is automatically created during the FI-GL transfer (transaction FPG1). Furthermore, you can determine the debit and credit posting key of the FI-GL document as well as the default segment for the segment reporting.
The totals records are saved in the DFKKSUM* tables.
Various business processes create a reconciliation key automatically. The reconciliation key is identified by the current day in the business year, which is derived from the creation date and the run ID or the name of the process.
Reconciliation keys that have been created automatically are closed automatically at the end of the process.
The system can also propose reconciliation keys for manual business transactions (cash desk or manual posting). To do this, reconciliation groups for default values must be maintained in customizing. These reconciliation keys can be accepted or overwritten. You must close them manually before transfer to the general ledger.
The reconciliation key can be structured for a user group specifically for manual online postings. User-dependent and user-independent reconciliation keys can also be proposed for origin keys stored in customizing.
You can use event 1113 to generate default values for the reconciliation key.
During mass closing (transaction FPG4), the system closes all keys that are not reserved for a specific group of postings, such as postings for a payment run or a payment lot or returns lot.
In addition to this, reconciliation keys that are reserved for posting invoicing documents from SD are also closed.
If necessary, you can also delete reconciliation keys that have been created but are not used. To do this, select the Delete Unused Open Keys or Delete Unused Closed Keys parameter.
You can use the RFKKABS30 Document Itemization report to select all FI-CA documents posted under a reconciliation key. The totals records are displayed together with all linked FI-CA items.
You must close reconciliation keys to be able to transfer totals records to the general ledger.
You can use transaction FB03 to display the FI document which is automatically created during the totals record transfer. On the initial screen, choose Document List and enter reference transaction FKKSU and the reconciliation key followed by * in the selection parameters.
You should regularly check the totals record transfer for the following issues:
Reconciliation differences between subledger and general ledger
Technical issues like database problems or termination of mass processes
You can use the following reports to execute the checks (overview):
RFKKABS1 Totals Records Reconciliation in FI-CA
RFKKGL20 Totals Records Reconciliation in FI
RFKKGL30 Totals Records Items Audit in FI
RFKKABS8 Totals Records Restructuring
RFKKGL00 Totals Records Transfer
RFKKOP04 Open Item List in FI-CA
Documents in a reconciliation key are cumulated according to posting date and general ledger account.
Transferring totals records with a different posting date creates different FI documents in the general ledger for each posting date.
The reconciliation key is transferred according to the key date. If the reconciliation key contains documents with posting dates in the future, then the reconciliation key is only partially transferred to general ledger accounting on the key date. The rest of the key is transferred if the future posting date is earlier than or the same as the transfer date.
If the number of lines in the general ledger document exceeds the maximum number of document lines allowed in financial accounting, the document is split and an additional document is created.
The required zero balance is posted via a transfer account.
You can use the RFKKGL00 report to transfer the totals records accumulated in the reconciliation keys to the general ledger.
You can use the RFKKGL20 report to reconcile FI-CA and the general ledger. The program reads the documents that were posted in FI-GL as a result of the FI-CA totals records transfer. The documents are then compared with the FI-CA totals records. Differences are displayed in color and marked with a red light. You can select the corresponding menu option from the output list to correct any differences that occurred (for example, if posting was terminated) and that you were not able to post subsequently. If you select the Correction Run indicator, the system corrects the differences automatically in background processing.
You can use the RFKKABS1 report to reconcile inside FI-CA. The program checks whether the FI-CA postings totals match the totals of the associated FI-CA documents and that the balance of the FI-CA documents is zero. Any discrepancies between the posting totals and the FI-CA documents are displayed. The differences can be corrected online or in background processing. If FI-CA documents do not have a balance of zero, the corresponding document numbers and reconciliation keys are output. These reconciliation keys cannot be exported and cannot be corrected automatically.
You can use the RFKKOP04 report to generate a key-date-specific list of all open items in FI-CA. You can use the report during your closing operations (monthly, quarterly, yearly) or for reconciliation purposes.
You can use the RFKKGL30 report to display the FI-CA documents that have been transferred to the general ledger as totals records. The general ledger documents are read according to the selection criteria. The corresponding totals records and document lines from FI-CA are selected and sorted.
You can use the RFKKGL30 report therefore to ensure that all FI-CA documents can be audited. This means that you can determine and display the FI-CA items and documents for a general ledger transfer document at any time. A general ledger document can be explained by the items in the subledger at any given point in time.
You can use the RFKKABS6 report to reconcile the general ledger accounts. The program outputs postings that were transferred to the general ledger. The postings are displayed as a balance overview or as line items with the corresponding posting date and, if available, an alternative posting date.
You can use the RFKKOP10 report to reconcile the current balance for all reconciliation accounts or the reconciliation accounts specified, as well as clearing accounts. The following balances are calculated:
Balance of current open items in FI-CA
Balance of current reconciliation accounts in FI-CA and FI-GL
Balance of reconciliation keys in FI-CA that have not yet been transferred
Balance of adjustment totals records in FI-CA that have not yet been transferred
