Data ABAP systems

Access through: Administration > Data > ABAP systems

The ABAP systems folder has all functions to load and manage data from connected ABAP data sources.

Load data from ABAP systems

Load data from ABAP systems

Access through: Administration > Data > ABAP systems > Load data from ABAP systems

The Load data from ABAP systems report loads data from connected ABAP data sources into Snow Optimizer for SAP^® Software.

Description

This report allows you to load ABAP data from the selected satellite systems to the master system via an RFC connection to make the data available in Snow Optimizer for SAP^® Software reports. You can load the following periodic and non-periodic data types:

Non-periodic data

• System data

• System measurement data

• Roles and authorizations

• Transaction codes

• Professional user/Limited professional user table activities

• HR data

• Business functions

• Add-on data

• RFC destinations

• User master data

• Digital Access measurement data

Periodic data

• CCMS statistics data

• Change document data

• Digital Access estimation data

• IDocs

• Batch input data

note

To have up-to-date data in Snow Optimizer for SAP^® Software, you should load user master data and periodic data on a regular basis, preferably once a month.

tip

Use the Job swarms for loading data from ABAP systems report to automate the parallel processing of data load jobs.

Selection criteria

In addition to the standard selections, the selection screen of the report has the following selections:

Options for non-periodic data types

You can select the non-periodic data types to load.

note

• You can select Only roles to avoid a possible short dump due to insufficient memory when loading full roles and authorization data.

• To use the Only license-relevant users option in Snow Optimizer for SAP^® Software reports, you must activate Roles and authorizations and USMM license type systematic when loading data.

• You can set the Only dialog users and Only current valid users checkboxes to be preselected and uneditable in Data load ABAP.

If you select Digital Access measurement, optionally enter the start date of the measurement.

note

• To measure Digital Documents, support packages including SAP Passport must be installed on the systems.

• Digital Documents can only be measured from the point in time when SAP Passport is installed on the systems. It is impossible to measure Digital Documents that were created before this time.

• When Digital Access measurement data is reloaded, only the delta of the data is loaded. To load all existing Digital Access measurement data, select Refresh data.

Options for periodic data types

You can select the periodic data types to load.

If Load CCMS statistics data remains selected, you can select the task type and deselect Load module information and Load external accesses if not required.

note

You can define defaults for loading periodic data in Periodic data.

Options for processing

You can select the USMM license type systematic to load.

note

• USMM license type systematic is only selectable if you select User master data.

• To use the Only license-relevant users option in Snow Optimizer for SAP^® Software reports, you must activate Roles and authorizations and USMM license type systematic when loading data.

• You can set USMM license type systematic to be preselected and uneditable in Data load ABAP.

• There is a report that applies or removes the USMM license type systematic to the loaded user master data only after the data is loaded.

You can execute this report in the background.

Result

A pop-up shows information about the number of successfully loaded data sources, failed data sources, and inactive data sources. If there are errors, select Error details to show details.

The result shows the load protocol for each data source with the data types and the number of loaded records per data type. If applicable, the data is broken down by period.

Job swarms for loading data from ABAP systems

Job swarms for loading data from ABAP systems

Access through: Administration > Data > ABAP systems > Job swarms for loading data from ABAP systems

Job swarms automate the parallel processing of data load jobs. They are an efficient and fail-safe alternative to manual processing or planning jobs with the Load data from ABAP systems report.

When job swarms are executed, the selected ABAP data sources are divided into individual jobs, one job for each ABAP data source. All jobs can be processed in parallel, thus reducing the runtime of the entire data load process. This procedure can speed up the data load process by a factor equal to the number of available batch processes within an SAP system.

Jobs for different clients on the same satellite systems are automatically distributed evenly across the job swarm to minimize the total runtime and peak loads on the satellite systems.

