Complex Assignment

[former_member283645]

Hi,

I have..

Article Type as z1 or z2 or z3

coming into MDM..

So, once it has arrived in MDM, i have a field called Article Number which need to be generated based on article type And the generated article Number has a range based on article Type.

IF art type = Z1 then article numbers should be from 1 -50

IF art type = Z2 then article numbers should be from 50 - 100

So if i have 4 records coming in to MDM.. they should look like..

Art type ||| Art Number

Rec1 Z1 1

Rec2 Z2 50

Rec3 Z1 2

Rec4 Z2 51

So, the article Numbers should be Incremented With in Their Range of Values .

Can any one please HELP me ...

Kind Regards

Eva

[former_member205403 · Accepted solution]

Hi Eva,

One possible solution is:

You enable remote key mapping on the table using a "Qualified Range" option.

Maintain your range i.e. for the remote key in Console. i.e.

IF art type = Z1 then article numbers should be from 1 -50

IF art type = Z2 then article numbers should be from 50 - 100

Now as soon as you syndicate to the appropriate remote system, remote key will be generated for the records based on the range defined in console.

But issue with this solution is, this number will be stored as remote key and can not be stored in any field using standard MDM. this makes it hard to search records based on the number. Also, this number will be generated at the time of syndication.

if these are big issues at your end, then the only solution left is to use MDM APIs and write some ABAP/Java program to calculate and assign number to the record.

let me know if you need any clarification..

Best Regards,

Shiv

[Former Member · Accepted solution]

HI Eva,

What Shiv has suggested should solve your problem.

However,we can attain Article number inside MDM using a workaround.

We can syndicate Article no out of MDM and using PI we can put the same record for import inside MDM.

Thus we update the same record with the generated Article number.

However what one has to weigh is usage of this workaround or usage of APIs for this purpose.

Hope this helps!

Thanks,

Ravi

[former_member283645 · Accepted solution]

Hi,

Thanks Folks that worked.

I syndicated by the qualified range and asked PI to send it back to mdm.

thanks a ton for the help..

Kind Regards

Eva