Reports in SD

[Former Member]

Hi,

I would like to know

1. What are all the types of Reports used in SD

2. In real times how the reports are being prepared

Regards,

Priyadharsini.R

[Former Member]

Hi ,

Regarding your questions,

Many of our friends had given the list of diferent reports which we can generate through standard sap transaction codes.

In real time, if it is possible to generate a report through ABAP query either using single table or with multiple tables, we generally generate reports so that they can solve the issue instantly and immediately.

If the requirement is in such a fashion that we have to generate the reports often, then we can ask the abaper to develop a programme and a z transaction code so that the client can use it in a easy manner.

Coming to the other questions,

SAP Query we can create a query through the transaction codes SQ03, SQ02,SQ01 and generally termed as SQ's

Functional specifiation is a document which is prepared for a requirement.

We will include in this functional specification ,

why the requirement has to be met.

How it was met

what configuration was done to meet the requirement

What assumptions are taken into consideration to meet the requirement

what are the dependencies of this requirment

on which factors/modules/flow does this impact

who is the owner of the document

and other details

When once we give a functional specification, if it is to be coordinated with abap, the abaper will prepare the technical specification document based on the functional spec.

Hope this throws some light.

Award points if it adds information.

Thanks

Mohan

[Former Member]

Hi,

Can any one help me in finding solutions

1. what is functional specification and how it is used in real time

2. SAP Queries

Regards,

Priya

[Manoj_Mahajan78]

Priyadharsini,

Below are Std SD Reports...

But you will have to do SIS Confign-

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

REWARD IF U FINDS THIS AS HELPFUL...

Regds

MM

[Former Member]

Hi Priyadharsini

The std. SD Reports are

Standard SAP SD Reports

Reports in Sales and Distribution modules (LIS-SIS):

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

Completed Quotations SDQ3

Create Quotation VA21

Display Incomplete Quotations V.04

Expired Quotations SDQ2

Expiring Quotations SDQ1

List of Quotations VA25

Display Incomplete Inquiries V.03

List of Inquiries VA15

Reward if useful to u

null

[Former Member]

Hi Priyadharsini Rajesh,

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

Apart from this if you want to develop new reports by using LIS and SIS and also using ABAP Query you can develop your own reports

Please Reward If Really Helpful,

Thanks and Regards,

Sateesh.Kandula