SAP ABAP IMG Activity ISP_IS_LDWDB_WERKZ1 (Set Up Statistical Data)
Hierarchy
☛ IS-M (Software Component) SAP MEDIA
   ⤷ IS-M (Application Component) SAP Media
     ⤷ JAS (Package) Application development R/3 Publishing Advertising System***
IMG Activity
ID ISP_IS_LDWDB_WERKZ1 Set Up Statistical Data  
Transaction Code S_KK4_74001648   IMG Activity: ISP_IS_LDWDB_WERKZ1 
Created on 19990816    
Customizing Attributes ISP_IS_LDWDB_WERKZ1   Set Up Statistical Data 
Customizing Activity ISP_IS_LDWDB_WERKZ1   Set Up Statistical Data 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name ISP_IS_LDWDB_WERKZ1    

Reorganization (of statistics) enters consistent and complete data in information structures.

One or more structures need to be reorganized in the following cases:

  • If a structure was just created using the Logistics Data Warehouse (statistics database)
  • If the structure update was activated after documents that needed to be included in the statistics were created in the system
  • If the statistics update was changed in customizing
  • If the statistics data is inconsistent

Preparations

In order to have a reorganization run restart when it is cancelled, you should assign a name to each background reorganization run.

If reorganization is cancelled or reorganization from archived documents is to be interrupted, the status reached is saved to the buffer under this run name.

When the run is then restarted using the same name, the system continues processing from this temporary status.

When a run is completed successfully, the temporary status is deleted.

Recommendation

  • These reports should be run in the background.
  • You should carry out the steps for the reorganization procedure in exactly the order described below.

Procedure

To fully reorganize statistics, you must perform the following steps:

  1. Initialize version for reorganization

    For reasons of security, the statistical data determined during reorganization should not be written to the actual data version of the data structures but instead saved under a different version name. This version stored temporarily must be initialized before reorganization can take place.

    This can be done using report RMCSISCP.

    The actual data is stored under the version name "000".

    Note

    It was previously only possible to update directly to version 000 in the Shop Floor Information System. This is now also possible in all other information systems linked to the Logistics Information System (LIS).

  2. Save actual data

    For reasons of security, you should save the actual data in the system under a different version name.

    Again, use report RMCSISCP for this purpose.

  3. Edit all archived documents

    This function is not supported for the Media Information System at present.

  4. Transfer all documents in the system

    This takes place using the various reports available in the Media Information System:

    • RJ-J1NEU Reorganization of Sales Orders (SD)
    • RJ-J2NEU Reorganization of Correction Order Data (SD)
    • RJ-J3NEU Reorganization of Delivery Data (SD)
    • RJ-J4NEU Reorganization of Billing Data (SD)
    • RJ-JANEU Reorganization of Order Data (AM)
    • RJ-JFNEU Reorganization of Billing Data (AM)

Note

If deliveries have never been updated, the indicator denoting that delivery was updated successfully will not yet be selected. Since the reorganization of delivery data does not select this indicator, you must ensure that the indicator is selected after reorganization. There are two alternatives for doing this:

Instead of reorganization, you can use the update program for deliveries (RJ-J3FZP, see below). This updates all active information structures from the deliveries not yet updated that exist in the system (corresponds to reorganization since no update has yet taken place).

This first option is preferable.

Once you have reorganized the information structure, select the update indicator in the deliveries affected using the utility report RJ-J3UTI.

  1. Transfer data obtained in reorganization from the reorganization version to the actual version

    Once the reorganization is successfully completed, the data obtained is imported to the actual version instead of the previous data.

    This is also done using report RMCSISCP.

    Note

    You can use standard analyses to display the versions of the standard information structures. The following options are possible:

    1. You can assign the version number of the version you want to display as a value for the user parameter 'MCR'.
      2. The system then enters the specified version number automatically in the 'Version' field under 'Parameters' on the selection screen for the standard analysis. The version number can be overwritten.
      This setting is user-dependent and applies to all standard analyses.
    2. If you assign the value 'X' to the user parameter 'MCR', the system always displays version '000' on the selection screen for the standard analyses. The version number can be overwritten here too.
      3. This setting is also user-dependent and also applies to all standard analyses.

      If you want to make use of one of these options, use the menu path System -> User profile -> User parameters. You can select this function from any menu.
      Recommendation
      You should start a different mode in order to change user parameters since it is not possible to return to your starting point again from the maintenance function.

    3. You can also use the 'User settings' to make settings for versions that are also user-dependent but only refer to one particular standard analysis.
      4. To do this, select Goto -> User settings on the selection screen for the standard analysis.
      The system accesses the standard drilldown. Now select Goto -> Parameters.
      If you select the indicator 'Selectable version', the system displays the 'Version' field containing the version number '000' on the selection screen. You can overwrite this version number at any time.

  2. Follow-up processing

    Once statistics reorganization is completed successfully, you can delete data you no longer require by deleting the version under which the data is stored.

    These versions are:

    • Backup copy of the actual data
    • Version for reorganization

      You can use report RMCSISCP to do this.

