Dear all,

We're gonna port our business partner data from one company to another. Would doing import and export through Exchange on tables
tccom100 bp
tccom110 sold to bp
tccom111 ship to bp
tccom112 invoice to bp
tccom114 pay by bp
tccom120 buy from bp
tccom121 ship from bp
tccom122 invoice from bp
tccom124 pay to bp
tccom130 addresses
tccom140 contacts
be sufficient? Or should we develop API session to make sure that the data pass through session logic of the receiving company before recorded there? Thanks very much for any pointer. Have a nice day (or night since we're a global community :) )!

Rgds,
Paul

Dear all,

Just ripped open the gut of tccom4205m000 Copy Business Partner. Turned out that it just read a business partner data on the tables tccom100 to tccom124, do a bit of clean up (e.g. clean the contact, credit limit information, etc.), then insert the clean data as new business partner using DAL.

I think I'll just replicate it using Exchange - Excel - Exchange thing then since Exchange can import using DAL too.

Cheers,
Paul

I think you may need to add tccom145 (Contacts by Business partners).

If you are using Electronic data by business partners, then may be tccom131 and tccom141 as well.

--Avinash

Thanks, Avinash. You're right, I need tccom145 too

Rgds,
Paul