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 project system Landscape?

6 Answers   ITC Infotech, MSG Global, TCS,

---

How can the standard tables of sap be modified?

0 Answers  

---

Can we call reports and transactions from interactive reporting lists?

0 Answers  

---

26) Explain the Importance of each type of window in scripts?

2 Answers  

---

Hi Gurus, I have 250 records in an internal table, tell me how to randomly delete the each 5th record...i,e 5,10,15,20 like this.

2 Answers   Accenture,

---

what is the use of free and refresh?

11 Answers   Accenture, IBM,

---

What are the 3 types of tables in sap? : abap data dictionary

0 Answers  

---

What is the difference between Check and Continue?

0 Answers  

---

what is RFC STUB program?

1 Answers   Cap Gemini,

---

What is the difference between a substructure and an append structure?

0 Answers  

---

why to create a custom BAPI if the BAPI already exists? y to find BAPI again? frankly even i dint undstnd tne question properly. if any one come across this q please do anser me.

0 Answers   IBM,

---

How to read files and process BDC's automatically ?

0 Answers  

---