KE5T differences. Root causes, possible ways of resolving the issue

KE5T differences. Root causes, possible ways of resolving the issue
 

Case 1. Due to program error:

One of the possible cases of KE5T differences is that open items weren’t distributed during the balance sheet adjustment (transaction F.5D), and these items are, so to say, ‘stuck’ in RF048 table. After running F.5D, open items in RF048 table should be displayed in field BLGCHR with indicator ‘T’. But due to program error, there can be cases, when documents are stored with ‘S’ indicator, because of which you might be having differences in KE5T report.

Here is the list of such documents, that can be accessed via program, for instances, FIUT_180_APAR  in testing mode:

If you go to RF048 and fetch any of listed documents, you will see that they are having ‘S’ stored in BLGCHR:

In order to fix those ‘stuck’ items, you need to run corrective program FIUT_180_APAR . Or SAP released very recent version of corrective program with OSS note 2156474, which is FIUT_180_PP. By using any of those program, we’re fixing values of  BFO*_A/AB  tables after BSA posting.

So the procedure here is as following:

      (1)  Before running PEC programs, execute FIUT_180_APAR  or FIUT_180_PP;

      (2) Proceed with PEC programs F.05, F.5D, F.5E, 1KEK.

Suppose, you are having differences in May, which is already closed. And you don’t want to open the period, reverse BSA postings and re-execute F.5D and 1KEK for the period, then you just simply run corrective program in June, before running PEC programs. So that in cumulative May- June KE5T report, differences will be cleared. 

Case 1.1: Program error, cont’d 

There are cases when RF048-BLGHR=’S’ for open items, after BSA postings, is correct (explanation is in OSS 1617868).  Program FIUT_180_PP, released with OSS 2156474 is valid only for partial payments with invoice reference.

When checking RF048, you need to check if open items are having without invoice reference. If yes, then they will be fixed with FIUT_180_PP. If no, and they are profit center assigned, for this reason they get RF048-BLGCHR = S.

With quite recent OSS 2188136 SAP has released some small corrections to corrective FIUT_180_APAR  program.

So the procedure here will be as following:

     (1) Before running PEC programs, execute FIUT_180_APAR  AND FIUT_180_PP;

     (2) Proceed with PEC programs F.05, F.5D, F.5E, 1KEK. 

   

Case 2: Reconciliation accounts maintained in 3KEH/3KEI

Starting from Release 4.0, reconciliation accounts shouldn’t be maintained in 3KEH/3KEI tables, otherwise Transaction 1KEKdoes not transfer any values for these accounts. This creates differences between reconciliation and valuation account in KE5T report.

Suppose reconciliation accounts maintained in trx. 3KEH. Therefore the data are being updated online on this account in PCA -  with origin 35. Trx. 1KEK does not consider the accounts assigned in trx. 3KEH,
means no transfer into PCA is done for these accounts.  Let’s consider two scenarios:

(1)    difference is coming from previous fiscal year, which is already closed. In this case procedure should be as following:

-          first of all, delete reconciliation account from 3KEH and 3KEI;

-          delete all the data posted for reconciliation account with origin 35 from affected company code from PCA.

Delete the data by report RPCA_DEL_BUKRS using these selection criteria:
Controlling Area                XXXX
Company Code                  XXXX
Profit Center                                                 to
Account Number                  XXXXXX             to
Origin object                   35
Transaction
Record Type                     0
Depreciation area
                                Plan Version
Posting period                    XX, XX (firstly  XX, then XX)
Fiscal Year                     XXXX
- x test run (first in test run)
- x log
(OSS note  1174360 for more information).

-          In order to clear the difference in period 12 and balance carryforward, you have no to run trx. 1KEK for period 12;

-          Run 2KES for current fiscal year to correct the opening balance in PCA;

-          Then re-execute 1KEK for periods affected.

(2)    differences that occurred due to 3KEH/3KEI in current fiscal year:

-          delete reconciliation account from 3KEH and 3KEI;

-          delete all the data posted for reconciliation account with origin 35 from affected company code from PCA.

Delete the data by report RPCA_DEL_BUKRS using these selection criteria:
Controlling Area                XXXX
Company Code                  XXXX
Profit Center                                                 to
Account Number                  XXXXXX             to
Origin object                   35
Transaction
Record Type                     0
Depreciation area
                                Plan Version
Posting period                    XX, XX (firstly  XX, then XX)
Fiscal Year                     XXXX
- x test run (first in test run)
- x log
(OSS note  1174360 for more information).

-          Re-execute 1KEK for periods affected.