Skip to Content
author's profile photo Former Member
Former Member

filtering

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 07:01 AM

    use alv it will have option called filter

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 07:03 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2007 at 07:10 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.