Skip to Content
author's profile photo
Former Member

Setup of Internal number ranges in MDM

Hi

Background

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.

Question

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?

Br

Göran

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    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 )

    hth

    thanks

    -Adrivit

    Add 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
    Posted on May 04, 2011 at 06:07 PM

    Hey,

    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:

    Range_Type,Last_Value,Counter
    Customer,100,1
    Material,200,1
    Vendor,800,1

    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.

    Thanks

    Aamir

    Add comment
    10|10000 characters needed characters exceeded