No data in SMOREPMA table even when the BW workbooks are visible

[Former Member]

Hi,

We’ve connected the CRM system and the BW system successfully. In BW System, the workbooks, queries and the users with respective roles have been assigned. Now using the transaction SMOBILEBW in CRM, we are able to view the workbooks and the queries.

The replication object REP_BOREPMA_WRTE, has been updated with relevant filters for queries and the workbooks. Before we moved to the mobile clients for the synchronization, I checked the table SMOREPMA table, and couldn’t find any information about these BW workbooks and queries. I understand that there should be 2 entries each, one for workbook and one for query, then it works successfully.

When will the data be updated to the table SMOREPMA? And how is it done? Automatically??

Are we missing anything here? Please help us.

Regards,

PG

Message was edited by:

PG

[Former Member]

Hi,

Our issue is resolved, now we see entries for queries in the table SMOREPMA. Actually, the queries which were assigned to the workbook were User-specific,so we requested data for each and every query in the work book separately, and got the data from BW system. After that we checked the table SMOREPMA, and found the entries for the queries aswell.

Thank you all for your help.

Regards,

PG

[Former Member]

Hi,

We've followed the instructions given at help.sap.com documentation.

http://help.sap.com/saphelp_crm50/helpdata/en/fc/c5154de9d611d3b2b50050da403d6a/frameset.htm

Finally, we're able to view the workbooks,queries and the roles assigned. And there are no entries for the Workbooks sent to CRM, in the CDB table SMOREPMA.

Also, it is no where mentioned in the documentation that the entries for workbooks and the queries, will be updated in the CDB table (SMOREPMA). When will this be updated? and how?

Please help us.

Regards,

PG

*********Helpful answers will be awarded points*********

[Former Member]

Hi Wolfhard,

There are no failures in SMOHQUEUE and no dumps. But there are few queues in SYSFAIL status which are related to R/3. No BW queues are seen here.

Regards,

PG.

[Former Member]

Hi,

any failures in Tx smohqueue or smq2 or even dumps in st22 available?

Regards,

Wolfhard