←Previous Step

Step1:Using Select * in SAP ABAP Important

Select * is a statement which is used to read whole data from a database table.The below is the example code for reading data from MARA table.

**Declare internal table
DATA : IT_MARA TYPE TABLE OF MARA.

*use select * to read data
SELECT * FROM MARA INTO TABLE IT_MARA .

The below example code is used to get data based on a condition with all fields(columns) from MARA table.

**Declare internal table
DATA : IT_MARA TYPE TABLE OF MARA.

* read data 
SELECT * FROM MARA INTO TABLE IT_MARA WHERE MTART = 'FERT' .