cancel
Showing results for 
Search instead for 
Did you mean: 

reports

former_member1249468
Contributor
0 Kudos

hi gurus,please give me inputs about what is reports,and its generation.an its use in support projects.

thanks in advance.

ravisankar.

Accepted Solutions (0)

Answers (8)

Answers (8)

Former Member
0 Kudos

If the question is answered, it is recommended to reward suitable points to helpful answers & close the Blog.

Former Member
0 Kudos

Hi,

A report is an executable programme which reads data from the database ,processes the data and then displays the result.

The result can be in the form of a List or a Form or a Grid or a document in Excel or Word or HTML.

Reports are generally developed in an implementation project as per the requirements of the users if he needs any besides the standard ones provided by SAP. In a support project reports are generally modified through user exits. Creation of reports is a rare requirement in support projects it could be an enhancement.

Former Member
0 Kudos

Dear Ravisankar,

There are two types of reports.

1. Standard Reports - that are provided by SAP

2. Custom Reports - not provided by SAP and are developed as per client's requirement

You can also generate reports using report painter and query.

Few of standard SD reports:

Customer - Incoming Orders SAP menu - Information Systems - Logistics - Sales and distribution - Customer - Incoming Orders MC(A

Customer - Returns SAP menu - Information Systems - Logistics - Sales and distribution - Customer - Returns MC+A

Customer - Invoiced Sales SAP menu - Information Systems - Logistics - Sales and distribution - Customer - Invoiced sales MC+E

Customer - Credit Memo SAP menu - Information Systems - Logistics - Sales and distribution - Customer - Credit Memo MC+I

Material - Incoming Orders SAP menu - Information Systems - Logistics - Sales and distribution - Material - Incoming Orders MC(E

Material - Returns SAP menu - Information Systems - Logistics - Sales and distribution - Material - Returns MC+M

Material - Sales SAP menu - Information Systems - Logistics - Sales and distribution - Material - Sales MC+Q

Sales Organization - Incoming Orders SAP menu - Information Systems - Logistics - Sales and distribution - Sales Organization - Incoming Orders MC(I

Sales Organization - Sales SAP menu - Information Systems - Logistics - Sales and distribution - Sales Organization - Sales MC+2

Shipping Point - Deliveries SAP menu - Information Systems - Logistics - Sales and distribution - Shipping Point - Deliveries MC(U

Shipping Point - Returns SAP menu - Information Systems - Logistics - Sales and distribution - Shipping Point - Returns MC-0

Customer SAP menu - Logistics - Sales and distribution - Sales Information Systems - Standard Analyses - Customer MCTA

Material SAP menu - Logistics - Sales and distribution - Sales Information Systems - Standard Analyses - Material MCTC

Sales Organization SAP menu - Logistics - Sales and distribution - Sales Information Systems - Standard Analyses - Sales Organization MCTE

Shipping Point SAP menu - Logistics - Sales and distribution - Sales Information Systems - Standard Analyses - Shipping Point MCTK

Reward points if this is helpful.

Regards,

Naveen.

Former Member
0 Kudos

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.

Former Member
0 Kudos

hi ravisankar,

what is a report: a report is nothing but a selection screen for selection data from data base

youu can build a report from t.code se38.

for sample reports put demo* and f4 in se38.

see might be of some

need documentation on report send your email id.

anuj...

Former Member
0 Kudos

Hi Ravi,

Reports are basically what the client uses to run his business to understand what is happening. In sap all the data is stored in the form of tables. So, when we want a report say to show the sales happd over the last 3 months or an year over some division for a product can be fetched from the database through these tables. we have a primary key, foreign key relation ship used by RDBMS used to fetch the data from various tables.

Classic report: In this report only one basic list is displayed.

Interactive report: It means first basic list is displayed and if we select any one line and double click on this line then secondary list is displayed.

For ex: if you have displayed all the sales order details from VBAK table on the output the it iscalled basic list. After that if u have selected reports any one line the basic list and double click on this sales order number then data is displayed from the VBAP line item data for that sales order number then it is called secondary list..

"Reward points if it helps"

With regards

Rajesh

Former Member
0 Kudos

HI ravi

A report is an executable programme which reads data from the database ,evaluates it and then issues the result.A report does not make any changes to the database.

CALL UP REPORT:If u want to restrict a list according to certain selection criteria, you must enter the criteria before creating the list.

You can call up the report from the reporting tree that contains all the reports.

choose Logistics--> Informjation systems--->General report selection.

Here you place the cursor on the application required and choose edit------> expand subtree.

to see the documentation for a report ,choose Help----->extend help.

RESULT: You will receive a list,in the list you can display or change a document,choosing sales document in the list,masterdata and document flow in the list.

Award points if it is useful .

Prasad.G

Former Member
0 Kudos

Hi Ravi;

Can you please provide more information in terms of what you are looking for. The question is very generic.

Regards,

Mani.