search help in output(using alvgrid function module)

[Former Member]

HEllo Experts,

I hav developed report using ALV grid function module, now my req is I need to provide the search help for particular field in the output.

my output contains .MATNO, PLANT AND STORAGE LOCATION.

Now based on mat and plant I need to provide the F4 help for storage location field in the out put.

could u pls anbody help me on the req asap. with details code.

will give u Full point if it suits my req....

[Former Member]

Hi Raja,

This is what you can try to do....first select the sales org and distribution channel for the value entered in the material in an 2 separate internal tables.

Then use the FM 'F4IF_INT_TABLE_VALUE_REQUEST' for each internal table to get a search help for the sales org and distribution channel for any particular material number.

Please write the code at AT SELECTION-SCREEN ON VALUE-REQUEST event.

or,

try this code.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_salesorg.

select salesorg from tablename into itab where matnr = p_matnr(selction screen value).

if sy-subrc eq 0.

CALL FUNCTION 'POPUP_WITH_TABLE_DISPLAY'

EXPORTING

ENDPOS_COL =

ENDPOS_ROW =

STARTPOS_COL =

STARTPOS_ROW =

• TITLETEXT =

TITLETEXT =

IMPORTING

CHOISE = W_LINEN0

TABLES

VALUETAB = itab

EXCEPTIONS

BREAK_OFF = 1

OTHERS = 2.

IF SY-SUBRC EQ 0.

READ TABLE itab INDEX W_LINENO.

IF SY-SUBRC EQ 0.

P_salesorg = itab-salesorg.

endif.

endif.

similarly for distribution channel pass sales org ....

kindly reward if found helpful.

cheers,

Hema.

[Former Member]

Hi Raja,

This is what you can try to do....first select the sales org and distribution channel for the value entered in the material in an 2 separate internal tables.

Then use the FM 'F4IF_INT_TABLE_VALUE_REQUEST' for each internal table to get a search help for the sales org and distribution channel for any particular material number.

Please write the code at AT SELECTION-SCREEN ON VALUE-REQUEST event.

or,

try this code.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR p_salesorg.

select salesorg from tablename into itab where matnr = p_matnr(selction screen value).

if sy-subrc eq 0.

CALL FUNCTION 'POPUP_WITH_TABLE_DISPLAY'

EXPORTING

ENDPOS_COL =

ENDPOS_ROW =

STARTPOS_COL =

STARTPOS_ROW =

• TITLETEXT =

TITLETEXT =

IMPORTING

CHOISE = W_LINEN0

TABLES

VALUETAB = itab

EXCEPTIONS

BREAK_OFF = 1

OTHERS = 2.

IF SY-SUBRC EQ 0.

READ TABLE itab INDEX W_LINENO.

IF SY-SUBRC EQ 0.

P_salesorg = itab-salesorg.

endif.

endif.

similarly for distribution channel pass sales org ....

kindly reward if found helpful.

cheers,

Hema.