SELECT SINGLE Statement

The Select Single Statement is used to ensure that only one row is read from the Database. The Search is terminated as soon as the that row is found with the required criteria. Select Single will definetly produce better performance then SELECT … UP TO 1 ROWS  … END SELECT when you have something is search for in the where clause.

If you like this post, you may as well like these too:

1. ABAP Programs: Using Select-Options REPORT CHAP1109.* Work areaTABLES CUSTOMERS.* Specifiying a Select-OptionSELECT-OPTIONS SNAME FOR CUSTOMERS-NAME.* Internal table for later useDATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE.* Reading table entries according to a...
2. ABAP Programs: Working with Select-Options REPORT ZSOURCE1602. * Work area TABLES CUSTOMERS. * Defining Select-Options SELECT-OPTIONS S_NAME FOR CUSTOMERS-NAME. SELECT * FROM CUSTOMERS WHERE NAME IN S_NAME. WRITE / CUSTOMERS-NAME. ENDSELECT....
3. ABAP Programs: Using select statements REPORT ZSOURCE1501. * Work areas TABLES: CUSTOMERS, BOOKINGS. * Reading data SELECT * FROM CUSTOMERS. WRITE / CUSTOMERS-NAME. SELECT * FROM BOOKINGS WHERE CUSTOMID = CUSTOMERS-ID AND FLDATE > ’19990501′...
4. ABAP Programs: Obtaining data with nested select loops REPORT ZSOURCE1111.* Work areasTABLES: CUSTOMERS, BOOKINGS.* Reading entries from both database tableSELECT * FROM CUSTOMERS. SELECT * FROM BOOKINGS WHERE CUSTOMID = CUSTOMERS-ID AND ORDER_DATE = ’19990101′. WRITE: / CUSTOMERS-NAME,...
5. ABAP Programs: Reading single entries REPORT ZSOURCE1105.* Work area for a database tableTABLES CUSTOMERS.* Reading a single entrySELECT SINGLE * FROM CUSTOMERS WHERE ID = ’87654321′.IF SY-SUBRC = 0. WRITE CUSTOMERS-NAME.ELSE. WRITE ‘Customer not found.’.ENDIF.~~~...
6. ABAP Programs: Selecting Single Fields REPORT ZSOURCE1106.* Work area for a database tableTABLES CUSTOMERS.* Selecting single fieldsDATA: CID LIKE CUSTOMERS-ID, CNAME LIKE CUSTOMERS-NAME.SELECT ID NAME INTO (CID,CNAME) FROM CUSTOMERS. WRITE: / CID, CNAME.ENDSELECT. ~~~ end...
7. ABAP Programs: Appending single lines REPORT ZSOURCE1204.* Work area for a database tableTABLES CUSTOMERS.* Types for later useTYPES: BEGIN OF T_CUSTOMER_CITY, ID LIKE CUSTOMERS-ID, CITY LIKE CUSTOMERS-CITY, END OF T_CUSTOMER_CITY.* Internal table with two columnsDATA...
8. ABAP Programs: Deleting single entries from a database table REPORT ZSOURCE1307.* Work areaTABLES CUSTOMERS.* Deleting an entryCUSTOMERS-ID = ’12345678′.DELETE CUSTOMERS. ~ end of post ~ ———————ABAPer, mail: abap.community@gmail.com http://www.erpdb.info...
9. ABAP Programs: Modifying single entries in a database table REPORT ZSOURCE1305.* Work areaTABLES CUSTOMERS.* Modifying an entryCUSTOMERS-ID = ’12345678′.CUSTOMERS-CITY = ‘Village’.MODIFY CUSTOMERS. ~ end of post ~ ———————ABAPer, mail: abap.community@gmail.com http://www.erpdb.info...
10. ABAP Programs: Updating single entries in a database table REPORT ZSOURCE1303.* Work areaTABLES CUSTOMERS.* Record used as alternative work areaDATA MY_CUSTOMER LIKE CUSTOMERS.* Updating one entry from the work areaCUSTOMERS-ID = ’12345678′.CUSTOMERS-CITY = ‘Village’.UPDATE CUSTOMERS.IF SY-SUBRC 0. WRITE: ‘Entry...
11. ABAP Programs: Inserting single entries in a database table REPORT ZSOURCE1301.* Work areaTABLES CUSTOMERS.* Record used as alternative work areaDATA MY_CUSTOMER LIKE CUSTOMERS.* Inserting one entry from the work areaCUSTOMERS-ID = ’12345678′.CUSTOMERS-NAME = ‘Brown’.INSERT CUSTOMERS.IF SY-SUBRC 0. WRITE: /...
12. What is a Financial Statement Version? Financial Statement Version A FSV (Financial Statement Version) is a reporting tool and can be used to depict the manner in which the financial accounts like Profit and Loss Account...
13. Chained Statement A Consecutive statement with the same initial keyword can be condensed into a single chained statement. The Initial part of the statement containing the keyword must be followed by a...
14. Configure Manual Bank Statement The following are the steps for configuring manual bank statement: Create account symbols for the main bank and the sub accounts Assign accounts to account symbols Create keys for posting...
15. Configure Electronic Bank Statement Following are the steps involved in configuring Electronic Bank Statement Create account symbols for the main bank and the sub accounts. Assign accounts to account symbols. Create keys for posting...