ABAP Report Programming_2.ppt

ABAP Programming (2) -Wenwen Hou 2007/03/01- ABAP Programming - Part IIAgenda SQL Commands Internal Table Processing More ABAP/4 Commands Select Processing Example Using the SELECT Statement TABLES: MARA. SELECT * FROM MARA. WRITE: / MARA-MATNR, MARA-MTART. ENDSELECT. The SELECT Statement with a WHERE Clause TABLES: MARA. SELECT * FROM MARA WHERE MTART = ‘ROH’. WRITE: / MARA-MATNR, MARA-MTART. ENDSELECT. Control statements - IF SY-SUBRC TABLES: MARA. SELECT * FROM MARA WHERE MTART = ‘ROH’. WRITE: / MARA-MATNR, MARA-MTART. ENDSELECT. IF SY-SUBRC 0. WRITE: / ‘No records found.’. ENDIF. The INTO Clause TABLES: MARA. SELECT MATNR MTART FROM MARA INTO (MARA-MATNR,MARA-MTART) WHERE MTART = ‘ROH’. WRITE: / MARA-MATNR, MARA-MTART. ENDSELECT. IF SY-SUBRC 0. WRITE: / ‘No records found.’. ENDIF. INTO CORRESPONDING-FIELDS TABLES: MARA. SELECT MATNR MTART FROM MARA INTO CORRESPONDING FIELDS OF MARA WHERE MTART = ‘ROH’. WRITE: / MARA-MATNR, MARA-MTART. ENDSELECT. IF SY-SUBRC 0. WRITE: / ‘No records found.’. ENDIF. CASE Statement DO Loop DO Examples WHILE Loop CHECK Statement EXIT Statement STOP Statement CONTINUE Statement Logical Expressions Logical Expressions use : RELATIONAL OPERATORS LOGICAL OPERATORS STRING COMPARISON OPERATORS Relational Operators Logical Operators String Comparison Operators Field string vs. Internal Table Declaring Internal Table - 1 Declaring Internal Table - 2 Declaring Internal Table - 3 Internal Table Processing Internal Table Processing Deleting an Internal Table Example -1 Example -2 Example -3 Control Level Processing Control Level Processing - Example Subroutines Sample Subroutine Subroutines Syntax Global vs. Local Data Global SAP Memory Function Modules Function Modules, Format ( CONVERSION_EXIT_ALPHA_OUTPUT：將數字前的0都去除 ) CALL FUNCTION CONVERSION_EXIT_ALPHA_OUTPUT EXPORTING