Technical problems with a single job do not cause all jobs in a job swarm to fail. In each job swarm, a control job is included in the data load job and is automatically released when the associated data load job successfully completes or fails. This procedure ensures that all data-load jobs are included in the protocol. The last control job executed in a job swarm takes over all logging and triggers a mail protocol that can be sent to selected recipients.

Start job swarm

Access through: Administration > Data > ABAP systems > Job swarms for loading data from ABAP systems > Start job swarm

The Start job swarm report allows you to create job swarms to load data from selected ABAP data sources.

The selection screen is the same as the selection screen of the Load data from ABAP systems report, only job classes are added to the selection. Job class C for load jobs and job class B for control jobs are selected by default

note

To have up-to-date data in Snow Optimizer for SAP^® Software, you should schedule this report in batch, preferably once a month.

Monitor and protocol job swarm

Access through: Administration > Data > ABAP systems > Job swarms for loading data from ABAP systems > Monitor and protocol

In Monitor and protocol, you can show the current data load processes and review the data load protocols of job swarms.

A table shows an entry per job swarm with the following information:

• Job swarm ID

• Total number of jobs

• Successfully completed jobs

• Running jobs

• Jobs with errors

• Estimated percentage of processed jobs

• Inactive jobs

• Start date and time

• User who started the job swarm

• Do one of the following:

  • To show details of a job swarm entry, select a row and select .

    1. To show the data load protocol, select a row and select .

  • To delete a job swarm entry, select a row and select .

    note

    You can delete job swarm entries even if the job swarm is not completed. If you delete an entry, the data load jobs will continue, but the protocol email will not be sent.

Data administration ABAP systems

Data administration ABAP systems

Access through: Administration > Data > ABAP systems > Data administration ABAP systems

The Data administration ABAP systems feature allows you to manage loaded data of connected ABAP data sources.

Description

Tabs for non-periodic data and single periodic data types show icons for the data status for each connected ABAP data source. When you select an icon, a pop-up shows the data source and category, and when and by whom the data was last loaded. If you select an empty field, a pop-up only shows the data source and category. Depending on the data type, the pop-ups offer options for loading and deleting data. For non-periodic data, you can define warning thresholds that specify the time when the data becomes outdated.

Data status

Non-periodic data

Icon	Description
	The data is loaded completely.
	The data is outdated based on the warning threshold.
	The data is not available due to the system type or version.
None	No data is loaded.

Periodic data (consumption data, Digital Documents, change documents, IDocs, and batch input data)

Icon	Description
	The Data is loaded completely because the selected period is complete.
	The data is loaded incompletely because the selected period is incomplete.
None	No data is loaded.

Manage warning thresholds

For each type of non-periodic data, you can specify the number of days from which the data is outdated.

1. Select .

2. Enter the numbers for the warning thresholds.

   note

   If you enter no number, the default value of 31 days is used.

3. Save

Load OpenText data

Load OpenText data

Access through: Administration > Data > ABAP systems > Load OpenText Add-on data

The Load OpenText Add-on data report loads OpenText archiving and document access data from connected ABAP data sources.

Description

With this report, you can load OpenText data from selected ABAP data sources before you execute the OpenText archiving and document access license report.

Selection criteria

The selection screen of the report has standard selection criteria.

You can execute this report in the background.

Result

A pop-up shows information about the number of successfully loaded data sources, failed data sources, and inactive data sources. If there are errors, select Error details to show details.

The result shows the load protocol for each data source with the sources, destinations, and the number of loaded records.

Apply or remove USMM license type systematic

Apply or remove USMM license type systematic

Access through: Administration > Data > ABAP systems > USMM license type systematic ABAP systems

The USMM license type systematic ABAP systems report applies or removes the USMM license type systematic from user master data.

Description

In addition to the explicit manual classification of license types, there are implicit license type classifications in the SAP system measurement:

• Default license type

• License type from reference user

• License type from classified role

After loading data from ABAP systems, you can use this report to apply the implicit classifications of the USMM license type systematic to the loaded user data. A USMM license type systematic can be, for example, that all users without a license type are assigned a default license type. If you already applied the USMM license type systematic to the data, you can remove it again.

