Answer / guest

-> goto to se11 & enter table name & display(f7),

->then press indexes.. button on the application toolbar,

->if secondary indexes already exist, a list of them will
be displayed in a dialog box named indexes for table
xxxxx.to create an index,press the create(f5) button.the
create index dialog box will be displayed.

->if no secondary indexes exist,you will not see a list of
indexes.Instead, you will see the create index dialog box
immediately.

->enter an index id in the index id field.customer indexes
should begin with y or z,although the system does not
enforce this.

->press the continue button.the abap/4 dictionary:table
maintain index screen is displayed.

->in the short text field,type a description of the index.

->in the fld name column,type the fields that should
comprise the index in the order that they should be sorted.

->if the values in these fields when taken together must
always be unique be unique,tickmark the unique index check
box.

->press the save button on the application toolbar.the
values in the status fields are now NEW & SAVED & directly
below them the message Does not exist in the database
appears.Also, the message Index xxx to table xxxxx was
SAVED appears at the bottom of the window in the status bar.

->press the Activate button on the Application toolbar.The
system generates SQL & sends it to the RDBMS,creating the
index in the database.If successful,the status fields read
ACTIVE & SAVED, & below the satus fields the message EXISTS
IN THE DATABASE appears.The DB Index Name field will
contain the name of the index in the database.Also, in the
status bar, the message INDEX xxxxx was successfully
activated , is displayed.

->press Back. The Indexes for Table xxxxx screen is
displayed.

->press Cancel to return to the Dictionary:
Table/Structure: Display Fields screen.


CAUTION: if you tickmark the Unique Index checkbox, the
combination of fields in the index is guaranteed to be
uniwue; this is enforced by the RDBMS. An insert or modify
statement will fail if the combination of values in index
fields is already present in the table.

Among pooled and Cluster tables, in which table data used to store in Row Format?

3 Answers   Altimetrik,

---

why particularly lock object name starts with EZ OR EY?

0 Answers  

---

If i have 6 fields in our ztables,But when i would like to display the contents,then only 4 fields would be come up,HOW IT WILL Handle?

3 Answers   Infosys, Pepsi,

---

Describe data classes.

1 Answers  

---

my questions are (1) how to transport a table along with its data from dev to prod/qa server? pls reply elaborately. if possible with screen shots. (2) i want to display like this :- * ** *** ****

4 Answers   HCL, IBM,

---

---

i have executed a report via back ground job, in this report i have used enqueue and dequeue function modules on a table, but before releasing the lock(before dequeue function module is not call) job gives the dump, so the lock is not released the table, here my question is how to set the lock automatically release the there is a short dump before calling the dequeue module?

0 Answers   NTT Data,

---

How to Delete an LSMW Projcet, Subproject and Object.

2 Answers   Emsang,

---

What is the use of AT Selection Screen output when we have At selection screen?Can u explain?

6 Answers   Genpact, Wipro,

---

Withou using SLIN transaction how would you check custom programs?

2 Answers   Bosch, IBM,

---

Create any functions? How to go about it?

0 Answers  

---

Which and How will you use function module for ALV Interactive report?

2 Answers   TCS,

---

What are Table control and tab strip control in dialog programming ?

0 Answers  

---