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 is the sap standard script for picking list?

2 Answers   Intelligroup,

---

Event handling in oops

0 Answers   Infosys,

---

In delivery processing which step comes first picking, packing, posting goods issue ?

0 Answers  

---

Explain the relationship between a functional area, user group, and query when developing queries using the sap query tool?

0 Answers  

---

difference between Valuation type and valuation category?

0 Answers  

---

What are control commands in sap scripts?

3 Answers   EDS,

---

what is the use of start-of-selection event? what is the difference betn end-of-page and end-of-selection?

2 Answers  

---

What is size category?

0 Answers  

---

how we output smartform in pdf format??? anyone give me steps on that.

2 Answers  

---

What's the use of AT PF event?

1 Answers   HP,

---

What is sap luw or update transaction?

0 Answers  

---

How we can retrieve data using secondary index. Explain with simple example?

0 Answers  

---