Thursday, February 3, 2011

Building a simple BSP Application to retrieve Material information

Go to transaction SE80. Select BSP application and input the name of the BSP application that you want to create.

Save and activate the application.

Right click on the application name and click àcreateàpage.

The resultant window appears as follows.

Enter the name of the page that you want to create. In this case it is the ‘default.htm’ that I am creating.

Enter the description of the page and click on ‘continue’.

Click save.

You can observe the ‘pages with flow logic’ and under that you can find ‘default.htm’ page in the BSP application tree.

Change the code in the layout as shown in the image below or copy and paste the code given below in the layout window.



<%@ page language="abap" %>


MATERIAL DETAILS


  Material Number







   <% data: wa_mara type mara. %>

<% if i_mara is not initial. %>
   





<% loop at i_mara into wa_mara. %>





<% endloop. %>
 <% else. %> 
 


 
 <% loop at it_mara into S_mara. %>
 



 

<% endloop. %>
<% endif. %>
MATNR ERSDA LAEDA VPSTA
<%= wa_mara-matnr %> <%= wa_mara-ersda %> <%= wa_mara-laeda %> <%= wa_mara-vpsta %>
MATNR ERSDA LAEDA
<%= S_mara-matnr %> <%= S_mara-ersda %> <%= S_mara-laeda %>





Create the page attributes as shown below.

Save, Check and activate the BSP application and execute. Enter the login name and password in the pop-up that appears.

The BSP page looks as shown below.





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.



No comments:

Tutorials on SAP-ABAP

Adobe Interactive Forms Tutorials

Business Server Pages (BSP)

Userexits/BADIs

Web Dynpro for ABAP (Step by step procedure for web dynpro,Tutorials on Web Dynpro,)

ALV Tutorials

Blog Archive

goodsites