Data Base modification.

[Former Member]

sir,

I know, as programmer I'm asking wrong question.

Actually, I modified posted sales invoce(VF02), and related Fi accounting documents.

that is 1)Accounting Document 2)Profit Center Doc. 3)Controlling Document.

Now problem is that:- General Ledger Account balance displayed in transaction FAGLB03,

may not match with balance for the same period (that is period 7)

on double clicking on cell in FAGLB03.

But the balances after double click are correct and I cannot modify FAGLFEXT table

because it contains very huge amount.

Can any one help me, to correction of the balances on FAGLB03 or avoid inconsistance

in data base .

Thank You,

Manoj.

[Former Member]

Hi Manoj ,

Due to your manual changes in the database , it has become inconsistent.

You should avoid these types of changes untill you know full process flow and all the database tables that are needed to be updated.

Suggessions :

1. Keep record of your changes , it may require to be reverted.

2. Try to find all the database tables that are updated during the process.Use Trace for this, Search insert and modify statements.This is time consuming.

3. Go in techincal setting of the field showing wrong value and check if it is dirct froma database table , if yes you can update the database table.

If it is structure , use where use list.

Hope this provide you some help.