Troubleshooting tool for generation of ECC condition tables in CRM
The most important note in condition transfer area, SAP Note 514952, contains the steps that must be performed in order to generate in CRM the condition tables from ECC. As members of SAP CRM Product Support team, we have helped our customers in issues related to condition tables for several years and we have noticed that many of the problems in condition table generation are related to missing or incorrect steps while implementing that note. That is the reason why we decided to create a report for automatic troubleshooting of the steps in the note. The coding of the report, along with some related explanations, is in KBA:
The report takes approximately 20 minutes to be implemented, but this small effort should pay off if you have to generate many condition tables, as it usually happens .You need to create a report in CRM system with a few selection texts and a function module in your ECC system that will collect the information related to the condition table fields. Then you can trigger the report from the CRM system indicating the ECC condition table name and the RFC destination of the ECC system from which you want to transfer the data.
You will get the results with traffic lights indicating whether the mapping has been correctly implemented for each of the fields.
There is a particular case that is not covered by the tool. The report checks if the field mapping settings for the selected ECC condition table have been correctly performed, but it does not analyze whether the condition table has been already generated or not. What happens if the condition table was already generated but you have changed the fields in the ECC condition table, or changed the data elements of any of its fields? In that case, if the steps in note 514952 have been correctly implemented considering the field changes in ECC, the report would show green lights for all the fields. However, as the condition table had been previously generated in CRM with the old fields, this is preventing the new table to be created. The solution for these cases is the deletion of the old condition table in CRM and the steps that must be performed are documented in KBA:
A particular case, where the data element must be changed for a field is also documented in blog:
The process for the deletion of a condition table might be tricky and this blog contains many screenshots to make it easier to understand. In the example taken for that blog, the old condition table does not contain condition records, it is still empty. If your old condition table contains condition records, you should also check the mentioned KBA 2028581.
We hope the new tool can be useful for you. Any feedback in the KBA of the tool, 2211042 , or in this blog is welcome.
José Ignacio Martin & Luis Rivera Gallego