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

Control Break statements- At new...endat.

903


What are the types of parameters in the function modules?

669


What are the different types joins?

571


Have you set up a back ground job ? How to create a background job without a variant ?

647


What are the tcodes for performance tuning?

912






What is retro active accounting

1600


WHAT ARE THE MANDATORY FIELDS TO BE FILLED FROM TABLES BAPIITEMIN, BAPIPARTNR, BAPIITEMEX, BAPICUCFG, BAPICUINS, BAPICUPRT, AND BAPICUVAL IN BAPI 'BAPI_QUOTATION_CREATEFROMDATA

2044


What abap statement will trigger list generation?

625


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


What are function modules?

582


What are extracts?

568


What is maintenance view?

601


What is the relationship existing between the various data elements? : abap data dictionary

593


Can you define a field without a data element?

560


What are the Synchronous and asynchronous methods in bdc ?

618