Skip to content

Get a List of all SAP users

This sample shows how to read the user names and address data of all users in the SAP system using the function module BAPI_HELPVALUES_GET.

Call BAPI_HELPVALUES_GET

The following sample code reads user names and address data of SAP users using uses selection parameters for the import Table (SELECTION_FOR_HELPVALUES) of BAPI_HELPVALUES_GET.

BAPI_HELPVALUES_GET
 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
static ArrayList getUserList(string sign, string option, string low, string high)
    { 

        // Set your ERPConnect license
        LIC.SetLic("xxxx");

        // Open the connection to SAP
        using var connection = new R3Connection(
            host: "server.acme.org",
            systemNumber: 00,
            userName: "user",
            password: "passwd",
            language: "EN",
            client: "001")
        {
            Protocol = ClientProtocol.NWRFC,
        };

        connection.Open();    

        RFCFunction func = connection.CreateFunction("BAPI_HELPVALUES_GET");

        func.Exports["OBJTYPE"].ParamValue = "USER";
        func.Exports["METHOD"].ParamValue = "GETDETAIL";
        func.Exports["PARAMETER"].ParamValue = "USERNAME";

        RFCStructure shlp = func.Exports["EXPLICIT_SHLP"].ToStructure();
        shlp["SHLPNAME"] = "USER_ADDR";
        shlp["SHLPTYPE"] = "SH";

        RFCStructure sfh = func.Tables["SELECTION_FOR_HELPVALUES"].AddRow(); ;
        sfh["SELECT_FLD"] = "MC_NAMELAS";
        sfh["SIGN"] = sign;
        sfh["OPTION"] = option;
        sfh["LOW"] = low;
        sfh["HIGH"] = high;

        func.Execute();

        connection.Close();

        ArrayList user = new ArrayList();
        for (int i = 0; i < func.Tables["HELPVALUES"].RowCount; i++)
            {
                user.Add(func.Tables["HELPVALUES"].Rows[i, 0]);
            }
        if (user.Count == 0)
            {
                user.Add("No results matching criteria");
            }               

        return user;                           
    }

Display Users

How to display all users, whose name start with M:

Display multiple users
1
2
3
4
5
6
7
8
9
static void Main(string[] args)
    {
        ArrayList users = getUserList("I","CP","M*","");
        foreach (object userdetail in users)
            {
                Console.WriteLine(userdetail);
            }
        Console.ReadLine();
    }