Database Update Directly or USING BAPI !

[Former Member]

Hi,

I Want to update

ZPLP1

ZPLP2

ZPLP3 AND ZPLP4 fields in MBEW. These fields found only in one table in SAP, the table in MBEW.

Can i write program to directly update that since it is only one table Or I need to use BAPI for this.

Any way BAPI also do the same, updating only one table. I want to know If i do direct update any problem will come.

Let me know, other things to consider when directly updating the table. Also, give the impact of LOCKING TABLES here whats the use.

My Ultimate Aim is to direct update table without any issues.

Looking for your response.

Thanks In Advance.

[Former Member]

Hi Rizvi,

I dont find a reason why you shouldn't go using a BAPI when you know that the BAPI updates the required table.

Generally a BAPI takes care of all the related issues when you use it.

It would handle the locking and unlocking of the tables.

If you are very sure that the BAPI does not do any thing apart from updating the table, it is not a bad choice to try updating the table directly.

But take care to lock and unlock the tables, so that you would be sure of the integrity of data.

Locking is done so that, no two ppl try to update the table at once. This would ensure consistency of data. So after analysis you could go ahead with either of these choices. If you are pretty sure of what u r doing then nothing should stop u doing that...all the best

Reward points if this helps,

Kiran

[Former Member]

Hi Kiran,

Here, i ve implemented direct update but not taken care of locking and unlocking the table. Please tell me, this will lead to any big issues and impact of this.

Also, explain how to lock and unlock the tables.

Thanks