Answer / vijeta

You can use UPTO 10 ROWS in your select query

Answer / samir

u CAN SELECT USING THE SELECT STATEMENT INSIDE THE LOOP
UISNG THE INDEX. ALSO INCEASE THE INDEX BY ONE AS LOOP
INCREASES...
HOWEVER IT IS NOT ADVISIBLE TO WRITE SELECT INSIDE LOOP AS
IT AFFECTS PERFORMANCE.

Answer / vimal

Select XXXXX
into table t_Rows
from YYYYYYY
up to 1 rows
order by XXXX descending.

XXXX---column name
YYYY---table name

For 'SELECT .... UP TO 1 ROWS' database selects all of the
relevant records that are defined by the WHERE clause or
lack of, applies any aggregate, ordering or grouping
functions to them and then returns the first record of the
resultant result set.

How to debug a script in abap?

0 Answers  

---

Difference between interactive and ALV Reports

3 Answers   TCS,

---

Suppose, we are creating one table. at that time we are mention table space and size category. Generally size category is from 0 to 6 is available. suppose if we are declare size category as 0(zero). For 0 (zero) the size of rows is from 0(zero) to 19000. I have 25000 records to insert into table. but table size is declared as 0(zero). i.e 19000 records. what about remaining 6000 records. shall i insert in to table or not? if insert how can i do? if not insert what can i do? Please answer me? i faced this one in TCS interview.

2 Answers   TCS,

---

Any once please tell me some interview questions regarding Smartforms?

3 Answers  

---

What is the syntex used to call a screen as dialog box (pop up)?

0 Answers  

---

What is roles and responsibilities of sap hr consultants? : sap abap hr

0 Answers  

---

What is the difference between upload and ws_upload ? : abap bdc

0 Answers  

---

how do you supress blank spaces in sap scripts?

2 Answers  

---

why we use 4 msg variable in BDCMSGCOLL stucture in BDC? why not more or less than 4?

3 Answers   IBM,

---

What are ranges?

0 Answers  

---

Events in Interactive reporting?

3 Answers   TCS,

---

to link the loop to a table control we use the addition WITH CONTROL else this works as as stand-alone________________?

1 Answers  

---