Ansicht
Dokumentation

GET_CORRELATION_IC_QUERY - Correlation Between Queries and InfoCubes in a BW System

RFUMSV00 - Advance Return for Tax on Sales/Purchases   General Material Data  
This documentation is copyright by SAP AG.

Functionality

Correlates the InfoCubes to all given queries.

At first, the BW system is verified and then table RSRREPDIR is checked. Queries are searched in the table and correlated to an infocube.

IMPORT: ,,table IM_TAB_CORR with structure WLBWUSGQRY (important: query ID has to be filled)

EXPORT: ,,table EX_TAB_CORR with structure WLBWCORR (if no InfoCube to query is found in the table, infocube is "unknown")

Example

DATA: tab_exist ,, TYPE wlbwtype-tabexist,

im_tab_corr TYPE wlbwusgqry,

ex_tab_corr TYPE wlbwcorr.

* The query names have to be collected by external function modules or programs.

PERFORM GET_QUERY_NAMES.

CALL FUNCTION 'GET_CORRELATION_IC_QUERY'

IMPORTING

ex_tab_exist = tab_exist

TABLES

im_tab_corr = im_tab_corr

ex_tab_corr = ex_tab_corr

EXCEPTIONS

no_bw_system = 1

others = 2.

CASE sy-subrc.

WHEN 1.

write: "Function module not reasonable in non-BW systems".

WHEN 2.

write: "Problem in correlating InfoCubes to queries: please investigate.".

ENDCASE.

Notes

This function module runs only in BW systems where this specific correlation table is available.

Further information

Parameters

EX_TAB_CORR
EX_TAB_EXIST
IM_TAB_CORR

Exceptions

NO_BW_SYSTEM

Function Group

SAPWL_BWMODULES

SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   General Data in Customer Master  
This documentation is copyright by SAP AG.

Length: 1914 Date: 20240523 Time: 094330     sap01-206 ( 27 ms )