topic Re: Drop down for a field in table maintenance generator in Application Development and Automation Discussions

Drop down for a field in table maintenance generator

Former Member — Thu, 07 Jan 2010 08:50:39 GMT

Hi All,

I have created a table maintenance for a table.

I need to give F4 help for a field as a drop down, as of now i am using POV event and PAI event to get it triggered and captured.

It is working fine, but as my field is key field, once i select any value from drop down all other key fields are becoming disable for input.

code in POV event in flow logic is,

SELECT busrule

FROM z100_pro

INTO CORRESPONDING FIELDS OF TABLE it_bus.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'BUSRULE'

value_org = 'S'

TABLES

value_tab = it_bus

EXCEPTIONS

parameter_error = 1

no_values_found = 2

OTHERS = 3.

code in PAI event is,

CASE ok_code.

WHEN 'SELECTED'.

MESSAGE i888(sabapdocu) WITH z100_sup_shdw-busrule.

ENDCASE.

Can any one please help me on this.

Thank you,

Regards,

Kusuma K.

Re: Drop down for a field in table maintenance generator

kesavadas_thekkillath — Thu, 07 Jan 2010 08:56:55 GMT

In the screen field attributes of that particular field ( i think the option will be in the third row of the attribute ),

there change it as list box with key or listbox.

Sorry i just answered looking at the thread subject.

Do you want it in drop down or whether you want to correct the error ????

Edited by: Keshav.T on Jan 7, 2010 2:28 PM

Re: Drop down for a field in table maintenance generator

kesavadas_thekkillath — Thu, 07 Jan 2010 09:02:07 GMT

DYNPPROG = SY-CPROG

DYNPNR = SY-DYNNR

DYNPROFIELD = 'screen field'

try passing the above fields to F4IF_INT_TABLE_VALUE_REQUEST

Re: Drop down for a field in table maintenance generator

Former Member — Thu, 07 Jan 2010 09:21:26 GMT

Sorry, it is not working.

Regards,

Kusuma K.

Re: Drop down for a field in table maintenance generator

Former Member — Thu, 07 Jan 2010 09:24:18 GMT

Hi,

You could assign a Foreign key to the the table field and regenerate the Table Maintenance, this will automatically create a drop down for you without coding.

Regards,

Nick

Re: Drop down for a field in table maintenance generator

Former Member — Thu, 07 Jan 2010 09:39:06 GMT

We can maintain foreign key but domain is having input help as Value table. So it is not giving me F4 help directly.

Thank you,

Regards,

Kusuma K.

Re: Drop down for a field in table maintenance generator

kesavadas_thekkillath — Thu, 07 Jan 2010 09:43:09 GMT

If its giving you the values from value table,

Then why are you coding POV and PAI in the table maintenance ?

Re: Drop down for a field in table maintenance generator

Former Member — Thu, 07 Jan 2010 09:49:25 GMT

Hi,

I don't see the relevance of the fact there is a Value table on the domain.

If you create a foreign key (the same table as the value table will be proposed) and regenerate the table maintenance you will get a drop down based on the value table.

Regards,

Nick

Re: Drop down for a field in table maintenance generator

Former Member — Thu, 07 Jan 2010 10:09:00 GMT

Thank you all, it is working fine now.

I got confused.

Regards,

Kusuma K.

Re: Drop down for a field in table maintenance generator

jitendra_it — Thu, 01 Aug 2013 09:04:38 GMT

Hello Nike,

I have assigned the foreign key and made the field as "List Box with Key" , but still it is not showing values in drop down while I am getting values as F4 help.

Could you please help me.

Many Thanks,

Jitendra