Business Partner _ Mass Upload

31/08/2017

Business Partner : Mass upload

(http://w ww.sap.c Products om/)

(https:/ (https: //www.sap.com/products.ht www.sap.com/products.html) ml)

Industries

(https://www.sap. www.sap.com/industries.h com/industries.html) tml)

Support

(https://www.sap. www.sap.com/ com/support.html) support.html)

Training Training

(https://www.sap. www.sap.com/training com/training-certi -certication.html) cation.html)

Community

Developer

Partner

(https:/ (https: //www.sap.com/community.htm www.sap.com/community.html) l)

(https:/ (https: //www.sap.com/developer.html) www.sap.com/developer.html)

(https:/ (https: //www.sap.com/partner.h www.sap.com/ tml) Aboutpartner.html)

About

(https://www.sap. www.sap.com/ com/corporate/ corporate/en.html) en.html)

 Home Home (https://www.sap.com) / Community (https://www.sap.com (https://www.sap.com/community.html) /community.html) / Archives (/) / Discussions

Actions

Archive Archive (/discussions) / SAP CRM: Webclient Webclient UI - Framework Framework (/discussions/space/crm/webclient-ui-fram (/discussions/space/crm/webclient-ui-framework) ework)

Archived Archived discussions are read-only. read-only. Learn more about more about SAP Q&A (https://go.sap.com/community/about/questions https://go.sap.com/community/about/questions-and-answers.html) -and-answers.html)

Business Partner : Mass upload Hi Experts, I have to upload some15 million Business partner through BP transaction . I want to know what will be the most suitable method to attain that. Should I use BAPI, BDC , LSMW ?? I am not clear at all, what should be the most appropriate solution to this. Please help me out. https://archive.sap.com/discussions/thread/649638

1/9

31/08/2017


Its very urgent. Regards Sourabh Verma customer_relationship_management

(https://people.sap.com/sourabh.verma3) Sourabh Verma (https://people.sap.com/sourabh.verma3) February 29, 2016 at 12:30 PM 0 Likes

Helpful Answer by Ambar Adhav (/discussions/message/4497975#4497975)

g for? View more on this topic (https://go.sap.com/community/tag.html? 5563033908644701) or /answers.sap.com/questions/ask.html?primaryTagId=556322785902137845563033908644701)

12 replies  Helpful Answer

(https://people.sap.com/ambar.adhav2) Ambar Adhav (https://people.sap.com/ambar.adhav2)replied

November 28, 2007 at 09:28 AM

Hi, You can use LSMW for this. Check transaction KCLJ and KCLL for resolving this issue too. For smaller number of data even ELM is very simple and effective upload method which provides facility to upload Marketing attributes data too. External Data Transfer for Business Partner using KCLJ The steps for business partner upload using the SAP standard program are as follows: 1. The transaction code for the report is KCLJ. 2. In the transfer program in kclj you have to give the sender structure name which is maintained in transaction KCLL. 3. While creating this sender structure (KCLL) specify the Transfer type as ‘015’ for the business partner and then give the dictionary structure. This dictionary structure should contains the fields which are available in the structure ‘BUS_DI’

https://archive.sap.com/discussions/thread/649638

2/9

31/08/2017


4. After specifying the sender structure in KCLJ, specify the input and output file name, file system, editing mode and file type. 5. Finally execute the report in test run mode to check the correctness of the data. 6. If the test run is successful, run the report without test run to start the actual transfer. 7. You can also define the transfer rules (KC7R) to assign the constant values while the transfer. 8. The documentation is available in SPRO->Cross-Application components->SAP Business Partner->External Data Transfer. With regards Ambar Adhav 0

(https://people.sap.com/atin.shee)

Atin Shee (https://people.sap.com/atin.shee)replied November 29, 2007 at 12:01 PM

Sourabh, In our project approx .1 milion BP uploaded (CRM) by using LSMW and didn't face much problem though the scenario was complex. Few assumption/important points: -> All the relevant BP role types are defined in both CRM and R/3 -> All the necessary configuration (such as Bank Master, number range, etc.) on either CRM and R/3 side and middleware between CRM and R/3 is complete for correct flow of BP data from CRM to R/3 -> To accommodate this, SAP CRM needs to be configured to take the external number assignment for migrating Business Partner purpose ->If Business Agreement is there, once Business agreement is created on the CRM side, a Contract Account is created on the R/3 side. This part happens as part of normal middleware configuration. Thanx, Atin 0


3/9

31/08/2017


(https://people.sap.com/amit.kumar28) Amit Kumar (https://people.sap.com/amit.kumar28)replied

November 29, 2007 at 16:36 PM

HI, We used BAPIs to upload approx. 4 million BPs in our project and it went well smoothly. But in case if you are uploading marketing attributes as well then it will take some time as the BAPI processing for the same is quite slow. Regards, Amit 0

(https://people.sap.com/sourabh.verma3) Sourabh Verma (https://people.sap.com/sourabh.verma3)replied

December 05, 2007 at 06:50 AM

Hi Amit, Can I know what was the source of data which you used for data uploading.Was it a flat file or some other source? Help would be appreciated. Regards Sourabh Verma 0



Hi Saurabh, We used flat files for uploading the data. Regards, Amit 0 https://archive.sap.com/discussions/thread/649638

4/9

31/08/2017




Hi Amit, Actually we are also supposed to load some 10 Million Business partner and our source of data is also a flat file. We are making a ABAP code and calling the respective BAPI's for our requirement. So ,I wanted to ask what type of peformance issues you faced while uploading the data? What was the frequency of data uploading process? How much time it took for you to get all the data in the system?? I would really appreciate if you could give me some more details about your scenario. It would be great help. Looking fwd for you reply. Thanks and Regards Sourabh Verma 0



Hi Saurabh, We faced lots of performance related issues in the beginning but then it was mainly due to lack of performance tuning to be done in database by Basis team. Once that was done, we uploaded approximately 2-3 lacs of record everyday. I would like to add one more thing. The standard BAPI which we used for uploading Marketing Attributes of BPs has major performance issue. SAP people said that very soon they are going to release SAP Note for that. We did not upload Mkt attributes during migration as it was not affecting business in the initial stages. If you are planning to migrate Marketing attribute as well then it would be difficult to upload even 1 lac record daily. Regards, Amit 0 https://archive.sap.com/discussions/thread/649638

5/9

31/08/2017




Hi Amit, As you have already faced this situation , I would just explain my scenario and may you could could just throw some light on that. I have created ABAP program in that I am calling the respective BAPI's BUPA_CENTRAL_FROM_FS_DATA02 : For loading the generic data Then BUPA_CENTRAL_ADDRESS_ADD : For adding secondary address Then BUP_MEMORY_BUT000_GET : For getting BP GUID form memory Then BUPA CENTRALCI_CHANGE : For Customised fields . Then After evey 100 records I am doing COMMIT through BAPI_TRANSACTION_COMMIT. So, for each record these all BAPI's area called, apart form last one which is called after every 100th record. Please tell me your opinion about this method. Would be thankful to you. Regards Sourabh Verma 0


December 05, 2007 at 13:06 PM

Hi Saurabh, We used following BAPIs: BAPI_BUPA_FS_CREATE_FROM_DATA2 BAPI_IDENTIFICATION_ADD CRM_MKTBP_CHANGE_BP Besides we called BAPI_TRANSACTION_COMMIT to commit transaction after processing each record. https://archive.sap.com/discussions/thread/649638

6/9

31/08/2017


Regards, Amit 0

(https://people.sap.com/samson.devadas) Samson Devadas (https://people.sap.com/samson.devadas)replied February 29, 2016 at 12:30 PM

Hi Amit, did u create 4 million BPs using loop ? What I am trying to ask is, did it run 4 million loops ? 0

(https://people.sap.com/arun.kumar48) ARUN KUMAR (https://people.sap.com/arun.kumar48)replied

November 30, 2007 at 07:24 AM

Hi Saurabh, You can use the ECATT or SCAT methodology also for uploading this. We used this and didnt find any problem. Regards Arun Kumar 0


November 30, 2007 at 12:37 PM

Hi Arun,


7/9

31/08/2017


Can you give some brief about ECATT and SCAT methodology. Regards Sourabh 0

Share & Follow (https://www.facebook.com/sapcommunity) (https://www.youtube.com/c/SAPCommunities) (https://plus.google.com/+SAPCommunities)

(https://twitter.com/SAPCommunity) (https://www.linkedin.com/company/sap) (https://instagram.com/sap/)

(http://www.slideshare.net/SAP)

Privacy (http://go.sap.com/about/legal/privacy.html) Terms of Use (http://go.sap.com/corporate/en/legal/terms-of-use.html) Legal Disclosure (http://go.sap.com/about/legal/impressum.html) Copyright (http://go.sap.com/about/legal/copyright.html) Trademark (http://go.sap.com/about/legal/trademark.html) Sitemap (http://www.sap.com/sitemap/index.html) Newsletter (https://go.sap.com/registration/newsletter.html)


8/9

31/08/2017



9/9

Business Partner _ Mass Upload

Recommend Documents