Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
We are using SAP ECC 6.0 with EhP 6.
e have SAP Connector.
We are trying to get the "Exception Report" from SAP :- "List of Employees who have not marked their Attendance on a particular day".
This report will be scheduled with "N-printing solution" and will be sent to the Site Timekeepers everyday 30 mins after the "Shift Start Time".
This is equivalent to creating and comparing two Excel Sheets
a. List of Employees who are supposed to be "Working" on a particular day say 01-01-2016.
b. List of Employees who have marked Attendance (Time IN) on the same day (01-01-2016).
c. Use VLOOKUP formula in first sheet to know the list of Employees who have NOT marked their attendance.
I am attaching the detailed requirement document for reference.
May I request for your help as "How to achieve this?"
Regards,
Parag Sinkar
Dear all,
Attaching excel with detailed explanation that will bring additional clarity to the requirement.
Regards,
Parag Sinkar.