Skip to Content
author's profile photo Former Member
Former Member

CRM BW extraction problem.......?

Hi Gurus.....,

when i am trying to check the status of the datasource i got the following error in <b>BWA1</b>.

i check both tables.., i didn't get what can i do there..., please let me know if any one knows it...


0CRM_QUOTA_ORDER_I: Fld PATH_GUID: 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.


in this how can we find out the wright value...,

expecting from ur help in this regards experts....,



Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2005 at 05:09 AM



    Inconsistency in the assignment of the info-object for the Territory extraction in One order datasources

    If the one order Infosources are activated then the mapping of the Datasource fields TERR_GUID and PATH_GUID are assigned to the same infoobject 0CRM_TR. Therefore, activation of the infosource causes an error.

    Other terms

    Sales Analytics, Service Analytics, One order data Extraction, Territory extraction

    Reason and Prerequisites

    PATH_GUID field of the Datasource is not marked as field hidden in BW


    Please note that this correction is available from the following CRM Releases

    CRM 4.0 SP08

    The correction is relevant for the following datasources















    In order to have this functionality available, please re-activate the datasource in the OLTP (CRM system) and replicate the datasource in the BW systems

    The correction is the following:

    The Datasource had the fields Territory Guid and Path Guid. The path guid should be marked as Field hidden in BW.

    Or in other words in the datasource maintenance in the transaction BWA1, for the extract structure tab, the field PATH_GUID should have the value for Selection as 'A'.

    If you still have any problems, do let me know.



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      Is there any custom fields?

      If Yes, then You need to map the new custom fields in txn BWA1 so that the bdoc is extended properly.

      If you go to the mapping tab in BWA1 and then use the 'check' icon..

      the application should show you a list of your new fields with a yellow

      light indicating that you need to map them. You must update table

      SMOXRELP to get the new fields to show on the extract structure tab

      in transaction BWA1.



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.