Skip to Content

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.

8. Display your info-structure in MC23. Go to Environment in menu bar and choose update definitions. Status of info-structure is Active.

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

To report this post you need to login first.

36 Comments

You must be Logged on to comment or reply to a post.

  1. ' 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$

    (0) 
    1. Former Member 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

      (0) 
  2. 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.

    (0) 
    1. Former Member 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

      (0) 
      1. 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

        (0) 
  3. Former Member

    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

    (0) 
    1. Former Member 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

      (0) 
  4. Former Member

    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

    (0) 
  5. 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

    (0) 
  6. Former Member

    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.

    (0) 

Leave a Reply