Modify Standard Search Help For Field MATNR 

We need to modify the standard collective search help for material and vendor master.
In this we need to filter all the material master records for which there is a deletion flag (LVORM = X).
How can we do this?

Answer:

Search help for Field MATNR is MAT1. 

- Go to SE11 set radio button to Search help Enter MAT1 next to it.

- Go to tab "Included Search helps" and click MAT1_A. 

- In that go to Tab "Included search helps" and click "MAT0M". 
There are many helps, this is basically the tabs shown when you press F4 in the MATNR field. 

- In the definition Tab - Selection method - M_MAT1M is shown.
This is the search help database view. 

So first check in which Tab you do want to show the material that is marked for deletion. 

Here I have taken - M_MAT1M, Material Number/Material Description. 

- Click the M_MAT1M and it goes to Database View. 

- Click Change. 

- In the "View flds" Tab, include LVORM in the "View Field" column 

- In the "Selection Conditions" Tab, 
Enter the following in the columns: 

- Table - MARA 

- Fieldname - LVORM 

- Operator - EQ 

- Comparative Value - ' ' 

- and save it. 

SAP MM Tips

Get help for your SAP MM problems
SAP MM Forums - Do you have a SAP MM Question?

SAP MM Books
SAP Material Management Certification, Interview and Configuration Reference Books

SAP Material Management Tips
SAP MM Configuration Tips and Materials Management Discussion Forum

Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.erpgreat.com

All the site contents are Copyright © www.erpgreat.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies.  The site www.erpgreat.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity.  Information used on this site is at your own risk.
 The content on this site may not be reproduced or redistributed without the express written permission of
www.erpgreat.com or the content authors.