Answer / lokesh

The driver Internal table 0r First internal Table Must have
records in it , if u use For All Entries . If the First
Internal table is initial (means no records in it) then the
For All entries will fetch all the records from the DB
table , which can be real perfromance Issue.
so before making a 'For all entries" for a table make a
check that its not empty.
eg. code :
select matnr werks from marc
into table t_marc
where matnr = p_matnr.

if t_marc is not initial.

select matnr mbrsh meins matkl from mara
into table t_mara
for all entries in t_marc
where matnr = t_marc-matnr.

else.
write : / 'No data was fetch by t_marc'.
endif.

Answer / kumar

If you use for all entries statement and if the internal
table which u r using for all entries it will retrieve all
the records from the table which you are using in select
query

Answer / siddharth samal

IF THE 1ST TABLE IS INITIAL THEN THE PROGRAM WILL SHOW DUMP
ERROR COZ ITS MANDATORY THAT THE 1ST TABLE SHOULD HAVE
VALUE.

Answer / babita

If we don't check for intial condition for table 1 and its
is blank, all the records of second table will be displayed.
Hence it is a good practice to always check for following
before using 'FOR ALL ENTRIES'

if not itab1[] is intial.

what are the types of session method in session method?

1 Answers  

---

How does the system handle roll areas for external program components?

0 Answers  

---

How to deactivate the sort button from the alv output

3 Answers   IBM,

---

What is the button to change the variant in ALV ?p

1 Answers   IBM,

---

differences between the sorted ,standard, hashed tables.

2 Answers   CSC, Icon,

---

What are the different types of locks? : abap data dictionary

0 Answers  

---

can we write at-line-selection and at-user-command at a time in same program. plz some body help me to know this answer.

2 Answers   HP,

---

In the `select' statement what is group by ?

0 Answers  

---

i have to fetch the data based on non primary key field from a pooled or clustered table, but for pooled and clustered tables we can't create secondary index then to achieve the performance what to do?

1 Answers   Wipro,

---

what is the difference b/w driver program & print program?

1 Answers  

---

How to find the status of failure a IDOC

2 Answers   IBM,

---

What are the different types of view?

0 Answers  

---