|
via Udemy |
Go to Course: https://www.udemy.com/course/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 BYWorried about New syntaxes? Don't worryLearn 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