Classical Reports

Classical Reports

• Simplest form of reports.
• Display data from the database on the basis of selection criteria.
• Level of reporting is only ONE.
• We will use the “SELECT” statement to retreive data from the tables

The below program displays Material details from MARA(Material Master)
Step1 Write the below code in the ABAP Editor (SE38)

Step2: After Activating and Executing the above program the below Selection Screen is displayed.

Step 3: Output List.

Classical Report giving details of Material Master are displayed.

Retrieving data from more than one table

In order to retrieve data from multiple table we have to use ‘JOINS’
SELECT * FROM tabref1 [INNER] JOIN tabref2 ON cond
In a relational data structure, it is quite normal for data that belongs together to be split up across several tables to help the process of standardization. To regroup this information into a database query, you can link tables using the join command. This formulates conditions for the columns in the tables involved. The inner join contains all combinations of lines from the database table determined by tabref1 with lines from the table determined by tabref2, whose values together meet the logical condition (join condition) specified using ON>cond.