메뉴 건너뛰기

SAP 한국 커뮤니티

REPORT Z04_022

sapjoy 2007.05.17 00:43 조회 수 : 2113

REPORT  Z04_022.


DATA: BEGIN OF wa,


                     carrid   TYPE sflight-carrid,


                     connid   TYPE spfli-connid,


           END OF wa,


           itab LIKE SORTED TABLE OF wa


                                WITH NON-UNIQUE KEY carrid.


 


SELECT a~carrid b~connid


           INTO CORRESPONDING FIELDS OF TABLE itab


           FROM sflight AS a


                     LEFT OUTER JOIN spfli AS b ON a~carrid   =  b~carrid AND


                                                                          b~cityfrom = 'OSAKA'.


WRITE 'OUTER JOIN 결과'


LOOP AT itab INTO wa.


           WRITE: / wa-carrid, wa-connid.


ENDLOOP.

번호 제목 글쓴이 날짜 조회 수
151 REPORT Z04_007 [1] sapjoy 2008.04.15 2179
150 REPORT z04_014 sapjoy 2007.05.22 2239
149 REPORT Z04_013 sapjoy 2008.04.15 2326
148 REPORT Z04_030 [1] sapjoy 2008.04.15 2312
147 REPORT Z04_004 [7] sapjoy 2008.04.15 2536
146 REPORT Z04_008 [1] sapjoy 2007.05.17 2191
» REPORT Z04_022 sapjoy 2007.05.17 2113
144 REPORT Z04_021 [4] sapjoy 2007.05.17 2252
143 REPORT Z04_002 sapjoy 2008.04.15 2475
142 REPORT Z04_001 sapjoy 2007.05.16 2406
141 REPORT Z03_030 sapjoy 2007.05.16 2191
140 REPORT z03_029 [1] sapjoy 2007.05.16 2171
139 REPORT Z03_028 sapjoy 2007.05.16 2129
138 REPORT z03_022 [2] sapjoy 2007.05.15 2158
137 REPORT Z03_017 [5] sapjoy 2008.04.15 2316
136 REPORT Z03_019 [4] sapjoy 2008.04.15 2185
135 REPORT Z03_018 [3] sapjoy 2006.12.03 2653
134 REPORT Z03_016 [1] sapjoy 2007.05.15 2261
133 REPORT Z03_015 sapjoy 2007.05.15 2149
132 REPORT Z03_013 [4] sapjoy 2007.05.15 2431