Business Partner : Mass upload

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member]

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

[Former Member]

Hi Arun,

Can you give some brief about ECATT and SCAT methodology.

Regards

Sourabh

[Former Member]

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

[Former Member]

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

[Former Member]

Hi Saurabh,

We used flat files for uploading the data.

Regards,

Amit

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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.

Regards,

Amit

[Former Member]

Hi Amit,

did u create 4 million BPs using loop ?

What I am trying to ask is,  did it run 4 million loops ?

[Former Member]

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