LIS
The LIS is a central integrated information system where one can create specific tables that are updated at specific stages and that can be used to report on values contained in specific fields. SAP has standard information structures for reporting purposes. The std info structures can be accessed via: LOSDSISStandard analysis. The reports use the following characteristics: customer, material, sales org, shipping point, sales employee, and sales office.
IMG menu path for SIS: IMG>Logistics General>Logistics Information System (LIS)
The Logistics data warehouse is divided into two main sections: data basis and updating. Data basis is responsible for the actual design of the info structure, that is, what key fields are reported on or displayed. Updating is responsible for the updating rules used by the system, determining how the info structure is to be updated, and when this updating is to take place.
Task 1: Create Self-Defined Information Structure
Use transaction code MC21 (menu path Logistics Data Warehouse>Data Basis>Information Structures>Maintain self-defined information structures> Create) to create a Self-Defined Information Structure. Give a customer-range number 990 (any available number between 501 and 999). To make it easier, use ‘copy from’ to copy structure from S001.
Task 2: Maintain Update Groups
SIS IMG>Logistics Data Warehouse>Updating>Updating Definition>General Definition Using Update Groups>Maintain Update Groups
You can use the existing system-delivered update groups. Use Update Group (UpdGrp) 1 for the standard order process of: SIS: Sales Document, Delivery, Billing Document and use UpdGrp 2 for the SIS: Returns, Returns Delivery, Credit Memo.
Task 3: Maintain Update Rules
SIS IMG>Logistics Data Warehouse>Updating>Updating Definition>Specific definition using Update Rules>Maintain Update Rules>Create Create (transaction code MC24). To make it easier, use ‘copy from’ to copy update rules from S001.
Please make sure the Source information is properly updated for all the characteristics. Since you copied the rules, the sales order and item rules are defaulted too. Make sure appropriate changes are made for events VC (delivery) and VD (Invoice).
Task 4: Maintain Statistics Groups
Maintain Statistics Groups
Maintain Statistics Groups for Customers, Materials, and SD Document Types etc. Most of the pre-defined settings are enough. Make sure that settings are updated for customized objects too, e.g., SD document types for your organizations.
Also, make sure that the customer (sales view) and material Master records are updated with appropriate Statistics Groups.
Maintain Statistics Groups for Customers, Material and Sales documents. Assign Statistics Groups for relevant Sales Document Type, item type, delivery type, item type, Determine Billing Document Types Relevant to Statistics.
Update Customer Master for Statistics Relevancy
Transaction Code XD02 (Sales view, field “Cust stats.Grp”)
Update Material for Statistics Relevancy
Transaction Code MM02 (Sales 2 view, field “Matl statistics grp”)
Task 5: Assign Update Groups to Header and Item Levels
Assign Update Groups on Header and Item levels
For combinations of Sales Area (Sales Org, Distribution Channel, Division), assign Update groups (transaction codes OVRO and OVRP).
SIS IMG>Logistics Data Warehouse>Updating>Updating Control>Settings: Sales>Update Group
- Update Groups at Item Level
- Update Groups at Header Level
Task 6: Activate SIS Update
Lastly, Activate SIS Update for the Structure (transaction code OMO1)
SIS IMG path: Logistics Data Warehouse>Updating>Updating Control>Activate Update>Choose Activity as Sales and Distribution.
Last update our SIS structure S677 with period as ‘Month’ and update option of ‘Asynchronous Updating (2)’.
Regards,
Rajesh Banka
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.