Types Of Reporting.

[Former Member]

Hi Experts,

This is Guru. New bie to ABAP. One of my friend said as a fresher in ABAP programming i must first focus on <b>Reporting stuffs</b>. Can anyone say what are the types of reporting in ABAP programming ?

Thanks in advance,

Guru.

[Former Member]

Hi Guru,

Types of reports.

1) Classical reports

2) Interactive reports

You can use normal reporting or ALVs for output of these reports.

<b>Friendly Note:</b> You have many open threads and Plz close the threads if they are answered/solved and reward points to the people who are helping you by taking their valuable time.

Thanks,

Vinay

[Former Member]

hi Vinay,

Thanks for your nice reply. I do closed the threads and rewarding the points accordingly. I know that it's a great help for me of spending your valuable time and answering. So i am closing my thread without fail.

Thanks for your replies again.

Guru.

[Former Member]

Hi,

Check this link

http://www.is-edu.hcmuns.edu.vn/WebLib/Books/Database/0-672-31217-4/index.htm

Regards

Arun

[Former Member]

Hi,

Report is basically a program which extracts the data from the database tables based on some inputs and gives the output as a list.

Report are classified as Classical Reports, Interactive Reports and ALV Report.

Classical Report is a normal report which just displays the output.User cannot interact with that report.

Interactive Report is nothing but, a user can interacte with the report.After a basic list is displayed, user can click on some field on the list which generates a secondary list giving the necessary information relevant to that field.

ALV Report is to provide users with a consistent, user friendly and functional method of manipulating the data, which appears on report lists. ALV provides more advantages than the normal report

Reports

http://www.sapgenie.com/abap/reports.htm

http://www.allsaplinks.com/material.html

http://www.sapdevelopment.co.uk/reporting/reportinghome.htm

http://www.sapfans.com/forums/viewtopic.php?t=58286

http://www.sapfans.com/forums/viewtopic.php?t=76490

http://www.sapfans.com/forums/viewtopic.php?t=20591

http://www.sapfans.com/forums/viewtopic.php?t=66305 - this one discusses which way should you use - ABAP Objects calls or simple function modules.

http://www.sapbrain.com/FAQs/TECHNICAL/SAP_ABAP_REPORTS_FAQ.html

http://www.sap-img.com/

http://www.sapdevelopment.com

http://www.sapmaterial.com

[Former Member]

hi,

There are 2 type of reports. They are:

1. Interactive report

2. Classic reports

In classic reports,we can see the output in single list where as in interactive reports we can see the output in multiple list.

In ABAP, there are a total of 7 types of reports. They are:

· Classical

· Interactive

· Logical Database

· ABAP query

· ALV Reports (ALV stands for ABAP List Viewer)

· Report Writer/Report Painter

· Views (There are different types of views also)

Classical Reports

These are the most simple reports. Programmers learn this one first. It is just an output of data using the Write statement inside a loop.

· Classical reports are normal reports. These reports are not having any sub reports. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT.

Events In Classical Reports.

· INTIALIZATION: This event triggers before selection screen display.

· AT-SELECTION-SCREEN: This event triggers after proccesing user input still selection screen is in active mode.

· START OF SELECTION: Start of selection screen triggers after proceesing selection screen.

· END-OF-SELECTION : It is for Logical Database Reporting.

Interactive Reports

As the name suggests, the user can Interact with the report. We can have a drill down into the report data. For example, Column one of the report displays the material numbers, and the user feels that he needs some more specific data about the vendor for that material, he can HIDE that data under those material numbers.

And when the user clicks the material number, another report (actually sub report/secondary list) which displays the vendor details will be displayed.

We can have a basic list (number starts from 0) and 20 secondary lists (1 to 21).

Events associated with Interactive Reports are:

1. AT LINE-SELECTION

2. AT USER-COMMAND

3. AT PF

[Former Member]

Hi,

1. Developed a report to display all purchase order whose goods receipt have been made but not invoiced.

2. Developed a Division wise Sales Analysis report.

3. Developed a report to display unconfirmed Purchase Orders.

4. Created a report to display a list of Sales orders, Ordered by customer who doesn’t have credit limit more

5. Developed a Stock Tracking report, which shows stock of various materials in various Storage locations.

