topic Re: is both value initial is considered equal? in Application Development and Automation Discussions

is both value initial is considered equal?

former_member625844 — Wed, 24 Mar 2021 09:16:59 GMT

I wrote below code tocheck changes in zplp1.

SELECT COUNT(*) FROM mbew WHERE matnr = wmbew-matnr AND bwkey = wmbew-bwkey
      AND zplp1 = wmbew-zplp1 AND zpld1 = wmbew-zpld1
      AND zplp2 = wmbew-zplp2 AND zpld2 = wmbew-zpld2.
IF sy-subrc <> 0.
        MESSAGE e006(zfico).
ENDIF.

And if the values of zplp1/p2/d1/d2 are initial it doesn't work. To solve this I think I can first query the orignial values from db and compare to new one like below.

 SELECT single *  FROM mbew WHERE matnr = wmbew-matnr AND bwkey = wmbew-bwkey
  into @data(mbew_o)    .
IF sy-subrc = 0.
       if ((mbew_o-zplp1 = wmbew-zplp1 ) or (mbew_o-zplp1 is initial and wmbew-zplp1 is initial)).
           else . 
                MESSAGE e006(zfico).
           ENDIF.
ENDIF.

Is there a simpler way to do it? Thx.

Re: is both value initial is considered equal?

former_member1716 — Wed, 24 Mar 2021 10:01:55 GMT

loki_luo15,

Your Question does not have all the necessary details to get an answer:

1) What is WMBEW here?

2) What is your expectation here?

3) Your select statement has AND operator and Conditional Statement has OR operator.

Can you explain your question better?

Regards!

Re: is both value initial is considered equal?

Sandra_Rossi — Wed, 24 Mar 2021 15:14:33 GMT

I guess you didn't check the option "not null" of the Z columns, so all existing rows have Z columns with value "null" and the comparison fails because ABAP "initial" <> database "null".

If you check the option "not null", there will be a table adjustment to set initial values where values were previously null.

Re: is both value initial is considered equal?

former_member625844 — Thu, 25 Mar 2021 01:21:08 GMT

@sandra.rossi.Thx. So if I want to check zplp1 changed or zplp1 is null I should write like below, is it?

where ( zplp1 = wmbew-zplp1 or zplp1 is initial )

Re: is both value initial is considered equal?

Sandra_Rossi — Thu, 25 Mar 2021 06:39:09 GMT

What I recommend is that you set the option "not null", otherwise people will often make errors. I would consider not setting the option "not null" as being "error prone".

If not, your program will look like a mess. In case a line has ZPLP1 equal to null, not initial (I don't know its type so I can't say space or zero or all zeroes...), you would use this complex code:

IF wmbew-zplp1 IS NOT INITIAL.
  SELECT ...
      WHERE ( zplp1 = wmbew-zplp1 ) ...
ELSE.
  SELECT ...
      WHERE ( zplp1 = wmbew-zplp1 OR zplp1 IS NULL ) ...
ENDIF.