select BKPF~BUKRS
BKPF~BELNR
BKPF~GJAHR
BKPF~BLART
into corresponding fields of table I_BKPF
from BKPF
where BKPF~BUKRS = P_BUKRS"公司代码
and ( blart = 'WE'
OR BLART = 'RE' )
* and BKPF~GJAHR = P_GJAHR"年度
* AND bkpf~monat = p_monat"期间
* and BKPF~BUDAT >= FIRST_DAY
and BKPF~BUDAT %_hints oracle 'index(BKPF"2")'.
(2).
SELECT * FROM spfli
INTO TABLE t_spfli
%_HINTS ORACLE 'INDEX("SPFLI" "SPFLI~001")'.