Remove Req with Partial Qty Delivered

[Former Member]

Hello...I am in some need of help. I have tried and tried to gather this information to no avail.

I am wanting to locate all the purchase Req's that have a PO that was generated for a partial qty and not the same qty that the req was created for. The goal is to get rid of the Req as it keeps coming up for a demand in MD04. My client wants all these to go away...delete them....How do I locate these req and how can I make them go away? I have gone in and Looked at Table EBAN and found fields BANFN BNFPO WERKS WEPOS EBELN FIXKZ MENGE BSMNG

However these fields do not bring me the correct data. Please help! I will award points generously.

[Former Member · Accepted solution]

Hi

I am not sure whether your problem has been resolved or not. One of the way to achieve your requirement is....

Check, if Qty Ordered is > 0 then set the closed indicator to 'X' in PR.

Hope this helps... if so ... award the points

Reg

Kumar

[Former Member · Accepted solution]

Thanks for your reply and it was helpful. I have the file now however I need to know what the table is for the "close" indicator in ME53N. Please advise. Thanks so much I awarded points

[Former Member · Accepted solution]

Hi,

Table name is EBAN. I suggest to update it through LSMW.

Regards

Kumar

[Former Member · Accepted solution]

Thanks for your reply. Yes I agree about LSMW and thank you.....Points awarded

[Former Member]

Hi Blair,

Even we had similar problem number of PR's were open & they wanted to close.

we have to close all open PR's to do this only possible way is through LSMW.

Create a lsmw & close all the PR's so that you can't see those in MD04.

Regards

Rang

[Former Member]

Hello Kimberly...

When a PR is converted to a PO, the reference is also storaged in table EKET,

If that same PR is used in others POs in this table you can see them.

[Former Member]

Hello.

That table does not seem to give me the info I need either

I am going to change the way I said the qestion...

I create a Req for 10000 ea of a material. A PO is greated for 5000. The req still shows a demand for 5000, with a firm indicator. I want to identify all these req that are like this with a firm indicator and delete them. What tables do I need for all three area (ie the req the po the firm indictor) and what would be the best process to delete the req? I hope I explained well. Thanks in advance and I will reward points....

[Former Member]

Kimberly,

If you have created the P-req manually, then i think the Fixed indicator must have been ticked in the p-req. Check & let me know if it is the case. If not check in EBAN table if the field ZUGBA has a 'X'. Check & let me know.

Vivek

[Former Member]

The "fixed" indicator in the Purchase Req is done automatically. The req is created by SAP. The user creates the PO but for a different Qty. I want to find the Purchase Req to where when a PO was created for a different qty, I need to identify that req, and delete the req so it will not show a demand in MD04. I believe I just need to remove the firm indicator that is in MD04 and the fixed indicator in ME57. I am not sure how to identify just these req and what tables I need to remove indicator...or if this is the solution in order to rid of the Req?