Possible entries for selection screen field

[Former Member]

Hi,

I have created a custom DDIC table Z_TAB which contains 3 fields of type char. The table contains about 100 rows of data. I want that at the selection screen, for each selection field a list of entries in the table should appear. E.g. Data rows:

Field1 Field2 Field3

aaaaa bbbbb ccccc

bbbbb bbbbb ccccc

ccccc bbbbb ccccc

(contd.) (contd.) (contd.)

Now at the selection screen:

Field1 _________

Field2 _________

Field3 _________

It is required that at selection screen:

Field1 should give the option of entries: aaaaa, bbbbb, ccccc, ...

Field2 should give the option of entries: bbbbb, ...

Field3 should give the option of entries: ccccc, ...

and so on, like for the standard DDIC tables.

How can this be achieved? Help is appreciated.

Regards

[prasanth_kasturi]

Hi,

try developing a search help with the three fields

and assign it to a field in the table

or use parameter option MATCHCODE OBJECT if you have a selection screen with parameters

regards

prasanth

[Former Member]

Hi,

Create search help for the fields and attach them .

If you dont want to attach search help at databse level then create the search help and in your program when you will declare the PRAMETERS add MATCHCODE OBJECT addtion with it.

For .g.

Parameter:P_PARAM(20) TYPE C MATCHCODE OBJECT <SEARCH HELP>.

I hope this will help you.

Help children of U.N World Food Program by rewarding points and encourage others to answer your queries.

[Former Member]

Hi Khan,

Try using search helps

Thanks,

Surya

[Former Member]

Hi,

Try using foreignkey relationship with the specified fields of the table for which you want search help. Then enter the check table name from which u want to import data.

reward if helpful.

[Former Member]

Hi,

we can use the FM 'F4IF_FIELD_VALUE_REQUEST'

write the code calling the above FM in the event AT SELECTION-SCREEN ON VALUE REQUEST <field>

reward if useful,

regards,

teja.

[Former Member]

Hi,

AT selection-screen output even you read the records of the table into internal table and then At selection-screen on value request event you

use function module F4IF_FIELD_INT_TABLE_VALUE_REQUEST

(dont exacty remember the FM sorry but will be of similar kind)

and populate value for that functional module for each field in the even

ON VALUE REQUEST FOR PARTICULAR field by reading that record from first to the FIRST FIELD and from second record to second Field and from Third to the THIRD FIELD..

Hope this would solve your problem

Regards

Narin Nandivada.