on 06-16-2007 5:15 PM
I have a problem with LIS reporting which i am not able to rectify . Its a Automotive business, we have 3 order types, ZCKD, ZCBU for Vehicles and ZSPT for Spare parts. All three have same item category YTAN and item category strategic group 1, also all three order types are assigned to order type strategic group 1. All there order types uses same customer and in all customer strategic group 1 is assigned, All materials of CKD, CBU, and Spares have strategic group 1. All assignment at header and item level are done for all sales areas.
Problem is that in LIS reports CKD and CBU values are updating successful but for spare parts even after almost 1000 order it is only shows the Customer name, material sold dates, but no value, all the values are 0, I have checked S001 to S001 in Se16 and for all the spare parts material values are 0. I have done checked at header level and item level update in customizing but it is showing no error, I am not able to find the reason, I also made another order type copied from OR and new spare Part material, and new customer but still no result. Please guide if I am missing something or doing something wrong.
I have also executed Oli7 , 8 ,9 , but no result. I hope I have stated the problem clearly.
Standard SAP SD Reports:=
Statistic Group:
Purpose To capture data for Standard Reports, we require to activate Statistic Group as under:
--> Item category (Configuration)
--> Sales document type (Configuration)
--> Customer (Maintain in Master data)
--> Material (Maintain in Master data)
When you generate statistics in the logistics information system, the system uses the combination of specified statistics groups to determine the appropriate update sequence. The update sequence in turn determines for exactly which fields the statistics are generated.
Configuration:
IMG --> Logistics Information System (LIS) --> Logistics Data Warehouse --> Updating --> Updating Control --> Settings: Sales --> Statistics Groups -->
1. Maintain Statistics Groups for Customers
2. Maintain Statistics Groups for Material
3. Maintain Statistics Groups for Sales Documents
4. Assign Statistics Groups for Each Sales Document Type
5. Assign Statistics Groups for each Sales Document Item Type .....
All Standard Reports which are available are as under:
SAP Easy Access: Information Systems -> Logistics -> Sales and distribution ->
1. Customer -> Incoming orders / Returns / Sales / Credit memos / Sales activities / Customer master / Conditions / Credit Master Sheet
2. Material -> Incoming orders / Returns / Sales / Credit memos / Material master / ...
3. Sales organization -> Sales organization / Sales office / Sales employee
4. Shipping point -> Deliveries / Returns
5. SD documents -> Orders / Deliveries / Billing documents ...
& so on.
Some of the Standard reports in SD are:
Sales summary - VC/2
Display Customer Hierarchy - VDH2
Display Condition record report - V/I6
Pricing Report - V/LD
Create Net Price List - V_NL
List customer material info - VD59
List of sales order - VA05
List of Billing documents - VF05
Inquiries list - VA15
Quotation List - VA25
Incomplete Sales orders - V.02
Backorders - V.15
Outbound Delivery Monitor - VL06o
Incomplete delivery - V_UC
Customer Returns-Analysis - MC+A
Customer Analysis- Sales - MC+E
Customer Analysis- Cr. Memo - MC+I
Deliveries-Due list - VL04
Billing due list - VF04
Incomplete Billing documents - MCV9
Customer Analysis-Basic List - MCTA
Material Analysis(SIS) - MCTC
Sales org analysis - MCTE
Sales org analysis-Invoiced sales - MC+2
Material Analysis-Incoming orders - MC(E
General- List of Outbound deliveries - VL06f
Material Returns-Analysis - MC+M
Material Analysis- Invoiced Sales - MC+Q
Variant configuration Analysis - MC(B
Sales org analysis-Incoming orders - MC(I
Sales org analysis-Returns - MC+Y
Sales office Analysis- Invoiced Sales - MC-E
Sales office Analysis- Returns - MC-A
Shipping point Analysis - MC(U
Shipping point Analysis-Returns - MC-O
Blocked orders - V.14
Order Within time period - SD01
Duplicate Sales orders in period - SDD1
Display Delivery Changes - VL22
Regards,
Rajesh Banka
Reward points if helpful.
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 points if helpful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear Rajesh,
Thanks for so detailed answer, but it will not solve my problem, i am using standard analysis, and the steps u mentioned for standard analysis are already done for all my sales areas, order types and item categories, also in customer master and material master strategy groups are setup I also have done Check Update Groups at Item Level , Check Update Groups at Header Level, it is not showing any error for any sales area, item category, material, customer and sales order combination.
Info Structures are updating information only for following Sales areas and sales document Type, where Item category is YTAN.
1000 10 10 for vehicles
1000 10 20 for vehicles
1000 10 40 for vehicles
1000 10 50 for vehicles
1000 10 60 for vehicles
Order Type ZCKD, ZCBU (For Vehicles)
But for the sales area and order type Below ,non of the info structure is updating, it only shows the customer name who ordered , Material ordered, but not showing any value for them.
1000 10 70 for spare part
order type ZSPT (Spare Parts)
here Item category is also YTAN, All customers are same as for Vehicles. Material strategy group for spare parts are also set up in master data.
I hope you understand my problem now.
Regards
Tari
User | Count |
---|---|
97 | |
11 | |
11 | |
6 | |
6 | |
4 | |
4 | |
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.