Selection criteria

In addition to the standard selections, the selection screen of the report has the following selections:

License type systematic

Select if you want to incorporate or revert the USMM license type systematic to the user data.

You can execute this report in the background.

Result

The report result shows information about the types and numbers of user classifications applied or removed.

Check availability of statistics data

Check availability of statistics data

Access through: Administration > Data > ABAP systems > Check availability statistics data

The Check availability statistics data report checks the availability of statistics data.

Description

With this report, you can check the availability of statistics data in the SAP Workload Monitor (transaction ST03N).

note

In order for Snow Optimizer for SAP^® Software to load data, there must be entries for the host/instance TOTAL and the period type M in the SAP Workload Monitor.

Selection criteria

The selection screen of the report has standard selection criteria.

You can execute this report in the background.

Result

The report result shows information about the statistics data on the selected data sources.

Functions available in the report result:

• To show available data for a specific period, select a row and select Details.

• To show the current parameters for the creation of statistical data (table SPWLCOPA), select Details parameters.

  tip

  For more detailed information on HTTP accesses, set the HTTP_STATREC_PATH_SPLIT_RULE parameter to value 1 or 2 by using the SWNC_CONFIG_URL report on the respective system.

Delete periodic data of ABAP systems

Delete periodic data of ABAP systems

Access through: Administration > Data > ABAP systems > Delete periodic data ABAP systems

The Delete periodic data ABAP systems report deletes loaded periodic data of selected ABAP data sources.

Description

This report allows you to delete loaded periodic data of ABAP systems like, for example, change documents, IDocs, or Digital Documents.

caution

When you execute the report, data is deleted immediately without warning.

note

Saved report results based on deleted periodic data are still available after deletion, but detailed information about the periodic data is no longer shown.

Selection criteria

In addition to the standard selections, the selection screen of the report has the following selections:

Data types

You can select the periodic data types that you want to delete.

You can execute this report in the background.

Result

The report result shows information about the deleted data types of the selected data sources within the selected period.

Delete non-periodic data of ABAP systems

Access through: Administration > Data > ABAP systems > Delete non-periodic data ABAP systems

The Delete non-periodic data ABAP systems report deletes loaded non-periodic data of selected ABAP data sources.

Description

This report allows you to delete loaded non-periodic data of ABAP systems which can be useful in some special cases. An example would be when data has reached a certain age and should no longer affect the results of reports, but the data source should remain in Snow Optimizer for SAP^® Software.

Selection criteria

In addition to the standard selections, the selection screen of the report has the following selections:

Load date

Enter the load date to delete the data loaded before this date.

Data types

You can deselect the non-periodic data types that you do not want to delete.

You can execute this report in the background.

Result

The report result shows information about the selected data sources, data types, and loading dates.

Functions available in the report result:

• Select rows and select to delete data.

New statistical data objects

New statistical data objects

Access through: Administration > Data > ABAP systems > New statistical objects

Over time, new statistical data objects are created that require updating the statistical data objects in Snow Optimizer for SAP^® Software Usage profiles. There are two reports to load and assign new statistical data objects to the usage profiles.

Load statistical data objects

Access through: Administration > Data > ABAP systems > New statistical objects > Data preparation

The Data preparation report loads new statistical data objects data from connected ABAP data sources.

note

• The report only loads the statistical data objects that were created since the last update of statistical data objects in Snow Optimizer for SAP^® Software.

• To have up-to-date data in Snow Optimizer for SAP^® Software, you should load statistical data objects on a regular basis, preferably once a month.

Selection criteria

The selection screen of the report has standard selection criteria.

You can execute this report in the background.

Result

The report result shows information about the loaded statistical data objects like, for example, data source, creation date, type, and description.

Show and assign statistical data objects

Access through: Administration > Data > ABAP systems > New statistical objects > Show statistical objects

