This function returns the value of the specified property for a specific BW variable.
Enter the formula alias for the data source. You can set the alias when configuring the data source on the Components tab in the design panel.
Enter the name or technical name of the variable.
If you enter VALUE, the current value of the variable is displayed.
If you enter VALUEASKEY, the current value of the variable is displayed as a key.
If you enter VALUEASTEXT, the current value of the variable is displayed as text.
If you enter INPUT_STRING, the current value of the variable is displayed as an input string.
This property name can only be used if the formula is called from VBA. It returns the input string as a string array.
If you enter DESCRIPTION, the variable name is displayed.
If you enter ISINPUTENABLED, the function checks if the variable is input-enabled.
If you enter ISMANDATORY, the function checks if the variable is mandatory.
If you enter TECHNICALNAME, the technical name of the variable is displayed.
Cell F20: =SAPGetVariable("DS_2";"0BW_VAR";"DESCRIPTION")
If you enter the formula in cell F20, the name of variable 0BW_VAR is displayed in cell F20.