topic Re: filtering in Application Development and Automation Discussions

filtering

Former Member — Wed, 21 Nov 2007 06:58:07 GMT

Hi all,

I have developed a report for displaying stock details. In the input field i have given material no and posting date. For the material no, it takes corresponding fields from mara and based on mara-matnr it takes corresponding fields from mbew for opening balance and closing balanace. lllrly for mara-matnr it takes corresponding fields from mseg for calculating receipts, issues and returns. Now after getting all these fields i need to filter all the fields based on posting date which i have given in i/p. But budat is not present in all these table, it is only present in mkpf table. So, by using mblnr entries in mseg, i select budat field in mkpf. But, the fields are not getting filtered. So, please give me a solution.

Thanks in advance,

Karthi.

Re: filtering

Former Member — Wed, 21 Nov 2007 07:01:27 GMT

use alv it will have option called filter

Re: filtering

Former Member — Wed, 21 Nov 2007 07:03:13 GMT

You got the budat from mkpf. Now delete all the records which contains date other than input date. :

delete from i_tab where budat<>p_date.

finally you will have the records for the input date in i_tab.

Note check the format of the date ie Format when you are fetching from MKPF and the input date format.

Re: filtering

Former Member — Wed, 21 Nov 2007 07:10:03 GMT

Hi Karthi,

Note that Mseg table has both mblnr and matnr fields...

fetch mblnr from MKPF table for the posting date...

now filter matnr vales passing these mblnr values..u wil get the req matnr...Regards,

Kaveri