SAP Note 22393 - Importing statistical data into LIS

Symptom:

1. The respective operative application (SD, MM-PUR, ...) has been working productively for some time, the associated information system (SIS, PURCHIS, ...), however, has not been used yet. The data from the operative application are also to be used in the information system.

2. When you change from a non-SAP system to an SAP System, statistical data should also be copied.

Solution

ad 1. Set up statistical data from SAP operative transactions ...

There are programs in the respective applications in order to subsequently create statistical data from the operative transactions.

Documentation is available for all information systems in the Implementation Guide "Logistics Information System (LIS) - Logistics Data Warehouse - Data Basis - Tools - Setup of Statistical Data".

Sales Information System:
RMCVNEUA, RMCVNEUL, RMCVNEUF (orders, deliveries, billing documents) available as of Release 2.1 - see Collective Note 88025.

Inventory Controlling:
Program RMCBNEUA - available as of Release 2.2 - see release-related collective notes.

Purchasing Information System:
Program RMCENEUA - available as of Release 2.1 - see Note 23125.

Plant Maintenance Information System:
Programs RIPMS000 / RIPMS001 - available as of Release 2.2

Quality Management Information System:
Program RMCQNEUA - available as of Release 3.0

***********************************************************************

Ad 2. Transferring data from a non-SAP system ...

Transferring statistical data from a non-SAP system into an SAP System depends upon the type of data and on possibly copying the operative transactions (customer orders, etc.):

a) Operative data is also copied from the non-SAP system ...
If operative transactions from non-SAP systems are also copied into an SAP System, the statistics update is automatically triggered by the new documents created in the R/3 System. The prerequisite is the use of standard copy tools, such as batch input, etc. as well as maintaining the Customizing tool of the info systems.

b) Only statistical data is copied ...
If the statistical data that is to be copied is already available in aggregated form, the corresponding info structure should be updated directly. Up to Release 2.2, there is no standard tool for this direct info structure update (as of Release 3.0: see below). You must write your own update program for this purpose. One possible procedure in this program is: import the data via a data medium (tape, file, etc.) - save the data in an internal table (note the maximum size) which has the same structure as the info structure that is to be updated - update the info structure with UPDATE FROM INTTAB, etc. As a model, you can use programs for updating SAP standard info structures or programs that are generated when you generate update rules. See FORM routine UPDATE_FROM_INT. You can find the update programs for an info structure in Table TMC2Q.
Should the data that is to be copied not be available in aggregated form but rather in a document structure, the special update programs of statistics update (for example, MCV_STATISTICS_UPD_V2_ORDER) can also be used for copying the data. These reports are not provided in the standard for such copy transactions. There is no corresponding documentation that can be used for this purpose. These programs require certain data structures which must be supplied with data from the non-SAP system. In this case, certain features must be taken into consideration so that general use of this program is only recommended when the corresponding developer is consulted.
As of Release 3.0, ALE is also available for statistical data update (Sales Information System, Inventory Controlling, Purchasing Information System). In this environment, interfaces for copying data will also be available. These interfaces could also be used for data transfer from non-SAP systems. In this case, the same applies as above - as this is not a standard functionality, there is no documentation on using these interfaces for the data transfer from non-SAP systems.
As of Release 3.0, you can use the "Copy Management" tool to transfer statistical data from non-SAP systems via Customer Exit RMCAF000.
(IMG path: Logistics, General -> Logistics Information System -> Logistics Data Warehouse -> Data Basis -> Tools).