SAP Certification, Functional, Basis and ABAP Programming Reference Books
SAP LIS - Wrong figures in Logistics Information System

Warning - Please test it in developer first. 

Alert : It can result in data loss or inaccurate data in your LIS table if not done properly.

This is bound to happened especially if the users made changes to the Purchase Order and you have set the online updates for your LIS.   Fields like Material groups are consider keys fields and should not be change as it somehow impact the updates to LIS.

If the figures are wrong for a particular period, you can do a reorganization for all the Purchase Order for the particular months.

Assuming that you want to reorganize the whole S012. 

When you execute OLI3, it will locked any Purchase Order that it is processing.  Therefore, it is advisable to run it during off office hours.

First Step :-

  • OLI3 - Statistical setup of info structures from purchasing documents
  • Info structure to be set up S012
  • Save under version &(
  • Tick Delete/create indices
  • Specify the Purchasing Documents or Document Date
  • Name of run S012-1
  • Tick New run?
  • Date of termination 99.99.9999
  • Time of termination 99:99:99
  • Tick Redetermine update group?
  • Tick Update documents?
NPRT - Log for Setup of Statistical Data

Final Step:-
OLIX - Copy/delete versions of an info structure
First Screen

  • Info structure S012
  • Processing type Copy + Delete
Second Screen
  • Source version &(
  • Untick Do not copy initial records
  • Tick Reset target version
  • Untick No automatic period conversion
Now, you can check the figures using transaction MCE5or any of the transaction that uses the table S012.
 

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com
 

All the site contents are Copyright © www.sap-img.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.sap-img.com is in no way affiliated with SAP AG. 
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk. 
 The content on this site may not be reproduced or redistributed without the express written permission of 
www.sap-img.com or the content authors.