Hi experts,
how can i use 1st SQL is listed below.
TABLES : T179, VBRK.
SELECT-OPTIONS : s_prdha FOR t179-prodh OBLIGATORY,
s_fkdat FOR vbrk-fkdat OBLIGATORY.
RANGES : R_MATNR FOR MARA-MATNR.
(1st SQL)***************************
SELECT 'I' 'EQ' matnr
INTO TABLE r_matnr FROM mara
WHERE prdha IN s_prdha.
IF sy-subrc = 0.
(2nd SQL)**************************
SELECT vbrkvbeln vbrkfkdat SUM( vbrp~fkimg )
INTO TABLE itab1
FROM vbrk AS vbrk
INNER JOIN vbrp AS vbrp ON vbrkvbeln = vbrpvbeln
WHERE matnr IN r_matnr
AND fkdat IN s_fkdat.
ENDIF.