ABAP Open SQL Statements

What are some of the OPEN SQL Statements used in ABAP?. Here it is :

SELECT
OPEN CURSOR, FETCH NEXT, CLOSE CURSOR
INSERT
UPDATE
MODIFY
DELETE
COMMIT WORK
ROLLBACK WORK

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

1. ABAP Programs:Dynamic Open SQL Commands: table name REPORT ZSOURCE2305. PARAMETERS TABLENAME(10) DEFAULT 'CUSTOMERS'. DATA COUNT_ROWS TYPE I. SELECT COUNT( * ) FROM (TABLENAME) INTO COUNT_ROWS. WRITE: TABLENAME, COUNT_ROWS. DATA WHERE_TAB(80) OCCURS 10 WITH HEADER LINE. APPEND 'name...
2. How to Identify Expensive SQL Statements? 1. Start ST05. 2. Switch on the SQL trace: “Trace on”. 3. Run the test program (in a different window). 4. Switch off the  SQL trace: “Trace off”. 5. List...
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: Working with hide statements REPORT ZSOURCE1704. * work area TABLES CUSTOMERS. * Internal table DATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE. * Processing data START-OF-SELECTION. SELECT * FROM CUSTOMERS INTO TABLE ALL_CUSTOMERS....
5. ABAP FAQs: SQL Performance SAP SQL Performance FAQs...
6. SAP FI FAQs – Financial Statements 1.    Discuss the concept of hierarchy levels with regard to the balance sheet in SAP. There are ten levels possible in the financial statement hierarchy.  For each level, an item...
7. Config to Open External URL from IC Webclient Web URL inside CRM IC Web BSP view can be launched using transaction launcher. Follow the steps below: First create URL ID using the path IMG->CRM->IC WebClient->Basic Functions->Transaction Launcher->Define URL’s...
8. Open/Closing Posting Periods Postings in SAP are controlled by the ‘opening’ or ‘closing’ of posting periods. Normally, the current posting period is open for document posting and all other periods are closed. At...
9. Open a New Fiscal Year in SAP System You do not need to open the new fiscal year as a separate activity. Once you make a posting into the new fiscal year, the new fiscal year is automatically...