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

filter up Open PO

Dear All,

I have to create a report to display the data of open po based on payment term, GR stage (delivery status), delivery date and po issuance date. Can anyone please guide me how should i filter out the blocked po, deleted po and only display out the open po?

Thanks alot!

Best Regards,

PC

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Nov 19, 2007 at 06:14 AM

    EKKO table

    field FRGKE Release indicator: purchasing document

    T16FB(Check table)

    to see whether PO is blocked or not.

    EKPO

    field LOEKZ Deletion indicator in purchasing document

    Based on this 2 conditions....write a select query to get the fields as per your requirement

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I had check with the MM user, they didn't use EKKO-FRGKE or table T16FB.

      If they want to block PO they will tick the delivery completed indicator, for delete indicator is EKPO-LOEKZ.

      So I wrote :

      IF NOT EKPO-LOEKZ = 'L'.
         IF NOT EKPO-ELIKZ = 'X'.          :
                :
      proceed my specify function.

      but it seems like not functioning. I still can get blocked and deleted po from my report.

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.