Skip to Content
Author's profile photo Ingo Woesner
Ingo Woesner
March 5, 2009 1 minute read

Enhanced Material Search with Creation – Part 4: How to create new Search Criteria w/o modification

Blogs about the Enhanced Material Search:

*********************************************************  
The Enhanced Material Search with Creation can be enhanced modification-free with additional customer specific Search Criteria via the Search Engine Service in the TREX index for standard materials and on the dynpro UI of the Enhanced Material Search.

**** if you are using Enterprise Search / Embedded Search this article is not applicable > please read this blog ****

Through this simple development steps you are able to create and use your own search criteria in Enhanced Material Search.
Here is how it works:
Step 1: Get customer specific field information into TREX
In the first step please follow SAP note 1131559 Symptom 2 (create a copy of the standard class CL_WSD_ERP_SE_BUS1001006 and extend the class with your own data fields you would like to include in the TREX index BUS1001006.

In case you copied the existing class you have to maintain the new class in customizing:

Go to transaction ses_Admin > goto > Customizing > Business Objects and Indexes > select “BUS1001006”, double click on “Settings for Business Object” and maintain the new class.

In any case (new class or modification of the extsing class) you have to delete the whole index BUS1001006, and recreate it again. After recreation, you have to run a full indexation.

If you would like to use your own Search Criteria on the UI screen of the Enhanced Material Search follow step 2:
Step 2: create own search criteria on the UI of the Enhanced Material Search
To use additional search parameters in the Enhanced Material Search functionality you have to append the additional fields to the existing structure WSD_MS_INPUT_FIELDS .
Definition of the additional fields within the DDIC: Component and component type are always the data element of the additional field itself.
Afterwards you can define these fields as search criteria within the Enhanced Material Search in IMG: Logistics General > Material Master > Enhanced Material Search with Material Creation > Define Search Parameters for Material Search.
That’s it. Enjoy!
Best regards,
Dr. Ingo Woesner

Product Manager
Suite Development – Multi Channel

SAP AG

P.S. Blogs about this and other Sales Order Enhancements are collected here:
Sales Order Enhancement Series: Overview

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member
      Hi Ingo,

      In reference to step 1 where we add our own fields to the Full test search. We are trying this out in our developmenet box and have followed all the steps outlined in the OSS note.

      In testing we find that if we populate full text with the full content of the value in the new field and leave Fuzzy Search Un-checked we recieve the material expected. However the same search with Fuzzy mode checked does not return a result.

      Is there another step that needs to be considered to make this new field work in Fuzzy Mode? 

      thanks,

      regards,

      Kevin.

      Author's profile photo Ingo Woesner
      Ingo Woesner
      Blog Post Author
      Hi Kevin,

      this must be an error. Please create an OSS ticket on component SD-MD-MM-CS for this problem.

      Please let me know the OSS ticket number on ingo.woesner@sap.com

      Thank you,
      Ingo

      Author's profile photo chirantan chanana
      chirantan chanana

      Hi Ingo,

      I am trying to add a Storage Location to Material Search(VA02). As you have stated above. I have completed Step 1 and Step 2 as well.

      However, when I go to VA02 and try Enhanced Material Search I get a message -

      -------------------------------------------------------------------------------------------------

      Material search customizing has invalid entry;  - <fieldname>

      Message no. WSD_MESSAGE007

      Diagnosis

      The Enhanced Material Search Customizing contains an entry unsupported either by the Search Engine Service (SES) business object class or by the component.

      System Response

      The exception text displays the relevant attribute name.

      Procedure

      Ensure that all Customizing table attribute names are spelled properly and are supported by both the component and the SES business object class.

      Procedure for System Administration

      Ensure that a valid SES business object class is specified for the material master business object.

      ------------------------------------------------------------------------------------------------------------------------

      I have double checked the attribute many times and it is OK.Am I missing something.

      Any advice.

      PS : Is there any config at TREX side that needs to be done?

      Thanks,

      Chirantan

      Author's profile photo Ingo Woesner
      Ingo Woesner
      Blog Post Author

      Hi Chirantan,

      this can't be much.

      Did you modify the existing TREX class  CL_WSD_ERP_SE_BUS1001006or created a new one? 

      In case you created a new one you have to maintain the new class in customizing:

      Go to transaction ses_Admin > goto > Customizing > Business Objects and INdexes > select "BUS1001006" and doubleclick on "Settings for Business Object" and maintain the new class.

      In any case (new class or modification of the extsing class) you have to delete the whole index BUS1001006, and recreate it again. After recreation, you have to run a full indexation.

      If this doesn't help please open an OSS ticket on component SD-MD-MM-CS.

      Best regards,

      Ingo

      Author's profile photo chirantan chanana
      chirantan chanana

      Thanks Ingo..I ran a few test runs using COM_SE_SEARCH_TEST and it seems to be working fine now. It would be safe to assume that attribute has been added to TREX Engine and is working in expected manner.

      However, I am still get the same message as earlier -

      "Material search customizing has invalid entry;  - <fieldname>"....

      Would it be correct to state that something is still not right in the second step?

      Thanks again for your help.

      Thanks,

      Chirantan

      Author's profile photo Ingo Woesner
      Ingo Woesner
      Blog Post Author

      Hello Chirantan,

      please create an OSS ticket on component SD-MD-MM-CS and send me the ticket number to ingo.woesner@sap.com

      I am curious to see the reason of the error. In case I missed something in the blog I will add the missing part.

      Best regards,

      Ingo

      Author's profile photo Richard Graf
      Richard Graf

      Hello Ingo,

      I have a little question about the dynamically generated search criteria screen.

      We have successfully added the 2 fields VKORG & VMSTA as search criteria (in structure WSD_MS_INPUT_FIELDS and in customizing).

      The program works fine, but the dynamically generated screen 0110 of the FG WSD_MATERIAL_SEARCH has now the status Inactive.

      So every time, when I activate any other program, I get the popup window with a list of all inactive objects (including this screen). But as it is in the SAP namespace, I cannot activate it without a modification key.

      Is it normal, that it gets inactive and how can we activate it again without a modification key?

      Thanks & Best regards

      Richard

      Author's profile photo Ingo Woesner
      Ingo Woesner
      Blog Post Author

      Hi Richard,

      I am no developer. Please open a ticket on component LO-GEN-EMF. I am sure the support colleagues will help you. Please refer to our discussion here.

      Best regards,

      Ingo

      Author's profile photo Richard Graf
      Richard Graf

      Hi Ingo,

      thanks for your reply, I'll do that. 🙂

      Best regards

      Richard

      Author's profile photo Richard Graf
      Richard Graf

      Hello,

      FYI, SAP created the S-Note 2170482 in response to our ticket.

      https://websmp130.sap-ag.de/sap(bD1kZSZjPTAwMQ==)/bc/bsp/sno/ui_entry/entry.htm?param=69765F6D6F64653D3030312669765F7361706E6F7465735F6E756D6265723D3231373034383226

      Best regards

      Richard

      Author's profile photo Oliver Butz
      Oliver Butz

      Dear Ingo,

      I try the link for the doc -4022 but it failed.

      **** if you are using Enterprise Search / Embedded Search this article is not applicable > please read this blog ****

      We have an SAP S74HANA 2021 system , and I thougth that your blog is only for ERP system with T-Rex , but in S/4 it changed .

      So i'm interested on information to extend the enterprice search w/o mondification with fields from our own tables. Is there a blog which explain it ?

      The standard help in our system explain unfortunatly only the T-rex based configuration, as well described in your blog.

       

      Where can I find the right information ?

      Regards Oliver

      Author's profile photo Ingo Woesner
      Ingo Woesner
      Blog Post Author

      Hi Oliver,

      I admit I wrote the blog some 15 years ago, and since then a lot has changed.

      I tested the Enhanced Material Search in S/4 with TREX (not Embedded Search) in 2019 - and the TREX worked very well.

      I think someone told me at that time that the Enterprise Seaerch was long gone, and the search that is embedded in S/4HANA is not the same with Enterprise Search, so the Enhanced Material Search is not compatible and/or supported with the build-in search in S/4.

      So you have to work with TREX.

      I hope this helps. All developers are long gone, retired, in new areas etc., including myself.

      I still see the Enhanced Material Search a fantastic tool for a wholesale business or a business where sales stock is in warehouses ready to ship.

       

      I hope this helps. I am happy to support you further in case you have questions, but I am no developer, so I can't help you with ABAP ...

       

      Best regards,

      Ingo