BC430:VIEW與Search Help

Download Report

Transcript BC430:VIEW與Search Help

BC430
ABAP Dictionary
Unit 8 Search Help 、
Unit 7 Views
LOGO
1. Search Help
ABAP 楊子青
Dic2-2
Input Help Requirements
ABAP 楊子青
Dic2-3
Search Help
決定由哪個table或 view 找資料
(1)
(2)
ABAP 楊子青
Dic2-4
Search Help
ABAP 楊子青
Dic2-5
Selection Method of a Search Help
ABAP 楊子青
Dic2-6
Description of the Dialog Behavior
ABAP 楊子青
Dic2-7
Interface of a Search Help
ABAP 楊子青
Dic2-8
Search Help
IMPORT (IMP):
screen上的值會
作為一個限制條
件,加入到
search help中
EXPORT (EXP):
哪些欄位需要
返回值
ABAP 楊子青
Dic2-9
Search Help
search help 可放至
1. Table field
2. check table
3. data element
ABAP 楊子青
Dic2-10
Search Help
1
若有好幾個search
help,由左而右決
定優先順序
2
3
ABAP 楊子青
Dic2-11
Search Help
2. Collective
search help:
把幾個
elementary
search help
組合在一起
ABAP 楊子青
Dic2-12
View as Selection Method of a Search Help
ABAP 楊子青
Dic2-13
2. Views
ABAP 楊子青
Dic2-14
Example: Structure of a View
ABAP 楊子青
Dic2-15
(1) Join Condition
多餘的欄位
ABAP 楊子青
Dic2-16
(2) Field Selection (Projection)
ABAP 楊子青
Dic2-17
(3) Selection Condition
ABAP 楊子青
Dic2-18
How are Tables linked to Views?
ABAP 楊子青
Dic2-19
Structure of the View
ABAP 楊子青
Dic2-20
Data Selection with Views (Open SQL)
ABAP 楊子青
Dic2-21
Data Selection with Views
 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 楊子青
Dic2-22
Inner and Outer Join
ABAP 楊子青
Dic2-23
The Different Types and Usage of Views
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.
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 楊子青
Dic2-24
2.1 Database Views
ABAP 楊子青
Dic2-25
Dynamic attachment of table fields in
database views
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 楊子青
Dic2-26
Dynamic attachment of table fields in
database views
ABAP 楊子青
Dic2-27
2.2 Maintenance Views
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.
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 楊子青
Dic2-28
2.2 Maintenance Views
ABAP 楊子青
Dic2-29
Maintenance view
ABAP 楊子青
Dic2-30