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

Ratings: 0.00 / 5.00




Description

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) –

  1. RIGHT OUTER JOIN

  2. Multiple conditions with ON for inner Join

  3. CASE WHEN STATEMENT

  4. CONCATENATE WHILE SELECT

  5. SUB QUERY ON SELECT

  6. SELECT ON INTERNAL TABLE

  7. LOOP AT GROUP BY

  8. LOOP AT GROUP BY REFERENCE TO WITH SIZE, INDEX and MEMBER ACCESS

  9. Aggregate Function

  10. Aggregate function under HAVING Clause

  11. Different Expression

  12. SELECT with SUFFIX

  13. Use of Expression in OPEN SQL

  14. UNION

  15. CROSS JOIN

  16. CLIENT HANDLING

  17. 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)

  1. Inline Declaration

  2. Value Operator

  3. For Operator – FOR inside FOR

  4. FOR THEN UNTIL/WHILE

  5. LET expression

  6. NEW Expression

  7. SWITCH

  8. CONDITION

  9. BASE OPERATOR

  10. LOOP WITH GROUP BY, SIZE AND INDEX

  11. CORRESPONDING, MAPPING

  12. Table Expression

  13. Find out the value, change the value directly

  14. Mesh( forward Association, Backward association)

  15. REF

  16. REDUCE operator

  17. CONVERSION EXIT (SHORT FORM)

  18. FILTER

What You Will Learn!

  • Inline Declaration | Subquery
  • Case an When | Coleasce Function
  • NW 7.40, NW7.50, NW 7.51, NW7.52 Syntaxes
  • Loop at group by | Mesh and Meshes type

Who Should Attend!

  • ABAP Developer
  • Techno Functional