Skip to Content

SAP B1 HANA Autokey Not get updated

Dec 20, 2016 at 07:14 AM


avatar image

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


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Pedro Magueija 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)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

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