Skip to Content
Author's profile photo Former Member

SIS Historical Data

Dear All,

Here i am trying to explain how to activate the historical data. than next question is what is this historical data and why we active 🙂 .

I hope you have a knowledge on SIS process , if you don`t my advise is first try to know about SIS and SIS configuration process. If i configure SIS today it able to fetch the data in to the SIS now on wads.

Ex:- I just configure SIS process in my system and create only one sales order(value 10.05) , Now the SIS report ( Tcode MCTA) is like this.

/wp-content/uploads/2012/06/1_114460.jpg

2.JPG

But as per the client requirement , they would also be interested in seeing the past data before SIS configured in to the system .then we will follow the bellow process.

step1:

              Go to  t code SE38 and run the program

                        i) RMCVNEUA – for sales orders( or you can directly run the Tcode OLI7)

                        ii) RMCVNEUL – for delivery documents ( or you can directly run the Tcode OLI8)

                       iii) RMCVNEUF – for billing documents (or you can directly run the Tcode OLI9 )

/wp-content/uploads/2012/06/9_114495.jpg

Execute the program and enter you info structure ( same you used in SIS configuration), “&(” in save under version field and give the name for run.

By executing this all the historical data will get copied into Version “&(“

3.JPG

Step 2:

Now we have to copy the data from version “&(”  to version “000” than we will see the all historical data in the report.

Goto Tcode SE38 –> RMCSISCP (or you can directly run the Tcode OLIX) and Execute.

4.JPG

Enter info structure( same one used in SIS configuration) and click on ” copy version” push button and Execute.

5.JPG

Enter Info structure, source version”&( ” in data source tab and enter target info structure( in my case i used same info structure) , Target version “000” and execute the record.

6.JPG

Than you will get the below conformation massage .

7.JPG

The total historical data is converted now. so you see the all records in SIS report.

Step 3:


Go to Tcode MCTA and execute the SIS customer report.

8.JPG

Hope you like my explanation 🙂 🙂

Regards,

Patchala.

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Very Nice to Know...

      Author's profile photo jagan mathew
      jagan mathew

      This is explained clearly and its really helpful ℹ

      Author's profile photo Balaji Parsewar
      Balaji Parsewar

      Nice articulation. Really helpful for beginners as well as professionals.

      I rated the article as I liked it.

      Thanks for sharing.

      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Nice and simple explanation.

      Author's profile photo Former Member
      Former Member

      It is a very good explanation on how to update LIS

      Author's profile photo SR Kumar
      SR Kumar

      Good. Thanks for sharing.

      Author's profile photo venu gopal
      venu gopal

      Hi  sir very informative 🙂

      Author's profile photo Khawar Awan
      Khawar Awan

      Nicely Presented

      Author's profile photo Mohammed Mustafa Ali Khan
      Mohammed Mustafa Ali Khan

      Amazing!

      But I have a quesiton, should we do this process after maintaining customer statistics group and material statistics group in customer and material master respectively? Or maintaining these statistics groups make no difference?