在ABAP SQL中使用表达式

1.字面量和常量

字面量（Literal）指的是一个不可变的值，比如代码中的10，可变的是NUM1。

DATA NUM1 TYPE I VALUE 10.

常量（Constant）指的是不可变的变量，这里NUM2是常量，1234是字面量。

CONSTANTS NUM2 TYPE I VALUE 1234.

字面量和常量在ABAP SQL中的应用。Hello是字符类性的字面量，1和-1是数字类型的字面量。C_NUMBER是常量，在语句中需要用@符号标识。

CONSTANTS C_NUMBER TYPE I VALUE 1234.

SELECT FROM /DMO/CARRIER
    FIELDS 'Hello' AS CHARACTER,
            1 AS INTEGER1,
            -1 AS INTEGER2,
            @C_NUMBER AS CONSTANTS
INTO TABLE @DATA(RESULT).

OUT->WRITE( RESULT ).

2.CAST

CAST关键字用来进行类型转换，超过类型的长度会自动截断。

SELECT FROM /DMO/CARRIER
    FIELDS '19891109' AS CHAR_8,
        CAST( '19891109' AS CHAR( 4 ) ) AS CHAR_4,
        CAST( '19891109' AS NUMC( 8 ) ) AS NUMC_8,
        CAST( '19891109' AS INT4 ) AS INTEGER,
        CAST( '19891109' AS DEC( 10, 2 ) ) AS DEC_10_2,
        CAST( '19891109' AS FLTP ) AS FLTP,
        CAST( '19891109' AS DATS ) AS DATE
INTO TABLE @DATA(RESULT1).
OUT->WRITE( RESULT1 ).

3.CASE

SELECT FROM /DMO/FLIGHT
    FIELDS
        FLIGHT_DATE AS DATE,
        SEATS_MAX AS MAX,
        SEATS_OCCUPIED AS OCCUPIED,
        CASE
            WHEN SEATS_OCCUPIED < SEATS_MAX THEN 'Available'
            WHEN SEATS_OCCUPIED = SEATS_MAX THEN 'Full booked'
            WHEN SEATS_OCCUPIED > SEATS_MAX THEN 'Overbooked'
            ELSE 'No possible'
        END AS BOOKINGSTATUS
WHERE CARRIER_ID = 'LH'
    AND CONNECTION_ID = '0400'
INTO TABLE @DATA(RESULT3).
OUT->WRITE( RESULT3 ).

---

总结

打完收工。