메뉴 건너뛰기

SAP 한국 커뮤니티

REPORT Z04_021

sapjoy 2007.05.17 00:42 조회 수 : 2213

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.

번호 제목 글쓴이 날짜 조회 수
151 REPORT Z04_007 [1] sapjoy 2008.04.15 2144
150 REPORT z04_014 sapjoy 2007.05.22 2221
149 REPORT Z04_013 sapjoy 2008.04.15 2306
148 REPORT Z04_030 [1] sapjoy 2008.04.15 2273
147 REPORT Z04_004 [7] sapjoy 2008.04.15 2495
146 REPORT Z04_008 [1] sapjoy 2007.05.17 2153
145 REPORT Z04_022 sapjoy 2007.05.17 2096
» REPORT Z04_021 [4] sapjoy 2007.05.17 2213
143 REPORT Z04_002 sapjoy 2008.04.15 2450
142 REPORT Z04_001 sapjoy 2007.05.16 2378
141 REPORT Z03_030 sapjoy 2007.05.16 2170
140 REPORT z03_029 [1] sapjoy 2007.05.16 2136
139 REPORT Z03_028 sapjoy 2007.05.16 2109
138 REPORT z03_022 [2] sapjoy 2007.05.15 2115
137 REPORT Z03_017 [5] sapjoy 2008.04.15 2274
136 REPORT Z03_019 [4] sapjoy 2008.04.15 2151
135 REPORT Z03_018 [3] sapjoy 2006.12.03 2614
134 REPORT Z03_016 [1] sapjoy 2007.05.15 2225
133 REPORT Z03_015 sapjoy 2007.05.15 2134
132 REPORT Z03_013 [4] sapjoy 2007.05.15 2392