SAP ABAP IMG Activity BW_GENERICDS_DEFINE (Maintain Generic DataSources)
Hierarchy
PI_BASIS (Software Component) Basis Plug-In
   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

  1. Select the DataSource type and assign a technical name to it.
  2. Choose Create

    The screen for creating a generic DataSource appears.

  3. Choose an application component to which the DataSource is to be assigned.
  4. Enter the descriptive texts. You can choose these freely.
  5. Choose from which data sets the generic DataSource is to be filled.
    1. 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.
    2. 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.
    3. 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.
    4. 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.
    5. If you want to extract data using a function module, choose Extraction Using FM and specify the function module and the extract structure.
    6. 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.
    7. For texts, data can also be extracted from domain fixed values.
  6. If necessary, maintain settings for the Delta Transfer.
  7. Choose Save.
  8. Extraction Using Functional Areas: Assignment to a User Group

Note for Extracting from a Transparent Table or a View:
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.

  1. 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.
  2. 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