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

reg search help

Hi Gurus,

Infact i have a situation where in i create a user defined search help and have

two fields like kunnr and name1 but i need is that kunnr should get populated

in the select option and i want to use name1 field value in my select statement.

Thanks in advance

PA

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 12:48 PM

    Hi.

    Hope u may try this.

    data : t_return like ddshretval occurs 0 with header line.

    select-options s_kunnr for kna1-kunnr.

    At selection-screen on value-request for s_field-low.

    select kunnr name1 from kna1 into corresponding fields of table itab.

    call function 'F4IF_INT_TABLE_VALUE_REQUEST'

    exporting

    retfield = 'KUNNR'

    dynprofield = 'S_Kunnr'

    dynpprog = sy-cprog

    dynpnr = sy-dynnr

    value_org = 'S'

    tables

    value_tab = itab.

    return_tab = t_return.

    if sy-subrc = 0.

    read table t_return index 1.

    s_kunnr-low = t_return-fieldval.

    read table itab into wa_itab where kunnr = s_kunnr-low.

    if sy-subrc = 0.

    name1 = wa_itab-name1.

    endif.

    endif.

    start-of-selection.

    **here u may use the name1 field for ur select statement.*

    Regards

    Bala..

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 02, 2007 at 06:47 AM

    HI

    write a condition for that like this

    TYPES : BEGIN OF ST_OBJID_SH,

    OTYPE TYPE HRP1000-OTYPE,

    OBJID TYPE HRP1000-OBJID,

    END OF ST_OBJID_SH.

    DATA : IT_OBJID_SH TYPE STANDARD TABLE OF ST_OBJID_SH.

    DATA : WA_OBJID_SH TYPE ST_OBJID_SH.

    ***********SELECTION SCREEN DESIGN***********************

    SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.

    *SELECT-OPTIONS : S_OTYPE FOR HRP1001-OTYPE NO INTERVALS .

    SELECT-OPTIONS : S_OBJID FOR HRP1001-OBJID NO INTERVALS .

    SELECT-OPTIONS : DATE FOR SY-DATUM NO-EXTENSION OBLIGATORY.

    SELECTION-SCREEN END OF BLOCK B1.

    **********END OF SELECTION SCREEN DESIGN*****************

    AT SELECTION-SCREEN ON VALUE-REQUEST FOR S_OBJID-LOW.

    • IF S_OBJID IS NOT INITIAL.

    SELECT OTYPE OBJID FROM HRP1000

    INTO TABLE IT_OBJID_SH

    WHERE OTYPE = 'D'.

    IF SY-SUBRC EQ 0.

    • SEARCH HELP FOR QUALIFICATION.

    CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

    EXPORTING

    • DDIC_STRUCTURE = ' '

    RETFIELD = 'OBJID'

    • PVALKEY = ' '

    DYNPPROG = SY-REPID

    DYNPNR = SY-DYNNR

    DYNPROFIELD = 'S_OBJID'

    • STEPL = 0

    • WINDOW_TITLE =

    • VALUE = ' '

    VALUE_ORG = 'S'

    • MULTIPLE_CHOICE = ' '

    • DISPLAY = ' '

    • CALLBACK_PROGRAM = ' '

    • CALLBACK_FORM = ' '

    • MARK_TAB =

    • IMPORTING

    • USER_RESET =

    TABLES

    VALUE_TAB = IT_OBJID_SH

    • FIELD_TAB =

    • RETURN_TAB = RETURN_TAB

    • DYNPFLD_MAPPING =

    • EXCEPTIONS

    • PARAMETER_ERROR = 1

    • NO_VALUES_FOUND = 2

    • OTHERS = 3

    .

    IF SY-SUBRC <> 0.

    • MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

    • WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

    ENDIF.

    ENDIF.

    .

    Add a comment
    10|10000 characters needed characters exceeded

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.