custom fields mapping issue of sales order replication from R/3 to CRM

[Former Member]

Hello Experts,

I have to replicate sales orders from R/3 to CRM system (Initial and Delta)

The issue is I have custome fields in R/3 which are maintained in custom table(Z table) in R/3.

We added those custom fields in CRM customer_i table to synchronise with R/3 data.

To MAP R/3 custom fields to CRM custom fields, i have the following customization.

1. Added the custom function module in the event CRMO_200 and moved all the custom fields into interal table IT_OTHER_INFO.

2. The intrnal table IT_OTHER_INFO with data is passed into CRM standard function modules.

3. But in CRM the BADI 'CRM_DATAEXCHG_BADI' implementation does not have the input parameter of internal table TI_OTHER_INFO.

All my custom data is in internal table TI_OTHER_INFO.

Please suggest where can i map this data to CRM enhanced fields.

Regards,

Umashankar.

[vanessa_donegan]

Hello Umashankar,

In the data exchange of sales transactions I have never seen CRM_200 used so I am not familiar with this. Please use note

1053817 as a guideline on what needs to be done to enhance the structures for transfer of custom transaction data, its similar in both directions just the method called to map the data is different. Can you get the header data to transfer i.e is the issue only with CUSTOMER_I?

Kind regards,

Vanessa.

[Former Member]

Hello Vanessa,

Thank you so much for your reply.

I went through the Note (1053817). It is good. I understand that the custom fields should enhance in the BAPE_VBAP in R/3.

My Scenario:

Goal: Orders replication from R/3 to CRM along with Custom fields.

In R/3, all the custom fields are maintained in Z table (Not VBAK or VBAP).

All these custom fields are belongs to Item level.

In CRM, The custom fields are maintained in CRMD_CUSTOMER_I table though AET.

I need to MAP these custom fields to CRM while order replication from R/3 to CRM.

Regards,

Umashankar.

[vanessa_donegan]

Hello Umashankar,

It is a complex process to add new tables to the data exchange scenario this is why generally its fields added to exiting tables. To map the data you need to use method CRM_DATAEXCH_R3D_MBDOC_FILL of the CRM_DATAEXCHG_BADI - see note 797815. Also in R3AC1 for the adapter object you define what tables are used to transfer data so you would need to add your Z table here too. The BAPI structure in ECC needs to be updated with the new fields so these can be mapped to the Bdoc structure in the data exchange BADI.

I hope this is some help.

Kind regards,

Vanessa