BC 430 ABAP Dictionary Unit 8 Search Help

BC 430 ABAP Dictionary Unit 8 Search Help 、 Unit 7 Views LOGO

1. Search Help ABAP 楊子青 2

Input Help Requirements ABAP 楊子青 3

Search Help 決定由哪個table或 view 找資料 (1 ) (2) ABAP 楊子青 4

Search Help ABAP 楊子青 5

Selection Method of a Search Help ABAP 楊子青 6

Description of the Dialog Behavior ABAP 楊子青 7

Interface of a Search Help ABAP 楊子青 8

Search Help search help 可放至 1. Table field 2. check table 3. data element ABAP 楊子青 10

Search Help 2. Collective search help： 把幾個 elementary search help 組合在一起 ABAP 楊子青 12

View as Selection Method of a Search Help ABAP 楊子青 13

2. Views ABAP 楊子青 14

Example: Structure of a View ABAP 楊子青 15

(1) Join Condition 多餘的欄位 ABAP 楊子青 16

(2) Field Selection (Projection) ABAP 楊子青 17

(3) Selection Condition ABAP 楊子青 18

How are Tables linked to Views? ABAP 楊子青 19

Structure of the View ABAP 楊子青 20

Data Selection with Views (Open SQL) ABAP 楊子青 21

Data Selection with Views v You would get the same result using an Inner Join: SELECT C~CARRID C~CARRNAME P~CONNID P~CITYFROM P~CITYTO F~FLDATE F~SEATSMAX F~SEATSOCC INTO TABLE ITAB_FLIGHTS FROM ( SCARR AS C INNER JOIN SPFLI AS P ON C~CARRID = P~CARRID ) INNER JOIN SFLIGHT AS F ON F~CARRID = P~CARRID AND F~CONNID = P~CONNID WHERE CITYFROM IN SO_CITYF AND CITYTO IN SO_CITYT AND SEATSOCC < F~SEATSMAX ORDER BY C~CARRID P~CONNID F~FLDATE. ABAP 楊子青 22

Inner and Outer Join ABAP 楊子青 23

The Different Types and Usage of Views v Database View § are implement an inner join § that is, only records of the primary table (selected via the join operation) for which the corresponding records of the secondary tables also exist are fetched. v Maintenance View § are implement an outer join § Data from several tables can be summarized in a maintenance view and maintained collectively via this view. § That is, the data is entered via the view and then distributed to the underlying tables by the system. ABAP 楊子青 24

2. 1 Database Views ABAP 楊子青 25

Dynamic attachment of table fields in database views v. You can include entire tables in database views. § In this case all the fields of the included table become fields of the view. § If new fields are included in the table or existing fields are deleted, the view is automatically adjusted to this change. § A new or deleted field is therefore automatically included in the view or deleted from it. ABAP 楊子青 26

Dynamic attachment of table fields in database views ABAP 楊子青 27

2. 2 Maintenance Views v. Data that is distributed on more than one table often forms a logical unit (application object) § The user usually is not interested in the technical implementation, such as the distribution of the data on several tables. § You should be able to display, change and create the data of such an application object together. v. You can maintain complex application objects in a simple way using a maintenance view. § The data is automatically distributed on the underlying database tables. ABAP 楊子青 28

2. 2 Maintenance Views ABAP 楊子青 29

Maintenance view ABAP 楊子青 30