在ABAP SQL中数值计算和字符串处理

养鱼种菜

已于 2024-04-15 17:36:48 修改

阅读量310

点赞数 6

分类专栏： ABAP cloud 文章标签：改行学it

于 2024-04-15 17:35:34 首次发布

本文链接：https://blog.csdn.net/z125512240/article/details/137788295

版权

ABAP cloud 专栏收录该内容

22 篇文章 5 订阅

订阅专栏

文章目录

1.算数表达式（Arithmetic Expressions）

SELECT FROM /DMO/FLIGHT
FIELDS SEATS_MAX,
    SEATS_OCCUPIED,
    SEATS_MAX - SEATS_OCCUPIED AS SEATS_AVAILABLE,
    ( CAST( SEATS_OCCUPIED AS FLTP ) * CAST( 100 AS FLTP ) ) / CAST( SEATS_MAX AS FLTP ) AS PERCENTAGE
WHERE CARRIER_ID = 'LH' AND CONNECTION_ID = '0400'
INTO TABLE @DATA(RESULT1).

OUT->WRITE( RESULT1 ).

在这里插入图片描述

2.调用数值类型方法（Numeric Functions）

SELECT FROM /DMO/FLIGHT
FIELDS SEATS_MAX,
    SEATS_OCCUPIED,
    ( CAST( SEATS_OCCUPIED AS FLTP ) * CAST( 100 AS FLTP ) ) / CAST( SEATS_MAX AS FLTP ) AS PERCENTAGE_FLTP,
    DIV( SEATS_OCCUPIED * 100, SEATS_MAX ) AS PERCENTAGE_INT,
    DIVISION( SEATS_OCCUPIED * 100, SEATS_MAX, 2 ) AS PERCENTAGE_DEC
WHERE CARRIER_ID = 'LH' AND CONNECTION_ID = '0400'
INTO TABLE @DATA(RESULT2).

OUT->WRITE( RESULT2 ).

在这里插入图片描述

3.字符串连接（CONCAT）

SELECT FROM /DMO/CUSTOMER
FIELDS CUSTOMER_ID,
    STREET && ',' && ' ' && POSTAL_CODE && ' ' && CITY AS ADDRESS_NORMAL,
    CONCAT( STREET, CONCAT_WITH_SPACE( ',', CONCAT_WITH_SPACE( POSTAL_CODE, UPPER( CITY ), 1 ), 1 ) ) AS ADDRESS_CITY_UPPER
WHERE COUNTRY_CODE = 'ES'
INTO TABLE @DATA(RESULT3).

OUT->WRITE( RESULT3 ).

在这里插入图片描述

4.字符串格式化

SELECT FROM /DMO/CARRIER
FIELDS CARRIER_ID,
    NAME,
    UPPER( NAME ) AS NAME_UPPER,
    LOWER( NAME ) AS NAME_LOWER,
    INITCAP( NAME ) AS NAME_INITCAP
WHERE CARRIER_ID = 'SR'
INTO TABLE @DATA(RESULT4).

OUT->WRITE( RESULT4 ).

在这里插入图片描述

5.字符串截取

SELECT FROM /DMO/FLIGHT
FIELDS FLIGHT_DATE,
    CAST( FLIGHT_DATE AS CHAR( 8 ) ) AS FLIGHT_DATE_RAW,
    LEFT( FLIGHT_DATE, 4 ) AS YEAR,
    RIGHT( FLIGHT_DATE, 2 ) AS DAY,
    SUBSTRING( FLIGHT_DATE, 5, 2 ) AS MONTH
WHERE CARRIER_ID = 'LH'
AND CONNECTION_ID = '0400'
INTO TABLE @DATA(RESULT5).

OUT->WRITE( RESULT5 ).