topic Re: Update BSID in Application Development and Automation Discussions

Update BSID

Former Member — Sun, 30 Sep 2007 17:09:06 GMT

Hi all,

I need to do a direct update to table BSID for field zuonr, where i need to replace zuonr with a number.

I coded my logic this way :

select * from bsid into table t_bsid

where zuonr = <itb_bsid>-vbeln.

if sy-subrc = 0.

loop at t_bsid assigning <fs_bsid>.

<fs_bsid>-zuonr = <itb_s3>-zuonr.

endloop.

update bsid from table t_bsid.

if sy-subrc = 0.

commit work.

<itb_s3>-remarks = 'A'.

else.

<itb_s3>-remarks = 'C'.

endif.

- when i select * from bsid, my t_bseg is having the line of recod, and is manage to change the value for zuonr to the new value, but when it try to update bsid from table t_bsid, if return sy-subrc as '4'.

Can anyone help me on this? I'm in urgent to settle this, thanks alot!!

Re: Update BSID

Former Member — Sun, 30 Sep 2007 18:55:31 GMT

<b>Absolutely do not do this.</b> You can ruin you financial system. Table entries that need to match will not.

You can use transactions FB02 to change individual documents or FBL5N to do many changes.

Rob

Re: Update BSID

Clemenss — Sun, 30 Sep 2007 19:57:16 GMT

pompougnia,

it is exactly as Rob said. BSID is a secondary index derived from values in related business documents. If the documents are updated through respective standard transactions (as i.e. FB02) alls data get updated properly - including BSID.

If you ask your auditor about this, it might be your last time to ask anything.

Regards,

Clemens