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

New column table not downloaded on ides database

Hi experts,

I'm working with SAP CRM Mobile Sales 7.0 SP04.

I'm facing the following issue: every time I add a new column to a table, and the related segment fields to the sBdoc, I cannot see the new column on the local ides database. These are the steps I performe:

- Add the new column on CDB

- Activete the table

- Add the segment Field to the bdoc

- Activate and generate the Bdoc

- generate the XML bdoc from tx GNRWB

- generate locally the Bdoc and the table with client console

- generate the BO that has the Bdoc

Executing a query with SQL on the table I cannot see the new column.

The only solution is to drop the table and then generate it again with client console.

This is a problem in case of MUP client. The tableIndexScrpt is not enough to apply the table changes and we cannot drop every time the table on the client tablet...

Does anyone have any suggestions?

Thanks in advance,

Laura

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Oct 27, 2010 at 02:54 PM

    Hello Laura,

    Are there any custom statitics on this particular table? The below query would help you to find this out :

    SELECT object_name(s.object_id) object_name, s.name AS statistics_name,

    c.name AS column_name

    ,sc.stats_column_id

    FROM sys.stats AS s

    INNER JOIN sys.stats_columns AS sc

    ON s.object_id = sc.object_id AND s.stats_id = sc.stats_id

    INNER JOIN sys.columns AS c

    ON sc.object_id = c.object_id AND c.column_id = sc.column_id

    WHERE c.name = 'TIMESTAMP'

    and s.user_created = 1 --finds Custom statistics specifically created by user

    Thanks,

    Rohit

    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.