Skip to Content

Pharma: shelf life with remaining 4 months should not be considered for planning


Hi,

Implementation in Pharma : FG Shelf life with remaining 4 months should not be considered for FG planning.

How to exclude this stock while planning for FG. FG planning is Make to stock.

BR

Subbu.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Jul 15, 2014 at 01:05 PM

    Hi Subbu,

    Requirement is not clear..For FG normally we enter forecast i.e. PIR's in Make to stock..

    I am not sure what do you mean by exclude stock while planning FG..means already existing stock with expiry of 4 months is not to be considered during MRP run ? or during delivery against the sales order it should not consider the stock of expiry of less than four months.?.

    can you please elaborate the requirement in detail..

    Thanks

    Kumar

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Subbu

      You must create a custom program to move the expired batches to another storage location and it must be executed periodically.

      Maybe it would be easier to create an implementation of BAdI MD_CHANGE_MRP_DATA, to exclude the expired batches from MRP. Method CHANGE_MDPSX_MARD should be useful.

      BR

      Caetano

  • Posted on Jul 19, 2014 at 08:42 AM

    Hi,

    Check this link..may help you out..

    MRP Shelf Life Planning in ECC - YouTube

    Thanks

    Kumar

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Kumar

      Thanks. Quite effective presentation in 1 min.

      Here, in this approach, Planned Orders are directly created, but is another approach. One need to model what kind of response is required - Ind. Requirement, Planned Order, Dep. Requirement etc. And how do we tag these requirements separately so that the user is aware that these requirements are due to Shelf Life based planning.

      Is this application shown in the video custom developed or is it something available for everyone with some OSS note etc from SAP?

      Regards

      mani.

  • Posted on Jul 15, 2014 at 12:26 PM

    Hello

    This selection is made during the batch determination. The following document explains in detail the setup of a batch determination based on the shelf life:

    Automatic Batch Determination Based on Shelf Life

    BR

    Caetano

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 15, 2014 at 04:43 PM

    Subbu,

    As far I know restricting the stock based on Shelf life from MRP is not possible.

    Either you need to Keep this stock in Blocked or Separate storage location to do so.

    Br

    KK

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 19, 2014 at 07:07 AM

    Dear Subbu,

    In one of my clients, the idea implemented was to use a 'custom program' that will determine these batches that will need to be excluded from the Planning run.

    This custom program will then create additional 'independent requirements' with a separate requirements type equal to the quantity of the batch. This Program is executed before the Planning run to create this additional requirements so that the batch quantity in the stock is nullified.

    Hope this helps.

    mani.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 26, 2014 at 01:02 PM

    Hi,

    Thanks to Caetano, Kumar & Mani..

    We have achieved this with below with customized program....

    Exclude those batches from MRP run whose difference between the (expiration date &
    current date ) is less than or equal to its procurement time mention in MRP-2
    view of material master.

    Before running MRP, one need to execute the program with following option:

    Input data will be plant, material type or list of material:

    System should execute following logic:

    1) In a plant list all material with given material type

    2) Execute the BAPI for find out the characteristic value of EXB_MRP from class
    type 001of material class (BAPI_OBJCL_GETDETAIL_KEY)

    3) If EXB_MRP = Y , then list out all such material.

    4) For such a material identity those batches which are available in stock other
    than ‘9999’

    5) All such batches characteristic of shelf life expiry date need to be derived
    from BAPI

    6) Calculate ( Expiry Date - Today’s Date)
    = Difference

    • PLIFZ ), batch of
      the material will be transferred to the 9999 storage location which will be
      excluded from MRP run.
    • PLIFZ ), batch of the material will be transferred
      to the 9999 storage location which will be excluded from MRP run.

    7) Run the MRP on materials

    8) Transfer posting from 9999 storage location to original storage location :
    Selection criteria

    On execution transfer the material back to required storage location.

    BR

    Subbu.


    Add a comment
    10|10000 characters needed characters exceeded

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.