Skip to content

Export layout; receiver validation required

SAP CATS attendance exports

Prepare CATS-oriented attendance CSV rows, then validate personnel numbers, time types and receiving objects in your SAP import process.

What Attendify produces

The SAP CATS layout is a downloadable CSV derived from reviewed attendance hours. Its columns are PERNR, WORKDATE, CATSHOURS, UNIT, LSTAR, REC_ORDER, AWART and REMARK. It uses the worker’s payroll ID as PERNR and formats the work date as day.month.year.

This is a CATS-oriented source file, not a certified connector or a direct write into SAP. Your integration owner chooses the supported receiving interface and validates the mapping against the relevant SAP system and profile.

Resolve the receiving object before importing

Attendify currently places the site name in REC_ORDER. A site called “North Depot” is not automatically a valid SAP order number. Map it to the receiver’s configured object. Confirm the activity type, attendance/absence type and personnel number; defaults are not a substitute for your configuration.

Illustrative source row: payroll ID 0001042, work date 06.09.2026, 7.50 hours, unit H and site name North Depot. The row demonstrates the source meaning, not a successfully accepted SAP posting.

Review before and after the handoff

Days with blocking attendance exceptions do not generate policy-export rows. Workers without payroll IDs are excluded from this named format and reported as unmapped. Reconcile the exported worker count and hours with exclusions before handing the file onward.

Then run the receiving system’s validation or test process and retain its result. SAP provides supported BAPI paths with profile/error checks; a BAPI call is not equivalent to bypassing validation through direct table writes. See SAP’s CATS BAPI guidance.

Confirm the acceptance test

Include a normal day, an overnight shift, an applied correction, an invalid order and an unmapped worker. Decide how a corrected period is reissued without duplicating time. Automatic scheduled delivery and end-to-end target acceptance are not promised by the existence of this export.

Continue the workflow

Bring your actual attendance workflow.

Tell us your worker and site counts, operating countries and payroll system. We can discuss fit, current availability and the checks needed for your rollout.

Discuss your rollout