DTW BP Catalog numbers many records

[Former Member]

Hi Experts,

I have a business scenario where the client has around 500 customers and around 50 Vendors. Each vendor has its own item list with specific BP Catalog numbers and price associated with the items supplied by that vendor. In order to maintain the difference in the item code from what is referred to by the vendors and customers in particular we are using BP catalog functionality of SAP Business One. I am aware of the DTW import for the BP catalogs.

The issue is, assuming there are around 1000 item codes supplied by different vendors, some of them may be common . If we make a BP Catalog import file for each customer for all the items in order to ease ourselves out of the effort of analysing the item codes that have different BP catalog numbers as compared to the item codes, the total records to be imported would come out to be at least 500,000 (500 X 1000). Doing a DTW import for this would take hours. Its running for 3 hours and still hasn't shown any progress bar yet where i am tring to import it from a database table rather than a CSV.

Could someone recommend a better out of the box solution for this scenario?

Thanks and regards

Amit Arora

[Former Member]

Take care to stop the process cose it could damage the DB. Probably if you check the performance of the server the memory or the processor are consuming high ammounts of resources.

[Former Member]

Hi Rahul,

Thanks for the response.

When you say a custom utility i understand you are referring to a DIAPI code doing this in a bit more optimized manner. However, when you are saying back end function, are you referring to SQL update. As from what i understand, a SQL update/insert function from the backend may not be allowed by SAP for such operations.

Regards

Amit Arora

[Former Member]

Hi Amit..........

While executing any query or any FMS or any Data Import SAP first checks each and every permutation and combination whether it can be done or not. If it finds any data missing then it gives error. So in your case as it has more permutation and combination SAP will obviously take time to check the availability of each record for every performed actions.

If you want it to be completed as much as fast it can be then you may have to develop your own utility.......

It might be a program or some back end function....

Regards,

Rahul