topic Re: Problem in table in Application Development and Automation Discussions

Problem in table

Former Member — Mon, 30 Jul 2007 13:16:47 GMT

Dear All,

I created one table.In that there are there quantity fields(of type Kmenge).Lets say A,B,C.

Here C = A - B.

Now the problem ,whenever C is negative and saved in table then if i am trying to see the data from SM30 then it is showing dump.

In the dump it is saying that C has negative sign and conversion error occured during displaying data on the screen.

Please let me know how to solve this.

Re: Problem in table

former_member194669 — Mon, 30 Jul 2007 13:22:31 GMT

Hi,

The datatype Kmenge is of type CHAR 1. ??

aRs

Re: Problem in table

Former Member — Mon, 30 Jul 2007 13:22:56 GMT

Hi,

You should check data element and domain of field C. If you get this message, that means that the domain of this field doesn't support negative amount.

Regards,

Nicolas.

Re: Problem in table

Former Member — Mon, 30 Jul 2007 13:29:10 GMT

You should use data element which supports negative values..

Regards

Pradeep

Re: Problem in table

Former Member — Mon, 30 Jul 2007 13:52:49 GMT

Hi..

You have to keep a check in module pool of maintenance view whether field A is less than field B.

If field A is less than B then, you should throw an error message.

If A is greater than or equal to B then only you should do subtraction.

e.g.


MODULE process INPUT.
  IF ztab_prax1-a GE ztab_prax1-b.
    ztab_prax1-c = ztab_prax1-a - ztab_prax1-b.

  ELSE.
    MESSAGE 'Plz input A greater than or equal to B.' TYPE 'E'.
  ENDIF.

ENDMODULE.                 " process  INPUT

and in the screen flow logic use this module as:


  LOOP AT extract.
    MODULE liste_init_workarea.
<b>
    CHAIN.
      FIELD ztab_prax1-a .
      FIELD ztab_prax1-b .
      MODULE process ON CHAIN-REQUEST.
    ENDCHAIN.
</b>
    CHAIN.
      FIELD ztab_prax1-a .
      FIELD ztab_prax1-b .
      FIELD ztab_prax1-c .
      MODULE set_update_flag ON CHAIN-REQUEST.
    ENDCHAIN.
    FIELD vim_marked MODULE liste_mark_checkbox.
    CHAIN.
      FIELD ztab_prax1-a .
      MODULE liste_update_liste.
    ENDCHAIN.


  ENDLOOP.

Reward if useful

Regards Prax

Re: Problem in table

Former Member — Mon, 30 Jul 2007 14:09:04 GMT

Please do the change in datatype of C field from INT1 to INT4 ...

" INT1

-> 1-byte integer, integer number <= 255

" INT4

-> 4-byte integer, integer number with sign

So your negative data in the C field will reffer to the datatype a INT4 which can avoid giving the Dump . and have the check box of sign . ok it will solve your problem .....

reward points if it is usefull ....

Girish

Re: Problem in table

Former Member — Mon, 30 Jul 2007 14:11:43 GMT

Hi,

I think, the data element you used is not allowing any - values. Try using DMSHB data element.

Thanks,

Sriram.

Re: Problem in table

Former Member — Mon, 30 Jul 2007 14:20:42 GMT

I have used one currency field in custom table and it works great.

I used data element WRBTR and domian WERT7 ,You can refer like this.

Thanks

Seshu