Building a simple BSP Application to retrieve Material information

...Previous

In the ‘Event Handler’ tab, under ‘OnInputProcessing’ tab, write the code as shown below or copy and paste the code that is given below. 

Code under ‘OnInputProcessing’. 

CASE EVENT_ID.

  WHEN 'select'.

    NAVIGATION->SET_PARAMETER( 'matnr' ).

SELECT * FROM MARA INTO TABLE I_MARA WHERE MATNR BETWEEN MATNR AND MATNR2.

  WHEN 'materials'.

SELECT * FROM MARA INTO TABLE I_MARA.

  WHEN OTHERS.

ENDCASE.

Click on the BSP application name and input as shown below. 

Save, check and activate the BSP application and then execute the application. The page would be displayed as shown below.

Enter the material numbers in the textboxes and then click on ‘Get details’. 

The output would be as follows.

The output is a result of the select query that we fired selecting the specified set of fields.

Click on the ‘Get all’ button to get the output as follows.

Remember, we have fired a select query selecting all the records from the database table ‘MARA’ and are displaying it.