on 07-05-2013 6:39 PM
Hi experts,
I'm trying to replicate a table (T001B) from ECC to CRM using an adapter object.
To do that, I created an adapter object in CRM from transaction R3AC3, with the following setup:
Object Class: CUSTOMIZING
Initial flow context: Source R/3 - Destination CRM
Tables Structure:
Mapping module: R/3 to CRM: a custom Function Module where I read data from BAPIMTCS and fullfill Z9CRM_T001B table with data.
Then I launched initial load from R3AS of the adapter object, but the table in CRM was empty.
I tried to debug the FM to map from R/3 to CRM, but I noticed that ti_bapimtcs is empty, so seems that no data is read from ECC.
Do anyone know why I cannot download table in CRM?
I'm missing something?
Thanks and Kind Regards,
Giacomo Migliorini
Here there is the solution I found to replicate table from ECC to CRM.
I wrote it here to let everyone know how to do it
Create a custom adapter object in tcode R3AC3 to download the two tables from ECC to CRM. The object class of the adapter object will be CUSTOMIZING.
The initial flow context will be from R/3 to CRM, and the consumer will be the one customized in the system.
Here will be set the tables to be downloaded from R/3, and in which tables they will be mapped.
We do need any filters, because we need to download all the data from the tables.
Leave empty.
Leave empty.
Here needs to be inserted a custom function module to map data from ECC to the table created in CRM.
This function module will be called after the download of information from ECC.
The ti_bapimtcs table will contain all the data downloaded from ECC. Using the loop we can look into all the data (segtype =’DA’ says that we are looking at data type into ti_bapimtcs table, which contain different types of data), and, using the two case we can differentiate the mapping structure for T001 and T001B tables.
After that we have to delete all the data from custom tables in CRM, and then update them with the new data downloaded from ECC.
Leave empty, since we do not have to send data from CRM to ECC.
Leave empty
After the creation of the adapter object, a standard report, SMOF_FILL_CRMATAB, needs to be executed.
It needs to be executed twice, one using as Source Site Name CRM, and then using OLTP, for the Objectname (adapter object) created in the steps above; an example can be seen in the screenshots below:
This report will update table CRMATAB in ECC; in this table there is one entry for every table we can take data using an adapter object; if we don’t execute this report, the CRMATAB will not be filled, and then will be impossible to retrieve data using an adapter object.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.