Ansicht
Dokumentation

UA_QUERY_GENERATE - Generate Access Functions for BW InfoProvider (ODS)

rdisp/max_wprun_time - Maximum work process run time   Vendor Master (General Section)  
This documentation is copyright by SAP AG.

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__.
  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.

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.

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).

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.

The system displays a hierarchical list with the InfoProviders available and the possible queries.

1. Set the indicator next to the technical name for every query that you want to generate access functions for.
2. Choose Class -> Generate Selected.

The system generates the access functions in accordance with your selection.

PERFORM Short Reference   PERFORM Short Reference  
This documentation is copyright by SAP AG.

Length: 3171 Date: 20240523 Time: 173742     sap01-206 ( 66 ms )