report for inquiries for all customers and material

[Former Member]

how can i see a report of all inquiries of all customer and materials is there any predefine report in sap

we do have va15 but it does not list depending on the custmer or material, how can we do it for all customer

thanks

[Former Member]

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.

[Lakshmipathi]

Dear varada rajan

You can try with SE16 - Table VBAK. There select Document Type and execute.

thanks

G. Lakshmipathi

[Former Member]

how can we ask user to view se16 is there any other way

[Former Member]

Hello Friend ,

You can use tn VC/2 just give sales area data and press F8 .

Rewards Point's if help ful Regrds

BHavesh

[former_member204513]

Dear Varada Rajan,

In the VA15 transaction itself we have selection fields Sold-t--party and Material.

If you want for all the sold-to parties just you enter the Material no then execute system will give the report for that Material for all customers (Who are all having Inquires for that Material).

I hope it will help you

Regards,

Murali.

[Former Member]

can i do this for all customer for all materials,

my user is asking that he want to see all the report for all materials for all customers

[former_member204513]

Dear Varda Rajan,

I think you can able to see through this VA15 either all customer with one material or all material with one customer.

Any how At last

You Try with this option you just enter only the document date from and to then execute, now you may get your requirement.

If not

You take ABAPer help copy this VA15 program make the change according to your requirement.

I hope it will help you

Regards,

Murali.