SAP ABAP SELECT STATEMENT
Module Objectives •Explain database Tables / data browser •Use the SELECT statement and the WHERE clause •Describe the SELECT SINGLE statement •Explain the ORDER BY addition •Describe retrieving individual columns •Exclude duplicate records during selection •Describe the SELECT statement syntax •Define aggregate expressions •Familiarization with ABAP 7.40 select statement new features •Discuss performance and best practices •SQL Console SELECT Statement - Basic Form the select statement is very simple in ABAP, we just use Keyword SELECT the we specified all columns of the table which we want to get we use * to show all columns with FROM keyword we specified the table. then we use a variable which will hold the result of the table and, in the end, we use ENDSELECT to end the select query. Select Query Selecting specific fields from database table Selecting specific fields from database table Inline Declaration after INTO for ABAP 7.40 instead of defining all the fields in ABAP 7.40 w
Comments
Post a Comment