topic Re: ABAP select query in Application Development and Automation Discussions

ABAP select query

former_member841438 — Tue, 08 Aug 2023 10:57:35 GMT

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'

Re: ABAP select query

Abhishek_10 — Tue, 08 Aug 2023 11:08:26 GMT

user conversion exit alpha input to convert matnr from 200000003 to 200000003 preceded with zeroes similar to what you see in se11/se16n. And then you send that data in where condition of select.

Re: ABAP select query

GuruDuttt_A — Tue, 08 Aug 2023 11:14:54 GMT

I would suggest to check the exact condition on the Table level. Using "BETWEEN" statement in the condition for the date could also be useful for getting the date for the Date range.

Re: ABAP select query

Sandra_Rossi — Tue, 08 Aug 2023 11:24:53 GMT

You say "when I check at table level records exists."

You need to understand the concept of Conversion Exit at the DDIC Domain (SE11) level = difference between external (display) and internal (database) value. See the conversion exit in the domain MATNR.

Solution is given by Abhishek ("alpha input to convert matnr from 200000003 ...").

See forum and ABAP documentation for more information about Conversion Exits.

Re: ABAP select query

Sandra_Rossi — Tue, 08 Aug 2023 11:26:19 GMT

So, you are recommending the OP to use

       AND BUDAT_MKPF BETWEEN @I_FKDATLOW AND @I_FKDATHIGH

instead of

       AND BUDAT_MKPF GE @I_FKDATLOW
       AND BUDAT_MKPF LE @I_FKDATHIGH

That's good, but that's not answering the question.