Skip to Content
avatar image
Former Member

SAP B1 HANA Autokey Not get updated

Hello Experts,

I have SAP HANA 9.2 PL 03.

While adding first record in UDO get correct AutoKey Number 1 but next number is not getting updated in ONNM table next time it same 1 number. this issue gets for all user defined form in addon. but it works on my development server. so i dont get what is the actual issue and how can i resolved it ?

I am using the following query for get the next Autokey

select "Autokey" from ONNM where "ObjectCode"='CBF_FARM'

Help me experts if any one get the solution.

- Thanks


Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 20, 2016 at 01:40 PM

    Hi Vikas,

    How is the data being added? Did you link your form with a UDO and let the UDO save the data?

    Are you using SQL (not recommended)?

    Note that, sometimes the numbering file gets corrupted, and there is an option you can use to fix it: Help -> Support Desk -> Restore -> Restore Numbering File.

    Good luck.

    Pedro Magueija

    LinkedIn | Twitter | Blog

    restore.png (20.2 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Pedro,

      Thanks for reply. I am Adding record by attaching UDO to Form.

      I have tried your solution by restoring Numbering File but still same issue AutoKey not get updated in ONNM table.

      - Thanks