Material Search Help With Stock Details

The input help (F4 help) is a standard function. Users can display list of all possible values for a screen field with the input help.

This search help is designed using combination of collective and elementary search helps.

This attached document illustrates search help for material, by doing this Business can view the stock available in Quality as well as unrestricted while creating PR/PO.

Procedural Steps :

1. Decide fields required in search help.

2.Identify corresponding database tables from  where these fields  can  be retrieved.

3.Create  Database View using  above mentioned tables and fields.

4.Create Elementary Search help using above view.

5.Maintain Search Help and parameter Assignment.

6.Check   whether new Search   help appears in any transaction where material field is present.

Step : 1 Below are the fields considered for material search help with[Stock]

1.  LABST [Valuated Unrestricted- Stock]

2.  MATNR [Material Number]

3.  WERKS [Plant]

4.  INSME [Stock in Quality Inspection]

5.  MAKTX [Material Description (Short Text)]

6.  LVORM [Flag Material for Deletion at Storage Location Level]

7.  SPRAS [Language Key]

The  above mentioned  fields are available in MARD and MAKT.

Step : 2 Create Data base view using above mentioned tables and fields.

Now go to T-Code SE11and specify a view name and click on create button as shown below.

Enter the name [Z_MAT_STOCK_VIEW]  and click the create icon.

Select the database view and click copy tab.

Now enter the short description for the view. In table/Join Conditions Tab, Specify the tables MARD and MAKT.  And also mention the table joins conditions as below.

Since the material description is not available in one of the table’s referred, it’s necessary to make a join condition. Common fields of the table are MATNR.

In view field tab specify the fields required.

In the selection conditions tab specify the following.

Here  in the above  screen  WERKS equal to plants[For Example : 0001,0002] as shown above.

In Maint. Status tab specify-Access Read  only  and “Display/Maintenance allowed with Restrictions” Save this view. Assign correct package.

Check and Activate.

Step  4: Create  elementary search  help using  the  above  view, now go  to transaction SE11 and specify  the
search  help  name [Z_MAT_STOCK_VIEW_1]and click on create icon.

Now click on the create icon.

Specify short description for this search help.  This description will appear as heading of the tab in collective
search for material. Specify view Z_MAT_STOCK_VIEW as Selection method. Specify “dialog with
value restriction “in Dialog type.

Specify   Search   help   parameters using   Z_MAT_STOCK_VIEW_1   view fields.

LVORM and SPARS default values are given as X [Deletion flag marked] and language EN.

Check all search help parameters with IMP (Import).

Check MATNR search help parameters with EXP (Export).

Specify  position in List and  Search areas.(for ex: give  1,2,3,4,5 in both  the columns).

Save and Activate.

Assign  the correct package.

Step 4: Maintain Search Help and parameter Assignment

SPRO    Logistics  
General   Material    Master     Tools    Maintain    Search Helps

Select maintain in Logon Lang

 

Now
select the included search helps
tab.

Now select the included search helps tab.

Now select a row and click on insert row icon, and specify the search help view we have created in
the previous step.

Now click on parameter assignment tab and click enter.

Finally save and activate.

Step 5: Check whether the new  material search  help  appears in transaction where material field is present.

Note: This material search  help will be applicable on all transactions where material search  field is there.

GO to Transaction MM03 to check the output.

Here  in the  above  screen  in unrestricted am giving 50, which will display all the material with stock level of 50 in unrestricted stock.