reports in SD

[Former Member]

Dear All,

i want to have standard reports from sales infromation system.I have given all the required datum in the fields for satndard analyses but not able to get any report.

Should i do special settings in IMG to activate the reports.

<b><REMOVED></b>

Thanking you,

Best Regards,

R.Srinivasan

[Former Member · Accepted solution]

Hi Ramanujam,

SD REPORTS

Reports: Reports consist of data, which is expected to be reveiwed or checked the transaction taken in said period. Reports are useful for analysis of decision taking for future activities.

Some of the standard reports for SD & its configuration guide is as under:

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

Shipment List Planning - VT11

List of Incomplete Shipments -Try VT04/VT11/VT32

Delivery without Shipments -Use VL06O

List of Rebate Agreements - VB(8

Please Reward If Really Helpful,

Thanks and Regards,

Sateesh.Kandula

[Former Member]

hi,

the std analyses may not be throwing data becos it dos not fetch past data. try by creating a new doc. make sure you have maintained the necesary statistic grps in customer, material and item catergories are enabled for statistical update.

if that dos not wrk go to t-code SARP, use SD01 as the tree and you will get all the standard reports in SAP. you do not need to activate ne thing.

saurabh

Message was edited by:

saurabh diwakar

[Former Member]

Dear Diwakar,

Thankyou very much for your helpful reply.

Best regards,

R.srinivasan

[Manoj_Mahajan78]

Sriniwasan,

SIS configuration steps

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.

Figure 2: Create a Self-Defined Info Structure

Figure 3: Structure S990 is created as a copy of S001

Structure S990 is created as a copy of S001. Accordingly, you will see defaulted characteristics and key figures. Review various settings (unit, sum, etc.).

• Add two more characteristics: Sales Order Number and Item Number.

Click on ‘Choose Characteristics’ Icon and then click on ‘Selection List’ icon to choose fields from ‘field catalogs’.

Choose field catalog ‘SD: Bus transaction (order)’ by double-clicking it. Double-click on ‘Sales Document’ and ‘Sales document item’ from ‘field catalog fields’ (you may need to scroll-down).

Figure 4: Choose fields ‘Sales Document’ and ‘Sales Document Item’ from Field Catalog

You can view technical names by toggling the Switch Display icon.

Figure 5: ‘Switch display’ to view technical names

Make sure that you have selected correct characteristics as: ‘MCVBAK-VBELN’ and ‘MCVBAP-POSNR’.

Click on ‘Copy + Close’ icon and then click on ‘Copy’ icon to accept the changes.

• Review information

Double-click on characteristics and key figures to review technical information. This step is not mandatory, just for information.

Figure 6: Review technical field information for characteristics: Customer (KUNNR), Sales Order (VBELN), Item (POSNR) and Key figures: Incoming Order (AENETWR), Open Order (OAUWE)

System displays the generation log.

Figure 7: Generation log for Structure S990. Table S990E is ‘Structural Information’ for Table S990

Task 2: Maintain Update Groups

• SIS IMG>Logistics Data Warehouse>Updating>Updating Definition>General Definition Using Update Groups>Maintain Update Groups

Figure 8: Update Groups for Sales and Distribution

No new entries need to be created. 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>Display

Info Structure S001 and Update Group 1.

Before we create update rules for S990, let's review how update rules are defined for S001. Review rules for Characteristics and key figures.

Figure 9: Update Rules for combination of Structure S001 and Update Group 1

Double-click to review specific details of the update rule for Key Figure ‘Incoming Orders’. Note that the event is ‘VA – Sales Order creation’.

Figure 10: Update rules for Key Figure ‘Incoming Orders’

Figure 11: Characteristics for Incoming Orders

Similarly review details of Key Figure ‘Sales’. Note that the Invoiced Amount (Sales Amount) is updated by event ‘VD – Billing Document’.

Figure 11: Update rules for Key Figure ‘Sales’

Figure 12: Characteristics for ‘Sales’

• Similar to Update Rules of ‘S001’, we need to create Update Rules for our Self-Defined Structure ‘S990’.

SIS IMG>Logistics Data Warehouse>Updating>Updating Definition>Specific definition using Update Rules>Maintain Update Rules>Create (transaction code MC24). To make it easier, use ‘copy from’ to copy update rules from S001.

Figure 13: Create Update Rules for Structure S990

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).

