topic DELETE COLUM in Application Development and Automation Discussions

DELETE COLUM

Former Member — Wed, 14 Jun 2006 08:27:50 GMT

I HAVE ITAB

1/AND I WANT TO DELETE THE COLUMN MANDT

2/AND MAKE ORGNIZE WITH MY CILMN HOW I CAN DO IT

Re: DELETE COLUM

Former Member — Wed, 14 Jun 2006 08:30:27 GMT

Hi rani,

1. AND I WANT TO DELETE THE COLUMN MANDT

I don't think we can do that.

regards,

amit m.

Re: DELETE COLUM

Former Member — Wed, 14 Jun 2006 08:34:26 GMT

Hi,

We cannot delete the column MANDT. Could you explain me point 2 clearly.

Regards,

Ram Mohan.

Re: DELETE COLUM

Former Member — Wed, 14 Jun 2006 08:34:57 GMT

Hi,

go to the internal table definition ,

if its defined with all the fields like

DATA : BEGIN OF ITAB OCCURS 0,

MANDT,

MATNR,

*--AND SO ON.

END OF ITAB.

If ITAB is defined in this way comment out MANDT here & also where ever they are using SELECT & populating ITAB there also you have to comment out MANDT.

if they used any INCLUDE structure in the ITAB definition, you cant do any thing with that, just copy all the fields & define your internal table as above(with only the fields you want).

2. i am not getting what you are asking !!!

regards

srikanth

Re: DELETE COLUM

Former Member — Wed, 14 Jun 2006 08:35:14 GMT

Hi rani,

Can you explain the second point

2/AND MAKE ORGNIZE WITH MY CILMN HOW I CAN DO IT

Sameena

Re: DELETE COLUM

Former Member — Wed, 14 Jun 2006 08:35:39 GMT

Hi ,

May be you had decalred your itab like this.

data :itab like vbak occurs 0 with header line.

In this cas itab will contain all coulumns of vbak including MANDT.

To avoid this you can declare itab in this way.

data : begin of itab occurs 0 ,

vbeln like vbeln ,

....

end of itab.

Then use like this.

select * from vbak into corresponding fields of itab

where <your condition>

<i>Hope This Info Helps YOU.</i>

Regards,

Raghav

Re: DELETE COLUM

Former Member — Wed, 14 Jun 2006 08:36:06 GMT

hi Rani,

We cannot delete MANDT field. If you are working with a Ztable then donot include that field in the Ztable this way you can avoid viewing MANDT field than deleting.

Regards,

Santosh

Re: DELETE COLUM

Former Member — Wed, 14 Jun 2006 08:36:30 GMT

Hi,

You can not delete the column, but you can delete the data in the column.

Loop at itab into wa.

clear wa-field1.

modify itab from wa.

endloop.

<b>Alternatively</b>: create another itab like ur existing itab except that column which u want to delete.

then move data ito this table.

rgds,

latheesh

Message was edited by: Latheesh Kaduthara

Re: DELETE COLUM

Former Member — Wed, 14 Jun 2006 08:36:54 GMT

Hi,

Are you using dynamic internal table or normal internal table.

ITAB means internal table only Right,

Dynamic internal table you can control at the starting level, But Run time it is not possible to remove the column and add new one.

Regards

vijay

Re: DELETE COLUM

Former Member — Wed, 14 Jun 2006 11:33:05 GMT

Hi ,

ans for1:-

Declare a filed-sybol for that itab.

Ex:

FIELD-SYMBOLS: <fs_itab> LIKE LINE OF iatb.

loop at itab assing ASSIGNING <fs_itab>.

<fs_itab>-mandt = SPACE.

endloop.

*bcz we cannot delete the colomn in internal table

*or u can skip MANDT while u r selecting,if u r selecting like * FROM then use above LOOP..ENDLOOP.

for 2:-

I didn't get what you r asking...

pls. cxplain clearly..

Regards,

Ramesh