Reply from Kumar Dave on Apr 24 at 2:53 AM Hi, Please change the selection filed / criteria Too many selection criteria will be conflicts. select few field. Hence, the best way to fetch up entire records follow below selection 1- TAKE reporting period = PAST (untill today) 2- SELECT few filed = Co code, EG,ESG Hope this help... Best regards, Kumar Dave
| | | ---------------Original Message--------------- From: SAP-HR-User Sent: Monday, April 23, 2012 3:21 AM Subject: sqvi: Query for HR Custom Report Dear All, I need a report via QuickViewer, I used tables (PA0000, PA0002, PA0001) but the output coming is only for 1000 employees where as from standard tables I am getting 1lkh+ records. 1. SAP Code. 2. Employee Name. 3. Employee group 4. Employment Status Criteria : 1) Till date all the active & inactive records. 2) As on a particular date all active inactive records. (eg: all active & inactive records as on 31.3.2012, from the time first employee code was created) List Fields: P0000-MASSN, P0000-MASSG, P0000-PERNR, P0000-STAT2, SYHR_A_P0000_AF_FIREDATE, SYHR_A_P0000_AF_HIREDATE, P0001-PERSG, P0001-PERSK Selection Fields: P0000-MASSN, P0000-STAT2, SYHR_A_P0000_AF_FIREDATE, SYHR_A_P0000_AF_HIREDATE, P0001-PERSG. Please suggest why the output is incorrect. Regards | | Reply to this email to post your response. __.____._ | _.____.__ |