6. Developed a report for customer out standings.

7. Developed a report for monthly dispatches.

8. Developed a report for displaying the vendor balances.

9. Created Vendor Performance report, which lists the vendor name, Materials Supplied, planned, Actual delivery items, Payment terms and Prices.

10. Created an Interactive Reports on blocked invoices.

11. Report to display all material rates by using Material number, Sales Organization, and Distribution Channel and condition type.

12. Developed a report which will list out all the purchase order details and the secondary list contains all the information about the supplier.

13. Developed an interactive report which displays the list of purchase requisitions in the basic list according to the user’s selection screen and which in turn allows the user to modify the purchase requisition in the secondary list.

14. Created an interactive report to list the purchase orders details for a vendor.

15. Created Report to Display the Details of Sales Quantity in the given date. Outputs Material No, Material Disc, Plant, current Month Sales, Previous Month Sales, Last Year same Month and Date (Quantity). Data was extracted from VBRK, VBRP.

16. Developed ABAP List View report program for Material Values to display list of all materials under a plant. Selection screen contains plant, material type.

17. Developed a Report To print report of all the items whose quantity is bellow re-order level.

18. Created a report to display sales order and dispatch details.

19. Developed a report to display the list of Inventory Differences by adding two new fields.

20. Developed AP aging report sort by Invoice date and Receipt date over dues Analysis.

21. Developed a report for mass selecting and printing Material Master Changed History.

22. Developed an interactive report to display sales orders for particular customer, items for particular order.

23. Developed a report that displays list of purchase requisition with details like MRP controller, release date and unit of measure.

24. Developed a report to display unused material numbers.

25. Developed vendor master analysis report, which lists the material including material number and storage location.

26. Developed an Interactive list for purchase requisitions at a given plant.

27. Developed a report to display list of purchase order details.

28. Developed a report, which lists delivery number, delivery quantity, customer number, material number and material description for a given shipping point.

29. Developed a report to display all sub-totals and grand totals for a particular vendor.

30. Developed a report that shows a list of purchase requisition and purchase orders for a selected vendor, by material group listing by material.

31. Developed a report to get list of purchase orders created during a particular month.

32. Developed the outstanding purchase order report based on acknowledgement date.

33. Developed material description report to display list of materials, language key, material description based on material type and plant.

34. Developed a report that lists purchase order entered into SAP, limit the selection to purchase order created during a specific period.

35. Created report, which will print the material stock, which will find out material group for material and find out the material description for each material.

36. Created an interactive report, which lists the customer details in the basic list. If the customer number is selected, the corresponding sales orders and item details will be displayed in the secondary lists. Drill down to transaction “MM03” is also provided.

37. Created utility report to copy batch characteristics from one batch to already existing another batch.

38. Created an ALV report to provide detailed information regarding all Materials by taking plant, material and material type as input.

39. Generated a warranty evaluation report.

40. Generated a report, which list out all the customers who have the warranty period for their product.

41. Developed a report to list warranty expired customers.

42. Created Vendor Performance Report that lists Vendor Name, Materials Supplied, Planned & Actual Delivery Times, Payments Terms and Prices.

43. Reports created to list out the sales documents created everyday, for credit approvals.

44. A report to monitor transportation details for delivery schedule.

45. Block for posting and mark for deletion all inactive vendors in all company codes and purchasing organization levels for period of 2 years.

46. Report to generate Material valuation.

47. Generated an interactive report, which will list out all the purchase order details and all the information about suppliers.

48. Generated a report listing stock position for a chosen material for chosen storage location in a given plant.

49. Developed a report on goods issue, which generate the information about how much stock issued to the customer according to the sales order for a particular period.

50. Delivery due list: This report program generates list with details of quantity available, quantity planned, quantity delivered and quantity still to be delivered for sales orders and stock transport orders based on shipping point.

51. Involved as a team member in generating interactive report program to give details on sales orders, vendors, customers for a particular material.

52. Created a report to display item, material, quantity, purchase order number, vendor and goods receipt date based on goods receipt number.

53. Developed an Interactive report that list out all the materials for a given plant. Secondary List contains Vendor who supplies the chosen material

54. Monthly warehouse report.

55. Report on customer payment, items cleared and discounts.

