on 05-04-2011 9:16 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Aamir
Ok. Just a question regarding your proposed solution. Don't you have any max- and min number range like 2 fields with a min- and max range value or have I missed something? Don't you want to keep the vendor number within a fixed number range? With your solution I assume that your vendor number can be anything from 800 and upwards?
Br
Göran
Edited by: Göran Westin on May 5, 2011 11:57 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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
-clarify your constraint in here
In the MDM Console->Admin->Remote systems when specifying number ranges for the qualified range it is not possible to give the same number range for different account groups.
- 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 )
If you are talking about when using the JAVA API - Yes. But I'm not sure if I follow you on how this can help me solving my problem?
Br
Göran
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.
User | Count |
---|---|
87 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.