topic Indexname in Database in Application Development and Automation Discussions

Indexname in Database

rainer_hbenthal — Fri, 24 Feb 2012 08:49:33 GMT

Hi,

creating an index on a table will result in nameschema like tablename~inx where inx is the three letter name you enter in SE11(Indexes).But: the indexname for the index in the database is limited in the dictionary to 18 chars. So some truncation occurs, eg the index Z10 on table ZSD_RU_CUSTOMLOG will result in ZSD_RU_CUSTOMLOGZ1

I thought the indexname in the database is stored in table DD12L in field DBINDEX, but in this case this field is blank? The index exists for sure and SE11 stated Index ZSD_RU_CUSTOMLOGZ1 exists in database system ORACLE

So where is this information stored? Unfortunetly, pressing F1 and F4 does not reveal any information where this comes from.

Re: Indexname in Database

ThomasZloch — Fri, 24 Feb 2012 09:11:52 GMT

I found this in MSGTBF01:

" AW: Manche generierte Indizes haben das Feld DD12V-DBINDEX
        " nicht gepflegt. >> Falls dies der Fall ist: bestimme
        "                                             Indexname neu.

        call function 'DD_INDEX_NAME'
             exporting
                  indexname = dd12v-indexname
                  tabname   = dd12v-sqltab
             importing
                  dbindex   = dd12v-dbindex.

So you would need to call this function to determine the name in case DD12L-DBINDEX is empty.

Thomas

Re: Indexname in Database

kesavadas_thekkillath — Fri, 24 Feb 2012 09:26:51 GMT

The logic lies inside the fm DD_LIST_INDEX & DB_GET_INDEXES. Place a debug point and check it

Re: Indexname in Database

rainer_hbenthal — Fri, 24 Feb 2012 09:53:58 GMT

Brrrr, SAP Coding... data: sections inside an if-statement

Re: Indexname in Database

Former Member — Fri, 24 Feb 2012 10:33:24 GMT

Little late to reply, just to share the way the text "Index ZSD_RU_CUSTOMLOGZ1 exists in database system ORACLE" in SE11 is determined.

If length of concatenated value of TABLENAME and INDEXNAME > 15
 concatenate [tablename] [indexname] to [dbindex name variable] (of length 18).

In your case, table length is already 16, as per above logic {dbindex name variable} will have truncated text.

See Program "LSDD0F02", sub-routine "DD_INDEX_NAME" called from Function module DB_EXISTS_INDEX.

Regards, Vinod