topic Re: table control dropdown list in Application Development and Automation Discussions

table control dropdown list

Former Member — Mon, 14 Jan 2008 04:56:34 GMT

Hi,

can anyone tell me which lines of codes inside RSDEMO_TABLE_CONTROL actually populate the dropdown list?

thanks. will reward if useful.

Re: table control dropdown list

Former Member — Mon, 14 Jan 2008 05:35:10 GMT

Hi,

Did you mean the drop down for carrier id?

If so it is coming from the search help of field sflight-carrid. In the screen layout editor they have set the field type as listbox. To see this, take the screen of table control. double click on the carrid field row. there you can see it set as listbox.

Hope this solves your issue. Pls reward points if good.

Regards,

Renjith Michael.

Re: table control dropdown list

Former Member — Mon, 14 Jan 2008 05:45:35 GMT

Hi,

If u press F1 on this field having drop down and drill down dataelement-> domain-> value range-> SCARR(as value table).

So it is taking up the entries from this table.

TO make use of this drop down go to se51 and 'Listbox option' from the drop-down after double-clicking col. name.

and check 'from dictionary' box.

Revert back for more details.

Regards,

Nishant Gupta

Re: table control dropdown list

Former Member — Mon, 14 Jan 2008 05:50:24 GMT

Hi,

That dropdown box they've defined in the screen(100) attributes,

fileds they have selected under PAI module of screen 100,(MODULE USER_COMMAND_0100 INPUT)

just check this for your reference.........

&----

*& Module STATUS_0100 OUTPUT

&----

text

----

MODULE STATUS_0100 OUTPUT.

SET PF-STATUS 'GRUND'.

SET TITLEBAR '100'.

IF INIT IS INITIAL.

Datenbeschaffung

SELECT CARRID CONNID CITYFROM AIRPFROM CITYTO AIRPTO DEPTIME ARRTIME

DISTANCE DISTID

FROM SPFLI

INTO CORRESPONDING FIELDS OF TABLE SDYN_ITAB.

DESCRIBE TABLE SDYN_ITAB LINES TABLE_CONTROL-LINES.

INIT = 'X'.

ENDIF.

ENDMODULE. " STATUS_0100 OUTPUT

&----

*& Module FILL_TABLE_CONTROL OUTPUT

&----

text

----

MODULE CHANGE_SDYN_CONN OUTPUT.

you can change the content of current table control line via
sdyn_conn
READ TABLE sdyn_itab INTO sdyn_conn INDEX table_control-current_line.

ENDMODULE. " FILL_TABLE_CONTROL OUTPUT

&----

*& Module READ_TABLE_CONTROL INPUT

&----

text

----

MODULE READ_TABLE_CONTROL INPUT.

Check input values

IF MARK = 'X' AND SAVE_OK = 'DELETE'.

DELETE TABLE SDYN_ITAB FROM sdyn_sdw4.

DESCRIBE TABLE SDYN_ITAB LINES TABLE_CONTROL-LINES.

ENDIF.

ENDMODULE. " READ_TABLE_CONTROL INPUT

&----

*& Module USER_COMMAND_0100 INPUT

&----

text

----

MODULE USER_COMMAND_0100 INPUT.

SAVE_OK = OK_CODE.

CLEAR OK_CODE.

CASE SAVE_OK.

WHEN 'SORT'.

DATA: FLDNAME(100),HELP(100).

READ TABLE TABLE_CONTROL-COLS INTO COL WITH KEY SELECTED = 'X'.

SPLIT COL-SCREEN-NAME AT '-' INTO HELP FLDNAME.

SORT SDYN_ITAB BY (FLDNAME).

ENDCASE.

ENDMODULE. " USER_COMMAND_0100 INPUT

reward points if useful,

seshu.

Re: table control dropdown list

Former Member — Mon, 14 Jan 2008 05:56:44 GMT

Hi,

List box is created in Module program screen

Data is populating at below code.

DATA SDYN_ITAB LIKE STANDARD TABLE OF SDYN_SDW4.-----List box name

SELECT CARRID CONNID CITYFROM AIRPFROM CITYTO AIRPTO DEPTIME ARRTIME

DISTANCE DISTID

FROM SPFLI

INTO CORRESPONDING FIELDS OF TABLE SDYN_ITAB.

To see the list box name and assignment

--> click on MODULE STATUS_0100 OUTPUT

--> you will goto Flow logic editor

-->click on layout button (ctrl+F7)

--->you will goto screen

---> double click on carrid field

> you can see the attribute of the field

--->you will find Drop down = listbox

---> name of the screen SDYN_SDW4-CARRID

Don't forget to reward if useful....

Re: table control dropdown list

Former Member — Tue, 15 Jan 2008 05:13:55 GMT

i have already done what u all suggested but still it doesn't work when i refer to my own database tables. how?

Re: table control dropdown list

Former Member — Tue, 15 Jan 2008 05:20:37 GMT

Hi,

While using your own tables you can populate the drop down in two ways.

1. You can use the VRM_SET_VALUES function module for the list. It requires some coding effort too.

2. The easiest way is that create a search help for your field in SE11. In the screen layout editor, in the 'Search Help' option give the search help name and make the field type as list.

This will solve your issue.

Regards,

Renjith Michael.