56. Material availability report.

57. Report on Dollar Value of Material, quantity on hand, average monthly quantity used.

Line item details for financial journal entries.

Financial gross sales margin.

Ending inventory balances.

58. Shippable details report.

59. Report for all blocked invoices.

60. Purchase order wise GR document and invoice receipt details line item wise.

61. Open sales order report. – VA05

&#61558; Created Classical and Interactive report to display all the Purchase Orders for the Purchasing Organization, Purchase groups and display the total, and individual values of all the Purchase Orders.

&#61558; Generated an Interactive report that displays vendor wise Purchase Order details.

62. Created an interactive report to display Sales Order data. In the basic list it displays the header data like SO number, created by, customer number etc., At the first level, SO screen and Customer master data is displayed by selecting appropriate item in the basic list. At the second level, report displays selected line item for the Sales order

63. Created a Report to display the pricing conditions in a sales order with standard details.

64. Created an report for purchase variance.

65. Created report to compute and display the list of outstanding orders by ship-to-party or sold-to-party.

66. A report on Sales Register: It lists the details like Invoice No, Date, Customer no, Sales value, Sales tax etc.

67. A Report to display the commissions for the sales department sorted by sales representative.

68. A Report to get the status of a particular delivery items with respect to a customer from specific shipping points over a given period.

69. A Report to show the list of Vendors with Blocked Payments.

70. An Interactive list showing all the Sales Areas, Customers of that sales area, Materials Ordered by them, information regarding materials and their net price.

71. An Interactive List displaying SO, Line Items which need to be delivered by certain Date.

72. An ALV Report for PO history for a particular period. Gives PO details based on specified company code, plant, Invoice receipt date and Vendor number.

73. An Interactive Report showing Vendor Information and his corresponding Bank Details.

74. Developed a report to compare the calculated average selling price for an item to a customer versus the current standard price for that item to that customer.

75. Developed a report to display Outstanding Quantity for Material.

76. Developed a report to drill down the displayed list, displaying the subsequent list of the line items for the selected purchase order.

77. Developed a report to display line item details information for financial journal entries.

78. Developed a report to List the Purchase Orders must allow the user to select the types of Purchase Orders.

79. Developed a report to displays all the Sales Orders processed to one particular customer for a given range of time.

80. Material Master Detail report for a given plant and material type, displaying material and plant depending on material.

81. •&#61472;&#61472;&#61472;&#61472;&#61472;&#61472;Sales Journal - which displays sales details for a particular plant in a particular period of time.

82. • developed a report to display the stock details.

83. Created a report for list of purchasing group for given plants. this report displays the list of plants, purchasing group, description of purchasing group according to the plant.

84. Created Vendor performance Report that lists vendor related details.

85. Developed a report to display Vendor master information and vendor bank details.

86. Developed a report to display all purchase orders whose goods receipt have been made but not invoiced.

87. Developed Division wise Sales Analysis report.

88. Developed a report to display unconfirmed Purchase Orders.

89. Developed a report to display list of Materials.

90. Created a report to display a list of Sales orders, Ordered by customer who doesn’t have credit limit more.

91. Developed a Stock Tracking report, which shows stock of various materials in various Storage locations.

92. Developed a report for customer out standings.

93. Developed a report for monthly dispatches.

94. Developed a report for displaying the vendor balances.

95. Created Vendor Performance report, which lists the vendor name, Materials Supplied, planned, Actual delivery items, Payment terms and Prices.

96. Created report, which will print the material stock, which will find out material group for material and find out the material description for each material.

97. Created an interactive report, which lists the customer details in the basic list. If the customer number is selected, the corresponding sales orders and item details will be displayed in the secondary lists. Drill down to transaction “MM03” is also provided.

98. Created utility report to copy batch characteristics from one batch to already existing another batch.

99. Created a Report to display the pricing conditions in a sales order with standard details.

100. Created an report for purchase variance.

100. Created report to compute and display the list of outstanding orders by ship-to- party or sold-to-party.

101. Created Classical and Interactive report to display all the Purchase Orders for the Purchasing Organization, Purchase groups and display the total, and individual values of all the Purchase Orders.

102. Generated an Interactive report that displays vendor wise Purchase Order details.

