on 04-03-2007 4:02 PM
hi gurus,please give me inputs about what is reports,and its generation.an its use in support projects.
thanks in advance.
ravisankar.
If the question is answered, it is recommended to reward suitable points to helpful answers & close the Blog.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ravi;
Can you please provide more information in terms of what you are looking for. The question is very generic.
Regards,
Mani.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.