Welcome to Burgess's blog

Sales organization, distribution channel and division together are called sales area.
It means certain sales organization can operate certain division through certain distribution
channel.  Here, I will show how to set up sales area.

Step1:  Enterprise Structure--->Assignment--->Sales and Distribution
            --->Set up sales area--->click 'Clock' icon
          

Step2:  select sales organization, and then click 'Assign'
          

Step3:  select Distribution Channels, and then Enter.
            

Step4:  select distribution channel, and then click 'Assign'
          

Step5:  select Division, and then Enter
                     

Step6:  save it
                    
          

Here, I will show how to create your favorites,the below picture is an example:

1  Inserting an Item from the SAP Standard or User Menu:
1> You can use drag and drop
2>use the menu bar:
Choose an item, and then Favorites-->Add


2  Inserting a Web Address or a File
1>Right-Click Favorites, and then choose Add other objects:

choose Web address or file:

input information required:

2>use the menu bar

3  Inserting a Transaction

Here,I introduce some methods to import data from excel to DB,

1  By OPENDATASOURCE

SELECT * FROM OPENDATASOURCE(
    'Microsoft.Jet.OLEDB.4.0',
    'Excel 8.0;DataBase=D:\TEST.xls')...[sheet1$]

Note: Sometimes, error message will occor when executing above script like this:
Msg 15281, Level 16, State 1, Line 1
SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'Ad Hoc Distributed Queries' by using sp_configure. For more information about enabling 'Ad Hoc Distributed Queries', see "Surface Area Configuration" in SQL Server Books Online.

The solution issetting Ad Hoc Distributed Queries to 1,you can refer to my post: http://www.cnblogs.com/Burgess/archive/2008/09/24/1298195.html

2   By Linked server

EXEC sp_addlinkedserver  --add linked server
    @server = N'MyExcel',
    @srvproduct = N'Jet 4.0',
    @provider = N'Microsoft.Jet.OLEDB.4.0',
    @datasrc = N'd:\TEST.xls',
    @provstr = N'Excel 8.0'
GO

Note:You can also add linked server by below method:

exec sp_addlinkedsrvlogin 'MyExcel','false' --login without account (Optional)
go

select * from MyExcel...sheet1$  --query data
go

 3  By VBA

Code
 1Private Sub cmdInsert_Click()Sub cmdInsert_Click()
 2
 3    Dim LinCnt As Integer
 4    LinCnt = 6
 5    If InputBox("Please input password1", "口令输入框", , 8700, 4700) = "password" Then
 6        Rows("6:6").Select
 7        Rows("6:65536").Select
 8        Range("A6").Select
 9        
10        Connection.Open " Provider=SQLOLEDB.1;Persist Security Info=True;User ID=User_id;Password=PWD; Initial Catalog=DB_name;Data Source=Server_ip;Connect Timeout=60 "
11        Connection.CursorLocation = adUseClient
12        CMD.ActiveConnection = Connection
13
14        Do While Cells(LinCnt, "C") <> ""
15            If txtSoldto.Text = "" And txtQcimat.Text = "" And Cells(LinCnt, "G") = "" Then
16                MsgBox "Please maintain "
17                Exit Sub
18            Else
19                SQLstmt = " insert into table_name values('" & VBA.Trim(txt1.Text) & "','" & VBA.Trim(txt2.Text) & "','" & Cells(LinCnt, "C") & "','" & Cells(LinCnt, "D") & "','" & Cells(LinCnt, "E") & "','" & Cells(LinCnt, "F") & "','" & Cells(LinCnt, "G") & "','" & Cells(LinCnt, "H") & "','" & Cells(LinCnt, "I") & "','" & Cells(LinCnt, "J") & "') "
20                CMD.CommandText = SQLstmt
21                CMD.Execute
22                LinCnt = LinCnt + 1
23            End If
24        Loop
25        Connection.Close
26        Exit Sub
27    Else
28        MsgBox "You have no right to insert!"
29        Exit Sub
30    End If
31End Sub

 4   By SQL Server Import and Export Wizard
Detailed oprating steps is abbreviated here.

5  Other methods:
Please refer to http://support.microsoft.com/default.aspx/kb/321686

sp_configure is an useful SP, and we can display or change global configuration settings for the current server with it.

By default, you can't display advanced options when executing sp_configure. To show them, you must set show advanced option to 1 firsrt by executing below script: