Select Statements in ABAP - New Syntax and Inline Declaration [english]

The video shows various select queries in ABAP and the possibilities of the new syntax. The table SFLIGHT, which is available in every SAP system, is used as an example.
Functions are used, arithmetic calculations are performed and new columns are created.
#abap #select #syntax
▬▬ My Hardware ▬▬▬▬▬▬▬▬▬▬▬▬▬
Microphone: amzn.to/3zj2UIz
Headphone: amzn.to/3GUBRFg
*The links are affiliate links. There are no additional costs.
▬▬ My Software (free) ▬▬▬▬▬▬▬▬▬▬▬
Video Recorder: bit.ly/678fgh6
Video Editor: bit.ly/38Rj9lb
▬▬ Further Links ▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬
Become my subscriber: bit.ly/CustAnd...
All videos in English: bit.ly/CustAnd...

[@FernandoMcmlxiv]

Good explanation of CASE and very useful. I didn't know this CASE in a SELECT. I am starting with HANA and discovering the new functions.
I have found a trouble when inline internal table declaration with alias: a~name and b~name are not allowed.
Thanks!

[@CustAndCode]

Thanks for your comment! 😀 Do you start mit the DB HANA or the new ERP S4/HANA? Have you the trouble when you join the tables? Normally this should work. I show this in mei Video about joins in ABAP. 🤗
ua-cam.com/video/KykczIbaKr8/v-deo.html