of the
Editor note: this tip only applies to Dynamics 365 on premise. Online has a 1,000 field limit per entity.
CRM 2011 had a maximum of 1000 fields per entity in Dynamics CRM.
CRM 2013 and 2015 have a maximum of 1023 fields per entity.
How are you going to use your 23 more fields?
🙂
Hi,
This is not 100% true. The CRM has the limit of 1000 SIMPLE attributes limit per entity. But if you create complex attributes type Lookup or Currency or Option Set the number is much smaller because Lookup = 3 strings, Currency = 3 strings, Option set = 2 strings etc..
Cheers,
Zoran
Good point Zoran. But there is a firm 1000 field limit for the organization import in 2011. I think you should stay well away from that limit anyway
Hi Everyone,
Just want to highlight one point here, 1000 limit is for the FilteredView of that Entity in Database.
Below are the our Environment specifications:
Dynamics 365 CE V9.0 – On Premise Deployment
As I currently came across that situation. We have 567 Fields in Incident Entity, In Database also for IncidentBase we have 567 Columns but still we are not able to create any more new field in Incident Entity saying Maximum number of Field for this entity is reached.
Then we checked the FilteredIncident View , there we noticed that right now the column count is exactly 1000. Hence it is not allowing to create any more new field in Incident entity.
We have 67 Lookup Fields and more that 120 OptionSet fields and remaining all are other types of Fields in current Implementation.
Just thought to share this Update in order to provide more clarity. But however would like to have any thought if we can increase this limit somewhere. Where this Limit is Specified and Where to make changes if at all allowed/possible.
Is it in MSCMRM_Config DB or any config in IIS ???
Any pointers would be helpful.
Hello we are also facing this, do you have any idea what to do If we want to continue adding more field in entity even after limit reached ??
I’m sure those fields can be classified or grouped one way or another. Split your table into multiple and maintain 1:1 relationship between those (see Tip #163: Create a 1:1 relationship how to simulate 1:1 relationship)
Hey Joel,
Please update this tip to specify that it applies to on premise only and the online limit is still 1,000
thanks, tip updated.