on 2007 Dec 21 5:18 PM
hello,
I want to import data from 50.000 bank branches in a user table directly from sql, what kind of query can i use? There is another method? i use sql server express edition....thanks
Do you mean user table here is the table created directly in in the SAP B1 database server ? is the prefix name of table @ ? Or the user table is a table created from manage user field --> user table ? if yes,
DTW can't upload the data to that table. You must use DTS of SQL server management studio. You prepare the excel template and use the DTS to upload it to the table.
Rgds,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Is the User table created from SAP. If so, I would suggest you to use DTW.
Prepare an Excel similar to the DTW template with 2 rows of the same data.
Name the columns the same as in User Table.
If you user table is defined as no object then you would need to include code and name column in your DTW. Remember Code and Name are primary key columns and have to be Unique.
Example of Excel template
Code........Name........U_Field1............U_Field2........
Code........Name........U_Field1............U_Field2........
Suda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
103 | |
6 | |
6 | |
6 | |
5 | |
5 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.