동적 where 절 만들기

예전에 가지고 있든 셈플보다 6.0 help 에 나오는 예제가 더 나아보인다 ^^
4.6 에도 있었으려나?
모르겠다만.. 일단 비교..

REPORT YTEST_KTH6 .
PARAMETERS: CARR_ID LIKE SPFLI-CARRID,
            CONN_ID LIKE SPFLI-CONNID.
DATA: FTAB(256) OCCURS 0 WITH HEADER LINE,
      WTAB(72)  OCCURS 100 WITH HEADER LINE,
      AND(4),
      WA_SPFLI TYPE SPFLI.
REFRESH :  FTAB, WTAB.

FTAB = 'CARRID CONNID'.
APPEND FTAB.
IF NOT CARR_ID IS INITIAL.
  FTAB = 'CITYFROM CITYTO'.
  APPEND FTAB.
 CONCATENATE 'CARRID = ''' CARR_ID '''' INTO WTAB.
  APPEND WTAB.
  AND = 'AND'.
ENDIF.
IF NOT CONN_ID IS INITIAL.
  FTAB = 'DEPTIME ARRTIME'.
  APPEND FTAB.
  CONCATENATE AND ' CONNID = ''' CONN_ID '''' INTO WTAB.
  APPEND WTAB.
ENDIF.

SELECT (FTAB)
  FROM SPFLI
  INTO CORRESPONDING FIELDS OF WA_SPFLI
 WHERE (WTAB).

WRITE: / WA_SPFLI-CARRID,
          WA_SPFLI-CONNID,
          WA_SPFLI-CITYFROM,
          WA_SPFLI-CITYTO,
          WA_SPFLI-DEPTIME.
ENDSELECT.

링크 따윈 누르지 마시오..
출처: 김덕환 제보

 

WHERE - (cond_syntax)

Syntax

... (cond_syntax) ...

Effect

A logical expression can be specified as a parenthesized data object cond_syntax that contains the syntax of a logical expression or is initial when the statement is executed. It has been possible since SAP Web AS 6.40 to specify all logical expressions dynamically, with the exception of the evaluation of a subquery.

In particular, the logical expression in cond_syntax can also be combined using AND or OR or negated using NOT. The data object cond_syntax can be a character-type data object or an internal table with a character-type data type. The syntax in cond_syntax is, as in the ABAP Editor, not case-sensitive. In the case of the specification of an internal table, the syntax can be spread across multiple rows.

The result of the logical expression (cond_syntax) is determined by the result of the contained logical expression. If cond_syntax is initial when the statement is executed, the logical expression is true.

Notes

• Before SAP Web AS 6.10, it was only possible to specify an internal table with a flat character-type row type of a maximum of 72 characters for cond_syntax. It was also not possible before SAP Web AS 6.10 for the condition in cond_syntax to contain any named data objects (host variables) as operands dobj. Only literals could be specified. Finally, before SAP Web AS 6.10, a dynamic logical expression could only be used in the WHERE or HAVING condition of the select statement, but not in the statements DELETE and UPDATE.

• It is possible since SAP Web AS 6.20 to evaluate an internal table specified after FOR ALL ENTRIES in a logical expression since.

• It is possible since SAP Web AS 6.40 to check a selection table in a dynamic logical expression.

• If cond_syntax is an internal table with a header line, the table body is evaluated, and not the header line.

Example

Creating a dynamic comparison from user input. In the case of incorrect syntax or incorrect semantics, exceptions are generated, which are handled using the common superclass.

PARAMETERS: column TYPE c LENGTH 8,
            value  TYPE c LENGTH 30.

DATA spfli_wa TYPE spfli.

DATA cond_syntax TYPE string.

CONCATENATE column '= value'
            INTO cond_syntax SEPARATED BY space.

TRY.
    SELECT SINGLE *
           FROM spfli
           INTO spfli_wa
           WHERE (cond_syntax).
  CATCH cx_sy_dynamic_osql_error.
    MESSAGE `Wrong WHERE condition!` TYPE 'I'.
ENDTRY.