Automate

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

Hi Jana, 
You can create a database table in any of your sql databases.
and can use to fetch the values and delete the used value from the table.
----------------------
for example :
use below command to create the table : 
create table MaterialNumbers
(
Mnum int
)
insert into MaterialNumbers values(1)
insert into MaterialNumbers values(2)
insert into MaterialNumbers values(3)
insert into MaterialNumbers values(4)
insert into MaterialNumbers values(5)
insert into MaterialNumbers values(6)
insert into MaterialNumbers values(7)
select * from MaterialNumbers
* once table is created make a data connection to this table from the form solution.
* use these values in a dropdown for users to select.
* Configure a query control(run at end) to delete the selected number from the table.(shown in screenshot below).

* You can maintain the values stored in the database table according to your preference.

Hope this helps.

Regards 

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

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

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

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

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

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

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

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