on 05-23-2007 4:54 AM
Hi frnds,
I am stuck in one place .The standard reports which are in SIS(sales Information system) are not working.It shows an error that no data is selected whereas in the system data is there.
How do I activate these reports in customizing so that they can retrieve the data.
Please Help me.
Sunil
Hi Sunil,
Settings for SIS can be doone using:
SPRO - F5 - Logistic General - LIS - Logistic Data Warehouse - UPdating - UPdating Control - Settings: SD - Update groups:
do all the settings required.
Give you mail id i have sme documentation which might be useful to you.
Reward poins if it helps
Regards
Srini
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
Reward suitable points.
How to give points: Mark your thread as a question while creating it. In the answers you get, you can assign the points by clicking on the stars to the left. You also get a point yourself for rewarding (one per thread).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
When you are creating infostructure in MC21, you get a check box for
Plng Possible it should be ticked to get it in MCSI
Information structure with planning (Yes/No)
Indicator that determines if an information structure is relevant in flexible planning.
While creating the information structure, it must be decided if this structure should be used in flexible planning.
It is not possible to change the planning characteristic after creating the information structure.
If an information structure is created with this indicator, it can be supplied with planning data (standard).
Hi.,
You should assign customer Statstics group & material statastics group,and then you raise order,deliver,billing
Then we have some data & we can view the reports
Thanks & Regards
Narayana
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunil,
Pls go to MC30 and check if the SIS are getting updated. Before that pls maintain the parameter MCL as X in your profile (SU01, parameter screen). You will get to know which all SIS are getting updated upon a creation of a Sales Order/Billing through the transaction MC30.
Once you complete the validation, pls try using MCSI with the relevant SIS ( which were getting updated as seen through MC30).
Reg
Sachin
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks sachin.I have updated user profile using MCL = X
Now I create sales order & run the MC30 now system shows the list of Information structure.If i run any standard report it shows me result.
But when I run MCSI it shows no valus found....that i am not able to understand why system gives me this message.
Please help me
Thanks
Sunil
Hi friends,
I am in the same situation as of this thread.
After creating sales order,I got the info sturcture as S130 through T.code-MC30.
But I am not finding the above structure in T.code MCSI.The only structure available in MCSI is S501.
Please help in this regard,
Thanks & regards,
Praveen Kumar.
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.