Mass data upload in t code OKB9

[Former Member]

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.

[Former Member]

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.

[TammyPowlas]

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."

[Rob_McNally]

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.