103. Created an interactive report to display Sales Order data. In the basic list it displays the header data like SO number, created by, customer number etc., At the first level, SO screen and Customer master data is displayed by selecting appropriate item in the basic list. At the second level, report displays selected line item for the Sales order.

104. Contract Compliance Report : This report looks at the actual customer purchases (QTY) by period vs. targeted quantities.

105. The report created will list all the contracts quantity vs. shipped quantity in the period specified for a given customer or material or sales organization or contract number along with details such as material numbers, contract start date, contract end date, etc.

106. Contract Expiration Report : Contracts need to be monitored and quotations sent out for renewal as they approach their expiry date. A report is required to show the contracts expiring.

107. This report will list all the contracts expiring in the period specified for a given customer or material or sales organization or contract number along with details such as equipment numbers, material numbers, contract start date, contract end date, etc.

108. Audit Trial For Pricing Conditions : This report tracks the manual changes made to the Pricing Conditions.

109. Back Order Report by Customer, Material or Product Line : The definition of a back order is an item, which cannot be shipped on the date necessary to meet the customer’s requested delivery date.

110. This caters the back order by customer, material or product line which is to be used by DS.

111. Match Confirmation Report : This program reports the discrepancies in characteristics between the materials and the machine for a given production version.

112. This report will compare characteristics of the material to the machine characteristics and lists any discrepancies between the characteristics. This will replace the current legacy report (Mismatch report). The program will provide information that will prevent the Company from producing products on the wrong modules that can lead to significant waste, rework and potential product recalls.

113. Invoice Out of Tolerance : This will report against the customer invoices that are below a predefined margin rate. This will be the primary indicator of pricing problem.

114. Here Customer invoices below a specified gross margin value are reported.

115. Pricing Override Report : When there is a legitimate need to override system proposed pricing, it should be documented for use in downstream decision making.

116. On demand report detailing overrides to the proposed system pricing along with override reason. This report will allow for analysis and possible adjustment of pricing conditions.

118. Classical & interactive reporting.

Production report, Stock Balancing report, Delivery Schedule,

Material dispatch Updation, Material Freight Updation,

Material wise serial number for production & dispatch, Valued Stock Report,

Machine Dispatch of RG1 (Excise Returns)..

Warranty Reports (Item wise, Dealer wise, Machine wise).

Warranty expenses of machines with in the warranty period and beyond warranty

Period.

List of failures value wise and frequency wise.

119. Delivery Performance Report - The delivery performance report is used to compare the customer delivery schedules with the deliveries created in SAP to determine whether they are early, on-time, or late. This measurement is done by comparing the customer request date against the goods issue date from the delivery.

120. Batch Level Inventory Report - This is a quick method to review all inventory that is in the entire plant or being more selective, in a particular storage location.

121. Sales by Subcontractor - This report presents sales numbers by subcontractor for a given plant or all plants.

122.Generated reports for Customer info and Waiting list.

1. Created an interactive report that displays sales order information like sales order number, order reason, sold to party and delivery status. The detailed list gives item data and delivery status.

2. Maintenance of existing reports. Made changes as per their requirements. Developed new reports related to SD and MM.

3. Another report that takes date and customer ranges as input and gives the invoice details. If the user select any of the invoice, it checks whether it is credit or debit based on that further details of the particular invoice would be displayed as an interactive report.

4. Interactive report which displays all the purchase orders for one particular customer, the items order for that particular order, quantity ordered, goods issue date and contact information about that customer.

5. Created report lists for the gross sales, credit returns, gross weight for the customer for the current year and comparing the same with that of the previous year for the same period. The data is selected from KNVV, BKPF, BSEG and MARA.

6. Report that lists the shipping point, loading point, transport partner name and the shipping date given the sales order number as user input.

7. Created an interactive list displaying sales orders and line items, which needed to be delivered by a certain date. Selection criteria were used to enter the specified delivery dates.

8. Developed a report which displays material wise Suppliers for a given plant.

9. Developed a report that displays Sales Analysis By Customer.

10. Developed a report that tracking down the invoices.

11. Developed Monthly Extract Report for Indirect Sales.

12. Developed a report program for displaying General Material data according to the selection of the material number and batch number by the user provided on the selection screen.

