Creation of Reports in SD

[Former Member]

Hi,

Based on client requirement, I would like to know how do we create reports which is very customised for eg : A report that talks about the list of sales orders for the quarter July - Sep that also shows the customers with the highest number of orders who have always maintained the credit limit consistently well.

I would like to know the complete path or T-code and also in detail as to how to go about in terms of creating the report customised to the above requirement.

I would also like to know the standard t-code or path to create standard reports (list of orders, list od deliveries,list of TO,list of QT etcc) in SD

Rgds

Milan

[Former Member · Accepted solution]

Hi

You can use Tcode VA05 to full fill your purpose upto a certain extent and your requirement is something different than you have to go for Z report

cheers

shalsa007...........

[Former Member]

Hi,

please see these are the reports avilable in sap.

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

Regards,

venkataswamy.y

[Former Member]

Hi,

For your requirement,we can go for VA05 or VA05n T.Codes.

Here we have to give teh date range as per your requirement.

But for the requiremnet of credit limit we have to for the customized report.

As it is similar to the existing one just we will copy the existing code intially.After this we will go for enhancement.

This will be saved as a "Z" program.

This will be done by your ABAPer.

So some reuirement is matching with the existing ones then we will make a copy of the existing program.If no then we will go for new development.

For all the standard reports viewing go to the T.Code "SAP1" from your "SAP Easy Access" screen.

Regards,

Krishna.

[former_member315051]

you can see all standard reports in T code - SAP1 , If standard is not suitable then take the help of ABAPer to develop new report based on the client Requirement.

Regards,

Ramesh