Skip to Content
avatar image
Former Member

Control on the procurement of material in a year

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Dec 23, 2014 at 10:00 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 23, 2014 at 10:13 AM

    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. "

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Dec 23, 2014 at 01:35 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2014 at 12:33 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded