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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
570 | REPORT Z17_011 | sapjoy | 2007.02.12 | 2287 |
569 | INCLUDE Z17_011_CLASS | sapjoy | 2007.02.12 | 2489 |
568 | REPORT Z17_012 | sapjoy | 2007.02.12 | 2304 |
567 | REPORT Z17_014. [1] | sapjoy | 2007.02.13 | 2503 |
566 | REPORT Z17_015 | sapjoy | 2007.02.13 | 2280 |
565 | REPORT Z17_016 . | sapjoy | 2007.02.13 | 2162 |
564 | REPORT Z17_017 . | sapjoy | 2007.02.14 | 2181 |
563 | REPORT Z17_019 [1] | sapjoy | 2007.02.14 | 2748 |
562 | REPORT Z17_021 . | sapjoy | 2007.02.21 | 2386 |
561 | REPORT Z17_022 | sapjoy | 2007.02.21 | 2315 |
560 | REPORT Z17_000. | sapjoy | 2007.02.22 | 2419 |
559 | REPORT Z17_020 | sapjoy | 2007.02.22 | 2172 |
558 | REPORT z17_025 | sapjoy | 2007.02.22 | 2202 |
557 | REPORT Z17_020. [2] | sapjoy | 2007.02.23 | 2185 |
556 | REPORT Z09_013 | sapjoy | 2007.02.23 | 2243 |
555 | REPORT Z17_028 | sapjoy | 2007.02.26 | 2937 |
554 | Z17_ZSFLIGHT | sapjoy | 2007.02.26 | 2413 |
553 | REPORT Z02_016 | sapjoy | 2007.02.27 | 2294 |
552 | REPORT Z18_001 | sapjoy | 2007.03.02 | 2774 |
551 | Z18_001_PBO | sapjoy | 2007.03.02 | 2585 |