Diffrenec between two statements

[Former Member]

1. SUBMIT RUTDBCHK

WITH TABNAME = TABNAME_K.

• WITH INDEXES = ''.

2. SUBMIT RUTDBCHK

WITH TABNAME = TABNAME_K.

WITH INDEXES = ''.

I want to know what is diffrenec between these to statements and what they do?

[Former Member]

Hi

Both codes are same but in one statement u have commented with index thats it

SUBMIT

-->When using this addition, the specified variant vari of the program prog is taken in USING SELECTION-SET vari. On the other hand, all variant-related actions on the selection screen of rep (Get, Save as variant, Display, Delete) refer to the variants of prog.

<b><i>Example:</i></b>

SUBMIT REPORT01 
       VIA SELECTION-SCREEN 
       USING SELECTION-SET 'VARIANT1' 
       USING SELECTION-SETS OF PROGRAM 'REPORT00' 
       AND RETURN.

RUTDBCHK -->This is the standard report for ABAP Dictionary/Database Consistency Check

WITH TABNAME = TABNAME_K. --> Calling a table

• WITH INDEXES = ''.

An index is a copy of a database table that is reduced to certain fields. This copy is always in sorted form. Sorting provides faster access to the data records of the table, for example, when using a binary search. A table has a primary index and a secondary index. The primary index consists of the key fields of the table and is automatically created in the database along with the table. You can also create further indexes on a table in the Java Dictionary. These are called secondary indexes. This is necessary if the table is frequently accessed in a way that does not take advantage of the primary index. Different indexes for the same table are distinguished from one another by a separate index name. The index name must be unique. Whether or not an index is used to access a particular table, is decided by the database system optimizer. This means that an index might improve performance only with certain database systems. You specify if the index should be used on certain database systems in the index definition. Indexes for a table are created when the table is created (provided that the table is not excluded for the database system in the index definition). If the index fields represent the primary keys of the table, that is, if they already uniquely identify each record of the table, the index is referred to as an unique index.

<u><b>Prerequisites</b></u>

You have opened a table for edit.

<b><u>Procedure</u></b>

...

1. Choose the Indexes tab.

2. To create an index, choose New.

3. Enter a name for the index. Index names, like table names, also have a prefix, followed by an underscore.

If the name of an index was registered on the name server, it cannot be deleted.

4. To select table fields, choose New.

5. if the index is a unique index,

6. If the index is used for all databases, choose and whether it is to be created for all databases. Choose the appropriate checkboxes.

7. Choose File Save All Metadata.

Reward all helpfull answers

Regards

Pavan

[Former Member]

1. SUBMIT RUTDBCHK

WITH TABNAME = TABNAME_K.

• WITH INDEXES = ''. " not exeuted comment

2. SUBMIT RUTDBCHK

WITH TABNAME = TABNAME_K.

WITH INDEXES = '' " show error