13. Report that displays all the late shipments in a particular period of time.

14. Developed vendor performance report that lists vendor name, material supplied, planned and actual delivery times, payment terms and prices.

15. Developed a report that displays a list of Purchase Requisitions.

16. Developed a report in material master that outputs valuated stock, grouped by material type and plant . Data was extracted from MARA, MARC, MARD, MAKT, EKKO, EKPO, MKPF, MSEG and T001W.

17.

[Former Member]

hi,

reporting is of two types

1. online reporting programs [module pool programming]

2. offline reporting prgs

2.1. classical reporting

2.2. interactive

alv is a tool in abap. and not any reporting type.

if helpful reward some points.

with regards,

Suresh Aluri.

[Former Member]

In ABAP, there are a total of 7 types of reports. They are:

Classical

Interactive

Logical Database

ABAP query

ALV Reports (ALV stands for ABAP List Viewer)

Report Writer/Report Painter

Views (There are different types of views also)

[Edit section] Classical Reports

These are the most simple reports. Programmers learn this one first. It is just an output of data using the Write statement inside a loop.

Classical reports are normal reports. These reports are not having any sub reports. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT.

Events In Classical Reports.

INTIALIZATION: This event triggers before selection screen display.

AT-SELECTION-SCREEN: This event triggers after proccesing user input still selection screen is in active mode.

START OF SELECTION: Start of selection screen triggers after proceesing selection screen.

END-OF-SELECTION : It is for Logical Database Reporting.

[Edit section] Interactive Reports

As the name suggests, the user can Interact with the report. We can have a drill down into the report data. For example, Column one of the report displays the material numbers, and the user feels that he needs some more specific data about the vendor for that material, he can HIDE that data under those material numbers.

And when the user clicks the material number, another report (actually sub report/secondary list) which displays the vendor details will be displayed.

We can have a basic list (number starts from 0) and 20 secondary lists (1 to 21).

Events associated with Interactive Reports are:

AT LINE-SELECTION

AT USER-COMMAND

AT PF<key>

TOP-OF-PAGE DURING LINE-SELECTION.

HIDE statement holds the data to be displayed in the secondary list.

sy-lisel : contains data of the selected line.

sy-lsind : contains the level of report (from 0 to 21)

Interactive Report Events:

AT LINE-SELECTION : This Event triggers when we double click a line on the list, when the event is triggered a new sublist is going to be generated. Under this event what ever the statements that are been return will be displayed on newly generated sublist.

AT PFn: For predefined function keys...

AT USER-COMMAND : It provides user functions keys.

TOP-OF-PAGE DURING LINE-SELECTION :top of page event for secondary list.

[Edit section] Logical Database Reports

Logical database is another tool for ABAP reports. Using LDB we can provide extra features for ABAP reports.

While using LDB there is no need for us to declare Parameters.

Selection-screen as they will be generated automatically.

We have to use the statement NODES in ABAP report.

If there are many tables the Performance will be slow as all the table data will be read from top node to bottom node .

[Edit section] ABAP Query Reports

ABAP query is another tool for ABAP. It provides efficency for ABAP reports. These reports are very accurate.

Transaction Code : SQ01

The advantage with ABAP QUERY is logic required for classic & interactive reports system design automatically 80%.

For ABAP QUERY handle these

SQ01 ; QUERY

SQ02 : INFOSET OR FUNCTIONAL AREA

SQ03: USER GROUP.

[Edit section] Report Writer

Key Concept :

Super users and end users can use Report Painter/Report Writer tools to write their own reports.

Giving them the ability to report on additional fields at their discretion shifts the report maintenance burden to them, saving SAP support groups time and effort normally spent creating and maintaining the reports.

Instead of using ABAP code to write a report in FI and CO, many users build a Report Painter/ Report Writer library using transaction MC27.

However, this workaround has some drawbacks. Little known transaction GRCT solves these problems in most cases, and eliminates the need to use transaction MC27.

[Edit section] ABAP Report Types

ABAP report types are those ones available in some report's attributes screen, i.e. :

Executable program

Function group (containing function modules)

Include

Interface pool

Class pool

Module pool

Subroutine pool

