Need your expertise on this.
When we view KE5T report for account 60685, we noticed a difference between the base ledger and comparison ledger amount. For the base ledger totals, we found out that totals from GLT0 table was calculated based on the amounts from FBL3N (G/L Line Item Display )report but we cannot find out how does SAP came up w/ the totals for comparison ledger(PCA - GLPCT table). We tried checking GLPCA table for a more detailed data to find out how totals on PCA was calculated but totals did not matched with ours.In addition, no records were found when we tried searching for account 60685 in GLPCA table. Note that all FI docs(auto posted thru MM) has its corresponding PCA docs.
Can you please enlighten us how comparison ledger total amounts are calculated?