Symptom
- Cannot Report On Pay Component Group Associate with Pay Component In Adhoc Report
- Cannot report on Foundation object
Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.
Environment
Employee Central - Adhoc report
Reproducing the Issue
- Go to Adhoc report -Foundation Object
- Select all Pay Component Group
- Run report Ad Hoc Reports Export Offline or Ad Hoc Reports Export Online
- Result: Error message
@Employee Central Product Support: See internal memo for further guidance
Cause
Product limitation
- Go to admin center - Manage organization, Pay and job Structures
- Select Foundation Object Pay Component Group
- Pay Component Group associated with 120 Pay Components
Case Example: 5000 characters.
Resolution
While reporting on Pay Component group, The system need to identify all the Pay components which constitutes the Pay Component Group and the Pay components will be separated by Pipe '|' symbol. This entire string consisting of Pay comps separated by "|" symbol can't exceed 4000 characters as it's a limitation in Database.
- limitation from the Database side as "XMLELEMENT" has size limitation of 4000 characters.
- "The identifier can be up to 4000 characters and does not have to be a column name or column reference"
Example : How to Determine the number of characters
Step: 1
- Go to admin center - Manage organization, Pay and job Structures
- Select Foundation Object Pay Component Group
- Copy all associated Pay Component
Case Example: 1271 characters.
Step 2: Note Pad
- Copy and paste into a text editor like Notepad
- See below example in this case : number of character= 1271
FAQ - Additional Information
Q) how many pay component can I add to Pay group Via UI or Manage organization, Pay and job Structures?
A) There is no limitation.
Q) Provide any best practice
A) it's not a best practice to combine 100 of Pay comps in single Pay Comp Group.
Keywords
ECT-109498, 4000, characters, Pay Component group, Ad Hoc Reports Export Offline ,Ad Hoc Reports Export Online , monitor job, provisioning, Pay component, Foundation Object , KBA , LOD-SF-EC-REP , Reporting Data (EC core only) , LOD-SF-EC-FOO , Foundation Objects (Organisation, Pay and Job Structures) , Problem