Q. What steps to process a Cursor?

http://anubhavtrainings.com
Prepared by :
Charu Borkar charusb@gmail.com
SAP UI5, Fiori, ABAP on HANA Consultant, Australia
Referenced from Training delivered by Anubhav Oberoy (
anubhav.abap@gmail.com
) on ABAP on HANA
P age 19
2. Open the Cursor (Submit the query to Database) – query submitted to DB and data is loaded in context area (memory)
OPEN
3. Fetch statement to process/manipulate the data one by one record.
FETCH INTO ;
4. To access values of fields use .column_name
5. Close cursor
Q. Syntax to create a Table Type?
Ans. Table types are created to hold multiple columns of different types
CREATE TABLE TYPE ( col type, col type);
CREATE TYPE AS TABLE col type, col type);
Pname TABLE(col type, col type….);