Question Re: Issue with Query Returning Incorrect Data from MARM Table in Technology Q&A

Issue with Query Returning Incorrect Data from MARM Table

wanrooy — Mon, 10 Mar 2025 14:58:57 GMT

Hi everyone,

I'm facing an issue with a query that is supposed to retrieve data from the MARM table, specifically the UMREN field. However, the query consistently returns the value 10, which is incorrect. Below is the code I am using:

DATA: lv_umren_ea TYPE P.
CLEAR lv_umren_ea.
SELECT SINGLE MARM~UMREN
INTO lv_umren_ea
FROM MARM
JOIN MARC ON MARM~MATNR = MARC~MATNR
JOIN CAUFV ON MARC~WERKS = CAUFV~WERKS
  WHERE MARM~MEINH = 'EA'.
Z_EA = lv_umren_ea.

Could anyone help me identify what might be wrong with this code? Any suggestions or insights would be greatly appreciated.

Thank you!

Re: Issue with Query Returning Incorrect Data from MARM Table

Sandra_Rossi — Mon, 10 Mar 2025 21:11:02 GMT

Your WHERE is unprecise, you are extracting millions of lines and keeping only the data of one random line...

Re: Issue with Query Returning Incorrect Data from MARM T...

wanrooy — Wed, 19 Mar 2025 07:36:25 GMT

You are right. I have adjusted the code, but I am still not getting the desired result. The result remains the same.

DATA: lv_umren_ea TYPE P,
      lv_matnr TYPE MARM-MATNR.
CLEAR lv_umren_ea.
CLEAR lv_matnr.
SELECT SINGLE MATNR
INTO lv_matnr
FROM MARM
WHERE MARM~MEINH = 'EA'.
SELECT SINGLE MARM~UMREN
INTO lv_umren_ea
FROM MARM
JOIN MARC ON MARM~MATNR = MARC~MATNR
JOIN CAUFV ON MARC~WERKS = CAUFV~WERKS
WHERE MARM~MEINH = 'EA'
  AND MARM~MATNR = lv_matnr.
Z_EA = lv_umren_ea.

Re: Issue with Query Returning Incorrect Data from MARM T...

Sandra_Rossi — Wed, 19 Mar 2025 08:01:52 GMT

Please don't post an "answer", which means a solution, instead post a comment.

Re: Issue with Query Returning Incorrect Data from MARM Table

Sandra_Rossi — Wed, 19 Mar 2025 08:04:51 GMT

In your latest reply, you are using SELECT SINGLE from a JOIN/WHERE clause which extracts hundreds of lines, which means that you take any RANDOM line out of these hundreds of lines.

Re: Issue with Query Returning Incorrect Data from MARM Table

wanrooy — Wed, 19 Mar 2025 08:27:11 GMT

As you may have noticed, I (still) don't have much knowledge of ABAP programming. However, I do enjoy learning more about it. I would like to try to solve this problem. How can I further resolve this? In the query I created, information is displayed about confirmations on an order (CO11N). I want to add the value "EA" to this. I hope you can help me further with this.