The Show statistical objects report gives you information about the new statistical data objects from connected ABAP data sources per system and monthly period. You can assign the new statistical data objects to Usage profiles.

Selection criteria

The selection screen of the report has standard selection criteria.

You can execute this report in the background.

Result

The report result shows information about the statistical data objects that were created in the selected period.

Functions available in the report result:

• To assign a statistical data object to usage profiles, select the statistical data object entry and select Show profiles.

  • To include the statistical data object in a usage profile, select a usage profile entry and select .

  • To exclude the statistical data object from a usage profile, select a usage profile entry and select .

  • To delete the statistical data object from a usage profile, select a usage profile entry and select .

Offline data

Offline data

Access through: Administration > Data > ABAP systems > Offline data

The Offline data feature allows you to load and create offline files containing data from ABAP data sources that are relevant for measuring but cannot be connected via an RFC connection.

Load offline file

Access through: Administration > Data > ABAP systems > Offline data > Load offline file for ABAP data source

This report loads ABAP data from offline files that were created with Snow Optimizer for SAP^® Software Offline Tool or were exported from another installation of Snow Optimizer for SAP^® Software.

note

If you receive the error message Not enough memory for data provider when loading data, you need to restart the SAP GUI.

Selection criteria

In addition to the standard selections, the selection screen of the report has the following selections:

Options for file selection

You can select whether the report loads the offline file from the application server or from the front-end. In both cases, you must enter the file path.

Options for assignment to a data source

You can select whether the report assigns the data manually or automatically to an ABAP data source in Snow Optimizer for SAP^® Software. If you select the manual option, you have to select a data source.

note

If the ABAP data source is still empty and has a TMP_ designation, you must use the manual assignment. If the data source is already assigned to a specific system and client, you can also use the automatic assignment.

Options for report execution mode

You can select the execution mode of the report:

• To load the file and import data, select Load file.

• To detect and show only system data, select Detect system data only.

• To simulate the data import, select Full simulation.

You can execute this report in the background.

Result

The report result shows information about the loaded data.

Create offline file for one ABAP data source

Access through: Administration > Data > ABAP systems > Offline data > Create offline file from ABAP data source

This report creates an offline file with data from a single ABAP data source and saves it to an application server or a front-end. The offline file has all data of the activated data types. After creation, you can load the offline file into another installation of Snow Optimizer for SAP^® Software.

Selection criteria

In addition to the standard selections, the selection screen of the report has the following selections:

Options for file selection

You can select whether the report saves the offline file on the application server or on the front-end. If you select Application server, select the server and path, and change the file name if required. If you select Frontend, select the path and enter the file name.

Options for data types

You can select the data types of non-periodic and periodic data. For periodic data enter the period.

note

You cannot deselect System data, because data about system details is always created.

Options for language keys

You can enter the keys of the languages in which you want to create the offline data file.

You can execute this report in the background.

Result

A message shows the number of successfully exported characters. The offline file is saved on the application server or front-end.

Create offline file for many ABAP data sources

Access through: Administration > Data > ABAP systems > Offline data > Create offline file for multiple ABAP data sources

This report creates an offline file with data from several selected ABAP data sources and saves it to an application server or a front-end. The offline file has all data from activated data types. After creation, you can load the offline file into another installation of Snow Optimizer for SAP^® Software.

Selection criteria

In addition to the standard selections, the selection screen of the report has the following selections:

Options for file selection

You can select whether the report saves the offline file on the application server or on the front-end. If you select Application server, select the server and path, and change the file name if required. If you select Frontend, select the path and enter the file name.

Options for data types

You can select the data types of non-periodic and periodic data. For periodic data enter the period.

note

You cannot deselect System data, because data about system details is always created.

Options for language keys

You can enter the keys of the languages in which you want to create the offline data file.

You can execute this report in the background.

Result

A message shows the data source names and the number of successfully exported characters. The offline file is saved on the application server or front-end.