SAP ABAP IMG Activity UA_QUERY_GENERATE (Generate Access Functions for BW InfoProvider (ODS))
Hierarchy
☛ SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
   ⤷ FIN-BA (Application Component) Business Analytics
     ⤷ UA_TOOLBOX (Package) Useful Bits
IMG Activity
ID UA_QUERY_GENERATE Generate Access Functions for BW InfoProvider (ODS)  
Transaction Code S_SE3_62000026   (empty) 
Created on 20021002    
Customizing Attributes UA_QUERY_GENERATE   Generate Access Functions for BW Queries 
Customizing Activity UA_QUERY_GENERATE   Generate Access Functions for BW Queries 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name UA_QUERY_GENERATE    

Use

You carry out this activity to gain access to key figures that are part of a query in the SAP Business Information Warehouse (SAP BW). The system generates access functions for all key figures of the query you selected within this activity. These access functions are available in the formula editor of concurrent costing in addition to the standard functions to enable the key figure values read from the query to flow into the cost estimate.

The system proceeds as follows when generating the access functions:

  • An individual function is generated for every key figure that is contained in a query. This also applies to calculated or restricted key figures that are only valid within the query.
  • The name of the generated function has the following structure:
    READ_<technical name of query>_<consecutive number>.
    This means the respective key figure is not immediately apparent from the name of the function as a consecutive number (beginning with 1) is assigned for this . However, in addition the name of the key figure is stored for the function in a descriptive text
  • The input parameters of the function correspond to the list of all characteristics contained in the query from the header area, lead columns, filter variables. All of these parameters must be supplied with a valid value to select the desired key figure clearly on function call.
  • The function value returned by the function corresponds to the value of the key figure for the selection described by the current function parameter.

The generated access functions are available in concurrent costing independent of the selected working environment or data basis.

Restrictions

The generated functions reflect the status of a query at the time of generation. When calling up the functions no comparison takes place between the generated functions and the query definition. Therefore, you must make sure yourself that the consistency between the definition and the generated functions is kept after changes to the query definition. Should it be necessary, you must generate the functions again.

Requirements

You have set up an RFC destination through which you can create a connection to a SAP BW System. You can only generate access functions for those queries that are set up for access using the ODBO interface (you make this setting in the SAP BW Query Designer).

Standard settings

Activities

  1. At the start of the activity you have set up an RFC destination that refers to the SAP BW System the queries of which you want to generate access functions.
    2. The system displays a hierarchical list with the InfoProviders available and the possible queries.
  2. Set the indicator next to the technical name for every query that you want to generate access functions for.
  3. Choose Class -> Generate Selected.
    4. The system generates the access functions in accordance with your selection.

Example

Business Attributes
ASAP Roadmap ID    
Mandatory / Optional 3   Nonrequired 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 UA_QUERY_GENERATE 0 SEM0000001 Strategic Enterprise Management 
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 UA_FUNC_GENERATE  
History
Last changed by/on SAP  20050804 
SAP Release Created in 350