Issue with Query Returning Incorrect Data from MARM Table

[wanrooy]

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!

[Sandra_Rossi]

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

[Sandra_Rossi]

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.

[wanrooy]

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.

[wanrooy]

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.

[Sandra_Rossi]

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