SAP Knowledge Base Article - Public

2079964 - API Ad Hoc Reporting ids - Employee Central

Symptom

  • Within the API what are the IDs used with EC Ad Hoc Reporting?
  • API jobs often use EC Ad Hoc Reports to pull data for integration purposes. API integration can utilise a code that identifies a call to run a specific Ad Hoc Report Sub Domain Schema. What ID code relates to which Ad Hoc Report?

Environment

  • Employee Central

Resolution

  • ADHOC_ectft is the Foundation Objects Report. This query extracts Foundation Objects. Each view/field group represents a single object.
  • ADHOC_ectint is the Person and Employment Info (as of Date) Report. This shows employee data as of a given date (today by Default) - a snapshot of related person and employment objects for each Employee.
  • ADHOC_ectAudInfo is the Person and Employment Audit Report. This shows Employee Audit trail data. This returns all change history for person and employment objects for each employee.
  • ADHOC_ectExport is the Person and Employment Export Report. This exports all effective and non-effective dated records for employees. Employee data is exported in a format ready for reimport.
  • ADHOC_ectintJobInfo is the Job Information (Date Range) Report. This returns a row for each employee Job Information event.
  • ADHOC_ectintCompInfo is the Recurring Compensation Information (Date Range) Report. This provides Employee data within a given data range, driven by recurring compensation information – arrow is rreturned for each employee Compensation Information event.
  • ADHOC_ectintBonusPayout is the Non-Recurring Compensation (Date Range) Report. This returns all non-recurring pay components whose payout date is within a specified date range.

Keywords

KBA , sf integration , sf api , sf employee central , LOD-SF-EC , Employee Central , How To

Product

SAP SuccessFactors HCM Core all versions