topic Difficulties with table output in Application Development and Automation Discussions

Difficulties with table output

former_member797394 — Wed, 11 May 2022 09:24:00 GMT

Hi everyone.

I am having some problems with a program. I know that the problem is that I am using two Selects. Could someone please help me with this issue? The problem is in locnr value. The table shows dublicated values. Screenshot will be attached.

SELECT-OPTIONS : 
 filia FOR wint_carrh-asort DEFAULT ' ' 
 MATCHCODE OBJECT wsor, 
 p_locnr FOR wrsz-locnr, 
 p_artnr FOR wlk1-artnr. 
LOOP AT i_werks.
 FREE i_wlk1.
 SELECT wlk1~* INTO TABLE @i_wlk1 FROM wlk1
 JOIN wrsz ON wrsz~asort EQ wlk1~filia
 WHERE filia EQ @wlk1-filia
 AND wlk1~datbi GE @datum_rc
 AND wlk1~datbi LE @max_datum
 AND quell EQ '3' 
 AND locnr IN @p_locnr 
 AND wlk1~artnr IN @p_artnr. 
.........
ENDLOOP.
LOOP AT lt_output ASSIGNING <fs_output>.
 PERFORM material_read_mara(saplwso1)
 USING <fs_output>-artnr sy-datum mara makt.
 <fs_output>-maktx = makt-maktx.

SELECT SINGLE locnr INTO <fs_output>-locnr FROM wrsz WHERE asort EQ <fs_output>-filia AND datbi GE sy-datum AND locnr IN p_locnr.
SELECT SINGLE name1 INTO <fs_output>-name1 FROM t001w WHERE werks EQ <fs_output>-locnr.

ENDLOOP.

Result:

If any other piece of code is needed, I will provide it.

Thank you in advance!

Re: Difficulties with table output

Sandra_Rossi — Wed, 11 May 2022 11:21:04 GMT

Please edit your question, select your code and press the button [CODE], which makes the code appear colored/indented, it will be easier for people to look at it. Thank you!

Re: Difficulties with table output

Sandra_Rossi — Wed, 11 May 2022 11:28:18 GMT

Your question is not more clear than your previous one (https://answers.sap.com/questions/13634681/selection-screen-problems-1.html).

If you don't post the whole code, then please explain the details which are needed for us to understand.

Re: Difficulties with table output

former_member797394 — Wed, 11 May 2022 11:34:05 GMT

The code itself works well, however it duplicates the values after I made some additions to my code. Shall I share whole code for better understanding?

Re: Difficulties with table output

Sandra_Rossi — Wed, 11 May 2022 11:53:50 GMT

I prefer that you don't post the whole code, I prefer that you investigate and locate approximately your error so that to ask a more precise question. But if you don't know what details to give so that people can understand, then it's better that you post the whole code (please attach txt file).

Example about missing info: you didn't post any code about LT_OUTPUT, which is the most important information. I guess that it's the ALV internal table, but nobody can know how you fill it...

Re: Difficulties with table output

former_member797394 — Wed, 11 May 2022 12:46:21 GMT

yeah, sorry that I could not fully explain the problem, I am not that good in this. I would rather post the source code. If anything else is needed, I am here to provide. Thank you! source-code.txt

Re: Difficulties with table output

Sandra_Rossi — Wed, 11 May 2022 18:14:09 GMT

Your program is too complex for anyone in the forum, and most importantly we can't play it with your data.

If I understand your question, you say that you have duplicate values for LOCNR.

If that's the question, I don't see any code in your program where you remove the duplicates.

Re: Difficulties with table output

former_member797394 — Thu, 12 May 2022 04:23:07 GMT

sandrarossi thank you for your time and effort!