ABAP New Syntax and New Open SQL Made Easy

About ABAP New Syntax and New Open SQL Made Easy

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