Hi jana,
For this requirement you can ask your database administrator to create a database in your SQL server using SQL Manager then create table according to your preference, you can use this SQL table to make a dataconnection and reserve the material number.
you can use the command mentioned above to create the sql table.
since, the problem is quite complex i would recommend you to raise a support ticket referencing this community discussion. we can get on call on the support ticket to further assist you.
Regards
Hammad Naeem
------------------------------
Hammad Naeem
Precisely Software Inc.
------------------------------
Original Message:
Sent: 05-31-2023 02:39
From: Jana Kuschmierz
Subject: Reserving material numbers
Thanks for your input. But we do not want to generate them before we will use them definitly. Furthermore we try to use these in our different ranges in a way that speaks to them.
And the number should be eliminated from the list of possible numbers when one productmanager have choose them in his process. So it should be not possible that 2 productmanagers use the same number in their process of creating a new material.
The proposal of Hammad is exactly this what we want but I do not now exactly what he mean with database table.
Best regards
Jana
------------------------------
Jana Kuschmierz
Rigips AG
Original Message:
Sent: 05-30-2023 20:07
From: Sigrid Kok
Subject: Reserving material numbers
Hi Jana
There's a BAPI: BAPI_MATERIAL_GETINTNUMBER that will generate between 1-255 material numbers. Pass in material type, industry and the # of material numbers you want generated. It works great with the BAPI to create materials, but also works with MM Transaction scripts, too.
FYI,
Sigrid
------------------------------
Sigrid Kok
Precisely Software Inc.
Original Message:
Sent: 04-27-2023 09:22
From: Jana Kuschmierz
Subject: Reserving material numbers
Hello
We have external number assignment for our trade goods. Every productmanager can initiate a process for a new material. In my form they have to insert the material number they would like to have. But it could be that at the end of the process when creating the material in SAP the number is no longer available.
In SAP it is not possible to book/reserve a material number without creating the material.
I would like to do this in Evolve.
Perhaps like this:
in perhaps reference data or another list I insert all possible numbers (par ex. 20). In the form user choose a number. While choose the number, it reserve it and the next who open the list of all possible numbers there is only 19 left.
Is this a possiblity to do in Evolve?
Thanks for your ideas.
Jana
------------------------------
Jana Kuschmierz
Rigips AG
------------------------------