How to get the no of records using select statement?

Answer Posted / bhushan

select count( * ) into variable where condition

You will get the number of records...

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is Field group?

669


How the Sy-Mandt value gets updated in the table and Is this having any foreign key relationship.

1708


How can we omit a leading sign and a leading zero in sapscript?

612


What is the collect statement?

677


What is update task

7643






What is an rfc?

597


What is tmg?

694


A field containing quantity amounts (data type quan) must be assigned to a reference table and a reference field. Explain? : abap data dictionary

679


What are the uses of the information in the data dictionary? : abap data dictionary

730


I have 3 transactions,where the output of one transaction is input of another and output of 2nd transaction is input of 3rd transaction.i have one flat file with all data for the 3 transaction.if the 3rd transaction failed can we rollback the remaining 2 transactions or not.Is this possible in BDC,How/

1815


Explain different types of locks?

572


What is meant by read lock? : sap abap data dictionary

565


What is a table pool? : abap data dictionary

609


What are the different methods of passing data? : abap modularization

583


What are the different types of luws. What are they?

631