FORM PUT_SPFLI.
DATA L_WHERE TYPE RSDS_WHERE.
DATA L_TAB_FIELDS TYPE RSFS_TAB_FIELDS.
* Dynamic selections for tables SPFLI
MOVE 'SPFLI' TO L_WHERE-TABLENAME.
READ TABLE DYN_SEL-CLAUSES WITH KEY L_WHERE-TABLENAME INTO L_WHERE.
* Field selection for node SPFLI
MOVE 'SPFLI' TO L_TAB_FIELDS-TABLENAME.
READ TABLE SELECT_FIELDS WITH KEY L_TAB_FIELDS-TABLENAME INTO L_TAB_FIELDS.
* Data retrieval
SELECT (L_TAB_FIELDS-FIELDS)
INTO CORRESPONDING FIELDS OF SPFLI FROM SPFLI
WHERE CARRID IN CARRID
AND AIRPFROM IN AIRP_FR
AND AIRPTO IN AIRP_TO
AND (L_WHERE-WHERE_TAB) ORDER BY PRIMARY KEY.
PUT SPFLI.
ENDSELECT.
ENDFORM.
FORM PUT_SFLIGHT.
DATA L_TAB_FIELDS TYPE RSFS_TAB_FIELDS.
* Field selection for node SFLIGHT
MOVE 'SFLIGHT' TO L_TAB_FIELDS-TABLENAME.
READ TABLE SELECT_FIELDS WITH KEY L_TAB_FIELDS-TABLENAME INTO L_TAB_FIELDS.
SELECT (L_TAB_FIELDS-FIELDS)
INTO CORRESPONDING FIELDS OF SFLIGHT FROM SFLIGHT
WHERE CARRID = SPFLI-CARRID AND CONNID = SPFLI-CONNID
AND FLDATE IN FLDATE ORDER BY PRIMARY KEY.
PUT SFLIGHT.
ENDSELECT.
ENDFORM. "PUT_SFLIGHT
FORM PUT_SBOOK.
CONSTANTS MARK VALUE 'X'.
DATA L_TAB_FIELDS TYPE RSFS_TAB_FIELDS.
MOVE 'SBOOK' TO L_TAB_FIELDS-TABLENAME.
READ TABLE SELECT_FIELDS WITH KEY L_TAB_FIELDS-TABLENAME INTO L_TAB_FIELDS.
CASE PA_CANC.
WHEN MARK.
SELECT (L_TAB_FIELDS-FIELDS)
INTO CORRESPONDING FIELDS OF SBOOK FROM SBOOK
WHERE CARRID = SFLIGHT-CARRID
AND CONNID = SFLIGHT-CONNID AND FLDATE = SFLIGHT-FLDATE
AND BOOKID IN BOOKID.
PUT SBOOK.
ENDSELECT.
WHEN SPACE.
SELECT (L_TAB_FIELDS-FIELDS)
INTO CORRESPONDING FIELDS OF SBOOK FROM SBOOK
WHERE CARRID = SFLIGHT-CARRID
AND CONNID = SFLIGHT-CONNID AND FLDATE = SFLIGHT-FLDATE
AND CANCELLED = ' ' AND BOOKID IN BOOKID.
PUT SBOOK.
ENDSELECT.
ENDCASE.
ENDFORM. "PUT_SBOOK
DATA L_WHERE TYPE RSDS_WHERE.
DATA L_TAB_FIELDS TYPE RSFS_TAB_FIELDS.
* Dynamic selections for tables SPFLI
MOVE 'SPFLI' TO L_WHERE-TABLENAME.
READ TABLE DYN_SEL-CLAUSES WITH KEY L_WHERE-TABLENAME INTO L_WHERE.
* Field selection for node SPFLI
MOVE 'SPFLI' TO L_TAB_FIELDS-TABLENAME.
READ TABLE SELECT_FIELDS WITH KEY L_TAB_FIELDS-TABLENAME INTO L_TAB_FIELDS.
* Data retrieval
SELECT (L_TAB_FIELDS-FIELDS)
INTO CORRESPONDING FIELDS OF SPFLI FROM SPFLI
WHERE CARRID IN CARRID
AND AIRPFROM IN AIRP_FR
AND AIRPTO IN AIRP_TO
AND (L_WHERE-WHERE_TAB) ORDER BY PRIMARY KEY.
PUT SPFLI.
ENDSELECT.
ENDFORM.
FORM PUT_SFLIGHT.
DATA L_TAB_FIELDS TYPE RSFS_TAB_FIELDS.
* Field selection for node SFLIGHT
MOVE 'SFLIGHT' TO L_TAB_FIELDS-TABLENAME.
READ TABLE SELECT_FIELDS WITH KEY L_TAB_FIELDS-TABLENAME INTO L_TAB_FIELDS.
SELECT (L_TAB_FIELDS-FIELDS)
INTO CORRESPONDING FIELDS OF SFLIGHT FROM SFLIGHT
WHERE CARRID = SPFLI-CARRID AND CONNID = SPFLI-CONNID
AND FLDATE IN FLDATE ORDER BY PRIMARY KEY.
PUT SFLIGHT.
ENDSELECT.
ENDFORM. "PUT_SFLIGHT
FORM PUT_SBOOK.
CONSTANTS MARK VALUE 'X'.
DATA L_TAB_FIELDS TYPE RSFS_TAB_FIELDS.
MOVE 'SBOOK' TO L_TAB_FIELDS-TABLENAME.
READ TABLE SELECT_FIELDS WITH KEY L_TAB_FIELDS-TABLENAME INTO L_TAB_FIELDS.
CASE PA_CANC.
WHEN MARK.
SELECT (L_TAB_FIELDS-FIELDS)
INTO CORRESPONDING FIELDS OF SBOOK FROM SBOOK
WHERE CARRID = SFLIGHT-CARRID
AND CONNID = SFLIGHT-CONNID AND FLDATE = SFLIGHT-FLDATE
AND BOOKID IN BOOKID.
PUT SBOOK.
ENDSELECT.
WHEN SPACE.
SELECT (L_TAB_FIELDS-FIELDS)
INTO CORRESPONDING FIELDS OF SBOOK FROM SBOOK
WHERE CARRID = SFLIGHT-CARRID
AND CONNID = SFLIGHT-CONNID AND FLDATE = SFLIGHT-FLDATE
AND CANCELLED = ' ' AND BOOKID IN BOOKID.
PUT SBOOK.
ENDSELECT.
ENDCASE.
ENDFORM. "PUT_SBOOK
댓글 0
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
31 | REPORT Z13_013 | sapjoy | 2007.01.09 | 2635 |
30 | REPORT Z13_012 | sapjoy | 2007.01.09 | 2284 |
29 | REPORT Z13_003 | sapjoy | 2007.01.06 | 2438 |
28 | FORM set_field_catalogs_grid USING lt_fieldcat TYPE lvc_t_fcat. | sapjoy | 2007.01.04 | 2877 |
27 | REPORT Z12_004 | sapjoy | 2007.01.03 | 2261 |
26 | REPORT z12_002 | sapjoy | 2006.12.28 | 2630 |
25 | MODULE f4_drum_s101 INPUT. 2 | sapjoy | 2006.12.27 | 2375 |
24 | module f4_drum_S101 input. | sapjoy | 2006.12.27 | 2544 |
23 | REPORT Z11_010 | sapjoy | 2006.12.23 | 2362 |
22 | REPORT Z11_008 | sapjoy | 2006.12.23 | 2498 |
21 | REPORT Z11_005 | sapjoy | 2006.12.22 | 2274 |
20 | REPORT z11_004 . | sapjoy | 2006.12.22 | 2465 |
19 | REPORT Z11_001 | sapjoy | 2006.12.20 | 2980 |
» | PUT_SPFLI PUT_SFLIGHT PUT_SBOOK | sapjoy | 2006.12.20 | 2614 |
17 | REPORT Z09_010 | sapjoy | 2006.12.20 | 2523 |
16 | DBZF1SSEL | sapjoy | 2006.12.20 | 2848 |
15 | REPORT Z09_006 [1] | sapjoy | 2006.12.18 | 2839 |
14 | REPORT Z09_005 | sapjoy | 2006.12.18 | 2515 |
13 | REPORT z09_002 | sapjoy | 2006.12.15 | 2605 |
12 | REPORT Z07_017 | sapjoy | 2006.12.08 | 2609 |