Central Master Data Management

[Former Member]

Hi All,

We are trying to implement Central Master Data management for Customer master and facing a problem -

How do we achieve the internal allocation of master data numbers within an ECC system e.g. customer number according to different account groups. For example If we the account group of a particular customer is 'a' then the internal number generation for this customer should lie between 1-1000 and if the account group is'b' then the internal number generation for this customer should lie between 1001-2000 etc.......

Thanks,

Tony

[Former Member · Accepted solution]

This is possible in SAP ERP system..I don't know whether you want to create Internal allocation of Numbers in SAP ERP or SAP MDM...Let me know..

Regards.

GK

[Former Member · Accepted solution]

Since I am trying to do central master data management in SAP MDM i.e creation of records in MDM, I want this validation / logic to be realized in MDM only.

Thanks,

Tony

[Former Member · Accepted solution]

Tony,

Create the customer in MDM with the auto generated id, send it to ECC, create the required ID there and then maintain a key mapping to that ID in MDM.

This might take some roundabout work but it might work

Venkat

[Former Member · Accepted solution]

Hi Tony,

Correct me if I am wrong: The Cust Id which you are generating in MDM in CMDM scenario is auto number..right? what you can do is,

make one new field and write an assignment which can check your a/c group. If it is "a" than assign num range from 1 to 1000...

Will it solve your prob?

You can also use Qualified numbering range present in Console> under admin node> remote system...

thx,

Ronnie

Message was edited by:

R.n

[Former Member · Accepted solution]

Hi, all

Venkat, how should we deal with account groups in your solution? The thing is that we should create ECC IDs for account groups with external number assignment and we should not create them for groups with internal numbers assignment. In your case as I understand, no ECC IDs are created in MDM at all, which is appropriate only for account groups with internal number assignment in ECC. Even if we would create IDs for groups with external group assignment in MDM, what algorithm for creating them should we use? How can we be sure that created ECC IDs do not exist in ECC?

R.n, creating special field for remote keys for each new remote system is not the best idea, right? Anyway, even if we do that with assignments, how can we be sure that customer no. produced by assignment doesn't exist yet in ECC or at least doesn't exist in MDM? Unfortunately, assignments can't invoke remote system calls (to ECC in our case) to get array of free or used customer numbers.

You also mentioned qualified numbering range - that possibly could be a solution when only one account group with external number assignment exists in ECC, but typically this is not the case

Tony, hope my suggestions help you evaluate advantages and disadvantages of possible solutions presented here.

Regards,

Vadim Kalabin

[Former Member · Accepted solution]

Hi All,

Thanx for your answers.

Rn,

Can you please exactly explain as two how should I write my assignment expression to achieve this as I am not getting where I would provide the number range in my assignment exoression. Eg - If Acc group=a then...... What should i write in then to five the number range?

Thanks,

Tony