Skip to Content
avatar image
Former Member

reports

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

thanks in advance.

ravisankar.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • avatar image
    Former Member
    May 22, 2007 at 12:10 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2007 at 01:45 AM

    Hi Ravi;

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

    Regards,

    Mani.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2007 at 03:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 04, 2007 at 04:33 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2007 at 10:09 AM

    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...

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2007 at 10:16 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22, 2007 at 10:55 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 27, 2007 at 11:23 AM

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

    Add comment
    10|10000 characters needed characters exceeded