SELECT a~ryear,a~racct,a~rbukrs,a~drcrk,a~activ,a~awtyp,
CONCAT( 'HSL',LPAD( CAST( b~num AS CHAR ),2,'0' ) ) AS col_name,
CASE b~num
WHEN 1 THEN hsl01
WHEN 2 THEN hsl02
WHEN 3 THEN hsl03
WHEN 4 THEN hsl04
WHEN 5 THEN hsl05
WHEN 6 THEN hsl06
WHEN 7 THEN hsl07
WHEN 8 THEN hsl08
WHEN 9 THEN hsl09
WHEN 10 THEN hsl10
WHEN 11 THEN hsl11
WHEN 12 THEN hsl12
WHEN 13 THEN hsl13
WHEN 14 THEN hsl14
WHEN 15 THEN hsl15
WHEN 16 THEN hsl16
END AS col_value
FROM v_faglflext_view AS a JOIN ztseries AS b ON b~num <= 16
ORDER BY a~ryear,a~racct,a~rbukrs,a~drcrk,a~activ,b~num
INTO TABLE @DATA(lt_data)
UP TO 160 ROWS.
cl_demo_output=>display( lt_data ).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
7 | |
3 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |