메뉴 건너뛰기

SAP 한국 커뮤니티

REPORT Z04_021

sapjoy 2007.05.16 15:42 조회 수 : 2206

REPORT  Z04_021.


DATA: BEGIN OF wa,


                     carrid TYPE spfli-carrid,


                     connid TYPE spfli-connid,


                     fldate TYPE sflight-fldate,


           END OF wa,


           itab LIKE standard TABLE OF wa.


 


SELECT  a~carrid a~connid b~fldate


           INTO  CORRESPONDING FIELDS OF TABLE itab


           FROM   ( spfli AS p


                     INNER JOIN sflight AS f ON a~carrid = b~carrid AND


                                                                a~connid = b~connid    )


           WHERE b~seatsmax > b~seatsocc.


 


WRITE : '---INNER JOIN 결과---'.


 


LOOP AT itab INTO wa.


           WRITE: / wa-carrid, wa-connid, wa-fldate.


ENDLOOP.

번호 제목 글쓴이 날짜 조회 수
190 REPORT Z05_008 [2] sapjoy 2007.05.27 2611
189 REPORT Z05_007 [2] sapjoy 2007.05.26 2192
188 REPORT Z05_003 sapjoy 2007.05.21 2406
187 REPORT z05_005 sapjoy 2007.05.21 2160
186 REPORT Z05_002 sapjoy 2007.05.21 2172
185 REPORT Z05_001 [3] sapjoy 2007.05.21 2880
184 REPORT Z04_019 [2] sapjoy 2007.05.21 2476
183 REPORT Z04_018 sapjoy 2007.05.21 2109
182 REPORT Z04_017 sapjoy 2007.05.21 2233
181 REPORT z04_014 sapjoy 2007.05.21 2216
180 REPORT Z04_015 sapjoy 2007.05.16 2111
179 REPORT Z04_011 [1] sapjoy 2007.05.16 2249
178 REPORT Z04_012 [1] sapjoy 2007.05.16 2064
177 REPORT Z04_022 sapjoy 2007.05.16 2092
» REPORT Z04_021 [4] sapjoy 2007.05.16 2206
175 REPORT Z04_008 [1] sapjoy 2007.05.16 2150
174 REPORT Z04_003 [9] sapjoy 2007.05.16 2561
173 REPORT Z04_001 sapjoy 2007.05.16 2375
172 REPORT Z03_030 sapjoy 2007.05.15 2166
171 REPORT Z03_028 sapjoy 2007.05.15 2102