The CD1251 table in SAP ERP or S/4HANA stores Authorization Data for Role data. There are total 7 fields in CD1251 table. The Authorization Data for Role 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 CD1251 table. It is in ABAP Role Administration (Profile Generator) (S_PROFGEN) ABAP package and is part of the ABAP Authorization and Role Management (BC-SEC-AUT-PFC) module.
SAP CD1251 Table Fields
Following is the list of fields that are available in SAP CD1251 table. The primary key fields of the table are AGR_NAME (Role Name), OBJECT (Auth. Object in User Master Maintenance), AUTH (Authorization name in user master maintenance), FIELD (Field name of an authorization), COUNTER (Menu ID for BIW).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| AGR_NAME | Role Name | AGR_NAME | * | CHAR (30) |
| OBJECT | Auth. Object in User Master Maintenance | AGOBJECT | * | CHAR (10) |
| AUTH | Authorization name in user master maintenance | AGAUTH | * | CHAR (12) |
| FIELD | Field name of an authorization | AGRFIELD | CHAR (10) | |
| COUNTER | Menu ID for BIW | MENU_NUM_6 | NUMC (6) | |
| LOW | New Contents of Changed Field | FLDVALN | CHAR (254) | |
| HIGH | New Contents of Changed Field | FLDVALN | CHAR (254) |
