SAP SELECT INTO NEW TABLE ABEXA

Get Example source ABAP code based on a different SAP table
  SAP Help

SELECT, Create Internal Table as Target Area
The example demonstrates the creation of an internal table as a target area of the statement SELECT.

ABAP_SOURCE_CODE
DEMO CL_DEMO_SELECT_INTO_NEW_TABLE

ABAP_DESCRIPTION
Creates an internal table that matches any DDIC database table in the INTO clause and reads the first rows rows of the DDIC database table into the internal table.
The method CHECK_TABLE_NAME_STR of the class CL_ABAP_DYN_PRG checks whether the DDIC database table specified exists and can be used.
See also the executable example for CREATE DATA with explicit creation of the internal table.