Symptom
The boolean fields in Global Job Information domain in Advanced Reporting displays values "t" or "f" instead of "Yes" or "No"
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
Report Canvas
Advanced Reporting
Reproducing the Issue
1. From Advanced Reporting query, add Boolean field type from Global Job Information table (Example: Is Fulltime Employee?, Eligible for Car Benefit)
2. Preview query or run report.
Result: Result shows "t' or"f" instead of "Yes" or "No"
Cause
Expected Behavior. Underlying data is 't' and 'f'. Advanced reporting is returning the actual underlying data.
Resolution
Use other reporting types (Report Table or Report Story) if you need to see the profile value of the boolean field in the report
See Also
Keywords
KBA , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , Problem