topic Re: Using UPDATE in reporting in Application Development and Automation Discussions

Using UPDATE in reporting

Former Member — Tue, 07 Aug 2007 11:36:51 GMT

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

Re: Using UPDATE in reporting

Former Member — Tue, 07 Aug 2007 11:40:21 GMT

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

Re: Using UPDATE in reporting

Former Member — Tue, 07 Aug 2007 11:41:57 GMT

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

Re: Using UPDATE in reporting

Former Member — Tue, 07 Aug 2007 11:50:50 GMT

Hi All,

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

Rewarded if helpful..

Regards

Re: Using UPDATE in reporting

Former Member — Tue, 07 Aug 2007 11:55:13 GMT

Hi,

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

Regards, Dieter

Re: Using UPDATE in reporting

Former Member — Tue, 07 Aug 2007 11:56:54 GMT

Hi All,

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

Rewarded if helpful..

Regards

Re: Using UPDATE in reporting

Former Member — Tue, 07 Aug 2007 12:06:25 GMT

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 UPDATE DB table directly and SET Some of its fields to some given values.

Any helpful suggestions...

Regards

Nagaraj

Re: Using UPDATE in reporting

Former Member — Mon, 13 Aug 2007 06:30:41 GMT

*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