Generating Table Script 

Use

In this procedure you generate the table script and execute the script in the Mobile Client Console.

Procedure

Mobile client
Windows desktop	Start ® Programs ® SAP CRM Mobile ® Administration Tools ® Client Console
Navigation bar	Action ® Client Administration ® Table Script Generation

 

...

       1.      Find and select table CMBSCPSAP040 from the displayed list.

       2.      Mark the box for Log Table Scripts to a File, and enter a path and file name (for example, c:\temp\CMBSCPSAP040.txt) in the entry field next to it.

       3.      Generate the script by choosing the Generate button. The script will be placed in the file indicated in the previous step.

 

You must execute the script on your local database using the Microsoft SQL Server.

To launch the Microsoft SQL Server and open the Query Analyzer tool choose the following path:

Mobile client
Windows desktop	Start ® Programs ® Microsoft SQL Server 7.0 ® Query Analyzer

 

       4.      Log on to the database:
User: SA
Password: “ “ (blank)

       5.      Select the IDES database.

       6.      Copy the script from the text file you created (CMBSCPSAP040.txt) and paste it into the Query Analyzer tool.

       7.      Execute the script.

       8.      Repeat this procedure for other A-tables.