Field code in query for customize report, SQ03, SQ02, SQ01

[Tokomak]

Hello Guru

I had created additional fields with tcode: SQ02 including some condition in it.

if VBRK-VBTYP = 'N' OR
VBRK-VBTYP = 'S'.
NETAMOUNT = VBRP-NETWR * VBRK-KURRF * -1.
else.
NETAMOUNT = VBRP-NETWR * VBRK-KURRF.
endif.

But, it's showing * (Star Sign) in Net Value (Local).

I think some steps need to do and please advise me.

Thanks

[Sandra_Rossi]

If you have a question about your code, please show it. * is shown if target field cannot contain a number including a place for the sign unless you indicated explicitly "no sign".

[Tokomak]

if VBRK-VBTYP = 'N' OR
VBRK-VBTYP = 'S'.
NETAMOUNT = VBRP-NETWR * VBRK-KURRF * -1.
else.
NETAMOUNT = VBRP-NETWR * VBRK-KURRF.

endif.

[Tokomak]

screenshot-2022-06-10-123609.png

[Sandra_Rossi]

If you have NETAMOUNT defined as 1 character then you'll always get * because there's no place to contain a number. Choose a big length. Better choose a numeric type (with big size of course) instead of characters.

[Sandra_Rossi]

See ABAP documentation - Conversion Rules for Elementary Data Objects → Numeric Source Fields → Source ... → Character-Like Target Fields.

[Tokomak]

Dear Sandra Rossi,

I got it and thanks you so much bro.

[venkateswaran_k]

If you have the solution, kindly update the solution and close this thread. So that it will be useful for others who is looking for similar solution.

Regards,

[venkateswaran_k]

Hi

When you define your custom field in SQ02 - for the Net Amount variable - Please review what you set as below

Please review the Data type, length and Sign (if any)

Regards,

Venkat

[Tokomak]

Dear Venkat,

I got it and thank you!

[venkateswaran_k]

If you have the solution, kindly update the solution and close this thread. So that it will be useful for others who is looking for similar solution.

Regards,

Venkat