Update on FI-table BSEG

[Former Member]

Hi,

i have an abap where i make a

update bseg set mansp = 'value' where cond..........

The update in bseg works well, BUT: the corresponding fields in BSID or BSAD are NOT updated. As bseg is a cluster-table i thought that the update in bsid and bsad will take place automaticly ???

How can i handle this ?

[Former Member]

Hi,

You should never update the standard tables directly, this will result in the loss of database integrity like its happening in your case. you should use the appropriate function.

What are you trying to do, create a MATERIAL Document?

Please explain.

Regards,

Ravi

Note : Please mark the helpful answers

[Former Member]

Hi Ravi,

no, i just want to update the field MANSP in bseg in an FI-document. (customer).

What do you mean by 'appropriate function' ?? There is no function for doing this ?

regards, Martin

[Former Member]

Martin,

As I said you should <b><u>NEVER EVER </b></u> update the standard database tables directly. If you can tell us the details of the business process then we probably can suggest a suitable function module to update the required details.

The problem with updating directly, we don't know what are the related tables and where all its going to affect us leading us to inconsistent data in the tables.

Regards,

Ravi

Note : Please mark all the helpful answers

[Former Member]

Ravi,

there is no 'business process' behind it....i

will simply update ONE field under certain

circumstances. I want to set the field mansp

to blank if it has the value 'T' and a date-field

from another table has a special value.

Finish. Very simple. So i am not sure if there

is any 'function' for that.

regards, Martin

[Former Member]

Hi martin,

1. since you are updating standard sap table,

please make sure you have specifications

and signature of the functional consultant,

and highlight the reason for updating the field.

regards,

amit m.

[Former Member]

Hi,

I just looked at the field that you mentioned that is specifing the reason for the DUNNING Block. And usually you don't update this just like that, there will some screen / transaction where this will have to be updated as this stops the dunning process for that specific customer. That is the business process.

Please check with your functional consultant, how you can but a dunning block on a specific document / for a specific customer. He might be able to give you the info.

Regards,

Ravi

[Former Member]

Hi margin,

1. bseg is a cluster table does not mean

that automatically other related tables will get updated.

2. when dealing with sqls,

we have to one by one update the tables.

3. automatically it will never happen.

regards,

amit m.

[Former Member]

Hi,

As Ravi said you should not update the standard tables directly. SAP provides standard Function module to do this.

You check the following function modules:-

SET_ALL_BSEG

FMUDBSEGH_UPDATE

FMUDBSEG_UPDATE

Regards,

Sameena

[andreas_mann3]

hi,

try to prg. a batch-input to transaction fb09

with trans.-recorder (shdb) - it's very simple

Andreas

[Former Member]

only it can be possible using the function module with out you cant do anything