SAP ABAP IMG Activity BIW45 (Connect Information Structures)
Hierarchy
SAP_APPL (Software Component) Logistics and Accounting
   LO-LIS (Application Component) Logistics Information System (LIS)
     RS_IMG_LIS (Package) OLTP-IMG LIS (Logistics Information System)
IMG Activity
ID BIW45 Connect Information Structures  
Transaction Code S_ALR_87099855   (empty) 
Created on 19981230    
Customizing Attributes BIW45   Connect Information Structures 
Customizing Activity BIW45   Connect Information Structures 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name BIW45    

This marker enables you to link up an LIS information structure to the Business Information Warehouse (BW). A link in this case means data transfer of an informaton structure through a respective data source into the BW.

You can select the different functions through radio buttons. You can execute them separately.

These functions are explained as follows:

Information Structures

The LIS distinguishes between standard information structures (delivered with the name range S001 - S500) and customer-individual information structures (generated in the name range S501 - S999).

If the delta update in LIS is supported, you can switch this on or off via activate/deactivate.

Note
This step does not have any effect on the activation of the standard LIS update. It only affects the additional update of the delta information.

For the transfer information structures, you can activate both the update type as well as the delta update through the function Activate/Deactivate Update in Management of Transfer Information Structures.

  • Standard Information Structures

    Only certain standard information structures are designed for data transfer to the BW. These structures are also offered in the input options (F4 help) of the field Information structures.

    Standard information structures are delivered either with or without support of the delta update in the BW. These settings can be called up using Display settings.

  • User-Defined Information Structures

    As a rule, you can transfer user-defined information structures to the BW. The delta update is supported for this. Two copies of the table belonging to the information structure and a transfer structure are creaated for this in the DataDictionary and in the database. For example, the tables S501BIW1, S501BIW2 und the structure S501BIWS are created for the information structure S501.

Settings

The system issues a log with details of the link status. If the delta update is active in LIS, you receive detailed specifications on the current table by calling up the description text of the messages issued.

Generate Environment

Before a data source can be generated from an information structure, the so-called environment must be generated. This consists of two tables (SnnnBIW1, SnnnBIW2) and of the extract structure SnnnBIWS. The latter is tailored to the needs of the BW and uses partially different, more uniform data elements. The tables SnnnBIW1 and SnnnBIW2 are exact copies of the information structure.

Generate Data Source

If the environment was generated without errors, you can generate a data source in this step. The name of the data source is derived from the information structure and the application:

Example:
S501, Application 01: Name of data source: 2LIS_01_S501

The description is taken from the information structure.

Depending on the SAP BW you are using, one of the following appears:

  • A maintenance view (from SAP BW 2.0 onwards) for choosing the selection fields for the data extraction.
  • A maintenance view (only SAP BW 1.2) for assigning extract structure fields for info objects. Here the system proposes the correct unit fields automatically. You will find a description of the maintenance view under Expand Info Source (Movement Data) and Expand Info Source (Master Data).

    You can select indicators that are type C (text), type D (date), type T (time) and indicators whose summation indicator is not set in the information structure definition. Please note that only those fields that are marked as "selectable" in the maintenance view of the DataSource (Selection of the Selection Fields) will be taken into account during extraction.

The generation of a data source is independent of the name range of the information structure.

Delete Environment / Data Source

If the environment and the data source of an information structure are created, you can use this option to delete all the objects generated for it. The objects that will be deleted include: :

  • Tables SnnnBIW1 and SnnnBIW2
  • Extract structure SnnnBIWS
  • Any data element copies that may have been created
  • The generated programs belonging to the tables in the data selection
  • The DataSource

After the LIS environment has been deleted successfully, the update programs for the information structure are automatically regenerated. The LIS updating must be deactivated in all clients for this step to work properly.

Delta Update in the LIS

The following two items are only of importance if the data is to be transferred to the BW in the form of delta information. Updating delta information is only possible if the update program is re-generated.

In contrast to the environment and the data source, which are client-independent, the delta update is client-dependent, in the same way as the standard LIS update.

Generate Update

In this step, the update programs can be regenerated. In this way, an additional update of the tables SnnnBIW1 and SnnnBIW2 is possible. The LIS update must be deactivated during this.

Activate/Deactivate

If tables such as SnnnBIW1 and SnnnBIW2 exist and the update program supports the delta update, you can switch on or off the updates to these tables (client-dependent) in this step. Information as to which table is currently active for delta updates is stored in the table TMCBIW. This information is accessed in the update programs (that is, during the update posting).

Activities

To maintain the link from the meta data of a standard information structure to the BW, proceed as follows:

  1. Enter the information structure.
  2. Choose the radio button Generate data source.
  3. Depending on the SAP BW you are using, process the respective maintenance views as described above.

To link up your own user-defined information structure, proceed as follows:

  1. Set Up LIS Environment

    The Customizing environment is set to the requirements for data transfer to the BW. To support the delta update in LIS, you create two database copies of the information structure and a transfer structure. In this way, for example, tables S501BIW1 and S501BIW2 as well as the structure S501BIWS are created for the information structure S501.

  2. Generate DataSource

    Depending on the SAP BW, process the respective maintenance views as described above.

  3. Delta Update in LIS

    To support the delta update mode for the data transfer to BW, a delta update must be enabled in the LIS. For this purpose, the update programs for the respective information structure must be regenerated.

  4. Update Activation
    First activate the delta update and then the LIS update.

Business Attributes
ASAP Roadmap ID 254   Transfer Data 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-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 BIW45 0 HLB0009789 Open Information Warehouse 
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 LBW0 LIS: Create InfoSource for information structure 
History
Last changed by/on SAP  19991220 
SAP Release Created in