topic Re: selection screen fetch data based on dynamic condition in Application Development and Automation Discussions

selection screen fetch data based on dynamic condition

Former Member — Mon, 24 Nov 2008 16:09:53 GMT

Hi am having 4 parameters on selection screen.

1st contains table name eg: mara

2nd contains table name eg: marc

3rd contains key fields of mara with number representation eg: (1,2)

4th contains key fields of marc with number representation eg: (1,2)

Am having where condition in select query with inner joint but condition

i need in this way a_{(1,2) = b}(1,2) and fetch data plz let me know

how to do.

regards

Martin

Former Member — Mon, 24 Nov 2008 16:40:37 GMT

??????

What do you mean?

3rd contains key fields of mara with number representation eg: (1,2) ????

4th contains key fields of marc with number representation eg: (1,2) ????

Can you give us more details?

Max

Former Member — Mon, 24 Nov 2008 18:49:02 GMT

(1,2) means 1st field in mara table i,e MATNR field and 2 means second field in mara.

Former Member — Tue, 25 Nov 2008 08:23:07 GMT

I don't believe it's possible to create a dynamic selection for a join, u should try to create two innested selections:

SELECT * FROM (TAB1) INTO WA WHERE (TCOND).
   SELECT * FROM (TAB2) INTO WA2 WHERE (TCOND2).

U can create TCIND2 in order data selected from TAB1

Max