Symptom
National ID column is not visible in Ad Hoc Reports.
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 SuccessFactors HCM Core > Ad Hoc Reporting
SAP SuccessFactors HCM Core > Report Center
Reproducing the Issue
- Create a new Ad Hoc / Report-table report
- Choose one of the Employee Central domains (ex: Job Inforamtion Date Range)
- Look for the 'National ID' column
The column won't be available in any of the tables
Cause
Fields that are changed to be 'Masked' in the UI via Admin Tools > Business Configuration UI, will not be viewable in Ad Hoc Reporting and cannot be used within a report.
This is expected behavior.
Resolution
If National ID is masked then that particular field will not be available in reports. System provides this privilege to hide field (which is masked) in the reports.
- Go To BCUI
- personal Infos
- NationalID
- Masked: YES
Via Code
- Access back-end system (Provisioning or Via UI export: Succession Data Model "SDM" 3066117 - How to export Data Models?
<hris-field id="national-id" max-length="256" visibility="both" required="true" pii="true" logreadaccess="true">
<label>National Id</label>
<label xml:lang="en-GB">National ID</label>
<label xml:lang="en-US">National Id</label>
</hris-field>
Please note, if you use Advanced Reporting/ORD then you will be able to report on this data there.
See Also
Keywords
National, ID, ad, hoc, reports, table, center, missing, hidden, masked, EC, Employee, Central, PII, hide , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-ANA-ADV , Advanced Reporting (ODS) , How To