Mass Reversal....and posting through LSMW

[Former Member]

Dear Gurus,

We hv data from last months. In some of the documents didnt updated/ missing the Business Area. Wht is the best way to solve this?

-- Can we Directly update necessary tables ( BA based on Plant wise i.e both are same name). If Yes wht are the tables need to update.

-- If we do mass reversal of all document and re-post through LSMW. If yes,

What will to do for clrng documents. Can we need to do.

Can anybody did like this, can u share ur exp or problems.

Regards,

Venkat

[Former Member]

We do mass reset and reverse (needed for cleared items.) using something similar to LSMW. Normally it is when the payment run fails. This makes the items open and reverses the documents so ths system is back in the state it was before the documents were posted!

We steer clear of directly updating tables, as you never what other tables are linked/rely on this data.

[Former Member]

Dear Barry,

Thanx for your reply. Where we can do mass Reset of open items.

a) Can we clear the open items by posting through LSMW. Wht are steps needs to do

b) We need to upload the Transaction data in two flat files i.e one for header data and another for transaction data.

c) In which tables we needs to update for line item file. ( through F-02). is it table is BSEG only na.

d) When i am seeing table name through F1 help, its giving structure name. Can we know the table name from structure name.

Thanx in advace.

Regards,

Venkat

[Former Member]

You cannot do a mass reset, however you would be able to record an LSMW seesion on FBRA - Reset and reverse cleared items.

We have an upload program for posting the new documents via FB01, although it can be customised to most Enjoy SAP Transactions.

http://code.ittoolbox.com/Codemaster/code/FIfromExcel.zip

This file will allow you to upload a single posting upto 999 lines, and header data in same file. This will load and psot to the correct tables.

We have successfully been using this upload program for over four years.

[Former Member]

Dear Barry,

Thanx u very much for ur inputs. I will go through and let you the result..

Regards,

Venkat

[Former Member]

Dear friend,

Document needs to reverse and repost are following:

SA-GL Docs

RE- Gross Sales Doc

WE- Good Receipt

--As per your documentation, its post only FI documents. What abt documents which are posted in FI through SD, MM & PP.

--One more things, Again we need to reverse the corresponding documents in Controlling? Is it necessary?

If hv 1000 documents, then i need to create 1000 work books with 1000 sheets.

Thanx inadvance and sorry for troubling you.

Regards,

Venkat

[dominic_holdstock]

Hi,

The documents generated from MM SD etc will have to be reversed from thoose modules.

It is not necessary to reverse corresponding documents, as the reversal of the original document will also generate the reversals for the connected documents

regards