SAP Knowledge Base Article - Public

3128985 - Cannot Edit or Run Ad-hoc Report Sub - Domain Person and Employment Info (as of Date)

Symptom

You would receive an application error when trying to edit report (Person and Employment Info (as of Date)).

The application error id would be accompanied by the fingerprint id =

  • da0d5a9ae90a386f18b60648a4582b7459e5a951
  • f0b38630bbf86318d8ef6eb2280b3ed7f2967529
  • f8c5e280bab3ae2c661ebfc26f22cbfd19b09f2d

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

Reproducing the Issue

  • Go to Reporting:
  • Select Person and Employment Info (as of Date)
  • Edit
  • Click "preview"
  • Result: error message

Cause

  • Legal Entity object definition not updated in Database table
  • Invalid table name: Could not find table/view LEGALENTITY_VIEW in schema 

Resolution

Refresh data for the object Legal Entity but making some small changes (dummy change) in Legal Entity object definition

Step 1:

  • Go to Object Definition: LegalEntity or Company
  • Make correction
  • Description: add (dot).
  • Save
  • Make correction 
  • Description: remove (dot).
  • Save 

Step 2:

Run MDF cache: 2171588 - SuccessFactors: OData API Metadata Refresh and Export

Keywords

invalid table name: Could not find table/view LEGALENTITY_VIEW in schema, OData API Metadata Refresh and Export, legal entity, Adhoc report, Person and Employment Info (as of Date),INC1323550, INC0912986, CS20210001907828, da0d5a9ae90a386f18b60648a4582b7459e5a951, f0b38630bbf86318d8ef6eb2280b3ed7f2967529, f8c5e280bab3ae2c661ebfc26f22cbfd19b09f2d , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , Problem

Product

SAP SuccessFactors HXM Core 2111