topic clear the value in Application Development and Automation Discussions

clear the value

Former Member — Tue, 11 Sep 2007 15:22:02 GMT

hello experts,

I want to clear the bahns field value from the lfa1 table.

here I am trying to write the code for it.... I got struck in the middle can anyone help me comeplete this code....

data: BEGIN OF it_train,

lifnr type lifnr,

bahns type bahns,

END OF it_train.

data: it_vend like STANDARD TABLE OF lfa1 WITH HEADER LINE.

select lifnr bahns into table it_train.

clear it_train-bahns.

Thanks a lot for your anticipation

Nitesha

Re: clear the value

Former Member — Tue, 11 Sep 2007 15:25:41 GMT

try this....

loop at it_train.

clear it_train-bahns.

endloop.

Regards

Vasu

Re: clear the value

Former Member — Tue, 11 Sep 2007 15:25:47 GMT

Try:


loop at it_train
  clear it_train-bahns.
  modify it_train.
endloop.

Rob

Re: clear the value

Former Member — Tue, 11 Sep 2007 15:27:54 GMT

Thanks a lot for your replies guys

I want to update this same blank value in lfa1 for all the vendors

Can anyone guide me to do this

Re: clear the value

Former Member — Tue, 11 Sep 2007 15:32:29 GMT

LFA1 is a standard SAP table. Use a BAPI or BDC to do this.

Rob

Re: clear the value

Former Member — Tue, 11 Sep 2007 15:37:52 GMT

data : itab like standard table of lfa1 with header line.

select * from lfa1 into table itab .

if sy-subrc eq 0.

loop at itab.

clear itab-bahns .

modify itab index sy-tabix.

endloop.

<b>modify LFA1 from table itab.</b>

endif.

Re: clear the value

Former Member — Tue, 11 Sep 2007 15:40:19 GMT

loop at it_train.

update lfa1 : set bahns = ' ' where lifnr = it_train-lifnr.

endloop.

or change where condition...as per ur requirement......

Regards

Vasu

Re: clear the value

Former Member — Tue, 11 Sep 2007 15:43:55 GMT

Mahesh and Vasu - it is very dangerous to do direct updates on SAP tables. In this case, how will central address management be affected?

Rob