topic Search using Long Text in Application Development and Automation Discussions

Search using Long Text

Former Member — Wed, 23 Apr 2008 07:56:07 GMT

Material Master standard search help provides for searching via short text in the master. Is it possible to create a custom search on the long text maintained in Purchase Order Text or Basic Data Text tabs of the master? What could be the approach?

Alternatively, can we create a report which can work on Long Text as a selection field?

Regards

Sriram

Re: Search using Long Text

Former Member — Wed, 23 Apr 2008 08:04:23 GMT

Hi,

1.Custome long text creation is possible.

We will need the same parameters for saving the text as well. The function modules that you can use for this will be SAVE_TEXT followed by COMMIT_TEXT. The parameters play a very important roles as you might not see the saved text in the standard transaction if you give wrong parameter values.

CALL FUNCTION 'SAVE_TEXT'

EXPORTING

CLIENT = SY-MANDT

HEADER =

INSERT = ' '
SAVEMODE_DIRECT = ' '
OWNER_SPECIFIED = ' '
LOCAL_CAT = ' '
IMPORTING
FUNCTION =
NEWHEADER =

TABLES

LINES =

EXCEPTIONS
ID = 1
LANGUAGE = 2
NAME = 3
OBJECT = 4
OTHERS = 5

IF SY-SUBRC <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

CALL FUNCTION 'COMMIT_TEXT'

EXPORTING
OBJECT = '*'
NAME = '*'
ID = '*'
LANGUAGE = '*'
SAVEMODE_DIRECT = ' '
KEEP = ' '
LOCAL_CAT = ' '
IMPORTING
COMMIT_COUNT =
TABLES
T_OBJECT =
T_NAME =
T_ID =
T_LANGUAGE =

Regards,

Shiva.

Re: Search using Long Text

Former Member — Wed, 23 Apr 2008 08:15:11 GMT

Hi Shiva

Not sure you understood the question, I am asking if it is possible to create custom search help for long text in the material master dropdown field.

Regards

Sriram