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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
50 | REPORT Z11_010 | sapjoy | 2006.12.22 | 2358 |
49 | REPORT Z11_008 | sapjoy | 2006.12.22 | 2496 |
48 | REPORT Z11_005 | sapjoy | 2006.12.22 | 2273 |
47 | REPORT z11_004 . | sapjoy | 2006.12.22 | 2465 |
46 | REPORT Z11_001 | sapjoy | 2006.12.20 | 2976 |
» | PUT_SPFLI PUT_SFLIGHT PUT_SBOOK | sapjoy | 2006.12.19 | 2614 |
44 | REPORT Z09_010 | sapjoy | 2006.12.19 | 2523 |
43 | DBZF1SSEL | sapjoy | 2006.12.19 | 2842 |
42 | REPORT Z09_006 [1] | sapjoy | 2006.12.18 | 2839 |
41 | REPORT Z09_005 | sapjoy | 2006.12.18 | 2514 |
40 | REPORT z09_002 | sapjoy | 2006.12.15 | 2602 |
39 | REPORT Z07_033 | sapjoy | 2006.12.08 | 2317 |
38 | REPORT Z07_031 [2] | sapjoy | 2006.12.08 | 2309 |
37 | REPORT Z07_030 [4] | sapjoy | 2006.12.08 | 2438 |
36 | REPORT Z07_027 [3] | sapjoy | 2006.12.08 | 2374 |
35 | REPORT Z07_026 [3] | sapjoy | 2006.12.08 | 2632 |
34 | REPORT Z07_023 | sapjoy | 2006.12.08 | 2255 |
33 | REPORT Z07_022 | sapjoy | 2006.12.08 | 2070 |
32 | REPORT Z07_024 | sapjoy | 2006.12.08 | 2472 |
31 | REPORT Z07_021 [2] | sapjoy | 2006.12.08 | 2453 |