Mass Display Report for Material Characteristics

After a long break, I’m back with another ABAP report. In this report, we will display the characteristic values entered under the material class in the material master data as a structured report for the user.

As seen in the screens above, navigating through materials to view the characteristics entered in the material master data collectively can be a challenge. As a solution to this issue, we have designed a report that takes the following input:

As a result, we will develop a report that generates output in the following format.

First Step: Defining Variables and Parameters for the Report

To begin, we will define the variables and declarations that will be used in our report.

Once the necessary declarations are in place, we will define the parameters that we will receive from the user.

In the START-OF-SELECTION section, we check whether either the material number or material groups are filled. If both are empty, the process is canceled using the CHECK statement.

Next, the required data is queried and transferred into the GT_METADATAS table using the query below.

Since characteristic values may have unit definitions, we retrieve the unit descriptions from the T006A table. However, not all characteristic values have a unit of measure, so we use a LEFT JOIN to link the tables. Due to the LEFT JOIN rule, we cannot directly filter for a single language, so in line 17, we remove entries from GT_METADATAS that do not have an empty language definition and do not match the user’s input language.

After retrieving the data, we need to convert numeric values, which are in scientific notation (e.g…