Example:
SELECT FROM sbook
FIELDS
carrid,
connid,
order_date,
fldate,
bookid,
customid,
loccuram,
smoker,
CASE smoker
WHEN 'X' THEN floor( loccuram * @lc_smoker_fee )
ELSE ceil( loccuram * @lc_non_smkr_disc )
END AS adjusted_amount,
loccurkey,
DAYS_BETWEEN( order_date,fldate ) as days_to_flight
WHERE customid in @s_custm
INTO TABLE @DATA(lt_sbook).
Please share with your ABAP friends and follow us.
Комментарии