What is the diffrence between select single * and Select
upto 1 row?

Answer Posted / kiran kumar v

Select Single * -- 1) Will never have endselect.2)
Applicable key fields are mentioned in Where clause.3) It
retrieves the first record which matches the condition.

Select upto 1 row -- 1) Will have endselect. 2)Where clause
is not mandatory. 3) Pull up all the records and display
the first record in the list.

Is This Answer Correct ?    9 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

send coding to write a program to create customer quotation using BAPI 'BAPI_QUOTATION_CREATEFROMDATA2/BAPI_QUOTATION_CREATEFR OMDATA'

2413


Can a constructor be declared private? If yes then in which scenario?

919


What is the sap abap?

625


what is the difference between Blocked ALV and interactive ALV?

1866


Explain the use of table maintenance allowed?

536






1 . how do u design technical documentation in abap ? 2 . what u currently devloped in sap abap ?

2564


How to get that a secondary index is attached to a select query?

939


Cds views

7671


What is the use of f4if_shlp_exit_example function module ? : sap abap data dictionary

1291


Hat are the different types of mode (run code) in call transaction method?

570


Is sap xi intended to replace ale?

580


What are field symbols?

631


What is the difference between table and template?

572


If i wont like to change the standard print program where i copied standard script to customer namespace,in this case is it possible to retreive the data if u connect the script with standard program.if yes how?if no why? Is it possible to print the logo in first page only,where the form consists of 10 pages.How can u do this? How can u set a table format where it cosists of fields like cust no, custname, amount ...in a script? How do u know that the particular BADI is suitable for the existed report.How do u findout this?When do u opt for BADI OR USEREXIT?did functional people tell u to adopt BADI or USEREXIT? What is the difference between SY-INDEX & SY-TABIX ? I have a report with fields Status,time & date. the contents it consists are Status Time Date AAA 01:20:15 05-06-10 AAA 11:02:32 O3-06-10 AAA 23:11:00 05-06-10 AAA 09:14:46 05-06-10 HOW DO U WRITE A CODE TO DISLAY A ROW WHICH WAS RECENTLY EXECUTED?( for this question it should display AAA 23:11:00 05-06-10 AS Output)

2063


Which objects are independent transport objects? : abap data dictionary

571