Table of contents
1 Objective and Scope
1.1 Objective of this Procedure
2 Scope
3 Responsibilities:
4 Performing the FI-AA check
4.1.1 When the check should be done:
5 Operating Process
5.1 Procedure applied to WP1 companies
5.1.1 Manual check with excel file support:
5.1.2 FI-AA check by transaction Z1F_CHECK_FIAA in WP1 system
5.2 Procedure applied to PF1 companies

5.2.1 Manual check between FI-AA

Objective and Scope

Objective of this Procedure

The purpose of this document is to describe the process to perform the completeness and reliability check between FI and AA Accounting.

Scope

This operating procedure (OP) applies to PF2 and WP2 environments, concerning all companies migrated in SBS Finance Service Line.

Responsibilities:

This check has to be done by SU MAC members.

Performing the FI-AA check

When the check should be done:

This check should be done as final step of the AA-closure, after depreciation posting, last settlement of WBS for investment and ASKB.
To keep up the reliability of the information, this comparison check should be reviewed after any changes in the AA module.

Operating Process

Procedure applied to WP2 companies

The differences between FI and FI-AA for WP2 companies are analyzed by two methods: Manual check is performed with an excel file support and automatically, by transaction Z1F_CHECK_FIAA.

Manual check with excel file support:

This check is done with the support of an excel file "FI AA Check". Where a sheet with "Instructions" is foreseen to help in the check performance.

You will find the WP2 FI-AA check file template in AODOCS.

There are several reports that need to be extracted from AA and FI module:

• • AA module: The data is extracted from the reports AR02 (Asset history sheet) and S_ALR_87012052 (Asset retirements).

When retrieving the data from the AA module ensure that you are using the proper Depreciation Area:

Please note that for DE companies, the depreciation area 49 should be replaced by DA48.

1) ABST2

Go to transaction ABST2, insert company code and run. 

The outcome should be green, otherwise, run transaction ASKB.

Insert a screenshot in sheet "ABST2". 

2) Tab Extract

AR02

Update the green cells:

Date of report: Last day of the closing month
Company code: update accordingly
Select "Extract AR02"
NOTE: Please make sure that the first SAP window opened is WP2

After running the macro, Excel will replace information in three sheets: DA 15, DA 49 and D32

Note: Please do not delete sheets DA15, DA49 and DA32.

Replace the dots with nothing/space as the numbers in sheets DA14, DA49 and D32 should have the format as above.

Balance Sheet

Green cells should be updated accordingly:
Company code
Fiscal Year
Closing Period: only month we are closing
Select "Extract BS sheet"

Confirm if the sheet "BS" was correctly filled.
Replace the dots with nothing/space as the numbers in sheets.

NOTE: If having problems using the macro extract manually AR02 and the Balance sheet.

3) Control Asset Depreciation

This sheet compares the information in FI and AA for depreciation, impairments, retirements, and asset sales: 

If there are values on accounts 98671010 or 98673010 please proceed with the retirement check, as follows:

Company code: update accordingly
Depreciation area 15 / 49
Posting date first day of the year to last day of closing month
Transaction type 210 and 260

After execution select layout /8090

Insert the amount of the column "Retirement revenue" in the Excel

NOTE: Check if there are no controls or delta, if needed correct them or justify accordingly.

FI-AA check by transaction Z1F_CHECK_FIAA in WP2 system

The differences between FI and FI-AA for WP1 companies are analyzed by two methods: Manual check is performed with an excel file support and automatically, by transaction Z1F_CHECK_FIAA.

A developed transaction is now available in WP2 system. This transaction gives us automatically the result of the congruence of FI-AA.
Transaction: Z1F_CHECK_FIAA

Execute transaction


You will get the following result:

The automatic FI-AA check in column "Difference"
In this case there is no difference between FI and AA.

Copy both extraction to sheets "Check - DA15" and "Check - DA49", to the right side. On the left, there is Balance Sheet information. 

Please make sure that there is no amount in the Control field. 

Procedure applied to PF2 companies

Manual check with excel file support:

This check is done with the support of an excel file "CCCC Check FI-AA MM.YYYY". 

You will find the PF2 FI-AA check file template in AODOCS.

When retrieving the data from the AA module ensure that you are using the proper Depreciation Area:

To perform the check through the file start with sheet "GS03" and follow the instructions as image bellow

When the macro stops running you should check sheet "Historical" to check if there is any difference.

Check if there is any difference for the Dep. for year check and for the Curr.bk.value. check. 

If there is a difference you should go to ASKB transaction and run it again.

If no difference you can proceed to the automatic check through transaction Z1F_CHECK_FIAA

To perform the check please fill in as follows:

If the check is for a DE (German) company please fill in as follows:

Click in execute

You will find the automatic FI-AA check in column "Difference"

In this case there is no difference between FI and AA.

Take a screenshot as the one above and copy it in to the file in sheet "SAP. Check FI AA DA50".

Afterwards it's needed to proceed with the same check for the Shares DA91

You will get the following result:

You will find the automatic FI-AA check in column "Difference"

In this case there is no difference between FI and AA.

Take a screenshot as the one above and copy it in to the file in sheet "SAP. Check FI AA DA91".

The check is finished for FI AA PF2, and you soul archive the file in AODOCS library in the designated file.