Also ALV means ABAP List Viewer. Most convenient way to use it is through reuse library (cf. transaction se83) available from release 4.6 of SAP R/3.

ALV is available in two modes: list and grid. List mode is good old list processing with standard functionnalities, and grid mode is using a new OCX object displaying grids.

[Former Member]

Hi Guru,

In ABAP, there are a total of 7 types of reports. They are:

Classical

Interactive

Logical Database

ABAP query

ALV Reports (ALV stands for ABAP List Viewer)

Report Writer/Report Painter

Views (There are different types of views also)

[Edit section] Classical Reports

These are the most simple reports. Programmers learn this one first. It is just an output of data using the Write statement inside a loop.

Classical reports are normal reports. These reports are not having any sub reports. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT.

Events In Classical Reports.

INTIALIZATION: This event triggers before selection screen display.

AT-SELECTION-SCREEN: This event triggers after proccesing user input still selection screen is in active mode.

START OF SELECTION: Start of selection screen triggers after proceesing selection screen.

END-OF-SELECTION : It is for Logical Database Reporting.

[Edit section] Interactive Reports

As the name suggests, the user can Interact with the report. We can have a drill down into the report data. For example, Column one of the report displays the material numbers, and the user feels that he needs some more specific data about the vendor for that material, he can HIDE that data under those material numbers.

And when the user clicks the material number, another report (actually sub report/secondary list) which displays the vendor details will be displayed.

We can have a basic list (number starts from 0) and 20 secondary lists (1 to 21).

Events associated with Interactive Reports are:

AT LINE-SELECTION

AT USER-COMMAND

AT PF<key>

TOP-OF-PAGE DURING LINE-SELECTION.

HIDE statement holds the data to be displayed in the secondary list.

sy-lisel : contains data of the selected line.

sy-lsind : contains the level of report (from 0 to 21)

Interactive Report Events:

AT LINE-SELECTION : This Event triggers when we double click a line on the list, when the event is triggered a new sublist is going to be generated. Under this event what ever the statements that are been return will be displayed on newly generated sublist.

AT PFn: For predefined function keys...

AT USER-COMMAND : It provides user functions keys.

TOP-OF-PAGE DURING LINE-SELECTION :top of page event for secondary list.

[Edit section] Logical Database Reports

Logical database is another tool for ABAP reports. Using LDB we can provide extra features for ABAP reports.

While using LDB there is no need for us to declare Parameters.

Selection-screen as they will be generated automatically.

We have to use the statement NODES in ABAP report.

If there are many tables the Performance will be slow as all the table data will be read from top node to bottom node .

[Edit section] ABAP Query Reports

ABAP query is another tool for ABAP. It provides efficency for ABAP reports. These reports are very accurate.

Transaction Code : SQ01

The advantage with ABAP QUERY is logic required for classic & interactive reports system design automatically 80%.

For ABAP QUERY handle these

SQ01 ; QUERY

SQ02 : INFOSET OR FUNCTIONAL AREA

SQ03: USER GROUP.

[Edit section] Report Writer

Key Concept :

Super users and end users can use Report Painter/Report Writer tools to write their own reports.

Giving them the ability to report on additional fields at their discretion shifts the report maintenance burden to them, saving SAP support groups time and effort normally spent creating and maintaining the reports.

Instead of using ABAP code to write a report in FI and CO, many users build a Report Painter/ Report Writer library using transaction MC27.

However, this workaround has some drawbacks. Little known transaction GRCT solves these problems in most cases, and eliminates the need to use transaction MC27.

[Edit section] ABAP Report Types

ABAP report types are those ones available in some report's attributes screen, i.e. :

Executable program

Function group (containing function modules)

Include

Interface pool

Class pool

Module pool

Subroutine pool

Also ALV means ABAP List Viewer. Most convenient way to use it is through reuse library (cf. transaction se83) available from release 4.6 of SAP R/3.

ALV is available in two modes: list and grid. List mode is good old list processing with standard functionnalities, and grid mode is using a new OCX object displaying grids.

[Edit section] Links

More information .

<b>http://wiki.ittoolbox.com/index.php/How_many_types_of_reports_are_there_in_ABAP_and_what_is_the_difference_between_them%3F</b>

<b>Regards,

Jackie.</b>