MDM limitations?

[Former Member]

I would like to

1) What is the maximum number of fields that can be created in main table?

2) What is the maximum number of fields that can be created in qualified table?

[Former Member · Accepted solution]

Hi Subin,

1) What is the maximum number of fields that can be created in main table?

There is no such thing as maximum limit of fields on Main Table.

It all depends on the following:

1.Business requirement - The data model heavily depends on Business requirement.

e.g If you want to maintain Material master data the number of fields can be more as compared to Customer master data.

2.Customer requirement - This is also a major driver in deciding number of fields.

e.g If Customer wants to have most of data in MDM he can have a repository loaded with fields whereas if MDM maintains only global data then MDM will be having fewer fields.

3.Landscape - Data Model and number of fields are also influenced by the type and nature of systems talking to MDM.

e.g One might require few remote system specific fields etc.

4.Workarounds and Design - It is up to the designer of the Data Model to optimize the number of fields in the repository.

Many a times one has to put in dummy or extra fields just to achieve some requirement,which normally is not achievable in normal scenario.

5.Future Enhancements - Many customers wish to create extra fields so that there future requirements are met.

This is also business driven.

6.Data Model - It is upto Consultants to optimize this and make a healthy scalable Data Model with optimum number of fields.

Choice of table and data flow governs this.

2) What is the maximum number of fields that can be created in qualified table?

Again here there is no fixed rule on this.But main deciding factor here is the fields in a Qualified table should be logically connected.

Also here one has to consider if for One line item in main table are you getting multiple line items,if yes then one can put this in Qualified table or Tuples.

e.g If field belongs to MARA table it should be in Main table and if it belongs at plant level it should be at Qualified or Tuple level.

As a healthy practice all Lookups should not have more than 30% of data content.

Hope this helps.

Thanks,

Ravi

[former_member182007]

subingeorge -

Always follow the business needs first in order to design your repository and make your data model in such a way that all major fields you can take into main table.

This first steps could impact your whole solution so be carful enough before designing your repository by also considering Harware needs and load impact in mind.

for basic understanding go through below link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/5d4211fa-0301-0010-9fb1-ef1fd9171...

hope it helps you.

thx

Deep

[Former Member]

Hello,

as of now there are no limitation to the number of fields that can be added to main table or qualified table.

if so any limitation, SAP would have published a SAP Note for the same.