topic Unique String in Databasetable in Application Development and Automation Discussions

Unique String in Databasetable

Former Member — Mon, 08 Mar 2010 16:33:02 GMT

Hi all,

i'm responsible for defining the tables needed for a rather big custom build part within SAP ECC 6.0.

Now the Client requests to have unique Names for a given object.

My initial thought is, thats not best practive and you normally have an unique ID and the Name is free text and you might be able to enter what ever you want.

However i though i post the question here to see if i'm right or if there are fast performing ways to give the client what he requests!

Once again the Requirement is to have a unique free form text for the Name of an object.

Re: Unique String in Databasetable

Former Member — Mon, 08 Mar 2010 20:30:28 GMT

Sounds like text processing that is stored in tables STXH and STXL. There the config can be set to store texts based on document, document/item, document/item/line, etc. where those combinations would be considered a value for 'TDNAME'.

Re: Unique String in Databasetable

Former Member — Mon, 08 Mar 2010 22:02:31 GMT

Hi,

thx for the answer but i'm not sure if it really solves my problems so i try to be more specific.

What the client request is basically a table in a format similar to this:

mandt -> mandt -> key

ContractName -> char 40 -> key

valid from -> dats

valid to -> dats

more data fields....

where the Contract name can be freely entered but has to be unique -> therefore is the key to this table.

Instead i was going for a layout of:

mandt -> mandt -> key

Contract ID -> numc 10 -> key

ContractName -> char 40

valid from -> dats

valid to -> dats

more data fields....

here the name would be a "normal" text maybe even in a own text table but not unique.

This table will be quite big and of course search for the name must be enables and as always highly performant.

Re: Unique String in Databasetable

Former Member — Mon, 08 Mar 2010 22:11:44 GMT

Moderator message - Welcome to SCN.

You may want to define a number range object for this. See the documentation for transaction SNRO [Number ranges|http://help.sap.com/saphelp_47x200/helpdata/EN/2a/fa02e3493111d182b70000e829fbfe/content.htm]

Rob