Skip to Content
avatar image
Former Member

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.

Its very urgent.

Regards

Sourabh Verma

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 28, 2007 at 08:24 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’

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2007 at 11:01 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 29, 2007 at 03: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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 30, 2007 at 06: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

    Add comment
    10|10000 characters needed characters exceeded