Control on the procurement of material in a year

[Former Member]

Dear SAP Experts,

My client has given a requirement but I have no idea how to resolve this one.

They are asking me how to set in SAP that in a year my procurement for a material should not go beyond this quantity.

I have checked in replenishment to maximum stock level but in that case if requirement for one day is greater than the maximum stock level system creates an order quantity for the required quantity.

In that case, a balanced stock/requirement situation is given higher priority.

But in my case I have to put a restriction beyond which material should not be procured in a year.

Is there any Standard configuration for this or else please suggest some alternate way.

Please help.

Regards,

Deepak

[former_member842102]

Kindly Explore this :

1. Create a Purchase Requisition with Quantity = Total Maximum Procurement Quantity. The expected date in the PR can be the last date of the financial year / fiscal year. You have to create PR line items for all your material/ plant combinations. The PR can be subjected to Release at item / header level.

2. While creating PO, it would be mandatory to enter the PR / PR item reference. The PR / PR item must be made mandatory. So everytime, system will check the PR open quantity. Once the PR quantity is exhausted, system will display a error message.

3. This can ensure that the procurement does not go beyond a defined limit. For More purchases ( exceeding the initial procurement plan), a new doc type ZNB can be created in which PO can be created without a PR reference. Only specific users will have access to ZNB.

This seems to be a quite workable design.

[former_member197616]

Hi,

The one problem using with contract is even though contract is expired or out with the quantity system will allow to create a PO with a warning message . Plan to make it as a error message for that . One more hurdle is system will allow to create another contract for this material and again might be the same story .

Regards,

[JL23]

Is this a realistic requirement? what is driving this requirement?

What if you have sales orders to fulfill, do you really want to tell your customer " I am sorry you can't get that finished good because I limited my procurement of a component to a maximum  quantity per year. "

[Former Member]

Yes,the top management has given this requirement.

They want to set a target beyond which user cannot procure in a year.

Can we use any exits to replenish to maximum stock level in MRP 1 view.

If yes please guide.

[Former Member]

Hi,

You can create contract for that material (Agreement type:Quantity contract) with contract validity one year.  You can create release order against this contract so that PO cannot be issued beyond this contract quantity.

[JL23]

you are a consultant, you should consult your top management.

They might just had an idea to restrict  users from ordering a quantity by wrong data entry which is even beyond an annual demand, but forgot the fact that this will also restrict them from expanding their development.

The idea with the contract is not bad, however users can still order without contract which allows them to go beyond the the annual quantity.

Further your idea to check against a maximum stock level in MRP 1 view is based on my experience nonsense except you buy all quantity in just one order.  Further you restrict yourself by misusing a field. You could no more use Reorder point planning with fillup to a maximum stock level if you need to procure the material several times in a year.

You would need a Z-table  (or make use of classification) to store a maximum quantity per year.  And then you would need an exit/Badi to check against this table when you create a PO.

[former_member197616]

Hi,

I do not think so that there is such kind of field in MMR or anywhere available in the MM module . How try add a field in the MMR through screen modification and fill the filed with the maximum quantity which can be procured for that material . and modify the PO creation standard functionality before save , that while saving system will check the total quantity till now procured with this PO qty will check with the MMR maximum quantity and issue a error message to stop the PO and the PO will not get saved .

Regards,