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.
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
489 | REPORT z17_15 . | sapjoy | 2012.08.01 | 2473 |
488 | REPORT z19_003 | sapjoy | 2007.03.26 | 2473 |
487 | REPORT z18_019 | sapjoy | 2007.03.12 | 2473 |
486 | REPORT Z07_024 | sapjoy | 2006.12.08 | 2472 |
485 | REPORT Z15_037. | sapjoy | 2007.02.05 | 2472 |
484 | REPORT zale_001 . | sapjoy | 2009.02.10 | 2470 |
483 | REPORT z17_21 . | sapjoy | 2012.08.01 | 2469 |
482 | report zunicode_008. | sapjoy | 2008.11.21 | 2465 |
481 | REPORT z11_004 . | sapjoy | 2006.12.22 | 2465 |
480 | REPORT z18_022 | sapjoy | 2007.03.16 | 2464 |
479 | REPORT Z07_008 | sapjoy | 2006.12.07 | 2462 |
478 | REPORT z18_018 [4] | sapjoy | 2007.03.11 | 2462 |
» | REPORT Z04_033 [1] | sapjoy | 2008.04.14 | 2456 |
476 | REPORT Z05_012 [1] | sapjoy | 2008.04.14 | 2455 |
475 | REPORT Z15_041 | sapjoy | 2007.07.31 | 2453 |
474 | REPORT Z07_021 [2] | sapjoy | 2006.12.08 | 2452 |
473 | REPORT z15_021 | sapjoy | 2007.01.29 | 2452 |
472 | REPORT zsapgos_002. | sapjoy | 2009.02.11 | 2451 |
471 | REPORT z18_035 | sapjoy | 2007.03.13 | 2450 |
470 | REPORT Z03_012 [6] | sapjoy | 2007.05.14 | 2448 |
NATIVE SQL 은 MANDT 를 자동인식 못하므로
만약 하나의 서버에 여러 CLIENT 인 경우
아래의 WHERE 절에 구문이 더 들어가야 할 듯 싶습니다.^
WHERE carrid = :c1
AND MANDT = 'XXX '