07-01-2008 11:36 AM
Hi experts,
If i have a field say AFABE(depreciation area);in selection screen we have f4 help but we want that depreciation are '51' should not appear.I got the idea that it can be done by using function module F4IF_INT_TABLE_VALUE_REQUEST.Kindly help me by suggesting if it can be done by thios function module and how it is to be used.I tried using it as below:
CALL FUNCTION 'DYNP_VALUES_READ'
EXPORTING
dyname = lv_progname
dynumb = lv_dynnum
translate_to_upper = 'X'
TABLES
dynpfields = lt_dynpro_values.
LOOP AT lt_dynpro_values INTO lwa_dynpro_values.
IF lwa_dynpro_values-fieldname = 'S_BUKRS-LOW'.
lv_bukrs = lwa_dynpro_values-fieldvalue.
ELSEIF lwa_dynpro_values-fieldname = 'S_ANLN1-LOW'.
lv_anln1 = lwa_dynpro_values-fieldvalue.
ELSEIF lwa_dynpro_values-fieldname = 'S_ANLN2-LOW'.
lv_anln2 = lwa_dynpro_values-fieldvalue.
ENDIF.
ENDLOOP.
siddiquizoheb (1:36:55 PM): IF lv_anln2 IS NOT INITIAL.
SELECT bukrs anln1 anln2 afabe bdatu
FROM anlb
INTO TABLE lt_dep_area
WHERE bukrs = lv_bukrs
AND anln1 = lv_anln1
AND anln2 = lv_anln2.
ELSE.
SELECT bukrs anln1 anln2 afabe bdatu
FROM anlb
INTO TABLE lt_dep_area
WHERE bukrs = lv_bukrs
AND anln1 = lv_anln1.
ENDIF.
lwa_field_tab-fieldname = 'BUKRS'.
lwa_field_tab-tabname = 'ANLB'.
APPEND lwa_field_tab TO lt_field_tab.
lwa_field_tab-fieldname = 'ANLN1'.
lwa_field_tab-tabname = 'ANLB'.
APPEND lwa_field_tab TO lt_field_tab.
lwa_field_tab-fieldname = 'ANLN2'.
lwa_field_tab-tabname = 'ANLB'.
APPEND lwa_field_tab TO lt_field_tab.
lwa_field_tab-fieldname = 'AFABE'.
lwa_field_tab-tabname = 'ANLB'.
APPEND lwa_field_tab TO lt_field_tab.
lwa_field_tab-fieldname = 'BDATU'.
lwa_field_tab-tabname = 'ANLB'.
APPEND lwa_field_tab TO lt_field_tab.
CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'
EXPORTING
retfield = 'AFABE'
dynpprog = lv_progname
dynpnr = lv_dynnum
dynprofield =
TABLES
value_tab = lt_dep_area
field_tab = lt_field_tab
return_tab = lt_return_tab.
Please reply soon.
Thanks.
07-01-2008 11:43 AM
Hi,
u got it all correct , just that u have to populate the below internal table with whatever vakues u want to disp in the f4 help
lt_dep_area
value_tab = lt_dep_area
tc
saji
07-01-2008 11:51 AM
Hi,
Before using FM F4IF_INT_TABLE_VALUE_REQUEST
you have to populate your value table
i.e.
Select description
from <table>
into table lt_dep_area
where description <> '51'...
then use this table in FM
i.e.,
value_tab = lt_dep_area