This is a continuation for the document: How to Create an LIS info structure - Purchasing - Part 1
Now, Select the Key figures (Output fields)
Double click on the key figures created in the first step:
Click on Copy + Close.Click on “Copy”
Generate the info structure:
Now, click on “Generate” as shown below:
Table Generate Log will be displayed:
Step 4:Create updating:
By defining the update process, you define the flow of statistical data from the application to the information system. Means you can define when the data to be updated in the info table created in the previous step.
The definition of the update rules depends on the information structure and update group.
Update rules consist, for example, of the source field, the event which triggers the update, requirements and formulas.
Once you have defined the update rules, the corresponding update programs are automatically generated.
Transaction Code: MC24
Now, you can define the update rules:
Select the required fields from F4 list manually or click on “Suggest Rules”
Click on next key figure as shown below:
Repeat the same process for all key figures and click on "Copy":
Now define the update rules for characteristics for each key figure:
Select the first key figure and click on "Rules for characteristics"
Repeat the Rules for the characteristics for each key figure.
Click on “Generate” as shown below:
Generation Log will be displayed:
Go back and click on “Activate Updating”
Place the cursor on the info structure created and go to details:
Maintain the update rules as shown below:
Note:
In the update rules, you could find the following options:
1. Period split:
Here, you can define the period for which the report / info table to be analyzed. If you select "day", you can analyze based on date, if you select week, you can analyze based on week and so on. The corresponding period only will be updated in the table.
2. Updating:
Here, you can define the time / sequence when the info table to be updated. The following options are available.
Here, I choose the period as "Month" in order to analyze the report on monthly basis and the update as "Synchronous Update" in order to update the table simultaneously along with standard tables.
Save the update:
Now, the configuration part is over:
Testing:
Complete a purchasing cycle and check whether the table is updated correctly: (Create PO – GR – Invoice) and check the table in SE16
To Analyze the report:
Transaction Code:: MCSJ (Path: Easy Access - SAP Menu - Information Systems - Logistics - Purchasing - Tools - MCSJ_User Defined Analysis
( for purchase - MCSJ, for Sales - MCSI )
Select the info structure.
Enter the selection parameters and execute:
Click on “Switch drill down” for further analysis.
You may select any other analysis criteria for analysis.
You may change the output layout as below:
Go to MCSJ and select the info structure: and click on “User Settings”
Click on Key figures for setting the output layout.
Note: 1. You may follow the same logic for creation of info structure for other areas like inventory, LIV, sales etc.
2. For more details about LIS transporting, refer the documentation in the path: SPRO- Logistics General --> Logistics Information System (LIS) --> Logistics Data Warehouse - "Technical information about the transport of LIS objects"
Also, refer the notes: 37845 - Technical Information: Transporting Info Structures and 50237 - Techn. info.: transport of update, field catalog
3. For further FAQ, please refer the following notes:
552152 - FAQ: General questions for LIS
552503 - FAQ: Questions for updating and reporting in LIS
Note: Currently, the info table will be updated from the date the info table is created. If you want the info table to be updated with previous data, you may follow the procedure explained in the doc: Update History Data to user defined LIS (Purchasing)
Reference: SAP Library - Logistics Information System (LO-LIS)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
2 | |
1 | |
1 |