topic Re: SEARCH HELP PROBLEM in Application Development and Automation Discussions

SEARCH HELP PROBLEM

Former Member — Mon, 25 Aug 2008 09:16:25 GMT

Hi,

I am getting problem in search help...when I click

F4 and select any region, i want the to see region not the description in selction field.

Here I am getting description.

This is my coding..

can any body suggest me......

Data : g_region type regio.

DATA : BEGIN OF IT_T005S OCCURS 0,

REGION LIKE T005S-BLAND,

END OF IT_T005S.

DATA : BEGIN OF IT_T005U OCCURS 0,

REGION LIKE T005U-BLAND,

BEZEI LIKE T005U-BEZEI,

END OF IT_T005U.

select-options : s_regio for g_region.

At selection-screen on value-request for s_regio-low.

select BLAND from T005S into table it_T005S where LAND1 = 'IN'.

SELECT BLAND BEZEI FROM T005U INTO TABLE IT_T005U FOR ALL ENTRIES IN IT_T005S

WHERE BLAND = IT_T005S-REGION AND SPRAS = 'EN' AND LAND1 = 'IN'.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'S_REGIO-LOW'

dynpprog = sy-repid

dynpnr = sy-dynnr

dynprofield = 'IT_T005U-REGION'

value_org = 'S'

TABLES

value_tab = IT_T005U.

At selection-screen on value-request for s_regio-high.

select BLAND from T005S into table it_T005S where LAND1 = 'IN'.

SELECT BLAND BEZEI FROM T005U INTO TABLE IT_T005U FOR ALL ENTRIES IN IT_T005S

WHERE BLAND = IT_T005S-REGION AND SPRAS = 'EN' AND LAND1 = 'IN'.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING

retfield = 'S_REGIO-HIGH'

dynpprog = sy-repid

dynpnr = sy-dynnr

dynprofield = 'IT_T005U-REGION'

value_org = 'S'

TABLES

value_tab = IT_T005U.

Re: SEARCH HELP PROBLEM

Former Member — Mon, 25 Aug 2008 09:38:51 GMT

Hi,

Parameters should be exchanged:

retfield = 'REGION'

dynprofield = 'S_REGIO-LOW'

Hope it helps.

Re: SEARCH HELP PROBLEM

naveen_inuganti2 — Mon, 25 Aug 2008 09:55:39 GMT

Hi.. .This code will works....

data : g_region like t005u-bland.

data : begin of it_t005s occurs 0,
region like t005s-bland,
end of it_t005s.


data : begin of it_t005u occurs 0,
region like t005u-bland,
bezei like t005u-bezei,
end of it_t005u.

select-options : s_regio for g_region.

at selection-screen on value-request for s_regio-low.

  select bland
         from t005s
         into table it_t005s
         where land1 = 'IN'.

  select bland bezei
         from t005u into table it_t005u for all entries in it_t005s
         where bland = it_t005s-region and spras = 'EN' and land1 = 'IN'.

  call function 'F4IF_INT_TABLE_VALUE_REQUEST'
    exporting
      retfield    = 'REGION'
      dynpprog    = sy-repid
      dynpnr      = sy-dynnr
      dynprofield = 'S_REGIO-LOW'
      value_org   = 'S'
    tables
      value_tab   = it_t005u.


at selection-screen on value-request for s_regio-high.
  select bland
         from t005s
         into table it_t005s where land1 = 'IN'.

  select bland bezei
         from t005u into table it_t005u for all entries in it_t005s
         where bland = it_t005s-region and spras = 'EN' and land1 = 'IN'.

  call function 'F4IF_INT_TABLE_VALUE_REQUEST'
    exporting
      retfield    = 'REGION'
      dynpprog    = sy-repid
      dynpnr      = sy-dynnr
      dynprofield = 'S_REGIO-HIGH'
      value_org   = 'S'
    tables
      value_tab   = it_t005u.

Thanks,

Naveen.I