topic Data not coming when debugging in Application Development and Automation Discussions

Data not coming when debugging

uzair_1234 — Thu, 06 Oct 2022 06:48:07 GMT

Hello all,

I have applied a select query to ekpo using inner join as INNER JOIN ekko AS b ON b~ebeln EQ a~ebeln

and tried putting it in lt_ekko1 but still cant get the data inlt_ekko1 while debugging. Can anyone explain in detail why isn't the data coming

Re: Data not coming when debugging

Jeansy — Thu, 06 Oct 2022 06:57:57 GMT

Hi,

can you please show us the full SELECT-statement in ABAP?

Kind regards
Jens

Re: Data not coming when debugging

uzair_1234 — Thu, 06 Oct 2022 07:47:05 GMT

Hi,

Sure here is the query

SELECT DISTINCT
a~ebeln,
a~ebelp,
a~matnr,
a~werks,
a~loekz,
a~elikz,
a~eglkz,
a~menge,
b~aedat
FROM ekpo AS a
INNER JOIN ekko AS b ON b~ebeln EQ a~ebeln
INTO TABLE @DATA(lt_ekko1)
WHERE a~matnr IN @p_matnr
AND a~werks IN @p_werks
* AND c~bwart IN ('641','642')
AND a~elikz <> 'X'
AND a~eglkz <> 'X'
AND b~aedat BETWEEN @p_sdate
AND @p_edate.

Re: Data not coming when debugging

Jeansy — Thu, 06 Oct 2022 08:13:21 GMT

AND b~aedat BETWEEN @p_sdate

This doesn't look okay from my perspective. Is this a select-option on the selection screen? Then just use the IN-operator for the selection.

Kind regards
Jens

Re: Data not coming when debugging

matt — Thu, 06 Oct 2022 09:55:08 GMT

As it says to the left of the "Your answer" editor

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that your answer complies with our Rules of Engagement.

Re: Data not coming when debugging

matt — Thu, 06 Oct 2022 09:57:51 GMT

You need the next line. It's badly formatted.

AND b~aedat BETWEEN @p_sdate AND @p_edate.

Of course, since we don't know what's in the database, nor what's in p_matnr and p_werks, it's very hard to answer the question.

Re: Data not coming when debugging

Jeansy — Thu, 06 Oct 2022 10:00:19 GMT

Oh you're right.

As select-options and parameters seem to have the same prefix, I did not see this in the non-formatted-code.

Thank you, matthew.billingham