Introduction
Once a variable has been created, the definition of some parameters (Processing By, Variable Represents and some others) can't be modified within Bex Query Designer or IP Modeler.
Goal
This blog describes how to change some variable parameters after it has been created and saved.
Business scenario
Let us consider a scenario where we have a variable represented by single value, but according to some business process, we need this variable to be represented by multiply single value instead of single value.
As mentioned above it is not possible to modify some parameters within Bex Query Designer or IP Modeler after a variable has been saved.
SAP recommended way to solve this issue is to delete this variable and create a new one with suitable parameter.
But what should we do if this variable already has been used within 100 queries ?
In this case we can use not recommended, but proper way - change these parameters directly via RSZGLOBV table.
Implementation
Go to TC SE16 -> Table RSZGLOBV and enter variable's technical name in Variable Name (VNAM) field.
When a result has been retrieved (it should be 2 records for one variable - M and A versions) select A version and press Change button (F6).
In the next screen it is possible to change any parameter of variable. In our case we want to change Variable Represents (Select parameters in RSZGLOBV table) parameter.
Change the content of Select parameters (VPARSEL) field from P to M and save the changes.
Do the same for M version entry in RSZGLOBV table.
Now we need to generate all the queries that use this variable.
Go to TC RSRT - > Environment - > Gen. Queries Directly.
Type info provider technical name with the queries to be generated and press Execute (F8).
5 Comments
