Using UPDATE in reporting

[Former Member]

Hi all,

I require the procedure to use UPDATE DB table in reporting , Such as in case of LFA1, I want to update LFA1 directly and change some of the mentioned fieldss to Hardcoded values and some of them are to be initilased from the internal table.

Kindly can anyone give the syntax of how to use UPDATE DB along with some key fields...

Regards

Nagaraj

[Former Member]

Hi,

be carefull to update standart-table. You get a lot of problems.

Don't use this way.

Update it by BAPI, tcode MASS or use BDC.

Regards, Dieter

[Former Member]

Hi,

cant you use

xk02 for changing the vendor master details...

or else select the record from lfa1

which you want to update into itab.

now change the itab

by using modify itab.

and use update lfa1 from table itab.

but this is not recommended

i think you can use XK02 ( if so you can use it)

thanks & regards,

venkatesh

[Former Member]

Hi All,

I wanna know in general, how to use <b>UPDATE</b> Keyword for DB table directly, along with some of the fields of that table hardcoded. My requirment demands so.

Rewarded if helpful..

Regards

[Former Member]

Hi,

are you realy sure that you cannot use BAPI, MASS or BDC??

Regards, Dieter

[Former Member]

Hi All,

I have my requirement to follow the procedure which I mentioned above as to use UPDATE Syntax directly in my code. If possible , send me the procedure for it.

I need to <b>UPDATE</b> DB table directly and <b>SET</b> Some of its fields to some given values.

Any helpful suggestions...

Regards

Nagaraj

[Former Member]

*EXAMPLE

UPDATE YDDLIMIT

SET DDLMT = '1000'

WHERE

BUKRS = 'C550' AND

VKORG = '1000'.

*ANOTHER E.G.

UPDATE LFA1

SET LAND1 = 'INDIA'

WHERE

LIFNR = '0123456789'.

*REWARD POINTS IF USEFUL,GET BACK IN CASE OF QUERY

Message was edited by:

Tripat Pal Singh

[Former Member]

Hi All,

I wanna know in general, how to use <b>UPDATE</b> Keyword for DB table directly, along with some of the fields of that table hardcoded. My requirment demands so.

Rewarded if helpful..

Regards