FI_PCA Reconciliation

1. 
   
   FI and PCA Reconciliation:
   

 

1. Discrepancies in these two reports (2KEE & ke5z) in case there are multiple SAP instances and you are using PCROLL to transfer PCA Amounts to the central SAP system. 2KEE report is based on GLPCA Table and KE5Z is based on GLPCT Table. If you have PCROLL IDOCS then they only update the GLPCT Table and not the GLPCA Table. Hence, causing the discrepancy.
   

Tcodes	Description
2KEE	Records from table GLPCT
KE5Z	Records from table GLPCA
FS10N
1KEK	Periodic data transfer program
S_ALR_87009822
GLPCT	2KEE
GLPCA	KE5Z
KE5T	Shows differences between FI-GL and PCA on the AR and AP reconciliation accounts.
2KES	Comparison Ledger update in period 0

 

1. 2KEE: Report 2KEE fetches data from table GLPCT. This report reconcile with FI only if we take it from period 00. SAP note 180906
   
2. KE5Z: Takes data from table GLPCA. GLPCA gets updated with actual line items (OI)when we run 1KEK
   
3. F.5D: At month end we run F.5D. F.5D make profit centre posting for customer / vendor. This is not done when Vendor invoice is posted. Vendor Invoice posting to CC, which make posting to PC for the expense a/c. But no posting to PC for amount credited to vendor. This single entry posting is made by F.5D. This update Table BFOD_A or BFOK_A as the case may be
   
4. 1KEK: This is a periodic data transfer program. Run at month end. It transfers data from table BFOD_A or BFOK_A to Profit centre ledger 8A.
   
5. In period 0 we run balance carried forward program (2KES) in PCA. The last year balances get's updated only in table GLPCT. Thus in period 0 there is balance in GLPCT (2KEE) but no balance in GLPCA (KE5Z).
   
6. In period 1, there is an open item balance in AP a/c of 800. Now when 1KEK is run to transfer balance from FI to PCA, Table GLPCA is updated with 800. But table GLPCT (2K3EE) is updated using delta technique. GLPCT is updated with (Current FI ending balance - Previous periods GLPCT balances). So if I have to reconcile FI with PCA (2KEE) in period 1 PCA total will be (GLPCT Period 0 + GLPCT period 1) = ( 600 + 200 ) = 800
   
7. Report 2KEE fetches data from table GLPCT. Whereas report KE5Z fetches data from table GLPCA. Please find below an illustration on FI & PCA reconciliation logic:
   

Period	FI Balances	GLPCA (KE5Z)	GLPCT (2KEE)
0	600	0	600
1	800	800	200
2	100	100	-700
3	0	0	100

 

1. In period 0 we run balance carried forward program (2KES) in PCA. The last year balances get updated only in table GLPCT. Thus in period 0 there is balance in GLPCT (600) but no balance in GLPCA (KE5Z). In period 1, there is open item balance in FI (800). Now when 1KEK is run table GLPCA (KE5Z) is updated with 800 but table GLPCT (2KEE) is updated using delta technique. GLPCT is updated with (Current FI ending balance - Previous periods GLPCT balances). So if I have to reconcile FI with PCA (2KEE) in period 1 PCA total will be (GLPCT Period 0 + GLPCT period 1) = (600 + 200) = 800.
   
2. Table GLPCT always has period 16. Following fields shows various periods in table GLPCT:
   

Fields	Period
TSLVT	O
TSL01	1
TSL02	2
HSLVT	0
HSL01	1
HSL02	2