Skip to Content
Author's profile photo Former Member

Information Structures in SAP

Information structures in SAP

An information structure is a table of fields from operative applications like sales or purchases and forms the basis for analytics in Logistics information system. It consists of three main parameters – period unit, characteristics and key figures.

  • A period unit gives is used to give reference of time like a week, month or year.
  • Characteristics are used to specify the range of data viz. company code, plant, sales organization, sales office or material etc. for which data is compiled.
  • Key figures are the data like sales volume, sales value etc. that is collected with reference to characteristics and period unit.
  • Create Info Structure:

1.  Go to IMG : Logistics General à LIS àLogistics Data Warehouse à Data basis àInformation Structures à Maintain self-defined information structures OR

Use T-Code – MC21, Enter number & description for your information structure, choose application 01, type as standard, enable planning and continue.

2. Choose characteristics from given field catalogs. Choose Sales Org, Distribution Channel, Division, Sold-to-party, Material and/or as required. Copy & Close.

Similarly, choose key figures like order quantity, confirmed quantity, gross weight, Net Weight, Volume, Billed Quantity, Open Orders Quantity etc. as required.

3. Save your information structure.

4. Go to MC24 to create updating for your information structure. Choose update group 1 (SIS: sales document, delivery, billing document) or as required.

5. Create update rules. Double-click on key figures and specify event, update type, source table source field. Choose table and date field for period determination or click on suggest rules. Copy.

Click on rules for characteristics to create update rules of characteristics for each key figure. Specify source tables and fields for each characteristic. Copy.

6. After creating rules for all your key figures, go to Environment in the menu bar and choose activate updating. Double-click your info structure to select                parameters as shown below. Set period split as required and asynchronous updating. Save.

7. Use T-Code LBW0 to connect your info-structure to SAP BW. Input your info-structure, choose set-up LIS environment and execute.

-Next Choose generate data source and execute.

-For Delta updating in LIS choose generate updating and execute.

Set up statistical data for your info structure

  Use T-Code –> SBIW to go to IMG and – go to Perform setup – sales & distribution and run activity Setup for Orders, deliveries, & billing.

9. Choose activity, enter the info structure (S898), give name of the run, date of termination, time of termination, No. of tolerated faulty documents.

Then execute.

10. Go to LBW0. Specify info structure and click ‘generate data source’.

— Go to Data Source in the menu bar and click on generate.
–Data Source 2LIS_01_S898 has been generated as shown below.

11. Display settings of your information structure in LBW0.

Settings of info structure will be summarized as below:

*******

Karuna Ravuri

Assigned tags

      36 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo ' MoazzaM '
      ' MoazzaM '

      Hi

      This is a nice presentation. I once tried it and was able to generate a report but I got one issue that I was not able to convert sale return document type and cancelled invoice quantity in negative. I tried this by creating a formula but system was not executing this as I checked by putting break point in formula. Can you put some light on this issue?

      Thank$

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi MoazzaM,

      Glad you found it usable. I think including item category along with relevant document types should take in to account sales returns & cancelled invoices. I am yet to try it and will post soon.

      Karuna

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

      Nice document, this will certainly help people to understand the setup of a LIS info structure

      Can you please double check, it seems to me that one screen shot is not coming.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Jurgen,

      Actually tried not to put too many screens for each step, only relevant ones. I will recheck and edit if required.

      Karuna

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

      In your step 7, I can see 3 frames for a screen shot, but only 2 screen shots. Thats the reason why I think there is one missing

      Author's profile photo Narendra Konnipati
      Narendra Konnipati

      Dear,

      Your Doc is very nice .Keep it up 🙂 .

      Note : I got small problem in 9 th step .I maintained correct time with the help of F4 but system is giving below error .

      "Time of termination  lies in the past " .

      Thanks,

      Naren

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Naren,

      Thank you. Glad you found it usable. As for error on Time of termination, I got it too, I then maintained 2 hrs ahead of current time and it worked.

      Karuna

      Author's profile photo Senthil Nayagam
      Senthil Nayagam

      nice work man.. Very useful

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank You 🙂

      Author's profile photo KRISHNA KUMAR
      KRISHNA KUMAR

      Hi Karuna,

      Really useful document & nice presentation.

      Great Work....Keep it up 🙂 ...

      Regards,

      Krishna.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank You Krishna!

      Author's profile photo Former Member
      Former Member

      Very Useful...Many Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Naresh 🙂

      Author's profile photo meghana pathak
      meghana pathak

      Hi,

      I need to update info structure S915. Firstly please tell me what happens after updating info structure.

      Author's profile photo Jignesh Mehta
      Jignesh Mehta

      Thank you Karuna. This is a really useful document.

      Regards,

      Jignesh Mehta

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Jignesh 🙂

      Author's profile photo SAQ MD
      SAQ MD

      Being New to this area...Did not felt like "NEW"..... Good job...Its appreciated.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi, Glad you could use it... 🙂

      Author's profile photo Former Member
      Former Member

      Hi,

      Thank you so much!

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      You're welcome! 🙂

      Author's profile photo Former Member
      Former Member

      Appreciable effort dear 🙂

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Srinivasa.. 🙂

      Author's profile photo Srinu S
      Srinu S

      Nice explanation Karuna, keep posting this kind of useful dox.

      thanks,

      Srinu.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Srinivas.. 🙂

      Author's profile photo Shantanu Shaligram
      Shantanu Shaligram

      Very nice presentation. Appreciate your help.

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Shantanu 🙂

      Author's profile photo Suhaib Bin Aziz
      Suhaib Bin Aziz

      Very informative Karuna 🙂 Thanks for sharing it.

      Besr Regards,

      Suhaib

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Suhaib 🙂

      Author's profile photo Former Member
      Former Member

      Bro... you put in a lot of effort. Really appreciate it.

      Regards

      JNM

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you JNM,

      Author's profile photo venu gopal
      venu gopal

      Hai Nice post Dear

      thank you so much for sharing keep it up for ever

      Dear   Ravuri

      i am not able to understand exact use of this plz explain in simple way

      thanks a lot when i will get output

      thanks a loit

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Venu

      Author's profile photo Former Member
      Former Member

      Thanks a lot for sharing...

      In my client, I have a problem. in Development client, we have assigned some info structure to planning type..but the same info structure was not taken to the quality client and hence info structure is missing in planning type..would you please suggest me how to reassign a different info structure to same planning type.

      Thanks

      Author's profile photo Former Member
      Former Member

      Thanks a lot for sharing...

      Author's profile photo Shubham Gupta
      Shubham Gupta

      Hi Karuna,

      I created a new Info Structure by following the steps as mentioned by you. When the analysis report I faced the error - " NO DATA EXISTS "

      Please suggest what should be done.

      Thanks for Wonderful Document.

      Author's profile photo Former Member
      Former Member

      Hi Karuna,

                     Nice Document. Keep it up dear.