We have added search box. Key in SAP issue keyword to search
TopBottom

Announcement: wanna exchange links? contact me at sapchatroom@gmail.com.

RE:[sap-log-mm] How to Get the List of Fully Open PO

Posted by Admin at
Share this post:
Ma.gnolia DiggIt! Del.icio.us Yahoo Furl Technorati Reddit

Reply from tomevans866 on Jun 8 at 1:38 PM
SayanPaul,
I think your logic goes beyond any delivered list/report in ECC. When I had only read the title of your post, I was thinking some use of ME2N, then filtering out Still to be Delivered = 0, Still to be Invoiced = 0, etc. If you downloaded the results from ME2N to Excel, you might be able to do compare logic between PO Qty and the "still to be" columns to achieve your goal.

The repeatable and user efficient solutions are, of course, custom reports/queries in ECC or in SAP BI/BW or other data warehouse. You are essentially building the ME2N logic from the EKKO, EKPO, EKBE, EKES (for ASNs) (Advance means Advance Ship Notice?)

Produce a list of any PO number in EKKO without any history on any line in EKBE or EKES. (And not marked for deletion/cancellation in EKPO?)

Regards,
TRE

---------------Original Message---------------
From: SayanPaul
Sent: Thursday, June 08, 2017 2:48 AM
Subject: How to Get the List of Fully Open PO

I want to get the report of all PO numbers which is fully open, i.e.

a. No Goods Receipt has been done against any of the Line items of the PO
b. No Invoice has been done against any of the Line items of the PO
c. No Advance has been done against any of the Line items of the PO

If the PO contains multiple line items, I want the list such PO which has no Purchase Order History created against any of the Line items.

(I have already executed ME2N using selection parameter "WE101", but that provides partial open PO list )

 
Reply to this email to post your response.
 
__.____._
Manage Settings | Unsubscribe | Create FAQ | Send Feedback
  
© 2017 Ziff Davis, LLC. and message author.
Ziff Davis, LLC. 28 E 28th Street New York, NY 10016
tomevans866  

Consultant
achievements
 
Mark as helpful
View this online
Ask a new question
 
In the Spotlight
Have a technical question? Need to find IT solutions? Ask your peers in the Toolbox for IT community.

_.____.__

0 comments:

Post a Comment

T r a n s l a t e to your language