Answer / jenny

Indexes are a sorted copy of the table that exist in the
database which helps in faster retrival of data from the
database.
Primary Index : User cannot create a primary index, the
system creates a primary index by default based on the
primary keys of the table.

Secondary Index : The secondary indexes are created by the
user.we can create a maximum of upto 15 secondary indexes
for a table.

Answer / bandivenkateswarlu

Index is used to retrive the fast access the data from the
database by using the indexes. This is the efficient
mechanizam to retrive the data differnt databases.

indexes are two types of given below.

1.primary index.
2. secondary index.

1.primary index.: is used to access the only one record from
the database. That means that should be unique. It is also
called one to one relation ship.
2.secondary index: is used to access the data only more than
one record data base. This is called the secondary index.
The secondary index is used to relation ship is the
one-to-many relationships.

I have a table with 400 recs. among some are duplicate records. how can I remove the duplicate records from the table. pls help me out.

4 Answers   IBM,

---

Explain the difference between tables and structures?

0 Answers  

---

What are logical data bases used in hr module? : abap hr

0 Answers  

---

9) We give KEEP in BDC structure...what is its purpose?

1 Answers  

---

How do you execute the payroll

0 Answers  

---

---

How to upload a flat file from a legacy system into sap using BAPI ? And i also want the flat File to be uploaded in another Client.. ie suppose i am working in client 800 , i want run the BAPI and upload the file to Client suppose 000 directly from 800.

0 Answers   PWC,

---

How many types os LSMW are there anyone knows please tell me?

3 Answers   Cap Gemini,

---

What is the first thing you do after vendor setup is complete?

0 Answers   Infosys,

---

What take most time in SAP Script programming?

2 Answers   Wipro,

---

can any body tell what is idoc archieving and how to do that

3 Answers   Accenture,

---

How to run a report in background??and if we try to run in foreground it says"this report sud be run in background".what can be done in this case?? 2-And how sud we stop a report running in background??

3 Answers   Cap Gemini,

---

BDC program to migrate data to SAP R/3 database. The data will be uploaded using transaction ME11. (Session Method) plz mention the detail coding Tahnks, Rahul

0 Answers   TCS,

---