Re: how to update database table

Former Member — Sat, 09 Jun 2012 06:15:06 GMT

Hi Expert,

I want to update the database table EKES as i am taking data from excel to the internal table and from internal table i want to update the datebase table ekes

below is my code

loop at gtab from 2.

    split gtab-line at ',' into wa_final-ebeln wa_final-ebelp wa_final-ebtyp wa_final-eindt2 wa_final-menge.

    CONCATENATE wa_final-eindt2+6(4) wa_final-eindt2+3(2) wa_final-eindt2+0(2) INTO lv_date2.
    condense lv_date2 no-gaps.
    wa_final-eindt2 = lv_date2.
    append wa_final to it_final.

endloop.

from it_final how to update the databae table EKES.

Regards,

Moderator message : Search for available information, discussion locked.

Message was edited by: Vinod Kumar

Re: Re: how to update database table

Former Member — Sat, 09 Jun 2012 07:31:25 GMT

Hi Antha,

Try this,

UPDATE dbtab FROM TABLE itab

INSERT dbtab FROM TABLE itab.

Thanks,

Ashik

topic Re: how to update database table in Application Development and Automation Discussions

Re: how to update database table

Re: Re: how to update database table