Skip to Content
author's profile photo Former Member
Former Member

Setup of Internal number ranges in MDM



We have a requirement to create vendor centrally in MDM. Therefore we also want to create the vendor number when the record is created/persisted in MDM. The vendor will be created via a WebDynpro application which is exposed in the portal.


I have already looked at the following guide:

MDM Internal Number Range Setup

but since we will have more than one account group for the vendor we cannot use the qualified range setup.

I'm already familiar with the MDM java api's but is there any java coding example on how to retrieve a vendor number from a specified lookup table in a MDM repository. The lookup table should, I guess, contain a number range, account group and a counter?



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2011 at 08:48 AM

    am not sure why you say u cant use the number range for the multiple acc group.

    you can have the vendors in the main table and account group as a multivalued field of type lookup !

    clarify your constraint in here

    when you retrieve the main table record details (in ur case Vendor)

    you would get the list of LinkIds (these have references to ur Qualified records )




    Add a comment
    10|10000 characters needed characters exceeded

    • You can add a field to the main table - Number Range of type lookup. You would then add another lookup table to the repository - Number Ranges. Using this Number Ranges lookup table you can set the Vendor number much the same way that ECC sets the number ranges. Another option is to add a field to the Account Group table - Number Range and associate it to the lookup table Number Ranges.

  • author's profile photo Former Member
    Former Member
    Posted on May 04, 2011 at 06:07 PM


    We are doing similar thing and its pretty straight forward:

    1. Create a lookup table (lets call it Number_Range)

    2. Number_Range table, will have 3 columns, Range_Type,Last_value,Counter.

    3. Add this lookup table to a attribute in Main Table.

    So your table will be something like below:


    Now, from Portal, you will call the Number_range table. lets say you want to generate number range for Customers, so read the first record (which is Customer), then read Last_Value,add the counter to it and dispaly on Portal, once portal assignment is complete, replace the Last_Value with the latest value you put in portal.

    In this way, if you want to add more number ranges or change the counter, you can simply do in MDM, portal will not be affected much.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.