Record Count Limit for Lookup Flat tables

[Former Member]

Hello Experts,

I wanted to know if there is any limit on the number of lookup values(records) that can be created in a Lookup Flat table. If yes, what is the limit and where can we find such details. Is there any SAP provided documentation for the same.

Thanks in Advance.

Best Regards,

Uday

[Former Member · Accepted solution]

Hi Udaya,

There should be limited number of records in lookup table when we consider MDM Performance considerations.

There is also desirable share of Main table records Vs lookup table provided by SAP.

Please refer below documentation for more details: 8.1 Performance considerations Page 61/97 onwards.

Kindly refer 8.3 Lookup tables and 8.5 Qualified tables

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70b0caa1-92e5-2c10-c687-a8d05e778...

It clearly tells that in Section 8.3 Lookup tables,

*Lookup tables and qualified lookup tables should have a very limited number of fields and number of records.

*Lookup table that are not referred should be eliminated.

*Lookup tables records between 10,000 and 100,000 records should be avoided.

*Lookup tables records above 100,000 should be absolutely avoided.

Regards,

Mandeep Saini

[Former Member]

Dear Experts,

Thank you all.

Regards,

Uday

[Former Member]

"A Flat, Hierarchy, and Taxonomy lookup table typically contains a relatively small number of records compared to the number of main table records". This is the only quote which is given by SAP in MDM400 Data Modeling Guide. Unfortunately, there is no fixed number mentioned.

BR,

Alok Sharma

[former_member208981]

Hi Udya,

There is no limit to the number of records you can maintain in Lookup tables.

Since, these are the reference tables, the number generally is not huge.

Thanks,

Priti

[Former Member]

Hello Uday

Theoretically, count record in LUT limited by internal key field lenght - it have type NUMBER(10)

Regards

Kanstantsin Chernichenka

[Former Member]

Hi,

There is no such limitation from MDM side.

Thanks

Sudhanshu