topic Re: Filter join table . in Application Development and Automation Discussions

Filter join table .

Former Member — Thu, 19 Feb 2009 15:44:55 GMT

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.

Re: Filter join table .

Former Member — Thu, 19 Feb 2009 15:50:24 GMT

It should be

where ekko-bukrs eq p_bukrs.

Re: Filter join table .

faisalatsap — Thu, 19 Feb 2009 16:07:13 GMT

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

Re: Filter join table .

faisalatsap — Thu, 19 Feb 2009 16:23:09 GMT

> 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

Re: Filter join table .

Former Member — Thu, 19 Feb 2009 16:30:51 GMT


> 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.