topic Re: Data Base modification. in Application Development and Automation Discussions

Data Base modification.

Former Member — Mon, 30 Nov 2009 06:01:40 GMT

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.

Re: Data Base modification.

Former Member — Mon, 30 Nov 2009 06:13:28 GMT

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.