topic Re: Updating database table through update in Application Development and Automation Discussions

Updating database table through update

Former Member — Fri, 06 Mar 2009 06:46:07 GMT

Hi,

I am updating database table through

UPDATE EBAN SET EBAKZ = 'X'

WHERE BANFN = T_INREC-BANFN AND BNFPO = T_INREC-BNFPO.

but when I am going to see in transaction me53n here I can't see user name who has made the changes.

Regards

Sagar

Re: Updating database table through update

Former Member — Fri, 06 Mar 2009 06:49:45 GMT

As you are writing direct update statement it may not work. try passing uname and time to the table as well.

Re: Updating database table through update

Former Member — Fri, 06 Mar 2009 06:50:07 GMT

Use commit work and check the same

Re: Updating database table through update

Former Member — Fri, 06 Mar 2009 06:53:54 GMT

hi,

you can use

COMMIT WORK AND WAIT

thanks

Re: Updating database table through update

Former Member — Fri, 06 Mar 2009 06:54:44 GMT

Hi Sager,

Check the data elment of that filed what ever you are updating is the Change Documents is checked.

then only the updating will reflect in the transactions..

if it checked..

checke that fied is updating in the data base.....if not do the COMMIT after udating then it will reflects..in the trasaction

Thanks!

Re: Updating database table through update

Former Member — Fri, 06 Mar 2009 06:56:04 GMT

Dont update database tables directly with UPDATE statement...its not recommended.

Try to use FM: ME_UPDATE_REQUISITION for ur requirement.

Reagards,

Dara.

Re: Updating database table through update

kamesh_g — Fri, 06 Mar 2009 06:59:29 GMT

When you are updating database table you are updating only values not attribute rite ?

Sowhen update the database table entries it will show your USERNAME details .

When you are doing any manual changes only it will show the USer details of modification .

Suppose if you change the attributes like table text . it will show your name .

And in transactinon how you are updating, may be with the help of bdc , here also we not just updating data but not changing the screens of TCODE like that . so in TCODE also you dont get your user details .

IF you want the changes by you Chekc it CDHDR,CDPOS tables .for your reference .

Re: Updating database table through update

Former Member — Fri, 06 Mar 2009 07:02:30 GMT

HI,

please check this link

http://help.sap.com/saphelp_nwce10/helpdata/en/e7/968aa8b2384dd9835f91e7f8470064/content.htm

Thanks and regrds

Durga.K

Re: Updating database table through update

Former Member — Fri, 06 Mar 2009 07:02:59 GMT

Hi Sagar,

you will not be able to see the username updated as this is trasaction specific. you will have to explicitly update the username field.

Have a nice day,

Varghese

Re: Updating database table through update

former_member222860 — Fri, 06 Mar 2009 07:04:46 GMT

UPDATE EBAN SET: EBAKZ = 'X'                  "check SET:
          WHERE BANFN = T_INREC-BANFN 
            AND BNFPO = T_INREC-BNFPO.

  COMMIT WORK.