topic DYANAMIC SELECT LIST in Application Development and Automation Discussions

DYANAMIC SELECT LIST

Former Member — Wed, 13 Dec 2006 12:25:21 GMT

Hi,

can any one help me how to write dyanamic select list i.e select (...) from tab

I have created the dyanamic select list but, if the list contains date fields then when i pass this dyanamic select list in selection it gives dump.

therefore can any one tell me how to take care of date fields.

thanks

Re: DYANAMIC SELECT LIST

Former Member — Wed, 13 Dec 2006 12:28:36 GMT

HI ,

Just wite select field1 field2 field3 from (tab_name) into table itab where <condition>.

Where tab_name is value from selection screen.

Regards,

Vaibhav B Gawali.

Re: DYANAMIC SELECT LIST

Former Member — Wed, 13 Dec 2006 12:29:05 GMT

Hello,

U could make use of thei code:

*--- Arbeitsbereich für interne Tabelle der PSP-Elemente

FIELD-SYMBOLS:

TYPE WKGXXX.

DATA: BEGIN OF SEL_WBS OCCURS 0,

SIGN(1),

OPTION(2),

LOW LIKE PRPS-POSID,

HIGH LIKE PRPS-POSID,

END OF SEL_WBS.

*----

*--- beim ersten Unterprogrammaufruf interne Tabellen für dynamischen

*--- Select füllen

IF L_T_SELECT_FIELDS IS INITIAL.

*--- Kostenart "/&-neuneu

L_T_SELECT_FIELDS_WA-FIELD = 'KSTAR'.

APPEND L_T_SELECT_FIELDS_WA TO L_T_SELECT_FIELDS.

*--- Geschäftsjahr

L_T_SELECT_FIELDS_WA-FIELD = 'GJAHR'.

APPEND L_T_SELECT_FIELDS_WA TO L_T_SELECT_FIELDS.

*--- Werttyp

L_T_SELECT_FIELDS_WA-FIELD = 'WRTTP'.

APPEND L_T_SELECT_FIELDS_WA TO L_T_SELECT_FIELDS.

*--- von 1 bis 16

WHILE L_F_MONAT LE 16.

*--- Wert gesamt in Kostenrechnungskreiswährung

L_T_SELECT_FIELDS_WA-FIELD = 'WKG'.

L_T_SELECT_FIELDS_WA-FIELD+3(3) = L_F_MONAT.

APPEND: L_T_SELECT_FIELDS_WA TO L_T_SELECT_FIELDS.

L_F_MONAT = L_F_MONAT + 1.

ENDWHILE.

ENDIF.

If useful reward.

Vasanth

Re: DYANAMIC SELECT LIST

Former Member — Thu, 14 Dec 2006 05:42:57 GMT

Hi,

I am getting error " TY-SELECT_FIELDS" not defined, can you tell me which table type you are using , because I could'nt find the same. I am using 4.6c version

L_T_SELECT_FIELDS TYPE TABLE OF TY_SELECT_FIELDS

thanks