Select statement to read data into internal tables. Types of Select statements

SELECT * INTO TABLE FROM

SELECT * FROM ------ INTO itab. 
ENDSELECT.

select ...from dbtable into table itab.select ...from dbtable into itab.endselect.

select * from database table into (internal table name)

         the above statement collects data into the header area of the internal table.

   and

select * from database table into table (internal table name)

          the above statement collects the data into the body area directly .

  1 User has rated as useful.

  

Login to rate this answer.

Related Open Questions

• Fast formula
• How many types of fast formulas are there in hrms?
• One SQL statement which produces the following output
• Write only one SQL statement which produces the following output
• What are the types of hard disks used in servers?
• How do you run a graph successfully with a reformat component which is failing due to data issue??
• Gear & pinion material
• Flow
• Analysis number design flow chart
• Logic and design

Ads

Connect

Ads

Interview Question

 Ask Interview Question?

 

Latest Questions

• Machine target in SAP
• How to copy the lsmw object into another name?
• Explain the principles of relational model.
• It seems that someone has mischievously hacked into out database and changed the password.The hacker then sent an e-mail that read:"doctors divine dominion darts daling demon devotees 55244522."within
• Does writing more than one trigger affect database or table performance?

Interview & Career Tips

Get invaluable Interview and Career Tips delivered directly to your inbox. Get your news alert set up today, Once you confirm your Email subscription, you will be able to download Job Inteview Questions Ebook . Please contact me if you there is any issue with the download.