topic cascade search help in Application Development and Automation Discussions

cascade search help

Former Member — Fri, 17 Apr 2015 08:15:19 GMT

Hello Experts,

First of all sorry if my Question is stupid but i am new to SAP Abap. I want to have cascade search help.

say there are three select option A B C... C depends on B and B depends on A.

A to B has many to many relation and B to C has also one to many relation.

if use enter value in A then relative value should be shown in search help for B and C.

but now if User directly enters value in B then search help for A and C should also show relative value(related to value entered in B).

if user enters value in C then also A and B search help should have relative entry(related to value entered in C).

so there is no specific order in which user enters number.

how to implement this?

Thanks in advance

Re: cascade search help

Former Member — Fri, 17 Apr 2015 08:45:31 GMT

Hi Zubin,

Design like this:

AT SELECTION SCREEN ON VALUE-REQUEST FOR so_a-low.

select a from table1 into itab1.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING itab1.

AT SELECTION SCREEN ON VALUE-REQUEST FOR so_b-low.

select b from table2 into itab2 where a = s_a-low.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING itab2.

AT SELECTION SCREEN ON VALUE-REQUEST FOR so_c-low.

select c from table3 into itab3 where b = s_b-low.

CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'

EXPORTING itab3.

regards,

Archer

Re: cascade search help

Former Member — Sat, 25 Apr 2015 10:59:43 GMT

@Dengyong Zhang : what if user wants to enter value in B first then enter values in C and then in A. in that case search help should be working. there is no specific order in which user enters the value.. is it possible to implement this?