SAP ABAP FI/CO Reconciliation in Company Code Currency Report

Reconciliation in Company Code Currency Report of SAP ABAP provides an overview of the reconciliation postings necessary to ensure that FI and CO postings made across company codes, business areas, and functional areas within the selected company code have been recorded to the
General Ledger (G/L), both on a period and a fiscal year-to-date basis. The company code currency is used for this reconciliation.

The accounting department uses this report to ensure that financial and controlling transactions reconcile for CO postings that occur across company codes, business areas, and functional areas. Since cross-company code postings affect financial statements, this report monitors the expected reconciliation postings based on CO data, and the reconciliation postings made to FI.

You must enter a value in the selection fields before running this report. You may leave the company code selection blank, and obtain a list that contains values for all company codes for which reconciliation postings have been made. If you choose to use a group of company codes, you must first create a set that contains them in order to access Report Painter/Report Writer reports.

You can run a context-sensitive actual line item report from this reconciliation ledger report. For example, when positioning the cursor on a cell, only the line items that make up the cell total will appear. The actual line items for a reconciliation ledger report can be executed for either one cell, or a range of cells.

By double-clicking on any subtotals in the report, the amount of detail that makes up the subtotal can either be hidden or displayed. For example, double-clicking on a cost element summary line will hide the debit/credit detail. To display this detail again, double-click on this line again.

This report contains data obtained from postings to the reconciliation ledger. This is a fixed special ledger to which postings are made when CO transactions span company codes, business areas, and functional areas. As such, the data cannot be changed or manipulated from the report.
The report contains two different blocks of data, as shown below. By navigating around these blocks, different types of reconciliation ledger data can be viewed.

To access the first screen for this sap abap report, choose Information systems → Accounting → Overhead costs and then, Cost elements → Report selection.

From the reporting tree, choose the following report: Reconciliation CO/FI → In company code currency → CO/FI Reconciliation in CCde Crcy.

1. Enter 1997 in Fiscal year. This report runs for only one fiscal year at a time.

2. Enter 1 in Period. This report shows the reconciliation postings for the company code in the selected period.
In addition, the report shows a cumulative value of the reconciliation postings from period 1 through the selected period.

3. Enter 3000 in Or value(s). You may also enter a range of company codes, or a company code group.

4. Choose Execute.
As the report begins to run, a threshold value determines how detailed the output will be.

5. Choose Enter.

This screen shows the reconciliation accounts to which postings will be made from the reconciliation ledger. For primary cost elements, the system uses the same account. For secondary cost elements, the system determines the reconciliation account based on its configuration.

A CO postings to the reconciliation ledger
B FI postings to expense accounts
C Variance between the CO and FI postings
D Entries to the reconciliation ledger that have been made to FI (no values because the period-end process has not been executed)

6. Double-click on the reconciliation account to reveal its field text.

This screen shows the original data that generated the variance between CO and FI, and which posts to the G/L from the reconciliation ledger.

7. Choose Next columns.

This screen shows a cumulative view of the same data. Since the selected period is also period 1, the values are the same.

8. Choose Previous columns to navigate to the first block of data displayed in the report.

Related Posts:

SAP ABAP FICO report about profitability analysis
SAP ABAP fico report profitability analysis report
My sapcrm customers and consumer segmentation
Organizational challenges in crm and mysap solutions
Business View and
What is SAP R/3 introduction to

No comments :

Post a Comment