This discussion is locked
3 Replies Latest reply: Aug 14, 2008 2:28 PM by Jose Oyon RSS

Update Last Physical Inventory Count

Sudhakar M S
Currently Being Moderated

Hi All,


The requirement is to update Last Physical Inventory Count Date in Material Master.

I find in SE11-MARD(table) and DLINL(field)-Date of Last Posted Count for Unrestricted-Use Stock. But when i check in MM03 i could not able to find the filed. I think it is in Invisible mode. How to bring to Visible in Material Master.


Pls give me the solution,  Urgent....

  • Re: Update Last Physical Inventory Count
    Juergen L
    Currently Being Moderated

    this field can only be updated with the inventory programs, it is not for manual entries as this would violate best accounting practise an audit rules.


    IF you use special stock like consignment or batches, then the last inventory date is set in their tables and not in MARD.

    • Re: Update Last Physical Inventory Count
      Rajen Patel
      Currently Being Moderated

      This might be too late for you.


      We had same issue and we updated last cycle count by direct table update after material master load. Reason being, we have to continue on same cycle counting program in SAP as legacy system. We needed last cycle count dates to get next cycle count documents. It worked pretty well.


      Hope this helps-

      • Re: Update Last Physical Inventory Count
        Jose Oyon
        Currently Being Moderated

        We have the same requirement here at FPL. We would like to bring the last count date from legacy during conversion. I know we can do this with a program doing a direct table update. Our concern is that we could be missing some other tables that SAP updates behind the scene when a physical count is executed.


        When you said that it worked pretty well what do you mean? Are you guys in production exceuting physical counts and using these converted dates with no problems? Is there an OSS note with an SAP recommendation?


        Thanks and regards, Jose Oyon.