Type of Select Statement

---------------------------------------------------------------------------
1. SELECT SINGLE INTO VARIABLE :
---------------------------------------------------------------------------

SELECT SINGLE variaA
INTO tp_variaA FROM payslip
WHERE month EQ tp_month.

---------------------------------------------------------------------------
2. SELECT SINGLE INTO TABLE :
---------------------------------------------------------------------------

SELECT SINGLE * FROM t512t
WHERE sprsl = sy-langu
AND molga = cn_molga
AND lgart = p_lgart.

CLEAR mara.
SELECT SINGLE * from mara
WHERE matnr EQ vbdpl-matnr.

---------------------------------------------------------------------------
3. SELECT * INTO INTERNAL TABLE :
---------------------------------------------------------------------------

select * into corresponding fields of table ibkpf
from bkpf
where bukrs = p_bukrs "Company Code
and gjahr = p_gjahr "Fiscal Year
and monat = p_monat "Fiscal Month(Include YTD month)
and budat = p_budat
and ( blart ne 'KZ'
and blart ne 'KW'
and blart ne 'DZ' ).

------------------------------------------------------------------------
4. SELECT SINGLE INTO MORE VARIABLE :
------------------------------------------------------------------------

select single bldat xblnr xref3
into (g_bldat, g_xblnr, g_xref3)
from bsak
where bukrs = in_bsak-bukrs "Company Code
and gjahr = in_bsak-gjahr "Fiscal Year
and augdt = in_bsak-budat
and augbl = in_bsak-belnr
and blart ne 'KP'.