topic Re: Alpha conversion on Internal table in Application Development and Automation Discussions

Alpha conversion on Internal table

former_member710665 — Mon, 08 Feb 2021 18:16:14 GMT

Hi,

Is it possible to do alpha conversion on Internal table column using |{ variable alpha = in}| ?

Re: Alpha conversion on Internal table

Patrick_vN — Mon, 08 Feb 2021 18:41:10 GMT

Something like this?

converted_table = VALUE #( FOR unconverted
                           IN unconverted_table
                           ( column_a = |{ unconverted-column_a ALPHA = IN }| )
                         ).

Re: Alpha conversion on Internal table

former_member710665 — Tue, 09 Feb 2021 08:41:35 GMT

Thanks Patrick,

I have tried this logic and it worked. But, all other fileds are blank in converted table

Re: Alpha conversion on Internal table

Patrick_vN — Tue, 09 Feb 2021 08:45:01 GMT

You have to add the other columns as well, for columns where the values don't have to be changed, you just map them like "column_b = unconverted-column_b", etc..

Re: Alpha conversion on Internal table

former_member710665 — Tue, 09 Feb 2021 08:46:11 GMT

Hi Mateusz,

My requirement is to add leading 0's.

Re: Alpha conversion on Internal table

MateuszAdamus — Tue, 09 Feb 2021 08:51:19 GMT

In this case you need to go field by field. How else could the logic know that it's a new field and not the ending part of the previous one?

I will remove my answer as it is not relevant.

Kind regards,
Mateusz

Re: Alpha conversion on Internal table

former_member710665 — Tue, 09 Feb 2021 09:09:56 GMT

Instead of hardcoding the columns, Is that can achievable with Move corresponding between the converted and unconverted tables ?

I added the below statement. It is moveing the records but the converted values are getting blank.

converted_table = CORRESPONDING #( unconverted_table EXCEPT column_a)

Re: Alpha conversion on Internal table

MateuszAdamus — Tue, 09 Feb 2021 09:40:26 GMT

Hello praveen_channa

Actually, you could try something like this.

FIELD-SYMBOLS:
  <lv_field> TYPE ANY.

LOOP AT lt_table REFERENCE INTO DATA(ld_row).
  DO.
    ASSIGN COMPONENT sy-index OF STRUCTURE ld_row->* TO <lv_field>.
    IF sy-subrc <> 0.
      EXIT.
    ENDIF.

    CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
      EXPORTING
        input = <lv_field>
      IMPORTING
        output = <lv_field>.
  ENDDO.
ENDLOOP.

Kind regards,
Mateusz