topic Re: Regarding Select-option in Application Development and Automation Discussions

Regarding Select-option

Former Member — Wed, 09 Jul 2008 05:33:48 GMT

Provide validation in selection screen to restrict the users to enter only four digit account codes. Provide dropdown functionality to show the four digit statutory accounts list to allow users to select the required account from the list. When four digit account code is entered, select all the related six and eight digit account codes. Get all the accounting data for the selected accounts and diplay the data based on the level entered in the selection screen.

rewards will be given.

Re: Regarding Select-option

Former Member — Wed, 09 Jul 2008 05:39:45 GMT

either use some search-help or do programming in AT SELECTION-SCREEN OUTPUT event

Re: Regarding Select-option

Former Member — Wed, 09 Jul 2008 05:46:55 GMT

Hi,

take the 4 digit numbers into a seperate internal

table then pass it to the bellow fm.

CALL FUNCTION 'POPUP_WITH_TABLE_DISPLAY'

EXPORTING

ENDPOS_COL = 85

ENDPOS_ROW = 15

STARTPOS_COL = 35

STARTPOS_ROW = 6

TITLETEXT = 'Title'

IMPORTING

CHOISE = ITAB

TABLES

VALUETAB = IKNA1

EXCEPTIONS

BREAK_OFF = 1

OTHERS = 2.

IF SY-SUBRC <> 0.

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

ENDIF.

Re: Regarding Select-option

Former Member — Wed, 09 Jul 2008 05:49:00 GMT

For validation

At selection-screen on (select-option1)-low.

At selection-screen on (select-option1)-high.

Regards

Aditya

Re: Regarding Select-option

Former Member — Wed, 09 Jul 2008 06:41:35 GMT

Hi,

U can set the limit to four digit using select options and then setting the High and Low limits.

Also you can do it by using search help.

Regards,

Manish

Re: Regarding Select-option

Former Member — Wed, 09 Jul 2008 07:56:42 GMT

1:example

type-pools: vrm.

data: it_val type vrm_values,

w_line like line of it_val,

wa_line like w_line occurs 0.

parameters P_ACCOUN(4) as listbox visible length 4 obligatory.

initialization--

initialization.

w_line-key = '0001'.

w_line-text = '0001'.

append w_line to it_val.

w_line-key = '0002'.

w_line-text = '0002'.

append w_line to it_val.

w_line-key = '0003'.

w_line-text = '0003'.

append w_line to it_val.

w_line-key = '0004'.

w_line-text = '0004'.

append w_line to it_val.

w_line-key = '0005'.

w_line-text = '0005'.

append w_line to it_val.

......

at selection-screen--

at selection-screen output.

call function 'VRM_SET_VALUES'

exporting

id = 'P_ACCOUN'

values = it_val.

DATA:P_ACCOUNT TYPE ACCOUNT.

CONCATENATE P_ACCOUN '*' INTO P_ACCOUNT.

SELECT

.....

FROM TABLE

....

WHERE

....

AND ACCOUNT LIKE P_ACCOUNT

...

....

Re: Regarding Select-option

Former Member — Wed, 09 Jul 2008 08:14:53 GMT

Hi get all acounts into one internal table.

LOOP AT itab INTO wa.

wa1-field = wa-field+0(4).

APPEND wa1 TO itab1.

CLEAR wa1.

ENDLOOP.

display itab1 in search help.

dynnr = sy-dynnr.

repid = sy-repid.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

RETFIELD = 'FIELD'

DYNPPROG = repid

DYNPNR = dynnr

DYNPROFIELD = 'ITAB1-FIELD'

VALUE_ORG = 'S'

TABLES

VALUE_TAB = itab1.

pass selected account 4 digit code into anthor table n get all acount detail data.

Re: Regarding Select-option

Former Member — Wed, 09 Jul 2008 08:19:21 GMT

hi,

you can use at selection-screen on upper and lower limits of the field.

thanks