Select Statement

Select Statement is used to fetch data from database into internal tables/variables.There are Number of Select Statement are used.

Create Transparent Table . Create  Entries.

Lets See Select Statements One by One.

Statement No.1. 
Select Single is a statement which is used to read single data from assign Field Column in Database Table.

Example. 
Step 1 . Declare Parameter and Data . Type Select Statement . Save and 
            Activate.



At Selection Screen
 Input .



Output . 



Statement No.2. 
Select (One Field) is a Statement Which is used to read entire data in assign Field Column from Database Table.

Example 
Step 1 . Declare Parameter and Data . Type Select Statement . Save and 
            Activate.



At Selection Screen, Enter Input P_F1 = A .  Execute.

Output :



Statement No.3. 
Select Single * is a Statement which is used to read single data in All Fields Columns From Database Table into Variable

Example
 Step 1 . Declare Parameter and Data . Type Select Statement . Save and 
             Activate.



At Selection Screen, Enter Input P_F1 = A .  Execute.



Statement No.3. 
Select * or Select (all Field names) is a  Statement which is used to read entire data in All Fields Columns From Database Table into Internal Table.

Example

Create Internal Table , Parameter & Declare Variables. 



Provide Input value & Execute.



Select Statement No 4.  
Select (more than one ) is a Statement which is used to Read Entire Data in Choosen Fields from Database Table into Internal Table.



Save , Check . Execute.