Number Ranges - AUTO ID

[Former Member]

Hi ,

Please let me know whether it is possible in MDM to create number Ranges same as SAP R/3 .E.g ( In SAP the material number will change based on the Material Type.Usually we can do these type of setting in SPRO...

Material Type 1 : 1000-2000

Material Type 2 : 2001-3000

.......

Can it be possible in MDM

Second Question :

Client wants to start AUTO ID from 60000 instead of 1.Please let me know how should do this MDM...

Thanks

SSGK

[Former Member · Accepted solution]

You cannot set a starting value for Auto Id Values.

You use a Calculated Field to achieve the same.

The calculated field will have the formula Auto Id + 6000.

[former_member710663]

If you have access to the SQL Server Enerprise Manager, and if you can drill down to the repository and Tables and locate the A2i_CM_Tables and by rightclicking open tables -Return all rows and scroll to the right.. you can see the Next AutoID for all the tables under that repository. You can set it to any # you want.

If you do not have access to any of this, you might be able to get Basis to do it.

Hope this helps.

[Former Member]

HI

SNRO is the t-code, where we will specify the Number ranges for a particular object. so find out the MDM object name, and reset that settings.

look at this doc..

http://help.sap.com/saphelp_erp2005vp/helpdata/en/7b/6eb2aa7aed44ea92ebb969e03081fb/frameset.htm

hope this info helps you.

with regards,

Rajesh.

<i>award suitable points</i>