Updating database table through update

[Former Member]

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

[Former Member]

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

[Former Member]

Use commit work and check the same

[Former Member]

hi,

you can use

COMMIT WORK AND WAIT

thanks

[Former Member]

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!

[Former Member]

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

Try to use FM: ME_UPDATE_REQUISITION for ur requirement.

Reagards,

Dara.

[kamesh_g]

Hi

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 .

[Former Member]

HI,

please check this link

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

Thanks and regrds

Durga.K

[Former Member]

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

[former_member222860]

Hi

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

  COMMIT WORK.