ABAP動態取得資料

動態取得資料的方法

 

ABAP動態查詢的實現：可以完全實現動態查詢，每個欄位都可以動態。

（1）         利用宏

（2）         利用abap指標

（3）         利用FIELD-SYMBOL

具體實現：

1.結構的動態查詢

DEFINE SELECT_DATA_TO_WA.

  SELECT &1

    FROM &2

    INTO CORRESPONDING FIELDS OF &3

   WHERE (&4).

    EXIT.

  ENDSELECT.

END-OF-DEFINITION.

2.變數的動態查詢

DEFINE SELECT_DATA_TO_VARIANT.

  SELECT &1

    FROM &2

    INTO &3

   WHERE (&4).

    EXIT.

  ENDSELECT.

END-OF-DEFINITION.

3.內表的動態查詢

DEFINE SELECT_DATA_TO_VARIANT.

  SELECT &1

    FROM &2

    INTO CORRESPONDING FIELDS OF TABLE &3

   WHERE (&4).

    EXIT.

  ENDSELECT.

END-OF-DEFINITION.

 

 

具體程式實現：

 

Code

DATA: L_FIELD(100) TYPE C,        L_TABLE(10) TYPE C,        L_COND(100) TYPE C. DATA: I_COND TYPE TALBE OF L_COND. FIELD-SYMBOLS <fs> TYPE  ANY.   START-OF-SELECTION.   CONCATENATE ‘CARRID’ ‘CONNID’ ‘CITYFROM’             INTO L_S    SEPARATE BY SPACE.   CONCATENATE ‘CONNID = ‘ ‘’ ‘0123’ ‘’’’ INTO L_COND. APPEND COND TO I_COND. L_TABLE = ‘SPFLI’. IF <fs> IS ASSIGNED.   UNASSIGN  <fs>.   ASSIGN SPFLI TO <fs>. ELSE. ASSIGN SPFLI TO <fs>. ENDIF.   SELECT_DATA_TO_WA (L_S) (L_TABLE) <fs> I_COND.