Report SDFI_CONSISTENCY_CHECK was written as a comparison program between Billing and Accounting for the Audit Information System (AIS). The report can be executed by users who are assigned authorization role SAP_AUDITOR_BA_SD.
For each billing document and account, the program maps the differences between the billing document values and the accounting amounts. For each account, it maps the total of all billing document values and the total of all accounting amounts. You can use the differences to find billing documents where incorrect accounting amounts were posted. You can use totalling to check accounts to which incorrect amounts have been posted. The system takes the amounts into consideration for the differences and also for the totals in the document currency.
The user is responsible for the evaluation. To enable you to quickly find inconsistencies, the program offers you the option of displaying only billing documents that contain differences. As an additional aid, you can go directly to the billing document, and from there display the accounting documents. You cannot make changes to documents. Various filter functions and sort options make the evaluation easier.
Use
a) Selection
The selection screen enables you to select billing documents by document number, billing date, company code, and posting period with fiscal year.
The checkbox ‘Only Documents with Differences’ specifies whether the system also includes documents without errors in the results list.
The system does not check all entered billing documents, or billing documents determined using other selection fields. The program extracts from the selection only billing documents with ‘Accounting document created’ as the status for transmission to accounting. For technical reasons, down payment requests are ignored.
b) Results lists
From the billing documents, you choose ‘Execute’ (F8) and the program determines relevant accounting documents. The results are displayed in two lists; the difference list and the totals list. Both lists are displayed in tabular form on two tab pages with the titles ‘Differences’ for the difference table and ‘Totals’ for the totals table.
The difference table contains the following columns:
- Billing document
- Account
- Departure country (tax)
- Destination country
- Tax code
- Account key
- Billing document value
- Accounting amount
- Difference amount
- Currency
The fields for departure country, destination country, tax code, and account key are only filled for tax lines, because usually for SD documents the account for the taxes is only determined in FI. That is to say, they replace the account. The fields for billing document, account, departure country, destination country, tax code, account key, and currency combined produce the primary key for the table. This means that billing document values are cumulated according to these fields. The same applies for accounting amounts. Difference amounts represent differences between billing document values and their corresponding accounting amounts. They are determined using the following formula:
Difference amount = Billing doc. value – Accounting amount
If the accounting document is missing, even though the billing document status states that one was created, the system assumes an accounting amount of 0. This means that differences will always occur where the accounting document is missing.
From the difference table, you can double-click the line to go to the billing document. The totals table contains the following columns:
- Account
- Departure country (tax)
- Destination country
- Tax code
- Account key
- Billing document value
- Accounting amount
- Difference amount
- Currency
The fields for departure country, destination country, tax code, and account key are only filled for tax lines (see above). The fields for account, departure country, destination country, tax code, account key, and currency are the primary key for the table. The system determines the billing document values, accounting amounts, and difference amounts from the difference table, by cumulating the corresponding fields. Hence the name ‘Totals Table’. The ‘Only Documents with Differences’ indicator from the selection screen is not taken into account during this cumulation. This means that this table is always displayed, whether there are errors or not.
Because only totals are displayed, you cannot go to the individual billing documents.
c) Functions in the pushbutton toolbar for ALV control
- Billing Document: If you select a line containing a billing document, then choose this button, the system starts transaction VF03 and displays the billing document.
- Refresh: After changes (sort, filter, and so on), displays the original list.
- I or User Documentation: You can use this function to access the SAP List Viewer (ALV) Grid Control documentation.
