In an Internal Table, I have 1000 records. I have to Retrieve One Record. In P

Categories >> Software >> ERP CRM >> SAP >> SAP ABAP
Suggest New Category

In an Internal Table, I have 1000 records. I have to
Retrieve One Record. In Performence wise what is the Best
Query?

Question Posted / sunayana

7 Answers
12179 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / sathish

Use READ TABLE STATEMENT

READ TABLE <ITAB> INDEX 1.

Is This Answer Correct ?

9 Yes

2 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / medepalli.sunil@gmail.com

1.READ TABLE ITAB WITH INDEX F1

2.Loop at itab where f1 and f2

-----

endloop.

out of these two the second has got the best performance
then the first one.

Is This Answer Correct ?

4 Yes

0 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / ajay chowdary

READ TABLE ITAB WITH INDEX 1. is the best procedure.

Is This Answer Correct ?

4 Yes

3 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / ravi

READ TABLE ITAB INTO WA WITH TABLE KEY F1 F2.. (PROVIDE FULL KEY).

OR

READ TABLE ITAB WITH INDEX 1.

Is This Answer Correct ?

0 Yes

0 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / nyk

select *
from <itab>
upto 1 row.

Is This Answer Correct ?

0 Yes

3 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / shruthi

select single * is the best query

Is This Answer Correct ?

2 Yes

10 No

In an Internal Table, I have 1000 records. I have to Retrieve One Record. In Performence wise what..

Answer / niladriroy_dgp

Select Single (with full primary key) is the best process
to fetch one record.

Is This Answer Correct ?

2 Yes

13 No

Post New Answer

More SAP ABAP Interview Questions

1.In Change pointers , Using BD61 I activate globally and I enable the MATMAS message type When I Ran the "RBDMIDOC" SYSTEM GIVES information messagge 253 MASTER IDOCS CREATED. MY Question IS :1.what is 253 2.PlZ explain internal PROCESS ,HOW ITS GENERATE 253 MASTER IDOcs?

1 Answers Accenture,

Explain a report that you recently did?

4 Answers Atos Origin, Cap Gemini, Deloitte, FutureSoft,

difference b/w classical report and intractive report

10 Answers

Can we write the code both call transaction and session method in single program?

0 Answers

Events in Reporting. Which events we can ignore while coding.

1 Answers ACS,

what is diff between idocs,bdc,rfc and bapi. give real time answer

3 Answers

Can you create a script with out a main window ?

7 Answers Unilogic Software,

1) What is read with binary search? 2) I have initialization write ?a? Top-of-page write ?b? what is the output for this/ 3) If I don?t have start of selection event in report will it execute?it is mandatory or not? 4) What is table maintenance generator? 5) Is it advisable to have secondary index/ 6) How we will imlement BAPI? 7) What is process code in idoc? 8) Where the information msg will display? 9) Where warning msg will display? 10) Where we use watch point?what exactly watch point means? 11) What is a spool? 12) What is program name that contains all print program names and form names other than TNAPR? 13) How we will capture errors in bapi? 14) How to transfer std text from production to quality?

5 Answers CSC,

what is sorted table and Hash table?

4 Answers Keane India Ltd,

What are the event key words in interactive reporting?

1 Answers

What is constructor expression in nw abap 7.4?

0 Answers

What is the effect on Customer Exits and User Exits maintained in a system on Up-gradation .

1 Answers

For more SAP ABAP Interview Questions Click Here