REPORT Z04_033.
DATA: BEGIN OF wa,
connid TYPE spfli-connid,
cityfrom TYPE spfli-cityfrom,
cityto TYPE spfli-cityto,
END OF wa.
DATA GT_WA LIKE WA OCCURS 0.
DATA c1 TYPE spfli-carrid VALUE 'LH'.
EXEC SQL PERFORMING loop_output.
SELECT connid, cityfrom, cityto
INTO :wa
FROM spfli
WHERE carrid = :c1
ENDEXEC.
FORM loop_output.
APPEND WA TO GT_WA.
ENDFORM.
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
171 | REPORT Z02_014 | sapjoy | 2008.04.15 | 2112 |
170 | REPORT Z05_014 | sapjoy | 2008.04.15 | 3011 |
169 | REPORT z05_028 | sapjoy | 2007.05.30 | 2276 |
168 | REPORT Z05_026 [2] | sapjoy | 2007.05.28 | 2428 |
167 | REPORT Z05_012 [1] | sapjoy | 2008.04.15 | 2455 |
166 | REPORT Z05_010 [1] | sapjoy | 2007.05.28 | 2122 |
165 | REPORT Z05_009 [2] | sapjoy | 2007.05.28 | 2150 |
164 | REPORT Z05_008 [2] | sapjoy | 2007.05.28 | 2612 |
163 | REPORT Z05_007 [2] | sapjoy | 2007.05.27 | 2192 |
162 | REPORT z05_005 | sapjoy | 2007.05.22 | 2160 |
161 | REPORT Z05_004 | sapjoy | 2008.04.15 | 2227 |
» | REPORT Z04_033 [1] | sapjoy | 2008.04.15 | 2456 |
159 | REPORT Z04_019 [2] | sapjoy | 2007.05.22 | 2476 |
158 | REPORT Z04_018 | sapjoy | 2007.05.22 | 2110 |
157 | REPORT Z04_017 | sapjoy | 2007.05.22 | 2233 |
156 | REPORT Z04_015 | sapjoy | 2007.05.17 | 2111 |
155 | REPORT Z04_012 [1] | sapjoy | 2007.05.17 | 2064 |
154 | REPORT Z04_011 [1] | sapjoy | 2007.05.17 | 2249 |
153 | REPORT Z04_010 | sapjoy | 2008.04.15 | 2153 |
152 | REPORT z04_009 [1] | sapjoy | 2007.09.13 | 2202 |
NATIVE SQL 은 MANDT 를 자동인식 못하므로
만약 하나의 서버에 여러 CLIENT 인 경우
아래의 WHERE 절에 구문이 더 들어가야 할 듯 싶습니다.^
WHERE carrid = :c1
AND MANDT = 'XXX '