Java Dictionary table naming prefixes

[Former Member]

Hello,

i'm looking for a recommendetion for the Table Name Prefix to use in Java Dictionary.

in SAP Help it states:

The following rules apply to table names:

○ Table names must begin with a prefix (for example, the name of a component u201AFI_*u2019).

○ The name of a table can be up to 18 characters long (inclusive of the prefix).

○ Open SQL Keywords are not permitted.

SELECT, INSERT, UPDATE, MODIFY and DELETE are some of the Open SQL Keywords.

○ The permitted characters are: letters, numbers, and underscores.

Name reservation takes place when the Dictionary object is assigned to an activity (checked in to the Design Time Repository). If the name is already reserved, you can create the table, but you cannot save it in the DTR.

So, I should use a prefix, but what prefix will be allowed. The WebAS itself uses Prefixes like BC_ and the like. So what prefixes are "reseved" for use by SAP. What Prefixes are free to use in custom development ?

Most samples show use of TMP_*. With regard to the limit of 18 char in table names, this will lead to naming conflicts.

Is there any best practice on this.

thx Johannes

[Former Member]

Hi johannes,

You can use every prefix that you like in your table, but you need to follow some rules:

- For testing and prototipe you can use TMP_* and TEST_*

- Not available: SAP_* , LOCAL_* , HOME_* , <single letter>_*

- Only to SAP Development: EP_, XAP_, FI_*, ...

A good convention to make the names is:

<company>_<product><table name>

Ex.: IBM_XIORDER, SUN_SCMPLANT

Regards

Marcos

[Former Member]

Hello,

thanks for your answer.

>Only to SAP Development: EP_, XAP_, FI_*, ...

This is the problem - is there a list or reference what prefixes ar reserverd "Only to SAP Development:"

or better a list what perfixes are NOT "Only to SAP Development:"

regards Johannes