Value (ABAP keyword)

Get single row

"sflight is an internal table of table sflight
DATA(single_row) = VALUE #( sflight[ carrid = 'AA'
                                     connid = '0017'
                                     fldate = '20171219' ] OPTIONAL ).

Without optional and no row is found, the exception cx_sy_itab_line_not_found is thrown.

Get field of single row

"sflight is an internal table of table sflight
DATA(single_row_field) = VALUE #( sflight[ carrid = 'AA'
                                           connid = '0017'
                                           fldate = '20171219' ]-price OPTIONAL ).

Without optional and no row is not found, the exception cx_sy_itab_line_not_found is thrown.

Append row to table

APPEND VALUE #( price = 123 ) TO lt_sflight.
lt_sflight = VALUE #( BASE lt_sflight ( price = 123 ) ).

Construct an internal table

flights_carrid_aa = VALUE #( FOR <flight> IN flights WHERE (carrid = 'AA' )
                             ( price = <flight>-price ) ).

---

This is a wiki created in the spare time of a private person working in the SAP ERP area. The aim is to collect knowledge for the own use. The wiki is maintained to the best of knowledge and belief.
All products shown, including in form of screenshots, belong to SAP SE. Their trademarks are, among others: SAP®,ABAP®,SAP Fiori®,SAP HANA®,SAP NetWeaver®,SAP® R/3®,SAP S/4HANA®,SAP S/4HANA® Cloud