Sometimes you need to take data from the database and replicate it declaratively in ABAP using the VALUE command. For example, to build ABAP Unit tests.

Did you know that, if you SAP is recent enough, you can use complex ABAP expressions in the middle of SQL commands?