Activities

To carry out statistics reorganization, please proceed as follows:

  1. Specify your selection criteria.
  2. Save your entries as a variant.
  3. Please carry out the corresponding program in the background.

Description of report RMCSISCP

Report RMCSISCP is used by almost all information systems in Logistics. This description refers to its use in Media.

Report RMCSISCP can be used to copy or delete versions from information structures under which statistical data is stored.

The data stored in an information structure differs according to the version under which it is recorded.

Version "000" contains the actual data, i.e. the data that was written to the information structure during the statistics update.

The versions beginning with '&(' are used to store the intermediate results that are created during reorganization of an information structure.

All other versions (version A00 and all numerical versions except 000) are used to store planning data.

Reorganization of an information structure takes place in the same way as an online update, except that the data is not usually written to version 000 but to a version of your choice beginning with '&('. The data is only copied from this version to version 000 once the reorganization is completed successfully.

Note

While copying into version 000, you must not make any postings that update the information structure.

To avoid losing the old version 000, i.e. the previous actual data, you should save these under a different version. This 'backup copy' is also created using report RMCVISCP.

This report can also be used to initialize a version - in other words, to delete the data stored previously under this version.

Activities

RESET N1

Specify the name of the information structure that is to be copied or deleted.
Choose a processing type.
The selection screen for LIS Copy Management appears. The requested processing type is displayed here.
Specify all further selection criteria on this screen.

Description of report RJ-JXINI (Initialization of MDIS Data)

This program enables you to delete data from information structures that belong to the media information system.

Note: This program also initializes an indicator in the deliveries for the Media system, denoting that the deliveries were already updated in the Media Information System. You may therefore need to ensure that the deliveries for all active information structures are reorganized using program RJ-J3FZP or that this indicator is reset using report RJ-J3UTI.

Selection parameters

  • Key figures to be initialized

    Select the source area from which key figures in the information structures of the Media Information System are to be deleted.

    Note: If you select all parameters here, the system does not only initialize the key figures (setting them to '0') but also physically deletes all the records from the information structures, i.e. the statistics tables are emptied.

  • Information structure to be initialized

    Specify the information structures for whi

Business Attributes
ASAP Roadmap ID 207   Establish Reporting 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 1   Critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG ISP_IS_LDWDB_WERKZ1 0 I170007158 Information System for Media Sales and Distribution 
SIMG ISP_IS_LDWDB_WERKZ1 1 O I170007159  
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
IMGDUMMY D - Dummy object OLIX ISP-IS0002 Copy or Delete Versions 
IMGDUMMY D - Dummy object J-F1 ISP-IS0030 IS-M/SD: Reorganize LIS Data from Sales Order 
IMGDUMMY D - Dummy object J-F2 ISP-IS0003 IS-M/SD: Reorganize LIS Data from Correction Request 
IMGDUMMY D - Dummy object J-FL ISP-IS0022 IS-M/SD: Reorganize LIS Data from Deliveries 
IMGDUMMY D - Dummy object J-F4 ISP-IS0005 IS-M/SD: Reorganize LIS Data from Billing Document 
IMGDUMMY D - Dummy object J-K3 ISP-IS0025 IS-M/AM: Reorganize LIS data from Orders 
IMGDUMMY D - Dummy object J-K9 ISP-IS0026 IS-M/AM: Reorganize LIS data from Billing Documents 
IMGDUMMY D - Dummy object NPRT ISP-IS0023 Display Logs for LIS Reorganization Run 
IMGDUMMY D - Dummy object J-F3 ISP-IS0004 IS-M/SD: Update Deliveries in Info Structure 
IMGDUMMY D - Dummy object J-IX ISP-IS0006 IS-M/SD: Initialize Info System Data 
History
Last changed by/on SAP  19990816 
SAP Release Created in