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
- Run a story
- Show prompts
- 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
SAP Knowledge Base Article - Public