Filter join table .

[Former Member]

Hello experts ,

In my query , i have 6 tables , i display this parameter on selection screen : p_bukrs .

In the program that was generate , i don't have filter in join with this parameter .

How can i to filter my join tables with this parameter , after this statment : "WHERE EKKO-BUKRS IN P_BUKRS ?

Thanks for your help.

Avi.

[Former Member]

It should be

where ekko-bukrs eq p_bukrs.

[faisalatsap]

>

> It should be 
where ekko-bukrs eq p_bukrs.

Sorry, Riki

I think that AVI using EKKO-BUKRS as a select option and for select option can't use

where ekko-bukrs eq p_bukrs." Mean you can't write EQ P_BUKRS

if you are thinking that there was no Extension Button and user can only give one Value and Interval is also not enable then you must use like following.

where ekko-bukrs eq p_bukrs-low.

and if you want to get the high Value mean Interval is on than.

where ekko-bukrs eq p_bukrs-high.

Hope Will Help,

Thanks and Kind Regards,

Faisal

[faisalatsap]

Hi,

Please have a look at the following Sample code.

SELECT afko~aufnr afpo~psmng afpo~wemng INTO CORRESPONDING FIELDS OF TABLE itab_orders
    FROM afko
    INNER JOIN afpo ON ( afko~aufnr = afpo~aufnr )
    INNER JOIN mvke ON ( afpo~matnr = mvke~matnr AND mvke~vkorg = '1000' AND mvke~vtweg = '20' )
    WHERE afko~aufnr IN aufnrs. " You Can Write like this

Kind Regards,

Faisal

[Former Member]

>

> Hello experts , 
> 
> In my query , i have 6 tables ,  i display this parameter on selection screen : p_bukrs . 
> 
> In the program that was generate ,  i don't have filter in join with this parameter . 
> 
> How can i to filter my join tables with this parameter , after this statment : "WHERE EKKO-BUKRS IN P_BUKRS ? 
> 
> Thanks for your help. 
> 
> Avi.

thanks faisal, i guess he said he is using a parameter in his first line.