system , control and info parameter

[Former Member]

Hello All,

               I have couple of questions :

               1) What is the difference between system , control and info parameter ?

                2) Is it that we can do a search on system and info paramter and not on a control parameter ?

                3) I am configuring a value set for a selection parameter. I followed the following steps:

                       a) Define an info parameter and marked the flag for value set. Define the value set for this info paramter.

                       b) Define the parameter mapping for info parameter.

                       c) Configure the field as selection paramter where "EM attribute id"  as info parameter defined in step a.

                       d) Define user profile , set the selection parameter for a profile.

                     I am getting a dump saying "Type Not Found" in the Web UI.

                   If i am following the same steps for control parameter then UI is working fine but not fetching the result on search. Any pointers on this.

Thanks,

Shubh.

[former_member190756 · Accepted solution]

Hello Shubh,

please check note 1260125 there should be question 1 and 2 be answered. Of course you can also search for Control Parameter. System Parameters are stored in a customer own table.

For 3:

Try to run report /SAPTRX/UCPD_CREATE after you have entered the value sets.

If this does not help you should open a CSN ticket.

Best regards,

Steffen

[Former Member]

Hi Shubh,

I don't see any difference in the functionality of control and system parameters.

Only difference I can think is the way we store the control and the system parameter. Control parameters are stored in Standard SAP table ( /SAPTRX/CTRL dont rem exact name) and It

has a field that stores the sequence number. So a control parameter can have multiple values.

you have a track of oldest and latest values based on this sequence number.

System parameters on other hand are stored in the Z table.

Best,

Shammi

[former_member190756]

Difference is that system parameters are stored with EH Guid per EH Type in an extra table.

Queries are faster using system parameters.

Info and Cntrl parameters are stored as name value pairs. They should only be used when you need indexed parameters. Query performance can extremly slow down when searching for 2 or more parameters at the same time.

Best regards,

Steffen

[kevin_wilson2]

Just to be clear about Control and System parameters:

Control Parameters

• Stored in table /SAPTRX/EH_CNTRL as name value pairs
• There is an existing index on name / value so searching is quick as long as you limit the search criteria to 1 parameter
• If you have multiple values for the same parameter then you must use either control or info parameter. System parameter is not an option
• The index number (referred to as sequence # above) does NOT give you the history of old and new values. It's used create multiple values for the same parameter. Normal Change documents, if activated, will track the changes of parameters for you

System Parameters

• Stored in a joining table with /SAPTRX/EH_HDR with the EH_GUID as the joining field
• In this table you place all your fields / parameters that you wish to search on
• Use a system parameter if you know how the users will be searching for EHs because you will then be able to create an index on those fields in order to greatly improve the search performance. i.e. This is the main consideration for making a control parameter, a system parameter, or not. Without providing the index on the field the system parameter is useless and should rather be created as a control or info parameter