Hierarchy
⤷ BC-BW (Application Component) BW Service API
⤷ RSAI (Package) Release-Dependent Objects for OLTP IMG
IMG Activity
ID | BW_GENERICDS_DEFINE | Maintain Generic DataSources |
Transaction Code | S_AX6_42000024 | IMG Activity: BW_GENERICDS_DEFINE |
Created on | 19990930 | |
Customizing Attributes | BW_GENERICDS_DEFINE | Maintain Generic DataSources |
Customizing Activity | BW_GENERICDS_DEFINE | Maintain Generic DataSources |
Document
Document Class | SIMG | Hypertext: Object Class - Class to which a document belongs. |
Document Name | BW_GENERICDS_DEFINE |
This step gives you the option of creating and maintaining generic DataSources for transaction data, master data attributes or texts from any kind of transparent tables, database views or SAP query functional areas or via a function module, regardless of application. This enables you to use the generic extraction of data.
Example
Requirements
Standard settings
Recommendation
Activities
Create a Generic DataSource
- Select the DataSource type and assign a technical name to it.
- Choose Create
The screen for creating a generic DataSource appears.
- Choose an application component to which the DataSource is to be assigned.
- Enter the descriptive texts. You can choose these freely.
- Choose from which data sets the generic DataSource is to be filled.
- If you want to extract data from a transparent table or database view, choose Extraction from View and enter the name of the table or database view.
- The result of generation is a DataSource whose extract structure corresponds to the database view or transparent table.
- For more information on creating and maintaining database tables and views, see the ABAP Dictionary documentation.
- If you want to use an SAP query functional area as a data source, choose Extraction from Query. Select the required functional area from the functional area catalog.
- Enhancements for Extracting Using SAP Queries
- The result of generation is a DataSource whose extract structure corresponds to the functional area.
- You can find additional information about the maintenance of functional areas in the SAP query documentation.
- If you want to extract data using a function module, choose Extraction Using FM and specify the function module and the extract structure.
- The data must be transferred from the function module to an interface table E_T_DATA .
- Interface Description and Extraction Process
- You can find information about the function builder in the ABAP Workbench documentation.
- For texts, data can also be extracted from domain fixed values.
- If necessary, maintain settings for the Delta Transfer.
- Choose Save.
- Extraction Using Functional Areas: Assignment to a User Group
If the extraction structure contains a key figure field that references a unit of measure field or a currency unit field, then this unit field has to be included in the same extraction structure like the key figure field.
A screen appears in which you can edit the extract structure fields.
- Edit the DataSource:
- Selection
- When scheduling a data request in the BW scheduler, you can enter the selection criteria for data transfer. You can, for example, set the data request to only cover data from the previous month.
- If you set the Selection indicator for a field of the extract structure, the data for this field is transferred according to the selection criteria for the Scheduler.
- Hide Field
- Set this indicator to exclude an extract structure field from the data transfer. This field is now no longer available in the BW when setting transfer rules, and thus it is no longer available when generating the transfer structure.
- Cancelation Field
- Reverse postings are possible for customer-defined key figures. Cancelations are therefore only active with certain transaction DataSources. These are DataSources that have a field designated as a cancelation field, for example, the Update Mode field in the DataSource 0FI_AP_3. If this field has a value, the data records are interpreted as reversal records in the BW.
- If you want to carry out a cancelation posting for a customer-defined field (key figure), set the Cancel indicator. The value of the key figure is transferred inverted (multiplied by -1) into the BW.
- Field Known Only in Exit.
- You can improve the quality of data by adding fields in append structures to the extract structure of a DataSource.
- For fields in an append structure, the indicator Field Known Only in Exit is set, meaning that, by default, these fields are not passed to the field list and the selection table in the extractor.
- Remove the Field known only in Exit indicator if you want the Service API to pass the field in the append structure to the extractor, along with the fields from the delivered extract structures in the field list and in the selection table.
- Choose DataSource -> Generate.
The DataSource is now saved in the source system.
Maintain Generic DataSource
Change DataSource
To change a generic DataSource, go to the initial screen of DataSource maintenance, enter the name of the DataSource and choose Change.
You can change the assignment of a DataSource to an application component as well as the DataSource texts. By double-clicking on the name of the table, view, functional area or extract structure, the corresponding maintenance screen appears. You can make the changes here required to add new fields. You can also completely substitute transparent tables and database views, though not functional areas. If you return to the DataSource maintenance and choose Create, the screen used to process the DataSource appears. To save the DataSource in the source system, choose DataSource -> Generate.
If you want to test the extraction in the source system independently of BW system, choose DataSource -> Test Extraction.
Delete DataSource
In the Change Generic DataSource screen, you can delete a DataSource that is no longer relevant. If you extract data from a functional area, also delete the corresponding query. If you want to delete a DataSource, make sure it is not connected to any BW system.
Further notes
Information about Extraction using the ABAP Query / ABAP/4 Query / SAP Query
Business Attributes
ASAP Roadmap ID | 201 | Make global settings |
Mandatory / Optional | 2 | Optional activity |
Critical / Non-Critical | 1 | Critical |
Country-Dependency | A | Valid for all countries |
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 |
OSOA | L - Logical transport object | RSO2 | Maintain Generic DataSources |
History
Last changed by/on | SAP | 19991001 |
SAP Release Created in |