topic Re: Delete column from an internal table in Application Development and Automation Discussions

Delete column from an internal table

Former Member — Wed, 06 Jan 2010 07:58:53 GMT

Hi experts,

I have a req. in which there is an internal table it_tab with 4 fields A, B, C, D.

After the data in the internal table is appended, I need to delete the field D from it.

For ex:

ITAB has following entries:

A B C D

1 2 3 4

5 6 7 8

I need to delete the D column totally.

How can this be achieved?

Thanks,

Ajay.

Re: Delete column from an internal table

Former Member — Wed, 06 Jan 2010 08:02:47 GMT

How about not to consider column D for further processing/Calculation/Printing and keep it Idle to avoid your next question like "How to get back column D?"

Re: Delete column from an internal table

Former Member — Wed, 06 Jan 2010 08:05:25 GMT

I am using this internal table in a FM, where I do need this field... The place where I am calling this FM in the main report, I don't need this field. So I need a logic to delete the field in the main report.

Re: Delete column from an internal table

Former Member — Wed, 06 Jan 2010 08:06:05 GMT

Hi ajay,

In case you want to CLEAR the contents of column D (and not delete column d), then one way is



Loop at itab.

clear itab-d.
modify d.

endloop.

Regards,

Amit Mittal.

Re: Delete column from an internal table

vinod_vemuru2 — Wed, 06 Jan 2010 08:12:10 GMT

Hi Ajay,

I dont see any possibility of deleting a column from internal table. Instead, you have to take another internal table with required fields, Loop at first table and populate the second table fields.

If you don't want the data in column D, you already got the solution from our friends.

May be if you can go in to the details, we can think of alternative approaches.

Thanks,

Vinod.

Re: Delete column from an internal table

Former Member — Wed, 06 Jan 2010 08:13:14 GMT

Hi you can take another internal table with 3 fields A B C,

Now loop the ist internal table ITAB1 and assign append values into 2nd internal table ITAB2



loop at itab1 into wa1
  
  WA2-A  = WA1-A
 WA2-B = WA1-B
WA2-C = WA1-C
append wa2 to itab2.

endloop.

You will get only 3 columns in your 2nd internal table

Please let me know if you need further info

Regards

Satish Boguda

Re: Delete column from an internal table

Former Member — Wed, 06 Jan 2010 08:13:35 GMT


> I am using this internal table in a FM, where I do need this field... The place where I am calling this FM in the main report, I don't need this field.

As a result I said, just keep this field into your internal table but do not use it anywhere in report within loop and keep it Idle. Thatu2019s it

Cheers

Re: Delete column from an internal table

Former Member — Tue, 29 Sep 2015 11:33:14 GMT

If you need to erase column, good way is using: MODIFY, statement.

Using following code you can erase a column (col1) from internal table (lt_data):

Data:

ls_data LIKE LINE OF lt_data.

ls_data-col1 = ''.

MODIFY lt_data FROM ls_data

TRANSPORTING col1

WHERE col1 IS NOT INITIAL.

It is not difficult but it could help some beginners.

Re: Delete column from an internal table

touzik_itc — Sat, 10 Apr 2021 12:26:33 GMT

modify itab. "instead of modify d.

Or you can use a field symbol to clear the column in the header line and modify table in one step:

LOOP AT itab ASSIGNING FIELD-SYMBOL(<fs>).
  CLEAR <fs>-d.
ENDLOOP.