SAP Knowledge Base Article - Public

2162838 - National ID Column is not visible in reporting

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

  1. Create a new Ad Hoc / Report-table report
  2. Choose one of the Employee Central domains (ex: Job Inforamtion Date Range)
  3. 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 

  1. 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>

NAD2.jpg

 

NAD3.jpg

Please note, if you use Advanced Reporting/ORD then you will be able to report on this data there.

 

See Also

  • 2216586 - 'Masked' fields do not appear in Ad Hoc Reporting
  • 2216586 - 'Masked' fields do not appear in Ad Hoc Reporting
  • 2162775 - How to mask National ID to be kept confidential - SuccessFactors Employee Profile

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

Product

SAP SuccessFactors HCM Core all versions