sap abap开发教程sap教程abap培训教材abap intro to abap - chapter 09.pptVIP

Database Access I SQL (SELECT) WHERE Clause: Single Access Syntax: Restricted Loop Processing Syntax: Between Values, Templates and Lists WHERE Clause: Loop Processing with Restricted Selection LIKE: Example of a Template (%_) IN: Example of a Comparison Value List IN: Example of a Range The ORDER BY Clause BYPASSING BUFFER SELECT Statement BC170_09.* REPORT: ZRACER01. TABLES: LFA1, LFB1, LFC3. GET LFA1. GET LFB1. GET LFB3. Authorisation Checking Logical Database ABAP Native SQL ABAP Open SQL No AuthorisationChecking Physical Database ABAP Programs REPORT: YNEWAPPL. TABLES... SELECT * FROM TABNA. ENDSELECT. ABAP Reports Data Database TABNA LFA1 LFC1 ------------------------------------------------------------------------------------------ report y170dm64. tables: tabna. Syntax of a select single statement for single access. ---------- select single from tabna where country eq ’D’ and id eq . if sy-subrc = 0. write: tabna-country, tabna-id, tabna-name1. endif. In the return-code field (SY-SUBRC), 0 = successful and 4 = entry does not exist. The SELECT SINGLE* statement requires the full primary key of the table in the WHERE clause. * * * * * * * SELECT * FROM table WHERE table field 1 relational operator field 1 AND table field 2 relational operator field 2 OR table field 3 relational operator field 3 AND table field 4 relational operator field 4 : : OR table field n relational operator field n. ENDSELECT. EQ = GE = = LE = = NE GT LT Relational Operators SELECT * FROM table WHERE table field... BETWEEN field 1 AND field 2 LIKE with ‘%’ and ‘_’ masked literal IN (field 1, field 2,......field n) report y170md65. tables: tabna. The result of the select statement is limited by the conditions of the where clause. * * select * from tabna where country eq ‘USA’ and id between ‘0000001’ and ‘0000002’ . write: / tabna-country, tabna-id. tabna-name1. endselect. if sy-