selection screen fetch data based on dynamic condition

[Former Member]

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]

Hi

??????

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]

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

[Former Member]

Hi

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