메뉴 건너뛰기

SAP 한국 커뮤니티

PUT_SPFLI PUT_SFLIGHT PUT_SBOOK

sapjoy 2006.12.19 20:00 조회 수 : 2614

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
번호 제목 글쓴이 날짜 조회 수
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