cancel
Showing results for 
Search instead for 
Did you mean: 

0CRM_QUOTATION_I - extracts 0 records

Former Member
0 Kudos

Dear SAP consultants,

we want to use standard CRM extractor 0CRM_QUOTATION_I in our scenario, but it is extracting 0 records, when tested in RSA3. There shouldn't be any problem with authorizations (SAP_ALL). Also respective tables seems to contain appropriate data.

I also checked this datasource in BWA1, selections and it seems to be ok. Our CRM system is 700, level 008.

Thanks and regards,

Peter

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi Venkatesh,

I am not aware of any enhancements to this datasource. And the data are in respective tables, even in ST05 I can see what is being read, which selections, etc. I see GUIDs selected.

Only at the end, the extractor returns 0 records. I will probably have to debug the extractor line by line and see where is the problem, although there are many FM's used and after several steps you are lost..

Regards,

Peter

Former Member
0 Kudos

Hi Peter,

it seems Quotation data is not capturing in the table level, get an idea from functional consultants wether the Quotations are successfully posting or not, it seems to be an error in quotation config .

Also check any enhancements have done for the DataSource if so check the Logic.

Regards,

Satya

Former Member
0 Kudos

I think we are close

I started the trace in ST05, everything seems to be ok. At the end, table ROIS is read, SELECT WHERE "ISOURCE" = '0CRM_QUOTATION_I'.

But this table contains entries only for Opportunities and Activities, not Quotations. I don't know if this is the reason, but could be. What do you think? And what is this table about?

Peter

Former Member
0 Kudos

Hi

This seems to be the problem, have you did any enhancements to this data source.

try to check once you have records for quotations in tables.

you can check the data source structure in below link

http://help.sap.com/saphelp_tm80/helpdata/en/61/ef451f577111d6b21500508b5d5211/frameset.htm

Regards,

Venkatesh

Former Member
0 Kudos

Hello Satya,

what you mean by "check with the mapping function module"? It is true, that I didn't perform any mapping or anything like that, but I suppose that when it is business content datasource, it is mapped already, at least some "basic" fields..

Regards,

Peter

Former Member
0 Kudos

Is it true ?

Every data source has mapping Function module you can check that with tracing option .

If that FM is active then it suppose to get the data from DB .

Regards,

Satya

Former Member
0 Kudos

Hi there,

Thanks for the replies. I checked RSA3 again and went to debug mode, according to what I saw, tables CRMD_ORDER_INDEX INNER JOIN CRMD_ORDERADM_H are read and there have been values selected.

So, appropriate data exist in the system, according to mapping and selections in BWA1, but still - 0 records extracted. There must be something wrong..

Peter

Former Member
0 Kudos

Hi,

According to you database table has the data but data is not able to extracting the data,

Check with the Mapping Function module whether it is working or not if still problem persist i think better to contact SAP .

Regards,

Satya

Former Member
0 Kudos

Hi,

Check the Quotation data in tables, if the data is available then use the debug mode to find the issue.

link to find the table for Quotation .

http://help.sap.com/saphelp_dm40/helpdata/en/61/ef4515577111d6b21500508b5d5211/content.htm

Regards,

Satya

Former Member
0 Kudos

hi,

u can check the CRM tables related to that data source for the data availablity & find the Object transaction available in table & BWA1 also.

if not then u have to maintain that in BWA1 & then execute the RSA3.

thanks