SAP Knowledge Base Article - Public

3405082 - Manually entered prompt value is not accepted in SAC, if the value is not listed in the F4 help, that is created via F4 BAdI implementation

Symptom

When manually typing in a dimension member value, that exists in the info provider and for which the query would return data, but which doesn´t exist in the F4 help of the corresponding variable, SAC denies execution.

Environment

SAC BW Live

Reproducing the Issue

  1. Run a story
  2. Show prompts
  3. Enter a dimension member value that is not part of the F4 member list.

Cause

You are using an F4 BAdI implementation (RSR_VARIABLE_F4_RESTRICT) on a dimension for which the query has an input ready variable. That BAdI restricts the list of dimension members that usually would be returned by BW according to whatever rules you have defined. The returned list is smaller than the standard F4 list. The value, that is manually typed into the variable in the SAC prompts dialog, was sorted out by the BAdI. The current design of the prompts dialog validates manually entered values with the F4 help. SAC triggers a F4 lookup for manually entered values. As the value is not found in F4, it is considered to be an invalid value. As a consequence the prompts dialog cannot be passed with that value, the input field gets a red rectangle.

Other clients, like AfO, might be less strict. They don´t do an F4 lookup for value validation of manually entered values and therefore can execute such input. 

Resolution

The current design of the prompts dialog in SAC doesn´t fully support using an F4 BAdI, which restricts the possible values. You need to ensure that entered values are part of the F4 help or deactivate the BAdI.

Keywords

KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , BW-BEX-OT-BICS-INA , BW INA provider , LOD-ANA-FLY , Firefly used for HANA , Problem

Product

SAP Analytics Cloud 1.0