Getting Error when Maintaining BWA1 Message No. SMOX3106
When maintaining BWA1, sometimes you may get the pop-up below:
If you click “Check” (F9), you may see the line with the error message. Double click on the line, you can see the error details like below:
0CRM_COMPLAINTS_I: Fld WARRANTY: Dif. selection indicators in ROOSFIELD (A) and SMOXRELP ()
Message No. SMOX3106
The information that that a field of the extract structure could be selected by or is hidden from BW is stored in both tables: SMOXRELP and ROOSFIELD. And this error occurs if these two tables have different informations.
This could be due to a manually change in one of the tables. (Normally the maintainance of these tables is done by the transaction BWA1 automatically.)
- To correct this problem, you can either repair it manually by changing the value in the table that is wrong.
- Or you let BWA1 do it for you: Edit the DataSource, change the shown value to the wright one (if necessary) and save it.
This is because the field maintained in BWA1 mapping is marked as ‘A’ in Extraction Structure.
Actually there is nothing to be done as this error will not cause any missing data during the extraction process. You could ignore this error and click “Yes” when the pop-up appears. But if you want to remove this error message, there are 2 ways:
1. Remove the field that causes this error in BWA1 mapping.
2. The table containing related parameter is ROOSFIELD. This table is by default not changeable. So a report needs to be written to make change to this parameter. Once parameter ‘A’ is removed, the error will disappear.
2355800 – Fields in CRM Datasource cannot be seen in BW