Ansicht
Dokumentation

Enhancements / Changes in Reporting ( RELNSAP_CONS_46C_REPORT )

Enhancements / Changes in Reporting ( RELNSAP_CONS_46C_REPORT )

Fill RESBD Structure from EBP Component Structure   RFUMSV00 - Advance Return for Tax on Sales/Purchases  
This documentation is copyright by SAP AG.
SAP E-Book

Short text

Enhancements / Changes in Reporting

Use

Filters in the list processor

In the standard list of the consolidation programs (for example flexible upload, currency translation, reclassifications, interunit elimination, consolidation of investment and others), a filter function is now available. This allows you to limit the list output interactively to entries, whose characteristics and key figures are in a freely selectable range of values. In this way lists with large datasets can be formed flexibly, according to certain criteria, and evaluated.
For example in the account balances of interunit elimination, the filter function can be used to only display the entries, in which the elimination differences exceeds a certain value. This can be very useful for the reconciliation of elimination differences in consolidation groups, where a large number of business relationships are to be eliminated.

Using ALV for additional financial data

The list output of additional financial data now uses a new list technique. The following reports are affected:

  • Inventory data
  • Supplier data
  • Investments
  • Equity
  • Goodwill
  • Equity holding adjustments
  • Changes to fair value adjustments

You can now adapt these reports to your requirements, that means above all showing and hiding fields or sorting according to certain criteria and/or forming subtotals. You can save the defined display variants generally or user-specific. In earlier releases, some of the above named reports were subdivided into several sub-reports with different field sequence and sort order. This function now covers standard display variants.

Using ALV for document evaluation

The report for document evaluation now uses the ALV list technique. Customizing is now two-step:

  • As in earlier releases you can define list layouts in the IMG and/or reuse layouts which are already defined. The less characteristics, texts on characteristics and key figures you select here, the better the perfomance of the report is.
  • In addition it is now possible, to modify the distributed lists further. You can save changes in the field sequence, selection or sort order generally or user-specific.

Reconciliation report FI documents / SAP Consolidation documents

In the area integration of consolidation, a reconciliation program is now available, that compares the document balances with each other in a consolidation processing ledger and in the general ledger. In this way a very detailed analysis of the local currency differences and their possible causes can be executed. You find this function in the consolidation application menu under Informations System/ Reports on Consolidation/ Integration/ Reconciliation Cons Processing Ledger/ Documents with General Ledger.
The programm knows two types of execution: Before the reconciliation run, the document volumes contained in the selection can be determined. The document numbers of the documents posted in Financial Accounting and Consolidation are displayed.

  • During the reconciliation run, the documents contained in the selection from Financial Accounting and Consolidation are matched and the values in local currency per consolidation item are compared with each other.

With both types of execution, the results can be exported in a file to the presentation or application server.
In ideal circumstances during the reconciliation run, every document from Financial Accounting contained in the selection is matched with a consolidation document (and vice versa), and the values in local currency per consolidation item match. As a basis, the system tries to use the local currency (or parallel local currency) of the company code, which agrees with the local currency of the integrated consolidation unit and the valuation of the globally set consolidation processing ledger in currency key and valuation.
Variances on these ideal circumstances lead to the following irregularities, which the program analyzes:

  • No Consolidation document was found for a given Financial Accounting document.
  • Several Consolidation documents were found for a given Financial Accounting document.
  • For a given Financial Accounting document, the balance per consolidation item, to which is posted, is equal to zero.
  • No Financial Accounting document was found for a given Consolidation document.
  • Several Financial Accounting documents were found for a given Consolidation document.
  • A Consolidation document shows a balance equal to zero in local currency.
  • A difference exists between the local currency balances posted in the Consolidation document and in the Financial Accounting document.






General Material Data   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 5475 Date: 20240520 Time: 230342     sap01-206 ( 111 ms )