Symptom
Under value search 'Search and Select' in Analytical Grid Apps like 'Year-to-Date Balances' App or 'Trial Balance' App initial value '#' comes up.
"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."
Environment
SAP S/4HANA Cloud Public Edition
Reproducing the Issue
- Enter App 'Year-to-Date Balances' or 'Trial Balance'.
- Select 'Search and Select' option of 'Company Code'.
- Value '#' is displayed with Description 'Not assigned'.
Resolution
'#' is within BW the representation of an initial value and occurs in Analytical Grid Apps (Web Dynpro Grid Apps) and it is added to all value help (you will find same entry in the value help for G/L Account, Cost Center or Profit Center). It is not an error or bug, it is not a value from master data table and cannot be influenced by the customer. Technically it is an additional entry to be able to filter for initial.
Keywords
Analytical Grid Apps, Web Dynpro, Trial Balance, Year-to-Date Balances, #, initial, value, not assigned, filter, search and select, value help, F0996, F 0996, W0177, W 0177 , KBA , FI-FIO-GL-IS , Reporting Apps , FI-FIO-GL-IS-2CL , Reporting Apps (Public Cloud) , Problem