Registration

Dear SAP Community Member,
In order to fully benefit from what the SAP Community has to offer, please register at:
http://scn.sap.com
Thank you,
The SAP Community team.
Skip to end of metadata
Go to start of metadata

Purpose

The purpose of this page is to clarify the understanding of the report ANALYZE_RSZ_TABLES

Overview

ANALYZE_RSZ_TABLES is designed as a check-tool for detecting and solving different types of inconsistencies in the main query definition database tables. The program is recommended for BW system administrators.

How to use it?

Call transaction SE38  with function module ANALYZE_RSZ_TABLES.

1)  Tables

 
RSRREPDIR
RSZELTDIR
RSZCOMPDIR
RSZCOMPIC
RSZELTXREF
RSZSELECT
RSZRANGE
RSZCALC
RSZGLOBV

RSZELTPROP

RSZCEL

 

1. Table RSRREPDIR
The table RSRREPDIR is a header table of the generated reports. Consistency of query definition in this table allows to select a query in the Open Dialogs of fronted application and to call report generated for this particular query using transaction RSRT.

2. Table RSZCOMPIC
The table RSZCOMPIC contains an InfoProvider assignment for queries and other reusable query components (STR, RKF and CKF).

3. Table RSZCOMPDIR
The table RSZCOMPDIR is the directory table containing the main properties of all reusable components. 

4. Table RSZELTXREF
The table RSZELTXREF contains all links and dependencies between the query elements within a query or query component.

5. Table RSZGLOBV
The table RSZGLOBV contains the definitions and technical properties of the variables. 

6. Table RSZELTDIR
The table RSZELTDIR is the main directory table containing all query elements available in the system. 

7. Table RSZELTTXT
The table RSZELTTXT is the table containing all language dependent text of query elements.

 

InfoProviders

  • Not Available InfoProviders                                          
  • Inactive InfoProviders                                            
  • InfoProviders Missing in Active Version                  

Table RSRREPDIR

Table RSZCOMPIC

  • Query Components in Non-Existing InfoProviders                     
  • Query Components in Inactive InfoProviders               
  • Query Components in InfoProviders Missing in "A" Version      

Table RSZCOMPDIR

  • Query Components Available Only in Backup Version                  
  • Query Components with Technical Names Used by InfoObjects          
  • Query Components with Special Characters in Technical Name         

Table RSZELTXREF

  • Missing Elements - Optional References                             
  • Distribution of Records by InfoProviders

Table RSZGLOBV

  • Variable with Empty FLAGLH Field                                   
  • Pre-query (COMPID) Does Not Exist                     

Execute Extended Check of the Table RSZGLOBV

Table RSZELTDIR

  •  Local Selection Missing in RSZSELECT                               
  •  Query Missing in RSZELTPROP                                        
  •  Restricted Key Figures Missing in RSZELTPROP                      

Table RSZELTTXT

  •  Texts with Incorrect Text Variables                          
  •  Unreferenced Text Variables                        
  •  Texts with Missing Text Variables                                 
  •  Distribution of Records by Languages

Table RSZELTPROP

  •  No Errors Found

Table RSZCALC

  • CKF with Missing Operand - InfoObject                             

Table RSZELTPRIO

 Table RSZCEL

 Table RSZRANGE

  •  Where-Used Information
  •  Property "Calculation Before Aggregation"
  •  Hierarchies and Hierarchy Nodes

Related Content

How to Fix Inconsistencies in SAP BEX Tables 

Related SAP Notes/KBAs

Notes describing and correcting function module ANALYZE_RSZ_TABLES are below:

2669427    RSZTABLES: improvements and enhancements (4) 

2600322    RSZTABLES: improvements and enhancements (2) 

2640242    RSZTABLES: improvements and enhancements (3)

2532529    RSZTABLES: improvements and enhancements (1)

1785509  ANALYZE_RSZ_TABLES: Improvements and enhancements (2)

1506560  ANALYZE_RSZ_TABLES: Improvements and enhancements

1834605  Customer Exit Variable not working or not found

1596579  Cannot determine valid variables: Terminate Message no. RSM1661

1020826  Hotfixes for check report ANALYZE_RSZ_TABLES

792779  Report ANALYZE_RSZ_TABLES

966080  Dump in ANALYZE_RSZ_TABLES

853826  Query elements: translation errors

907025  Duplicated technical names (COMPID) for query components

869809  Empty INFOCUBE field in the table RSZELTXREF

 

Link to this page: http://wiki.scn.sap.com/wiki/x/aIM2FQ