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
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$
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
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.
Hi Jurgen,
Actually tried not to put too many screens for each step, only relevant ones. I will recheck and edit if required.
Karuna
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
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
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
nice work man.. Very useful
Thank You 🙂
Hi Karuna,
Really useful document & nice presentation.
Great Work....Keep it up 🙂 ...
Regards,
Krishna.
Thank You Krishna!
Very Useful...Many Thanks.
Best Regards,
Naresh K.
Thank you Naresh 🙂
Hi,
I need to update info structure S915. Firstly please tell me what happens after updating info structure.
Thank you Karuna. This is a really useful document.
Regards,
Jignesh Mehta
Thank you Jignesh 🙂
Being New to this area...Did not felt like "NEW"..... Good job...Its appreciated.
Hi, Glad you could use it... 🙂
Hi,
Thank you so much!
You're welcome! 🙂
Appreciable effort dear 🙂
Thank you Srinivasa.. 🙂
Nice explanation Karuna, keep posting this kind of useful dox.
thanks,
Srinu.
Thank you Srinivas.. 🙂
Very nice presentation. Appreciate your help.
Thank you Shantanu 🙂
Very informative Karuna 🙂 Thanks for sharing it.
Besr Regards,
Suhaib
Thank you Suhaib 🙂
Bro... you put in a lot of effort. Really appreciate it.
Regards
JNM
Thank you JNM,
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
Thank you Venu
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
Thanks a lot for sharing...
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.
Hi Karuna,
Nice Document. Keep it up dear.
hello
how to check update rule for an already created info structure ?
regards