Skip to Content
0
Aug 08, 2023 at 10:57 AM

ABAP select query

49 Views

Hi,

Is below select query is correct to fetch data from MSEG for MSEG-MATNR = 200000003,

After executing the select statement getting zero records, but for same value when I check at table level records exists.

SELECT *
FROM MSEG
INTO TABLE @DATA(IT_MSEG1)
where WERKS = 'US01'
AND BUDAT_MKPF GE @I_FKDATLOW
AND BUDAT_MKPF LE @I_FKDATHIGH
AND MATNR = '200000003'
AND BWART = '531'