What is the limit for creating new extension attributes in Sourcing, V7.

[Former Member]

Hello Experts,

Quick question and one that I hope you guys can help me with. We are in the process of rolling out a massive customization effort to the Supplier Registration module and were wondering what (If any) is the limit in terms of new extensions we can create in the environment. Previously, we ran into a row limit while creating Big Text boxes in one of our clients environment, we would like to be better prepared as our new client has hundreds of more fields to customize than our previous customer.

In short, what is the limit for creating new extensions in Sourcing.

Any and all help is appreciated.

[vikram_shanmugasundaram]

Hi Woo,

The limit really depends on what data type the extension fields are. There is a limit to the number of columns that can be added to a table and the size of a particular row in certain databases. Big Text extensions will take up more space than say a text field with 40 characters. Generally speaking you would be able to create more text field extensions than big text extensions. Bottom line, you would have to test it on a sandbox system to make sure you are able to create all the extensions you need and also make sure system performance is acceptable.

If you have inactive extensions, that counts too. If you are on 7.0 SP3, it’s possible to delete extensions. I would suggest reading this blog

http://scn.sap.com/community/sourcing/blog/2012/11/29/deleting-inactive-extensions

Regards,

Vikram

[Former Member]

Hi Woo,

There was limit for creating extensions in 5.1 and Sourcing 7.0 (till SP02). But from 7.0 SP03, SAP was able to resolve limitation on creating extensions. So, please ensure that your client has Sourcing 7.0 SP03 and above. Then make note of 2 points:

1. If you are using DB2 database, then you should be good but if you are using oracle database, then you need to set system property 'system.allow_unlimited_oracle_extension_row' to TRUE

2. After this, try out in your dev environment, how it looks. Please note that with large number of Big Text, your system will show performance issues. Which means, you may be able to create 15-20 Big Texts or even more, but end users will complain on performance.

Thanks,

Sashi