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

Enhancing CRM datasources via BWA1

Hi,

I'm currently on a BW project based on CRM data. I have noticed that there is a lot of confusion everywhere about enhancing standard CRM extractors. Before I get any comments: I went through CR900 course and BW350 course where CRM extraction is clarified but as usual these manuals don't go deep enough. I also read this forum where some usefull things were said but none of them cover all my questions.

Questions :

1) In transaction code BWA1 you can see all extract structure fields for a datasource and a mapping to a segment and fieldname. What do these segment table and fields exactly mean ? Where do they come from ? They seem to be related somehow to the BDOCS but the names of these segments and segment fields are not identical to the ones you can see for transaction code SBDM.

2) How can I easily check which field is located in which segment for e.g. activities compared to the transaction screen ? We have a list of fields to be added but some of them are for sure in a certain segment so that would save a lot of time. Going through manually is a little bit stupid I guess...

3) After adding a new field that is available in an existing segment/field, will the content of this field be automatically available or do you need to adapt the mapping module (function) as well.(or fill it in the user-exit).

4) I have noticed that the R/3 user-exits still work (ZXRSAU01) but you now also have a Badi for mBdoc en SBdoc (CRM_BWA_SFLOW and CRM_BWA_MFLOW). What is the difference between the classical user-exit and these BADI's in case you use a BW Adaptor datasource ? In none of them you seem to be able to access the Bdoc/segments directly. So it seems these should be used if you need data from an external table but what is the difference ? I don't see an added value in the BADI's compared to ZXRSAU01...

5) Currently I feel like copying the BW adaptor relevant business content datasource to a Z-datasource and write all my new fields code in the mapping function module (copied from the standard one). This way I can access all segments tables/fields and I don't need any user-exits/Badi's at first sight. Does anyone see problems/objections with this approach ?

Thanks for feedback !!!!

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 20, 2006 at 04:29 AM

    hi doubleU can you please eMail me the CR900 document. eMail premkatragadda@yahoo.com

    thanks in advance...

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 02, 2005 at 02:29 PM

    Double U,

    I have just enhanced the extractor for complaints in CRM.

    I basically did the following:

    1. Enhance extract structure - select the datasource in RSA6 and click "Enhance Extraction Structure'. Create the append structure containing the extra fields you wish to send to BW.

    2. Function enhancement - select the datasource in RSA6 and click "Function Enhancement". Create a project (ZBW). Display the enhancments and assign RSAP0001. Click the "Components" button and modify function exit "EXIT_SAPRLSAP_001" to get your additional data from the business object.

    3. Replicate the datasource to BW.

    4. At this point I created my own InfoObject Catalog and InfoObjects for the additional data. You may wish to use existing ones.

    5. I then created my own ODS object and created the update and transfer rules.

    Hope this helps. The BW course TABW30 provides some details on how to do this.

    I did not need to modify any BDocs to do this.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Stuart,

      Thanks for your feedback. That is what I call the classical user-exit approach (ZXRSAU01) but for BW Adapter datasources via BWA1 you seem to be able to select additional fields from segments which is a lot easier then programming all the logic yourself (meaning that you have to known the tables and the relations). Furthermore the approach you mention is not always delta capable, meaning that in case the added fields change no delta is triggered.

      So I hope someone can answer the questions based on experience with BWA1. I'm really looking for further clarification on this.

  • Posted on Nov 02, 2005 at 02:56 PM

    Double U,

    You can only enhance the extractor in SE11 or RSA6. You cannot do it in BWA1. As you state, you would need to copy the standard extractor to a "Z" and create your own function modules etc.

    However, what's the point of creating your own extraction and mapping function modules when you can simply use the user exit and avoid any complications with BDocs?

    As far as I remember, all business documents in CRM use the same "one order" BDoc anyway, and that is the one you are seeing in BWA1 under the mapping tab.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Double U,

      I know this is very late response to your thread. I am also doing some kind of research on BWA1. Like attaching segment and segment fields to enhanced fields. I hope you might have got good idea on this by this time. Can you please help me on this. If you have any documents please email me to nz_raj@yahoo.com.

      Thanks

      RKR

  • Posted on Dec 13, 2005 at 09:52 AM

    Hi!

    you can see the message structure of the BDOC in SBDM open the BDOC Ex:-<b>BUS_TRANSACTION_MESSAGE</b> and click on the header and in the side window you can see the <b>"general Data"-"Related Data Type"</b> <i><b>BAD_BUS_TRANSN_MESSAGE</b> </i>.

    double click this and it will take you to its structure... where you see all the segments that are seen in the BWA1. and for if you click any of the segment for example <b>ACTIVITY_I</b> you can see the ITem type <b>BAD_ACTIVITY_I_MESS</b> and then double click it and it will show you the fields present in this segment.

    hope it helps.

    with regards

    ashwin<i></i><i></i><i></i>

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Ashwin,

      The whole thing is not making any sense to me.

      I went to tran SBDM and open the BDOC BUS_TRANSACTION_MESSAGE, and then expanded. The following is what I got

      BUS_TRANSACTION_MESSAGE

      --> BUS_TRANS_MSG_HEADER

      -->BUS_TRANS_MSG_ACTIVITY

      -->BUS_TRANS_MSG_STATUS

      -->BUS_TRANS_MSG_ORGMAN

      -->BUS_TRANS_MSG_PARTNER

      I didn;t find the "in the side window you can see the "general Data"-"Related Data Type" BAD_BUS_TRANSN_MESSAGE" after clicking on the header as you suggested.

      In the side , right hand side window I have the four tab

      "Segment Overview", "Mapping","Joins" and "Segment field"

      And I didn't find the bwa1 segment in there as you suggested.

      Any help or clarification? A detail document or steps with explanation would really help.

      Thanks

      Arunava

  • author's profile photo Former Member
    Former Member
    Posted on Mar 16, 2007 at 03:05 PM

    Hello Double U

    May I kindly ask you to send me docs CR900. My address is j.bukvaj@gmail.com

    Thanks in advance.

    Best regards

    Juraj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 07, 2007 at 05:47 PM

    Hi Double U,

    I have exactly the same questions you have as below and I have been trying to find answers to it.

    I have few CRM datasources which I am using and the all was in my Dev box.

    I have enhanced a leads and opportunities datasources and used the classical user exit in ZXRSAU01 to populate the data and it worked fine. Do I have to do anything on BWA1? Do I have to use BADIs.

    My problems started when I have transported these datasources to Quality system. My datasources donot have the Active checkbox indicator in BWA5 and I cannot see these datasources in BWA5 in Quality there by cannot load the data.

    However one datasource for Orders works fine in Dev and Quality as well.

    Could you please help me in resolving this issue.

    Thanks and best regards,

    KK

    Add a comment
    10|10000 characters needed characters exceeded

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.