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.
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
450 | REPORT Z03_017 [5] | sapjoy | 2008.04.14 | 2268 |
449 | REPORT Z04_002 | sapjoy | 2008.04.14 | 2447 |
448 | REPORT Z04_004 [7] | sapjoy | 2008.04.14 | 2487 |
447 | REPORT Z04_030 [1] | sapjoy | 2008.04.14 | 2268 |
446 | REPORT Z04_013 | sapjoy | 2008.04.14 | 2304 |
445 | REPORT Z04_007 [1] | sapjoy | 2008.04.14 | 2140 |
444 | REPORT Z04_010 | sapjoy | 2008.04.14 | 2153 |
» | REPORT Z04_033 [1] | sapjoy | 2008.04.14 | 2456 |
442 | REPORT Z05_004 | sapjoy | 2008.04.14 | 2227 |
441 | REPORT Z05_012 [1] | sapjoy | 2008.04.14 | 2455 |
440 | REPORT Z05_013 [3] | sapjoy | 2008.04.14 | 2653 |
439 | REPORT Z05_014 | sapjoy | 2008.04.14 | 3010 |
438 | REPORT Z02_014 | sapjoy | 2008.04.14 | 2111 |
437 | REPORT Z07_003 | sapjoy | 2008.04.14 | 2150 |
436 | REPORT Z07_016 | sapjoy | 2008.04.14 | 2804 |
435 | REPORT Z07_028 [2] | sapjoy | 2008.04.14 | 2139 |
434 | REPORT Z10_001 | sapjoy | 2008.04.14 | 2340 |
433 | REPORT Z13_004 [1] | sapjoy | 2008.04.14 | 2221 |
432 | REPORT Z13_022 [2] | sapjoy | 2008.04.14 | 1944 |
431 | REPORT z13_023 [1] | sapjoy | 2008.04.14 | 1859 |
NATIVE SQL 은 MANDT 를 자동인식 못하므로
만약 하나의 서버에 여러 CLIENT 인 경우
아래의 WHERE 절에 구문이 더 들어가야 할 듯 싶습니다.^
WHERE carrid = :c1
AND MANDT = 'XXX '