Code: Alles auswählen.
TYPES BEGIN OF TT.
INCLUDE STRUCTURE Viewname.
TYPES: ZUSATZFELD TYPE C,
END OF TT.
DATA DeineTabelle TYPE STANDARD TABLE OF TT.
Code: Alles auswählen.
TYPES: BEGIN OF ly_sflight.
INCLUDE STRUCTURE sflight.
TYPES: frei TYPE int4,
END OF ly_sflight.
DATA: lt_sflight TYPE TABLE OF ly_sflight.
PARAMETERS: p_class TYPE s_class.
START-OF-SELECTION.
SELECT
carrid, connid, fldate, price, currency, planetype, seatsmax, seatsocc,
paymentsum, seatsmax_b, seatsocc_b, seatsmax_f, seatsocc_f,
CASE
WHEN @p_class = 'Y' THEN ( seatsmax - seatsocc )
WHEN @p_class = 'C' THEN ( seatsmax_b - seatsocc_b )
WHEN @p_class = 'F' THEN ( seatsmax_f - seatsocc_f )
ELSE ( ( seatsmax - seatsocc ) + ( seatsmax_b - seatsocc_b ) + ( seatsmax_f - seatsocc_f ) )
END AS frei
FROM sflight
INTO CORRESPONDING FIELDS OF TABLE @lt_sflight.
cl_demo_output=>display( lt_sflight ) .
Folgende Benutzer bedankten sich beim Autor Somani für den Beitrag:
DeathAndPain