Loading System Data for a Non-SAP System from a File

Prerequisites

The CSV file is a text file that contains data structured as a table and primarily used for data exchange. The individual values are separated by a special separator (in this case, a tab). There is no official standard for the file format.

The individual fields of the CSV file have the following format and must be separated by a tab:

  • User name (CHAR12): Required field that must be correctly filled. If it is empty or incorrectly filled, you receive an error message.

  • User type (CHAR2): If this field is empty, the report fills it with a default value, which you need to enter using the selection screen of the report.

  • E-mail address (CHAR241)

  • First name (CHAR30)

  • Last name (CHAR30)

  • Last logon date (YYYYMMDD): If you enter an incorrect date, you receive an error message.

  • Creation date (YYYYMMDD): If you enter an incorrect date, you receive an error message.

  • Cost center (CHAR8)

  • Telephone number (CHAR16)

  • Name 1 (CHAR20)

  • Value 1 (CHAR128)

  • Name 2 (CHAR20)

  • Value 2 (CHAR128)

  • Name 3 (CHAR20)

  • Value 3 (CHAR128)

  • Name 4 (CHAR20)

  • Value 4 (CHAR128)

  • Name 5 (CHAR20)

  • Value 5 (CHAR128)

All fields other than the user name field are optional and can be replaced by a tab, unless the values are required later for grouping users. The name-value pairs at the end of the list are personalization data, which is available to you for additional information (which you can also use for grouping). Missing user types are filled with a default value when the report is run. You must enter this default value on the report's selection screen.

A correct system measurement file also contains the following data, which is automatically added, since it is constant.

  • Name: Value

  • Hardware key X0000000000

  • Installation number EXTSYSTEMS

  • System status PROD

  • Client 000

  • Category of the client P

  • Release Current system release

  • Selection

  • System ID *

  • Unique system number *

  • Description *

  • Date of the measurement (DDMMYYYY)

  • Time of the measurement (HHMMSS)

  • Name of the user who performed the measurement

  • Default user type *

  • User types not permitted

  • Pricelist selection

  • Path specification of the upload file

Fields marked with an asterisk (*) are required entry fields. Input help is available to ensure the specification of a correct data and a correct time, the entry of the user type, and the exact path specification. The system also checks whether the user type and the selected pricelist(s) match. You can also exclude user types from use.

Context

If you have non-SAP systems in your system landscape from which the users use the SAP system indirectly through interfaces (for example, with an RFC user), you can also use the LAW as the central measurement system for these systems. To do this, collect the data required by the LAW in a Character Separated Values file (CSV file, see Prerequisites). As of SAP NetWeaver 6.40, use report RSLAW_IMPORT_EXTERNAL_DATA to convert into a SID file that can be read by the LAW and then automatically load it into the LAW. For releases 4.6C and SAP Web AS 6.20, the report RSLAW_CONVERT_EXTERNAL_DATA is available by Support Package. This report generates a SID file. You can then load the file into the LAW by choosing Start of the navigation pathMeasurement Data Next navigation step Import Data Next navigation step From an External SystemEnd of the navigation path.

Procedure


  1. To convert the CSV file and to import the generated SID file into the LAW, choose the following path in transaction LICENSE_ADMIN (SLAW): Start of the navigation pathMeasurement Data Next navigation step Import Data Next navigation step From External SystemEnd of the navigation path.

  2. Enter the necessary data.

  3. Select the relevant pricelists.

  4. To display the generated table, select this option.

Results

You can optionally display the table generated in SID format. The data is then automatically transferred to the LAW (either directly or into the Inbox). If the CSV file contains errors, a detailed error log appears. In this case, the transfer does not take place.