topic Re: Mass data upload in t code OKB9 in Application Development and Automation Discussions

Mass data upload in t code OKB9

Former Member — Sun, 01 Mar 2020 11:12:10 GMT

I have got an requirement to write a program for uploading data in t code OKB9 - Automatic account assignment in Mass through following options :

1. BAPI

2 FM

3 BDC/LSMW

I have already searched for BAPI or FM for OKB9 but there is no suitable BAPI or FM for OKB9 which we can use.

As per my understanding OKB9 is an Enjoy transaction and BDC / LSMW is somewhat complex to code in ABAP.

Kindly suggest me suitable approach to fulfill this requirement where user will be able to upload data in mass into transaction OKB9.

Thanks in advance.

Re: Mass data upload in t code OKB9

TammyPowlas — Sun, 01 Mar 2020 13:01:16 GMT

I recommend looking at Eli's suggestion in this thread: https://answers.sap.com/questions/397456/mass-upload-of-okb9.html

"Would be much easier to update the table TKA3A directly. OKB9 is just view maintenance and no other action, apart from table update, happens when it's changed." and later he says "If direct table update is not accepted (why?), then create ABAP program which will read the file and do the table's update, which is practically the same."

Re: Mass data upload in t code OKB9

Rob_McNally — Sun, 01 Mar 2020 15:35:44 GMT

ABAP program is easiest solution.

On ECC6; LSMW can work if load is split into 3 pieces. It needs a separate script for the General, Profit Center & Business Area loads.

Then load each piece separately in that order.