内容文稿sap培训全ibm chapterdata with select statements

1、Retrieving Data with the SELECT Statement | 3.05March-2005Retrieving Data with SELECT Statements2March-2005Retrieving Data with the SELECT Statement | 3.05ObjectivesThe participants will be able to: Retrieve information from the database using Open SQL. Create basic Select statements for use in ABAP

2、 Code. Describe the system field SY-SUBRC and properly use it in an ABAP Program. 3March-2005Retrieving Data with the SELECT Statement | 3.05DBRetrieving Information From the DatabaseDataJohn SmithMary StilesStructured Query Language (SQL)-Data Manipulation Language (DML)Data Definition Language (DD

3、L)Data Control Language (DCL)4March-2005Retrieving Data with the SELECT Statement | 3.05Open SQLPortable across various databasesOpen SQL - a subset of standard SQL5March-2005Retrieving Data with the SELECT Statement | 3.05The Basic SELECT StatementDBMary StilesJohn SmithWork AreaSELECT *FROM .ENDSE

4、LECT.6March-2005Retrieving Data with the SELECT Statement | 3.05Example Using the SELECT StatementTABLES: KNA1.SELECT *FROM KNA1.WRITE: / KNA1-KUNNR, KNA1-NAME1.ENDSELECT.7March-2005Retrieving Data with the SELECT Statement | 3.05The SELECT Statement with a WHERE ClauseTABLES: KNA1.SELECT *FROM KNA1

5、WHERE KTOKD = 0001.WRITE: / KNA1-KUNNR, KNA1-NAME1.ENDSELECT.8March-2005Retrieving Data with the SELECT Statement | 3.05SY-SUBRCTABLES: KNA1.SELECT *FROM KNA1WHERE KTOKD = 0001.WRITE: / KNA1-KUNNR, KNA1-NAME1.ENDSELECT.IF SY-SUBRC 0.WRITE: / No records found.ENDIF.9March-2005Retrieving Data with the

6、 SELECT Statement | 3.05The INTO ClauseTABLES: KNA1.SELECT KUNNR NAME1FROM KNA1INTO (KNA1-KUNNR, KNA1-NAME1).WRITE : / KNA1-KUNNR, KNA1-NAME1.ENDSELECT.IF SY-SUBRC 0.WRITE: / No records found.ENDIF.10March-2005Retrieving Data with the SELECT Statement | 3.05INTO CORRESPONDING-FIELDSTABLES: KNA1.SELE

7、CT KUNNR NAME1FROM KNA1INTO CORRESPONDING-FIELDS OF KNA1.WRITE : / KNA1-KUNNR, KNA1-NAME1.ENDSELECT.IF SY-SUBRC 0.WRITE: / No records found. ENDIF.11March-2005Retrieving Data with the SELECT Statement | 3.05DemonstrationSelection of data from a database table, checking sy-subrc and displaying the va

8、lues in a report.12March-2005Retrieving Data with the SELECT Statement | 3.05PracticeSelection of data from a database table, checking sy-subrc and displaying the values in a report.13March-2005Retrieving Data with the SELECT Statement | 3.05SummarySQL has three main components:Data Manipulation Lan

9、guage (DML):Data Definition Language (DDL):Data Control Language (DCL):The DML provides the four basic data operations: Select (retrieve)InsertUpdateDeleteOpen SQL is a subset of standard SQL with a specific syntax recognised by ABAP.14March-2005Retrieving Data with the SELECT Statement | 3.05QuestionsWhat is