topic Re: Regarding Updating Database in Application Development and Automation Discussions

Regarding Updating Database

Former Member — Wed, 14 Feb 2007 17:49:45 GMT

hi guys,

i just got a problem with updation of Database table EINE. I got some price details

and these details have to be updated to EINE-NETPR.

i am using select statement to select price details and using update command to update EINE-netpr.

update EINE where netpr = itab-netpr. ( simillar to this )

if sy-subrc = 0.

commit work.

endif

But, still when i checked the entries in EINE, netpr ( price ) is not updated.

I checked in debug mode and update command works well but its not updating EINE in real when i am checking the entries in it.

can any one please help me, do u think UPDATE command can be used to update Data base tables or do u think i need to add any other commit work statements after update or can any one tell me exactly how to update the database tables.

please send me a piece of code if possible.

thank you

pavan kumar

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 17:53:23 GMT

Hi,

It is not good practice to do direct table udpates..

Instead use a BAPI or standard sap FM to update the standard sap tables..

Thank,

Naren

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 17:56:41 GMT

Hi,

You can use in this way also ..

<b>UPDATE EINE SET NETPR = 'A310'

WHERE field = XXX</b>

Regards

Sudheer

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 17:56:59 GMT

Hi,

Agree with Naren that it is not good practice to update SAP table directly. Try to use BAPI or BDC to update EINE.

But you can try like this.

UPDATE EINE SET NETPR = ITAB-NETPR

WHERE <your condition>.

Regards,

Ferry Lianto

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 17:57:56 GMT

Hi,

DO NOT try updating the table entries through update command or by going into debug modein your SE11 table entries.

We do not know which standard tables get afffected dur to this change.

As Narendran suggested, you can use the standard FMs to update the field.

Regards

Subramanian

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 17:59:32 GMT

thanks for your answers, but can you please tell me how do u use BDC to update the data base in my requirement or is there any standard BAPI available to update it.

thanks

pavan kumar

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 18:02:44 GMT

What is the standard transaction that updates this table?

Rob

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 18:04:01 GMT

standard transaction is ME11

thanks

pavan kumar

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 18:05:26 GMT

Hi,

USe ME12 or ME14.

Regards

Subramanian

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 18:06:11 GMT

Hi Pavan,

Please try this FM perhaps they may help.

ME_DIRECT_INPUT_INFORECORD

ME_DB_UPDATE_INFORECORDS

ME_UPDATE_INFORECORD

ME_UPDATE_INFORECORD_COND

ME_UPDATE_INFORECORD_PD

Regards,

Ferry Lianto

Re: Regarding Updating Database

Former Member — Wed, 14 Feb 2007 18:26:09 GMT

thanks for your answers, but if i use any one of the function modules i suppose these function modules specified are only used to update the info record right?

what i mean is, i can use any one of these function modules only after select statement just to update i.e instead of UPDATE command right?

thanks

pavan kumar