topic Write a Mass Update ABAP Program in Application Development and Automation Discussions

Write a Mass Update ABAP Program

Former Member — Fri, 21 Dec 2007 16:20:39 GMT

My User would like to me to write a mass update program to update the Accounting Clerk Field (KNB1-BUSAB) instead of using the xd99.

I learned that KNB1 is a SAP standard table and not able to direct update to the table.

I am thinking of using the BDC recording from tcode 'XD02' to update KNB1-BUSAB, but user say that there will be a large volume of records to be updated either or daily or monthly basis and would like to have something simplified 'XD99' instead using BDC.

I am studying the "XD99" and figure out that it using the function call "MASS_CHANGE_DATA" to do the mass update, refer below.

Anyone has the idea on how to use this function or is it a SAP standard function call ?

Are there any other ways to do the mass update without performance issue ?

Thanks.

Re: Write a Mass Update ABAP Program

former_member156446 — Fri, 21 Dec 2007 16:24:48 GMT

hi u can also use MASS transaction , may be it might be usefull

Re: Write a Mass Update ABAP Program

RoySayak — Fri, 21 Dec 2007 16:26:27 GMT

u should use some bapi to update customer master.

at this moment i can't remember any bapi for customer change.

otherwise u've to use BDC.

Thanks

Sayak

Re: Write a Mass Update ABAP Program

Former Member — Fri, 21 Dec 2007 17:03:11 GMT

It would probably be best if you convince management to go along with batch input.

But if you can't, this looks like one of those "safe" fields that SAP customers occasionally update on there own.

If I had to do this, I would run a performance trace (ST05) while updating this field. This will show you if there are any other fields/tables being updated at the same time. It may help you decide.

But you will probably find that both CDHDR and CDPOS are being updated. So if you simply change this field, no change documents will be created. But I think you can create the change documents separately.

Rob

Re: Write a Mass Update ABAP Program

Former Member — Fri, 21 Dec 2007 19:55:07 GMT

Take a look at the function module SD_CUSTOMER_MAINTAIN_ALL.

-Mark