topic Query cannot get value in ABAP Editor when WHERE statement parameter started with double zero (00) in Application Development and Automation Discussions

Query cannot get value in ABAP Editor when WHERE statement parameter started with double zero (00)

former_member780619 — Thu, 17 Mar 2022 14:27:17 GMT

Dear All,

I have a problem trying to get data with a query when the value of the parameter in the where statement starts with two zero digits (00). However, the query runs normally when the parameter value starts with only one zero digit (0).

Example:

p_invno = '001/SPK/2022'. " this is get 0 result

p_invno = '01/02/SPK/2022'. " this is get 1 result

SELECT * FROM table INTO TABLE lt_tab WHERE invoiceno = p_invno.

Please help and the solution.

Thank You

Re: Query cannot get value in ABAP Editor when WHERE statement parameter started with double zero (00)

Sandra_Rossi — Thu, 17 Mar 2022 19:02:36 GMT

The only reason why you don't get the line is that p_invno value is different from invoiceno.

Check value of p_invno in debug, at hexadecimal level to be sure.

Read invoiceno column from table in debug (do a select via a test program), at hexadecimal level to be sure.

And compare.

NB: don't believe what you see in the screens, believe what you see in hexadecimal IN DEBUG.