Delta load of customizing objects from R3 to CRM

[Former Member]

I need to set up a delta load for customizing objects for ex: DNL_CUST_BNKA from R3 to CRM. Is there any documentation on this subject? Please advise. Thanks.

[Former Member · Accepted solution]

Hi Vien,

To do delta download you need to create requests using transaction R3AR2.

<b>Defining Request</b>

1. Click on new entries. Put a request name(ANY) and adapter object: DNL_CUST_BNKA.

2. In the Request Details put in the table name(BNKA or T018P) and the field name ( For BNKA it is BANKS or BANKS & T018P it is PSLND or PSAMT)

3.Choose I for INcl/Excl.

4. For Options Choose EQ Equality(=Low)

5. In the Low field provide the key field value you wish to retrieve.

<b>Start Request</b>

Choose transaction R3AR4 and put in your request name, enter and execute.

<b>Monitor Request</b>

Choose transaction R3AR3 and put in the request name and execute.It will let you know the status of the download.

In case an error comes analyse it usinf Transcation SMW01.

Wish this is helpful.

If it is, do reward points.

Regards,

Shalini Chauhan

[Former Member · Accepted solution]

Hi Shalini,

Thanks for the info. It works well with your instructions but I would like to automate the delta so I've tried to use R3AC4 but there is no business transaction event to associate with object class CUSTOMIZING. I guess the solution is to schedule a batch job to execute R3AR2.

Regards,

Vien Phan

[Former Member · Accepted solution]

Hi Vien,

By Standard you can automate this process especially for getting the customizing objects.As you rightly said you will have to schedule a batch job to execute R3AR2.

Regards,

Shalini Chauhan

[Former Member]

Hi Vien,

You can automate the delta load in only one way,i.e scheduling the load, either daily, weekly or as per your required time duration, but yes to trigger the way you want, i.e any change in R/3 should trigger the download, you need to find an exit in R/3 where you can trace the change and would trigger the download in CRM using RFC connection.

You don't need to go for request download (R3AR2) it is ment for selective download, to go for delta donwload you need to execute R3AS4.

Best Regards,

Pratik Patel

<b>Reward with Points!</b>

[Former Member]

This is what I got from SAP

Bank Details information is a customizing object, and is not designed

for frequent changes, because there's no delta download for customizing

objects. If you create new Bank/change detail or delete an old one,

you have to perform initial load manually for DNL_CUST_BNKA again.

You can also do a request download of the replication object

'DNL_CUST_BNKA'to get some bank data added later on.

(Transaction \R3AR2 ).

You will need to do a request download of bank data from time to time

whenever you change the bank details. This is currently how it can be

done in SAP Standard.

If you change regularly bank master data:

The data has to be in sync between R/3 and CRM. If you make changes

often to the bank master data, you might consider scheduling a regular

job. See below for steps.

1. Transaction R3AS

2. Load Object = DNL_CUST_BNKA

Source Site = your R/3 system

Destination Site = your CRM system

3. Menu Goto > Variants > Save Variant

4. Enter a Variant Name and Description

5. Start Transaction SM36 to define a background job

6. Select the Job Wizard button:

In step Defining a Job Step, select ABAP program step

In step Define an ABAP Program Job Step, enter ABAP program name

SMOF_DOWNLOAD and the variant you created in step 4

7. Click on Job Wizard and follow the steps, choose ABAP Program

SMOF_DOWNLOAD and the variant you created in step 4

8. Select start time Immediately

9. Press Complete to finish

10.Choose Job Selection (SM37)

11.Enter the Job Name -> should have status finished

Schedule the job (SM36 > start condition) according to how often you

change your bank