SPAN {
font-family: "Courier New";
font-size: 10pt;
color: #000000;
background: #FFFFFF;
}
.L1S32 {
color: #3399FF;
}
.L1S33 {
color: #4DA619;
}
.L1S52 {
color: #0000FF;
}
1.demo_select_dynamic_columns
DATA: line(72) TYPE c.
DATA: list LIKE TABLE OF line(72).
line = 'cityfrom cityto'.
append LINE TO list.
2
reset===>
clear line.
3.
SPAN { font-family: "Courier New"; font-size: 10pt; color: #000000; background: #FFFFFF; } .L1S31 { font-style. italic; color: #808080; } .L1S52 { color: #0000FF; } SELECT DISTINCT (list) "DISTINCT(list)==>error, because DISTINCT is not a function
4.
when we use bracket to include something, ABAP will interpret it
for example
DATA name(10) TYPE c VALUE 'SCARR'.
SELECT *
INTO wa
FROM (name) CLIENT SPECIFIED
WHERE mandt = '000'. "current client is 800
CLIENT SPECIFIED
SPAN { font-family: "Courier New"; font-size: 10pt; color: #000000; background: #FFFFFF; } .L1S33 { color: #4DA619; } .L1S52 { color: #0000FF; } CONCATENATE 'cityfrom = ''' city1 '''' into cond.
APPEND cond to itab.
CONCATENATE ' OR cityfrom = ''' city2 '''' into cond.
APPEND cond to itab.
CONCATENATE ' or cityfrom = ''' 'BERLIN' '''' into cond.
WHY 4 ==》 '''' ？？？？？？？？？？？？？？？？
6
HIDE: wa-carrid, wa-connid, wa-seatsmax.
ENDSELECT.
AT LINE-SELECTION.
WINDOW STARTING AT 45 3 ENDING AT 85 13.
WRITE: 'Alternative Plane Types',
'for', wa-carrid, wa-connid.
ULINE.
DATA: line(72) TYPE c.
DATA: list LIKE TABLE OF line(72).
line = 'cityfrom cityto'.
append LINE TO list.
2
reset===>
clear line.
3.
SPAN { font-family: "Courier New"; font-size: 10pt; color: #000000; background: #FFFFFF; } .L1S31 { font-style. italic; color: #808080; } .L1S52 { color: #0000FF; } SELECT DISTINCT (list) "DISTINCT(list)==>error, because DISTINCT is not a function
4.
when we use bracket to include something, ABAP will interpret it
for example
DATA name(10) TYPE c VALUE 'SCARR'.
SELECT *
INTO wa
FROM (name) CLIENT SPECIFIED
WHERE mandt = '000'. "current client is 800
CLIENT SPECIFIED
Effect:
This addition deactivates the automatic client handling of Open SQL. If the addition CLIENT SPECIFIED is used, the client identifier specified in source is taken into account. Without the addition CLIENT SPECIFIED, the ABAP runtime environment does not transfer the client identifier specified in source to the database system, but transfers the identifier of the current client instead.
5SPAN { font-family: "Courier New"; font-size: 10pt; color: #000000; background: #FFFFFF; } .L1S33 { color: #4DA619; } .L1S52 { color: #0000FF; } CONCATENATE 'cityfrom = ''' city1 '''' into cond.
APPEND cond to itab.
CONCATENATE ' OR cityfrom = ''' city2 '''' into cond.
APPEND cond to itab.
CONCATENATE ' or cityfrom = ''' 'BERLIN' '''' into cond.
WHY 4 ==》 '''' ？？？？？？？？？？？？？？？？
6
HIDE: wa-carrid, wa-connid, wa-seatsmax.
ENDSELECT.
AT LINE-SELECTION.
WINDOW STARTING AT 45 3 ENDING AT 85 13.
WRITE: 'Alternative Plane Types',
'for', wa-carrid, wa-connid.
ULINE.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/13895577/viewspace-668760/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
