Skip to Content
0
Former Member
Jan 06, 2011 at 08:23 AM

Update GL document amount directly

58 Views

Hi All,

I know it's a tough job and not a recommanded way. But some of our guys got wrong input in the GL document, but for some reason he don't want to make a reversal document, now he asked me for help. He want me to find all related database tables and change the amount directly. I did ST05 and found the following tables may relevant to the requirement:

BSIK, BSIS, COEP, FAGLFLEXA, GLPCA, GLPCT, LFC1, COSP, FAGLFLEXT

But to my strange, even after I updated all the amount fields and go back to FB03, I still see the value remain unchanged. So there must be some other tables or some fields need to update. When I look BSIK, BSIS, etc. I can see the values have already been changed, how can BSEG still shows incorrect data? Are there any cache on BSEG? Or can anybody please tell me what's the secret under BSEG that prevent changing?

Thank you very much!

Best Regards,

Jeff