Skip to Content
0
Former Member
May 13, 2010 at 06:57 AM

Open SQL SELECT Like ORACLE SQL SELECT

88 Views

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.