Users_Gen with upload from a flat file option

[Former Member]

Hi,

I have a couple of question on using the users_gen to upload the users in to the org structure from a flat file

1) Do I need to create the users in SU01 before using this option? I tried this but I am getting a error message saying the user already exists

2) If I load new users from this option, I can see the users getting integrated in to the org structure with a new position, CP and BP but without user tied to it. Is this normal and how can I tie the user to this.

3) I was using semicolan as delimiter and I could load only the first record whenever I ran this program, should I use any end of the line indicator??

Finally, I wanted to ask if there is any easier way of loading users in to the org structure. I really appreciate if someone can give a step by step procedure of loading the users with the flat file load option.

Thanks a lot,

Sreedhar

[Former Member · Accepted solution]

Hi,

ad 1. If you are using flat file you don't need to create these users in SU01.

ad 2. The users should be created and attached to org structure too.

In the org sructrure you must have something like this:

user:

Marcin Gajewski ID S 500000001

|_Marcin Gajewski ID BP 000000023

| |_Marcin Gajewski US MGAJEWSK

|_Marcin Gajewski US MGAJEWSK

If you don't have US, then click right mouse button on root user and choose Assign option.

Regards,

Marcin Gajewski

[Former Member · Accepted solution]

Marcin,

Thanks for your input, but I am facing two problems like I said when I load users from the flat file.

1) The user is not assigned to the position, CP and BP

2) The users_gen is only loading user from line 1, its not going to line 2, my input file is like this.

SRMTEST30;TEST30;50000382;SREEDHAR.DOGIPARTHY@EMAIL.COM;US;SRM;X;SAP_BBP_STAL_EMPLOYEE

SRMTEST31;TEST31;50000382;SREEDHAR.DOGIPARTHY@EMAIL.COM;US;SRM;;SAP_BBP_STAL_EMPLOYEE

SRMTEST32;TEST32;50000382;SREEDHAR.DOGIPARTHY@EMAIL.COM;US;SRM;;SAP_BBP_STAL_EMPLOYEE

Do you thing it is a problem that I am using the same email address for all the records, its not reading the second record??

Also, the first record is created in the org structure, but when I searched for that user in SU01, I couldnt find that user? any ideas?

Thanks,

Sreedhar

Message was edited by:

Sreedhar Dogiparthy

[Former Member]

Hi

Please read this ->

<u>Import Users from File or from Other System</u>

This transaction allows you to manage SRM users.

Notes:
To use SRM transactions, SU01 user accounts in the SAP System have to be assigned to business partners with the role Employee. Business partners contain the person data; Person data in the SU01 user account is not used in SRM. (Exception: The e-mail address in the SU01 user account is used to send the password.)

If SRM is installed as add-on of an ERP system with HCM in the same client, this transaction is deactivated.
In this case, use the HCM transaction to assign employees to user accounts.

Create
Transfer user and employee data from a template
Choose one of the following functions to create SRM users in your SRM System.

1. Upload Users from File
This function allows user data import from an ASCII file.
Prerequisites
The data fields for a user are in a row and are separated by a semicolon (;). These files can be created in MS Excel for example. (Excel files should be saved as CSV files). The order of the fields is critical.
Example
D030456;Le.Tissier;50000105;matthew.le.tissier@aaaaa.com;uk
C00213445;Benali;50000106;francis.benali@bbbbb.com;us
D23456;Pahars;50010203;marians.pahars@ccccc.com;dk
Note
In the menu under Goto -> Define Separator, you can determine whether a semicolon or a comma is to be accepted as separator.
If all the data in the file is not accessible, default values are used for the missing data. If the file contains an e-mail address, the system generates a password and sends it via e-mail to the user. If the file has no e-mail address, you are prompted to specify an initial password for all users.
You must specify the technical key for the fields Academic Title, Form of Address, Manager Indicator, Role, and Country.
You can find the system keys for the academic title in the field/column TITLE_KEY of table TSAD2.
You can find the system keys for the form of address in the field/column TITLE of table TSAD3T.
If the user is to be a manager, you check the field Manager Indicator with a large X.
If you are assigning a role for a user, the technical name of the role has to exist in the file.
You should check in advance in transaction PFCG if the role actually exists.
2. Import Users from Other System via RFC
This function allows you to import users from an SAP System via RFC.
Prerequisite
You have created an RFC destination in the SRM System and this refers to the SAP System from which you want to import the user data.
The system from which you wish to import the user data corresponds to Basis Release 4.5 or higher.
The users exist in the remote system in the transaction SU01.
Note
The default password is only used for those users that do not have an e-mail address. For those users that have an e-mail address, the system generates a password automatically and sends it to the users.
3. Create Users from Existing SU01 Users
This function uses the person data of SU01 users and generates business partners with the employee role. Additionally, a position is generated for the relevant department. You can select the users that you want to assign to an organizational unit.
Prerequisite
You have already created users in transaction SU01 and now require these as SRM users.
4. Import SRM Users from an LDAP Directory
Prerequisite
You have already created users in an LDAP directory and you now require these as SRM users.
Procedure
In the first step, you can create all users from an LDAP server in the SRM System. These are not initially integrated in the organizational structure. If you carry out this step in test mode, only those users are shown that have been transferred.
Appending the users into the organizational structure occurs in the second step. You must select a country and an organizational unit. Then you select the users that you wish to assign.
Assign User Accounts to Employees
Assignment of SU01 user accounts to business partners with the role Employer is necessary for SRM transactions. (Person data in the SU01 user account is not used in SRM). If employees with user accounts are to be able to execute SRM transactions, you have to create this linkage. To do this, use the function Assign employees to user accounts. The list of search results for SU01 user accounts shows accounts that are not assigned to a business partner with role employee You can correct this by selecting Assign Employee and choosing an appropriate SU01 user account using the search help.

Generate User and Employee Data
The users are generated generically by the system and filled with standard values. The user ID consists of an initial part and a sequential number.

Example
Leading initials = ABC, number part from 1 to 1000, length = 8.
The system generates users with the IDs ABC00001, ABC00002, ...., ABC01000.

Further Notes
Generation of users can take some time (you can generate roughly 20 users per minute.) The status line shows how many users have been generated.
Warning:
Once the users have been created you can only delete them individually.
You can only process internal SRM users with this transaction. You can not process vendor users with this transaction.
You should not assign more than 200 users to any organizational unit.

Consistency check
Check User and Employee Data
You can use this function to check the integration of SRM users in the organizational plan and check the data for consistency.

Export
Export User and Employee Data
You can use this function to save user data locally to your PC. The file (of type CSV, for example) contains data in the format specified above. (Data fields are separated by a semicolon.)

Correction
Delete User Accounts and Employees
You can undo your changes and delete existing data records using this function.

Do let me know, incase you face any issues.

Regards

- Atul