Hierarchy
SAP_APPL (Software Component) Logistics and Accounting⤷
CA-OIW (Application Component) Open Information Warehouse⤷
MCZ (Package) Application development R/3 SAP Open Information Warehouse
IMG Activity
| ID | OIW1 | Maintain OIW Metadata |
| Transaction Code | S_ALR_87007785 | IMG Activity: OIW1 |
| Created on | 19981222 | |
| Customizing Attributes | OIW1 | Maintain OIW Metadata |
| Customizing Activity | OIW1 | Maintain OIW Metadata |
Document
| Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
| Document Name | OIW1 |
The Open Information Warehouse (OIW) contains data from the following information systems in the SAP R/3 System:
- Controlling
- Financial Accounting
The maintenance of the OIW metadata from General Ledger Accounting is described in OSS Note 82836.
- Logistics
- Personnel Management
In the OIW, you can obtain an overview of the info objects for these information systems. You can also make multiple queries by combining several info objects that are of particular interest to you.
The answers to your queries are based on information that is contained in the OIW information catalog. Basic data retrieval information, such as tables and programs, in the form of metadata (descriptive data) are stored in the OIW information catalog. The OIW contains links to the data collection in the R/3 information systems. However, the OIW does not have its own data tables.
In this step, you decide which metadata will be included in the OIW information catalog. The metadata that you choose will be used later as the data source for answers to future inquiries.
A Data source is a pool of info objects that can be combined for multiple queries. However, a query is only valid if at least one data source in the OIW contains all of the requested info objects. An info object can exist in several data sources.
The step includes the functions Display OIW metadata and Delete OIW metadata also.
In Logistics, you can restrict your selection of metadata by entering self-defined Information structures, that is, the selection version or by selecting the field Standard info structures
The selection of metadata can be restricted in Personnel Management also. The selection is carried out by using standard fields, such as Info types.
Caution
- If you select the field Delete entry, only metadata from the current application (Controlling, Logistics or Personnel Management) will be deleted.
- By using the push button Delete, metadata is deleted globally.
Note
The maintenance of the metadata is the central OIW activity and prerequisite for all other OIW Customizing functions and OIW tasks.
If you have not maintained the metadata and display the standard OIW information catalog, you will receive a message that the information catalog is inconsistent. This message means that the information catalog contains info objects that do not exist in the metadata. In this case, an empty information catalog will be displayed in Excel, the OIW browser.
When using the self-defined OIW information catalog, maintenance of the metadata is also a mandatory prerequisite. Only one self-defined information catalog can be created per company.
Activities
- In order to generate the OIW metadata, proceed as follows:
- Choose the OIW metadata for each application that you will need later for answers to future queries.
- Choose the menu options Program -> Execute.
- In order to display the selected data, choose Display OIW metadata.
- The following options can be used if you want to change your selection:
- You can delete a portion of the chosen metadata by selecting the field Delete entries and choosing the menu options Program -> Execute.
- You can delete the chosen data completely by choosing the push button Delete OIW metadata.
Transport information
The transaction for maintaining the OIW metadata has no automatic transport.
Consequently, you must adjust the corresponding customizing settings in the live system also.
Business Attributes
| ASAP Roadmap ID | 255 | Create Interfaces |
| Mandatory / Optional | 1 | Mandatory 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 | OIW1 | 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 |
| MCKA | T - Individual transaction object | MCKA | OIW_1 | OIW: Maintain OIW metadata |
History
| Last changed by/on | SAP | 19981222 |
| SAP Release Created in |
