standard DB table update issue

[Former Member]

Hi all,

The past/history creditworthiness of the business Partners has to be updated based on some calulation but the transaction FPCR2 does not allow for this change.

The requirement is to update the custom tables of DFKKCRH and DFKKCRP for Creditworthiness.

could not find any BDC approach and BAPI that can be used.

Is there any other way as i am tryin got avoid the direct update to the standard DB tables.

Your ideas appreciated.

Regards,

Stk.

[Former Member]

Hi,

If you dont find a BAPI or FM,

As a last resort, to update a standard table, and instead of using an UPDATE statement, Do the following:

1) create a custom(Z) view : with the tables: DFKKCRH and DFKKCRP

2) Create maintenace view for the view/table.

3) Now you can see the view or update the entries in the view created above using SM30.

4) Now perform BDC recording for transaction SM30 for the custom view crreated above and then update the view

Once the view is updated, the underlying tables(DFKKCRH and DFKKCRP) also get updated...

Try out the above method...This will work as i have already tried out many times...

Regards

Shiva

[Former Member]

Used the update approach via program