The CFX_HIST_AUTH table in SAP ERP or S/4HANA stores Saves all Changes to Authorization Objects data. There are total 11 fields in CFX_HIST_AUTH table. The Saves all Changes to Authorization Objects table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CFX_HIST_AUTH table. It is in Object History Management (CFX_HISTORY) ABAP package and is part of the Collaboration Folders (PLM-CFO) module.
SAP CFX_HIST_AUTH Table Fields
Following is the list of fields that are available in SAP CFX_HIST_AUTH table. The primary key fields of the table are MANDT (Client), ACTION_ID (GUID in ‘RAW’ format).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| ACTION_ID | GUID in ‘RAW’ format | GUID_16 | RAW (16) | |
| OBJECT_ID | Object ID | ACO_OBJECT_ID | RAW (16) | |
| ACTIVITY | Activity for Authorization Check | ACO_ACTVT | CHAR (10) | |
| USER_ID | User ID | CFX_USERID | CHAR (12) | |
| ACTION_DATE | UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) | TIMESTAMPL | DEC (21) | |
| REF_USER | User ID | CFX_USERID | CHAR (12) | |
| REF_USERGRP | GUID in ‘RAW’ format | GUID_16 | RAW (16) | |
| REF_ROLE | Role Name | AGR_NAME | CHAR (30) | |
| COL_ID | GUID in ‘CHAR’ Format in Uppercase | GUID_32 | CHAR (32) | |
| ACO_OBJ_TYPE | Object Category | ACO_OBJECT_TYPE | CHAR (15) |
