Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Manual database update

Former Member
0 Likes
513

Hi all,

I've added a couple of Z fields to table VBRP. I'm planning to use a exit to update any invoices in the future on create/change.

My question is this:

Is it safe to do database writes in ABAP to populate these fields in the old invoices. These fields don't exist anywhere else as I just created them. (or do they!?)

Thanks

1 ACCEPTED SOLUTION
Read only

valter_oliveira
Active Contributor
0 Likes
474

Hello.

If you respect databse locks it's safe. Before updating, try to enqueue the record that you will update. If you can't, that because someone else did before and you will have to wait until you can block the record. If you can it's safe. An advise, would be to run that program when noone is work (block all the users in system except yours!

However, i'll leave with a question: why don't you create a ZVBRP, with key VBELN/POSNR and all your ZFIELDS?

Regards.

Valter Oliveira.

2 REPLIES 2
Read only

valter_oliveira
Active Contributor
0 Likes
475

Hello.

If you respect databse locks it's safe. Before updating, try to enqueue the record that you will update. If you can't, that because someone else did before and you will have to wait until you can block the record. If you can it's safe. An advise, would be to run that program when noone is work (block all the users in system except yours!

However, i'll leave with a question: why don't you create a ZVBRP, with key VBELN/POSNR and all your ZFIELDS?

Regards.

Valter Oliveira.

Read only

Former Member
0 Likes
474

Thanks Valter,

I'll bear that in mind.

To answer your question:

I need to append directly to VBRK as I'm working with flexible planning and I need a table which has a LIS communication structure provided.