topic Re: Update GL document amount directly in Application Development and Automation Discussions

Update GL document amount directly

Former Member — Thu, 06 Jan 2011 08:23:39 GMT

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

Re: Update GL document amount directly

Former Member — Thu, 06 Jan 2011 08:44:50 GMT

Jeff,

You should try reversal. I don't think its a good idea to update BSEG directly. BESG holds accounting document line item data which are very useful .

In my case i wouldn't have done the changes manually. Instead go around with some BAPI's.

Re: Update GL document amount directly

RaymondGiuseppi — Thu, 06 Jan 2011 08:59:38 GMT

So called secondaty indexes (BSIS, BSIK, etc.) are programmatically updated when BSEG is updated by a SAP standard program, there is no database-maintained-link between those tables, those are not actual index, updating BSIS or BSIK don't update BSEG.

Actually, you certainly missed some tables, at least BSEG (database cluster RFBLG)

very, very bad idea...

Regards,

Raymond

Re: Update GL document amount directly

Former Member — Thu, 06 Jan 2011 09:29:13 GMT

Hi Raymond,

Thank you very much! Yes, you are correct. I didn't ever think about updating BSEG because in my mind, it's a mysterious table and everyone told me it's not exist in database, so I did not do even a try.

OK, Now the document updated, I'll ask that troublesome guy to have a test and if everything is OK, then do them in PRD system.

Thank you again for the information.

Best Regards,

Jeff

Re: Update GL document amount directly

ThomasZloch — Thu, 06 Jan 2011 09:35:46 GMT

Are you saying you already did the update? Don't you have auditors and internal revision check for such things? This is illegal accounting practice!

Also, you will never be able to update all relevant places in the wide SAP world, e.g. the postings might have been transferred to CO module, and now you have a mismatch between FI and CO. Many other things to observe, I wonder if SAP themselves know all the pitfalls.

NEVER do this, always reverse postings and post again with correct amounts, anybody suggesting differently is talking b.s.

Thomas

P.S. I was forced to re-arrange the points, so that there is not a misleading impression that your query was resolved in a proper way.

Edited by: Thomas Zloch on Jan 6, 2011 10:40 AM

Re: Update GL document amount directly

Former Member — Thu, 06 Jan 2011 10:47:50 GMT

Hi Tomas,

Yes, I know your concerns and I also tried to persuade that guy to give up, but he still insist on, and my boss also wanted me to have a try, so I suppose it has already been approved by the auditors.

I did a trace on the FB01 with the same values from the wrong document and found there are 12 tables related to this operation, including the costing and profit documents. I know for the other scenario, there probably will have more tables to be included. So it'll be a case by case practice. And I need to try my best to find out all the affected tables.

Best Regards,

Jeff

Re: Update GL document amount directly

Former Member — Thu, 06 Jan 2011 11:04:42 GMT

With no doubt, everyone hate this solution including me. But how can I do then if user would like to enjoy the dangaous thing? Sometimes real life is not as happy as we imagine:(. The only thing I'd like to do now is to pray for a peaceful year of 2011 and the upcoming "doomsday" 2012...

Best Regards,

Jeff

Re: Update GL document amount directly

ThomasZloch — Thu, 06 Jan 2011 11:41:34 GMT

I don't know your role, as a consultant I would try my best to talk a customer out of such illegal and dangerous ideas.

I would probably refuse to do it altogether.

I only know German legislation in this respect, but is very likely illegal in most if not all countries to restrospectively change already posted amounts, rather than reversing and re-posting.

Thomas

Re: Update GL document amount directly

brad_bohn — Thu, 06 Jan 2011 14:49:41 GMT

If you do it once, it only makes it easier to do it again. Nobody tries heroin just once ;-). Whether it's illegal or not, I can't believe your boss would agree to it. Stand up to those business leads! If it's a large value document, maybe you should recommend parking or some other review process prior to posting. FB08 or FBR2 is the way to go in this case...

Re: Update GL document amount directly

Former Member — Thu, 06 Jan 2011 15:18:25 GMT

Just to add my 2 cents:

Rather than relying on unofficial untested information you get from the internet, raise an OSS message and get some advice directly from SAP. They will probably say it is a consulting issue and either offer to do it for you (for a fee) or tell you not to do it at all.

Take their advice on this.

rob

Re: Update GL document amount directly

Former Member — Tue, 11 Jan 2011 02:50:38 GMT

Thank all of you. These days I kept telling the that guy and my boss about the legality of this solution and as a proof I also showed them your replies, so finally they agreed to give up and follow the normal way. It's a great news as I no need to take this unnecessary risk.

Thank you very much!

Best Regards,

Jeff

Re: Update GL document amount directly

SuhaSaha — Tue, 11 Jan 2011 05:05:13 GMT


> ... as a proof I also showed them your replies, so finally they agreed to give up and follow the normal way ...

Long live SCN