Skip to Content
avatar image
Former Member

Formatted Search Through SDK

Hello All,

I have created a user defined field in Sales Order Form named 😔 ItemDetail )

I want to allocate a formatted search in that field with query as follows :-

Select ItemName From OITM Where ItemCode Like %$[RDR1.ItemCode]

Now i know how to assign a Formatted search from the Front end screen .

But i want to assign the Formated Search through SDK.

How to code the Formatted Search in SAP using SDK in SAP 8.8

Thanks & Regards,

Amit

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 21, 2010 at 05:31 PM

    I wrote some code a long time ago to do what you are asking. I needed to use the SDK to create multiple formatted searches and each of them to several fields. So I wrote some generic subroutines that are probably alot more complicated than you need but I'm posting the code. Hopefully you will be able to dicipher it.

    I'm going to put the code in a second post because it is not formatting correctly here.

    Edited by: John Chadwick on Jun 21, 2010 1:37 PM

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      FYI

      Formatted Search can be defined also via SAP B1 Gui.

      Steps:

      1. Create a Custom Query you would like

      2. open your form, go to the required field and press SHIFT+F2

      3. Link your query to the field. (no refresh nesessary)

      4. Go to your addon, and when you press the TAB key on the required field (ET_KEY_DOWN event) activate menuitem SHIFT+F2 (menu id: 7425)