SAP AFRUHR Order Confirmations for HR Table
Overview
AFRUHR is a standard SAP S/4HANA table that stores Order Confirmations for HR data. There are total 26 fields in the AFRUHR table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AFRUHR belongs to Personnel Time Management (PT) module and is located in the package HR Time Management Application Development (PTIM).
In addition, following links provide an overview of foreign key relationships, if any, that link AFRUHR to other SAP tables and standard CDS views available based on AFRUHR table in S/4HANA 2020.
Techincal Settings of AFRUHR
Below are technical details of the table AFRUHR
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AFRUHR Fields
The following table gives you an overview of the fields available in AFRUHR
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| RUECK | Completion confirmation number for the operation | PW_RUECK | NUMC | 10 | |
| RMZHL | Confirmation counter | PW_RMZHL | NUMC | 8 | |
| BUDAT | Posting date | PW_BUDAT | DATS | 8 | |
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | |
| AUFNR | Order Number | PW_AUFNR | * | CHAR | 12 |
| STOKZ | Indicator: "Confirmation Canceled" | PW_STOKZ | CHAR | 1 | |
| STZHL | Confirmation counter of canceled confirmation | PW_STZHL | NUMC | 8 | |
| UNAME1 | User who wrote record to interface | PW_UNAME1 | CHAR | 12 | |
| DATUM1 | Date on which record was written to interface | PW_DATUM1 | DATS | 8 | |
| UZEIT1 | Time at which record was written to interface | PW_UZEIT1 | TIMS | 6 | |
| PGMID1 | Write Record to Interface Report | PW_PGMID1 | CHAR | 40 | |
| UNAME2 | Name of user who initially accessed record | PW_UNAME2 | CHAR | 12 | |
| DATUM2 | Date on which record was initially accessed | PW_DATUM2 | DATS | 8 | |
| UZEIT2 | Time at which record was initially accessed | PW_UZEIT2 | TIMS | 6 | |
| PGMID2 | Report used to access record initially | PW_PGMID2 | CHAR | 40 | |
| STATU2 | Log status when record was first accessed | PW_STATU2 | CHAR | 1 | |
| UNAME3 | Last user to access record | PW_UNAME3 | CHAR | 12 | |
| DATUM3 | Date on which record was last accessed | PW_DATUM3 | DATS | 8 | |
| UZEIT3 | Time at which record was last accessed | PW_UZEIT3 | TIMS | 6 | |
| PGMID3 | Last Used to Access Record Program | PW_PGMID3 | CHAR | 40 | |
| STATU3 | Log status when record was last accessed | PW_STATU3 | CHAR | 1 | |
| UNAME4 | User who first retrieved the record successfully | PW_UNAME4 | CHAR | 12 | |
| DATUM4 | Date on which record was first retrieved successfully | PW_DATUM4 | DATS | 8 | |
| UZEIT4 | Time at which record was first retrieved successfully | PW_UZEIT4 | TIMS | 6 | |
| PGMID4 | Report first used to retrieve record successfully | PW_PGMID4 | CHAR | 40 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AFRUHR
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AFRUHR | MANDT | 1: CN | T000 |