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

Answer Posted / kapil goyal

Select single fetches first matching record. If more than one matching records are there then only the first matching record will be considered other records will not be taken into account. Where as select up to 1 rows will fetch all the matching records from the database.(Again it will assign only One Record to the internal table/Work area)

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can we define our own match code id's for sap matchcodes ?

594


Hi! I want to join SAP ABAP course in Hyderabad, can any one tell me where should I join? and Which is the best institute for SAP WORKSHOP? Thank you...

1012


What is the use of 'for all entries'?

604


Which transaction code can I use to analyze the performance of abap program?

562


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 are the different buffering methods?

582


how to create module pool program using table controls based on selection criteria specified for sales document item in the first screen and item details in the second screen. plz mention the detail coding Tahnks, Rahul

3417


HOW TO TRANSFER VENDOR MASTER DATA FROM LEGACY SYSTEM TO SAP SYSTEM THRU LSMW (IN LSMW, USING DIRECT INPUT PROGRAM:RFBIKR00)

3296


What is the Process to transfer IDOC from Outbound System to Inbound system.

1680


What is luw?

688


where do we store all custom programs in SD module?

4897


What is sap abap data classes?

609


​​What is the symbol to do “concatenation” operation in​​ nw​​ abap​​ 7.4​​ ?

778


How would you set the formatting options statically and dynamically within a report?

664


What are the components of sapscript?

629