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
번호 | 제목 | 글쓴이 | 날짜 | 조회 수 |
---|---|---|---|---|
569 | REPORT Z03_010 [2] | sapjoy | 2007.05.14 | 2655 |
568 | REPORT Z05_013 [3] | sapjoy | 2008.04.14 | 2653 |
567 | REPORT ZRTTS_01 . | sapjoy | 2009.12.24 | 2650 |
566 | REPORT z16_002 | sapjoy | 2008.08.07 | 2648 |
565 | REPORT ZDYNAMIC_ITAB_12. | sapjoy | 2009.02.16 | 2643 |
564 | REPORT Z15_001 [2] | sapjoy | 2008.04.15 | 2643 |
563 | REPORT z18_038 [2] | sapjoy | 2008.04.21 | 2635 |
562 | report zunicode_032. | sapjoy | 2008.11.21 | 2634 |
561 | REPORT Z13_013 | sapjoy | 2007.01.08 | 2634 |
560 | REPORT Z07_026 [3] | sapjoy | 2006.12.08 | 2632 |
559 | REPORT z18_036 | sapjoy | 2007.03.13 | 2631 |
558 | REPORT z12_002 | sapjoy | 2006.12.28 | 2629 |
557 | FIELD_EXIT_GSBER_I | sapjoy | 2008.12.16 | 2625 |
556 | REPORT z15_014 | sapjoy | 2007.01.26 | 2625 |
» | PUT_SPFLI PUT_SFLIGHT PUT_SBOOK | sapjoy | 2006.12.19 | 2614 |
554 | REPORT Z05_008 [2] | sapjoy | 2007.05.27 | 2611 |
553 | report zunicode_022. | sapjoy | 2008.11.21 | 2610 |
552 | REPORT Z07_017 | sapjoy | 2006.12.08 | 2609 |
551 | report zsalv_040 . | sapjoy | 2010.08.20 | 2608 |
550 | REPORT Z03_018 [3] | sapjoy | 2006.12.02 | 2605 |