Skip to Content
Author's profile photo PRASOON AK

Update History Data to user defined LIS (Purchasing)

Please refer the below documents for how to create a user defined LIS info structure:

How to Create an LIS info structure – Purchasing – Part 1

How to Create an LIS info structure – Purchasing – Part 2

The scope of the current document is limited to historical data update to user defined LIS table.

Once a new LIS table is generated, the LIS table doesn’t contain historical data. If you check the table in SE16, the number of entries will show it.

In-order to update the historical data to this LIS table, you may proceed as explained below:

Follow the path: SPRO – Logistic General – Logistic Information System (LIS) – Logistic Data warehouse – Data Basis – Tools – Set up Statistical Data – Application Specific set up of statistical Data.

Transaction OLI3 for updating Purchasing LIS

Execute set up of the corresponding application.


Enter the info structure name to be updated along with other criteria as shown below:

The following are the important fields:

1. Save Under Version: Here, you can mention the version name. The version name will be displayed/updated in info table. You can save the new data update in a different version name. Also, you have the option of copy / delete versions.

    The version name for statistical set up should start with “&(” since other versions are used with planning.

    If you update with different version name, the same documents will be repeated with different version name.

2. Delete / Create Indices indicator: Here, you may set whether the secondary indices already existing in the info table are to be deleted and recreate. If you set this indicator, and if there is already data existing for a combination, the secondary indices (like vendor, order qty etc in the example) are deleted and recreated again. It is mainly for performance improvement.

3. Name of Run: Here, you can mention a name for the update run. This is useful when an update run is terminated and you use the same name as name of run next time, system will use the data which is already determined.

4. Re determination of update group: You can set this indicator, the system will redetermine the update groups for the documents which are processed at the time of the statistical set up. If this indicator is not set, there can be an inconsistency with the documents processed at the time of the statistical set up.

5. Update Documents: this indicator will update the update group in the already existing document. This indicator is mandatory if you modify the update group characteristics in customizing. If this indicator is not set, the existing documents will be updated in table as per previous update rules.

6. Block all Documents: This indicator is useful when you are updating the info structure parallelly to the business. If you set the indicator, all the documents relevant for the statistical update will be blocked till the update is completed. The block will be released once the update run is completed.

    If you are doing the info structure update in your business hours, this indicator is mandatory.

Execute.

Now, check the LIS table in SE16. The table will be updated with historical data.

The same details will be available for analysis in MCSJ transaction.

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Jürgen L
      Jürgen L

      This part could have been a bit bigger with explaining text.

      You circled some fields but did not give any explanation, e..g Update documents .

      What is the danger in doing it, what in not doing it?

      The Headline of the screen says setup, what happens to the old data?

      Why is there such a strange version, can I use a different?

      Is it save to do it during the day when others create new purchase orders at the same time?

      Author's profile photo PRASOON AK
      PRASOON AK
      Blog Post Author

      Hi Jurgen,

         Thanks for your valuable suggestions...

         I have updated the document with the important fields / indicator details.

      Regards,

      AKPT

      Author's profile photo Mehmet Ozgur Unal
      Mehmet Ozgur Unal

      Hi all ;

      Thanks to AKPT MM for implementable document.

      M.Ozgur Unal

      Author's profile photo Jürgen L
      Jürgen L

      Better now, thanks for updating

      Author's profile photo Joy Ghosh
      Joy Ghosh

      Hello,

           Thanks for sharing knowledge in the document series.

      Regards,

      Joy

      Author's profile photo Subeesh Kannottil
      Subeesh Kannottil

      Hi,

      Excellent Document,Really helpful.

      Regards,

      Subeesh Kannottil

      Author's profile photo Former Member
      Former Member

      Hi AKPT MM,

      Very helpful. Thanks a lot..

      Regards,

      Aloysius

      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Prasoon sir,

      I have created new infostructure and now,I have done like above to get the old data into my own infostructre but valuated stock value is coming and valuated stock ( quantity ) is not coming .

      1.JPG

      Kindly suggest how to get the valuated stock.

      Note:In standard report MC.1-S039, the data is coming.

      BR

      KNR

      Author's profile photo PRASOON AK
      PRASOON AK
      Blog Post Author

      Hi,

         Could you please check whether new postings are updated correctly in the info structure. Create new stock postings and check the updation in the info structure and revert back.

      Regards,

      AKPT

      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Sir,

      I have deleted versions( OLIX ) and again done OLI3 thereafter created PO with 12345 materialc code and done MIGO and executed MC.1 at plant level but I am able to see that material code data only.What about all material codes?

      Should I perform transactions ( PO and MIGO ) to get the data of them in MC.1?

      BR,

      KNR

      Author's profile photo Mohsin Abbasi
      Mohsin Abbasi

      Dear AKPT,
      Nice Stuff with in-depth detail........ 🙂

      Best Regards

      Mohsin Abbasi

      Author's profile photo Vaibhav Chandanshive
      Vaibhav Chandanshive

      Very Nice Document Prasoon Great Job