REPORT  ztest.
*
TABLES: eban, vbfa.
*
DATA:
BEGIN OF      t_initord OCCURS 0,
vbeln TYPE vbap-vbeln,
posnr TYPE vbap-posnr,
erdat TYPE vbfa-erdat,
banfn TYPE eban-banfn,
lfdat TYPE eban-lfdat,
END OF t_initord.
*
SELECT-OPTIONS: s_lfdat FOR eban-lfdat,
                s_erdat FOR vbfa-erdat.
*
SELECT t2~vbeln t2~posnr
       t8~erdat
       t4~banfn t4~lfdat
INTO TABLE t_initord
FROM vbak AS t1
"Соединение с VBAP
INNER JOIN vbap AS t2
ON t1~vbeln EQ t2~vbeln
"Соединение с EKKO
INNER JOIN ekko AS t6
ON t1~submi EQ t6~ebeln
"Соединение с EKPO
INNER JOIN ekpo AS t3
ON t6~ebeln EQ t3~ebeln
"Соединение с EBAN
INNER JOIN eban AS t4
ON      t3~ebeln EQ t4~ebeln
AND    t3~ebelp EQ t4~ebelp
"Соединение с VBFA
INNER JOIN vbfa AS t8
ON t2~vbeln EQ t8~vbelv AND
t2~posnr EQ t8~posnv
WHERE t4~lfdat IN s_lfdat
AND   t8~erdat IN s_erdat.