Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

when you are using 2 internal table in program, you have
decided to use for all entries statement to retrieve data
but unfortunately there are no records in the first internal
table. What will be the result? (2nd internal table contains
records).

Answer Posted / 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.

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an rfc?

1246


Can you create a table with fields not referring to data elements? : abap data dictionary

1287


What is an abap?

1012


What data is contained in data dictionary? : abap data dictionary

1106


Lock objects and what are parameters of ENQUEUE FM?

1788


What is the function of the transport system and workbench organizer?

1154


What is repository info. Systems? : abap data dictionary

1018


What are the basic objects of the data dictionary?

1016


Explain the sequences of event block?

1023


What is the difference between dialog program and a report?

1082


What are the arithmetic operators in the sap abap?

1086


What does the insert statement in extract datasets do?

1077


What are the two ways for restricting the value range for a domain ?

1211


What statement will be found in an sap application program that implements a function module exit?

1007


Do you know any other patterns if yes.. explain

1302