Skip to Content
author's profile photo Former Member
0
Former Member

how to add keyword functionality as a search tool in a program

Posted on Dec 03, 2007 at 03:39 AM 14 Views

Hi!

Good day.

I would like to inquire as to how I can add a search tool using certain keywords in a program? You see, the program I am developing stores data in a custom table. However, I am assuming that sooner or later the table will have plenty of data that it will be difficult to search for a particular data. That is why I am asking how to use search using keywords.

For example: For data "Car Manufacturer Information", I want that I will just input "Manufacturer" on the search field then the program will display all data that has the word "Manufacturer". How can this be done?

If there is a function module or an ABAP program for this, please let me know.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 04:49 AM
    1

    Hi,

    Try to use function module HELP_VALUES_GET_WITH_TABLE.

    In this function module just pass field name on which you want to search, then this can check that particular word in that field value for all the records.

    ALso table name, and search criteria.

    Thanks & Regards,

    Dipika.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Dec 04, 2007 at 01:46 AM

      Hi!

      We tried using the function module youe mentioned but it is already an obsolete function module. Do you happen to know of other function modules that can help us with the keyword functionality?

  • author's profile photo Prashant Patil
    Prashant Patil
    Posted on Dec 04, 2007 at 03:29 AM
    1

    Hi,

    Write a select query:

    Select * from ZTABLE into itab
where text cp 'Manufacturer'.

    Best regards,

    Prashant

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Dec 05, 2007 at 02:36 AM

      Hi! I have tried placing a select query but there's an error that occurs. The error states that "CP is not a valid comparison operator" when it was placed in the WHERE clause of the SELECT statement. How can this be corrected?

  • author's profile photo Sampath Adavelly
    Sampath Adavelly
    Posted on Dec 05, 2007 at 03:09 AM
    0

    Hi gino,

    Select -

    where text CP 'Manufacturer' is right answer. If you get error on that statment, you would probably check the field that is used in where clause.

    or try the following statement. Hope this will helps.

    select -

    where text = '%manufacturer%'.

    I think it will then become a performance issue. Explain it clearly that what exactly you want and where is this being used.

    Do you want some thing like search help? Example: customer number search from any customer field. If so try to create a search help and add the same to your custom field.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Dec 05, 2007 at 03:16 AM

      Hi!

      Actually, what I am trying to do is add something like a search help in the program. The data being stored in a custom table will have something like a keyword which can be used by the user as a search help.

      For example, if my table has the ff data:

      Cologne for Men

      Body Spray for Men

      Ladies Magazine

      Men of the Year

      When I input the word "Men" on the selection field, I want that all the data containing the word "Men" will be displayed. In this way, it kind of acts like a search help or something.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.