ABAP New Syntaxes and New Open SQL | NW 7.40 | NW 7.50 | NW 7.51 | CASE WHEN | CONCATENATE | SUB QUERY | REDUCE | VALUE | OPERATOR | LOOP AT GROUP BY
Worried about New syntaxes? Don't worry
Learn New ABAP Syntaxes in a super simple way. This course is about all the fundamental concepts required for ABAP New Syntaxes and New Open SQL.
Enjoy almost all the below list of syntaxes.
New OPEN SQL(7.40) –
RIGHT OUTER JOIN
Multiple conditions with ON for inner Join
CASE WHEN STATEMENT
CONCATENATE WHILE SELECT
SUB QUERY ON SELECT
SELECT ON INTERNAL TABLE
LOOP AT GROUP BY
LOOP AT GROUP BY REFERENCE TO WITH SIZE, INDEX and MEMBER ACCESS
Aggregate Function
Aggregate function under HAVING Clause
Different Expression
SELECT with SUFFIX
Use of Expression in OPEN SQL
UNION
CROSS JOIN
CLIENT HANDLING
OPEN CURSOR i.e. NW7.40 – Important Syntaxes NW7.50 – Important Syntaxes NW7.51 – Important Syntaxes NW7.52 - Important Syntaxes
New Syntax in ABAP (Magic of NW7.40)
Inline Declaration
Value Operator
For Operator – FOR inside FOR
FOR THEN UNTIL/WHILE
LET expression
NEW Expression
SWITCH
CONDITION
BASE OPERATOR
LOOP WITH GROUP BY, SIZE AND INDEX
CORRESPONDING, MAPPING
Table Expression
Find out the value, change the value directly
Mesh( forward Association, Backward association)
REF
REDUCE operator
CONVERSION EXIT (SHORT FORM)
FILTER