CRM BW Generic Datasource

[former_member572313]

Hi,

I have a generic datasource in CRM System, but I could not find any of the source (ie. View/Query/FM) via RSO2. But, when I checked in ROOSOURCE table, I could able to see extractor method as F1 and extractor as SMOX3_GET_DATA. I thought it might be created via BWA1 transaction, but when I'm trying to display it shows as " Datasource does not exist". I would like to know how the CRM generic datasource is getting created, do we have any specific transaction code in CRM to create generic datasource. Also, I would able to see the relevant selection and mapping functions in the table like SMOXHEAD_S, so, do we maintain the entries in the table for the custom DS manually. If we maintain manually, is it safe to promote the table entries to other systems?

thanks for your help in advance!

Regards,

Sathish

[RamanKorrapati]

Hi,

Any custom generic data source name will start with Y or Z only.

Can you name your data source?

Use RSA2 and get useful information.

Or at CRM side go to T c-de - RSA6,

double click on your data source and see.

You may find extractor or tables names.

Even try to debug your data source from CRM RSA3 with help of ABAP expert.

You may find all relevant/useful source information.

Thanks

[former_member572313]

Hi,

Thanks for your reply. My DS name starts with ZXX_XX_TRAN. I checked all the transaction codes like RSA2, RSO2, RSA6, BWA1, SBIW, RSA3. I could not able to find any of the source or the source is missing in RSO2, where as when I check the table ROOSOURCE, I could able to see the extractor method as F1 and extractor as SMOX3_GET_DATA. I knew that, it is FM based extractor. I would like to know how this data source being created/generated without using any transactions like RSO2 or BWA1.

I'm new to CRM based extractor.

Thanks

Sathish

[RamanKorrapati]

Hi,

As you said, your data source is function module based generic data source.

it might be created by using RSO2 by providing function module name there.

have you seen at RSA6?

You may find extract structure which been used at function module creation.

Go to RSO2, enter your data source name and click on display mode.

Go one you may find useful information on next screens.

SAme way try thru BWA1 also. use disply mode.

Thanks

[former_member572313]

Hi Ram,

Thanks!

I'm facing the similar problem

Here is the screen shot for your reference, I tried through RSO2 as well as BWA1, but when I'm debugging it hits the FM SMOX3_GET_DATA. I'm baffled how it would have been created.

Thanks

Sathish

[RamanKorrapati]

Hi Satish,

Seems like your data source may not be created properly.

Can you try to run at CRM Side RSA3 and see. whether it pulls data or not.

as my guess it won't pull data or it may throw an error.

Thanks

[former_member572313]

Hi Ram,

It pulls the data when I debug via RSA3 in CRM. FYI -  During 6 months ago, we upgraded our CRM system.

Thanks

Sathish

[RamanKorrapati]

Have you pulled data now? if yes then replicate data source into bw and activate it.

try to run info pack and check it.

[former_member572313]

Hi Ram,

Thanks for your help and reply. My requirement is not replicating/activating the datasource in BW. I would like to know how this Datasource being created or generated. I have  similar requirement to generate/create the Datasource for some other functional areas within CRM. Hence, I gather this information build new one.

Thanks

Sathish

[RamanKorrapati]

Creating custom data source is same in CRM or SD or PM systems.

We use T code - RSO2.

Based on type of generic we need to use tables/views/query or FM.

about generic data source creations you can get from Google help.

Lets try to create and check it.

While working if you got any error please let us know.

About Function module based you need to take abap expert help .

[former_member572313]

Hi Ram,

I don't think so, it might be created using transaction code RSO2. I looked at the custom datasource which has been created, it shows the generic delta based on numeric pointer. I think FM based on numeric pointer, will be possible through BC. I think there might be some other way in CRM, to create this custom datasource.

Thanks

Sathish

[Former Member]

Hi,

Do you have any idea, how to create custom CRM datasource based on BDOC? I want to copy the datasource 0CMS_RTCM_TRAN? I tried via BWA1, it doesn't support? Any other suggestions?

Thanks

Sathish

[KodandaPani_KV]

Hi,

creating the data source RSO2 either ECC or CRM data source.

while creating the data source use the table/view/FM.

but it is not possible to copy the 0CMS_RTCM_TRAN

0CMS_RTCM_TRAN this data source how it is getting the data to data source and find the tables then create the view.

-Phani.

[Former Member]

Hi Phani,

Thanks. that's my last option, if nothing works around, I'm thinking to go with that approach. However, I would like to understand what's the difference between 0CRM_SALES_ORDER_I and 0CMS_RTCM_TRAN. I could able to copy this datasource 0CRM_SALES_ORDER_I using BWA1, whereas 0CMS_RTCM_TRAN doesn't. I thought CRM data flows through BDOC's whereas ECC via IDOC's. I'm looking at this thread, having the same problem. I would like to how to find out the relevant steps.

Hi Sreekanth,

Thanks for the reply !

Could you please let us know the procedure to use CRM delta datsources. We are not able to get this Datasource in BWA1 Repository but can find in RSA2. We are able to get other Datasources like Opportunity in BWA1. Not sure how to proceed for this one. Please let us know.

Thanks,

Aparna