topic Re: SELECTION BASE ON SELECTION in Application Development and Automation Discussions

SELECTION BASE ON SELECTION

Former Member — Sat, 09 Jun 2007 15:41:18 GMT

hi all,

can anyone tell me how to code for a selection based on selection, that is i have taken suppose material document in the selection screen now when i look for a data in the field it should select based on the moment type displaying a popup window having moment type to be selected and accordingly dives the detail document number.can anyone tell me the sample code for this?urgent

abinash verma

Re: SELECTION BASE ON SELECTION

Former Member — Sat, 09 Jun 2007 15:45:00 GMT

You need to use At Selection-Screen event.

In which values for first selection will be available to you & then you can use this for second selection for fileteration.

Regards

Sushil

Re: SELECTION BASE ON SELECTION

sharat_chandra — Sat, 09 Jun 2007 15:50:32 GMT

Hi,

I am not sure if i have understood your requirement correctly but would make an attempt to provide a solution.

After you have the material document obtained from the selection screen ( you would have it in the select options field s_<some> or if you are using a parameter then some p_<> ).

Then use POPUP_GET_VALUES_DB_CHECKED or POPUP_GET_VALUES etc (there are many such FM's for getting value(s).) to get the movement type.

Then use these data to select the detail document.

Regards,

Sharat

Re: SELECTION BASE ON SELECTION

Former Member — Sat, 09 Jun 2007 16:00:05 GMT

hi abhinash,

use event called,

at selection-screen on value request for <field>.

data: begin of l_tab occurs 0,

matnr type matnr.

data: end of l_tab.

select matnr from <db table> into table l_tab where movement type = parameter-movement type.

then u can use funtion module called,

f4if_int_table_value_request.

in this u can pass reference field 'matnr' and table 'l_tab' paramters ,

then u can related matnr no to selection screen for the particula movement type.

reward points if helpful,

regards,

seshu.

Re: SELECTION BASE ON SELECTION

Former Member — Mon, 11 Jun 2007 07:39:38 GMT

hi,

i have used as u said but i am getting runtime error, i understand dats becoz of the fm.can you just correct this plz.i am actually fetching mblnr value based on radiobutton selection. radi and rad2.

AT SELECTION-SCREEN ON VALUE-REQUEST FOR MBLNR.

DATA: BEGIN OF I_MBLNR OCCURS 0,

MBLNR TYPE MSEG-MBLNR,

BWART LIKE MSEG-BWART,

END OF I_MBLNR.

IF RAD1 = 'X'.

SELECT MBLNR FROM MSEG INTO TABLE I_MBLNR

WHERE BWART = '541'.

ELSEIF RAD2 = 'X'.

SELECT MBLNR FROM MSEG INTO TABLE I_MBLNR

WHERE BWART = '551'.

ENDIF.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

DDIC_STRUCTURE = ' '

RETFIELD = MBLNR

PVALKEY = ' '
DYNPPROG = ' '
DYNPNR = ' '
DYNPROFIELD = ' '
STEPL = 0
WINDOW_TITLE =
VALUE = ' '
VALUE_ORG = 'C'
MULTIPLE_CHOICE = ' '
DISPLAY = ' '
CALLBACK_PROGRAM = ' '
CALLBACK_FORM = ' '
MARK_TAB =
IMPORTING
USER_RESET =

TABLES

VALUE_TAB = I_MBLNR.

FIELD_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.