Ansicht
Dokumentation

RSLAW_IMPORT_EXTERNAL_DATA - Report RSLAW_IMPORT_EXTERNAL_DATA

TXBHW - Original Tax Base Amount in Local Currency   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Purpose

SAP systems can be used directly by SAP users or indirectly via user interfaces. The latter is the case, for example, if a general user is used for dialog-free communication between systems (for RFC or CPIC users in different applications).

This allows you to use the License Administration Workbench (LAW) as a central audit system for non-SAP systems that access an SAP system.

The SAP systems and the central LAW system exchange data for license audit in a certain format, the SID file. This report converts a defined simple data format into the specific SID format and then imports the data into the LAW.

The customer must provide the raw data for this report in a CSV file. A CSV file is a text file that contains data structured as a table and is primarily used for data exchange. The abbreviation CSV stands for Character Separated Values or Comma Separated Values, as the individual values are separated by a special separator, often by a comma. There is no official standard for the file format.

The reporter anticipates a tab stop as a separator.

The lines have the following formats:

User name (CHAR12) *

User type (CHAR2)

E-mail address (CHAR241)

First name (CHAR30)

Last name (CHAR30)

Last logon date (YYYYMMDD)

Creation date (YYYYMMDD)

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)

The different fields must be separated by a tab stop. The field marked with an asterisk (*) is a required entry field. If no entry has been made here, or the entry is not correct, the system will post an error message. This also applies if you enter an incorrect date. If you leave 'User type' field blank, it will be filled with a default value when the report is run. You must enter this default value on the report's selection screen. All other fields are optional and can be replaced by a tab stop. Naturally though, a value must always be entered in fields that are intended for subsequent grouping of users.

The name-value pairs at the end of the list are personalization data, which is available to the customer for additional information (and can also be used for grouping).

If you create the file with Microsoft Excel, you must ensure that you use the correct date format. You might have to define your own format.

Integration

The report is integrated into transaction LICENSE_ADMIN (SLAW). You can start it by choosing Measurement Data -> Import Data -> From External System.

Prerequisites

Features

A correct system measurement file must contain the following data. As they are constant, they are added automatically.

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 *

A system ID that does not yet exist (common in SAP systems)

Unique system number *

A number between 1 and 999 that forms a unique SAP system number. Unlike in real SAP systems, the "number" is made up internally of the constant prefix "EXITSYSTEMS" and a 3-figure number. This prefix subsequently allows these systems to be recognized as non-SAP systems.

Description *

Brief description for the external system

Measurement date

Measurement time

Name of the user who performed the measurement

Standard user type *

This user type is used if no user type has been specified in the user data.

Price list selection*

Selection of the price list(s) used in the company.

Excluded user types

These can be used to explicitly exclude certain user types. If these types are contained in the user data, the system will post an error message.

Path specification of the upload file

Fields marked with an asterisk (*) are required entry fields. Input help is provided to ensure that you enter a correct date, time, user type and the exact path specification. The system also checks whether the user type and the selected pricelist(s) match.

Standard Variants

Output

You can display the result, the table generated in SID format. The result is imported to the LAW using a function module (either directly or into the Inbox).

Activities

Example

Example CSV file

Display with a header line that must not be included in the file.

BNAME,,BTYP,,EMAIL,,,,,,VNAME,,NNAME,,LLOGIN,,ADATUM,,KOSTST,,TELNR

DE52631,,72,,john.normal@company.com,,Vanessa,,Sample,,20040101,,20020303,,PERS05,,4711

MESMITH,,52,,,,,,,,,,Mark Edward,,Smith,,20040808,,20010101,,,,,,PERS03,,4812

RFUMSV00 - Advance Return for Tax on Sales/Purchases   ROGBILLS - Synchronize billing plans  
This documentation is copyright by SAP AG.

Length: 5759 Date: 20240520 Time: 102121     sap01-206 ( 101 ms )