Figure 14: Source Characteristics for Sales Document and Item

Since we copied the Update Rules, the source field and table information is also copied. We need to change appropriately to make sure correct source information is populated. Click on “Rules for charact” and verify source information for every key figure, by clicking on ‘previous key figure’ and ‘next key figure’.

Figure 15: For Event ‘VD – Billing Document’, Sales Document and Item are present in MCVBRP table

Figure 16: For Event ‘VC – Shipping’, Sales Document and Item are present in MCLIPS table

Figure 17: Maintain Update Rules for Structure S990 and Update Group

Task 4: Maintain Statistics Groups

• Maintain Statistics Groups

Maintain Statistics Groups for Customers, Materials, 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.

Figure 18: Maintain and assign statistics groups. IMG path: Updating> Updating Control> Settings: Sales> Statistics Groups

- Maintain Statistics Groups for Customers (OVRA)

Figure 19: Statistics Groups for Customers

- Maintain Statistics Groups for Material (OVRF)

Figure 20: Statistics Groups for Materials

- Maintain Statistics Groups for Sales Document

Figure 21: Statistics Groups for Sales Documents

- Assign Statistics Groups for relevant Sales Document Type

Figure 22: Assign Statistics Groups to relevant Sales Documents

Assign Statistics Groups for each Sales Document Item Type

Figure 23: Assign Statistics Groups to relevant Item Categories

-Assign Statistics Groups to each Delivery Type

Figure 24: Assign Statistics Groups to relevant Delivery Types

-Assign Statistics Groups to each Delivery Item Type

Figure 25: Assign Statistics Groups to relevant Delivery Item Categories

- Determine Billing Document Types Relevant to Statistics

Figure 26: Assign Statistics Groups to relevant Billing Types

Note: As mentioned earlier, most of the settings are already set in standard system. Make sure that customized objects specific to your company are also updated appropriately.

- Update Customer Master for Statistics Relevancy

Transaction Code XD02 (Sales view, field “Cust stats.Grp”)

Figure 27: Assign Statistics Groups to Customer Master Records (Sales view)

- Update Material for Statistics Relevancy

Transaction Code MM02 (Sales 2 view, field “Matl statistics grp”)

Figure 28: Assign Statistics Groups to Material Master Records (Sales view)

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

Figure 29: Update Groups at Item Level

Figure 30: Update Groups at Item Level - details

- Update Groups at Header Level

Figure 31: Update Groups at Header Level

Figure 32: Update Groups at Header Level - details.

Task 6: Activate LIS Update

• Lastly, Activate LIS Update for the Structure (transaction code OMO1)

SIS IMG path: Logistics Data Warehouse>Updating>Updating Control>Activate Update>Choose Activity as Sales and Distribution.

Let's update our LIS structure S990 with period as ‘Month’ and update option of ‘Asynchronous Updating (2)’.

Figure 33: Activate LIS Update for S990

Finally u go through t.code MCSI, select ur info structure. Then execute the LIS report.

ALSO Visit http://help.sap.com/printdocu/core/Print46c/en/data/pdf/LOLIS/LOLIS.pdf.

It has everything related to SIS...

REWARD IF U FINDS THIS AS HELPFUL..

Regds

MM

[Former Member]

Dear manoj,

Thamnkyou for very detailed reply.should i use similar settings to get reports for other functions like customer, sales organisation,material etc.can u please give me a reply in detail.

Thanking you