Skip to Content
avatar image
Former Member

Maximum length for a fields in MDM

Hi Folks,

I am working on BI side and we are working on a design where BI will get data from MDM

Today in legacy system all the code fields and descriptions are freely defined. Some of the code and description fields are 100 characters.

In BI we have a limitation that the field length of code and text fields cannot be more than 60 characters. For better reporting performance SAP has this limitation in BI.

Question : Does MDM has any limitation ? We are planning to use MDM 5.5 .

Regards

Poonam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Mar 11, 2009 at 09:08 PM

    Hi Poonam,

    In MDM the text field limitation is 333 characters.

    Best Regards,

    Silpa Chillakuru

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      MDM have three type of text fields:

      1)Normal text field length is 333 characters,

      2)Text(normalithed) field whith length is 333 characters

      "A Text Normalized field stores the actual text value, but

      uses the normalized value for sorting and searching. The normalized

      value is an upper-case version of the original with non-alphanumeric

      characters removed (includes a-z, A-Z, and 0-9 from original value)"

      3)Text(large) field where is field length up to 333 characters

      When we use first or second type of fields, we can change fields length in MDM Console(as default field width= 50)

  • Mar 11, 2009 at 09:49 PM

    Hi Poonam,

    Upper limit for text fields is 333.

    I guess these points about performance will be useful to you.

    Field Keyword search definition (fields defined as Keyword = Normal)

    If you define Keyword = Normal for your fields, you will have a big impact on the load repository process and on the virtual memory (VM) size used at runtime. It might cause an overhead when adding, deleting or updating records.

    Set Keyword = None whenever there is no need for a keyword definition, and where the number of unique values in this field is not too high.

    �� Field Sort Index definition (fields defined as Sort Index = Yes)

    Setting Sort Index = Yes for a field has a high impact on the repository loading time and main memory consumption. Set Sort Index = No when the sort index for a field is not

    needed.

    Please note that for all lookup tables (including qualified), the display field must have Sort Index set to Yes; also for searching on a qualifier, you need to set Sort Index to Yes.

    �� Key Mapping definition for tables (Tables defined as KeyMapping = Yes)

    This may have serious impact on data Import. Set to KeyMapping = No when key mapping is unused.

    Cautious usage of the MDM change tracking table

    The Change Tracking table tells the Master Data Server (MDS) which data modifications to track. Each entry set to Yes will cause the MDS to write one or more rows to the History table in the DBMS depending on the operation. Set the entries to No when tracking is not needed.

    For example, setting a field such as the Products->Name field to Yes will cause one row to be written when a record is added or deleted, or when that particular field is modified. Setting all n fields in a table to Yes will cause n rows to be written with a record when it is added or deleted.

    You can also refer to this link for performance related information

    [https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/oss_notes/sdn_oss_mdm/~form/handler%7b5f4150503d3030323030363832353030303030303031393732265f4556454e543d444953504c4159265f4e4e554d3d31303132373435%7d]

    Regards,

    Ravi Verma

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 12, 2009 at 04:39 AM

    Hi,

    As Suggested above MDM Text field is of 333 characters max.

    In your case since the BI system(max Text width=60) is getting the data from MDM system you can limit the field width to 60in MDM while defining the field mention the width=60.

    Apart from it various parameters such as Keyword search,Sort Index,Cache Qualifiers affect the performance.

    Regards

    Nisha

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 12, 2009 at 06:45 AM

    Hi Poonam,

    in MDM the maximum text length is 333.

    The following things impact on the performance are key word=normal etc.

    Reg,

    BIs

    Add comment
    10|10000 characters needed characters exceeded