topic Re: Remove zeros from quantity data after calculating quantity fields in Application Development and Automation Discussions

Remove zeros from quantity data after calculating quantity fields

deepak_dhamat — Mon, 31 Aug 2009 08:38:07 GMT

Dear ALl,

My requirement is to remove zero's from fields from internal table where i am sending that internal table as

html output thorugh mail and also aligne that fields value in center .

regards

Deepak .

Re: Remove zeros from quantity data after calculating quantity fields

Former Member — Mon, 31 Aug 2009 08:43:35 GMT

Hi,

To remove the leading zeros either use CONVERSION_EXIT_ALPHA_OUTPUT or SHIFT statement.

Eg,



loop at it_output.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
EXPORTING
input = it_ouputt-amount
IMPORTING
output = it_output-amount.
endloop.

Regards,

Vikranth

Re: Remove zeros from quantity data after calculating quantity fields

Former Member — Mon, 31 Aug 2009 08:44:06 GMT

Hi ,

first use replace statement for replacing zeros with spaces and then use condence with no-gaps. or u can use FM CONVERSION_EXIT_ALPHA_OUTPUT .

Please let me know if you still need any more help.

Thanks and regards,

rajeshwar.

Re: Remove zeros from quantity data after calculating quantity fields

kesavadas_thekkillath — Mon, 31 Aug 2009 08:48:27 GMT

its a Qty type field.

try changing it to character field of same size and move the values

Re: Remove zeros from quantity data after calculating quantity fields

venkat_o — Mon, 31 Aug 2009 08:52:58 GMT

Hi, <li>Once data is ready in your internal, you can do the following way.

DATA: BEGIN OF IT_T001 OCCURS 0,
        BUKRS TYPE T001-BUKRS,
        BUTXT TYPE T001-BUTXT,
        ORT01 TYPE T001-ORT01,
      END OF IT_T001.

START-OF-SELECTION.
  SELECT * FROM T001 INTO CORRESPONDING FIELDS OF TABLE IT_T001 UP TO 10 ROWS.
  LOOP AT IT_T001.
    WRITE: IT_T001-BUKRS TO IT_T001-BUKRS LEFT-JUSTIFIED,
           IT_T001-BUTXT TO IT_T001-BUTXT NO-ZERO,
           IT_T001-ORT01 TO IT_T001-ORT01 CENTERED.
    MODIFY IT_T001.
  ENDLOOP.

Thanks Venkat.O

Re: Remove zeros from quantity data after calculating quantity fields

deepak_dhamat — Mon, 31 Aug 2009 09:40:08 GMT

Thank you guys for the reply i have used character type field to display data in html output

Regards

Deepak