How does MDM actually understand the next available master number when a ma

[Former Member]

How does MDM actually understand the next available master number when a master is created?

I know about qualified tables and ranges, but I need to understand how does it actually happen, eg: how does it know the next available number for the master.

[former_member188878 · Accepted solution]

Hi,

At the data base level there is a code, which takes care of number creation once the field is auto ID.

regards

shankar

[Former Member · Accepted solution]

Thanks, we are closer to the solution now.

But can we see that code/table? How can I view that? Any ideas?

[Former Member · Accepted solution]

Hey Justjas,

There are many tools depending on the database which allow you to view and edit data at DB level.

MS SQL Server Management studio being one of them.Once you log in you can see various table structures pertaining to Roles,records,languages etc.I am not really sure where it lies in here,but possibly you can find it here.

Hope that helps.

Thanks,

Ravi

[Former Member]

Hi justjas ,

You need to go to DB and check directly the table. For example, in SQL you may open the XXX_m000 DB and view the Table "A2i_CM_KeyGenerations" If you're using Qualified Range to numbering in this case a Material, here is the counter of each range.

Regards

Daniel

[Former Member]

Hi Justjas,

Very intresting question I must say,well its a product design level question but let me add my two cents here.

Let us see how SAP system does this,We have number ranges defined in SPRO settings and SAP system holds this in a Number range table.When a new material is created SAP checks that table and gives the new material the next number available as per the table.

Now how does MDM do that?I guess a similar mechanism holds true where SPRO configuration corresponds to Qualified ranges,and a table should be available which picks next available number so that no duplicate number is assigned.

Hope that helps.

Thanks,

Ravi

[Former Member]

Ok. If a table in MDM is updated, then why cant I find/ search that table anywhere?

[Former Member]

Hey Justjas!

Can you please give me a example of what exactly you mean?

Are your refering to Change tracking,if yes thats a other tool which is integrable in multiple ways with MDM.

The changes made at data level are saved in a history table and that tool accesses that.From MDM level you set whoich field sto track.

Thanks,

Ravi

[Former Member]

Also for better experience in sdn please go through this link : http://wiki.sdn.sap.com/wiki/display/HOME/RulesofEngagement

[Former Member]

I know the question is not straight.

With refernce to your reply " Now how does MDM do that?I guess a similar mechanism holds true where SPRO configuration corresponds to Qualified ranges,and a table should be available which picks next available number so that no duplicate number is assigned."----> wanted to know like ECC, what would be the table in MDM which gives the next available value for the master from the range given...

[Former Member]

The difference is that SAP MDM is C++ based tool and not ABAP based ,these configurations we are talking about are saved in MDS.

Most of the configurations are stored in A2i tables at the database level.Exactly which table stores what can be seen by exploring the DB view but not all can be seen this way.

Thanks,

Ravi