STRUSTCRT SAP (Certificates table with certificate status) Table details
Dictionary Type: Table
Description: Certificates table with certificate status
Description: Certificates table with certificate status
Table field list including key, data, relationships and ABAP select examples
STRUSTCRT is a standard SAP Table which is used to store Certificates table with certificate status data and is available within R/3 SAP systems depending on the version and release level.
The STRUSTCRT table consists of various fields, each holding specific information or linking keys about Certificates table with certificate status data available in SAP. These include ISSUERHASH (SHA-1 Issuer Name Checksum), SERIALHASH (SHA-1 Serial number Checksum), STAGING (Staging Value), ISSUER (Certificate Issuer Name).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced
SAP STRUSTCRT table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| ISSUERHASH | SHA-1 Issuer Name Checksum | STRUSTISSUERHASH | RAW | 20 | |||||
| SERIALHASH | SHA-1 Serial number Checksum | STRUSTSERIALHASH | RAW | 20 | |||||
| STAGING | Staging Value | CR_STAGING | CHAR | 1 | CR_STAGING | ||||
| ISSUER | Certificate Issuer Name | CR_CERT_ISSUER | STRG | 0 | |||||
| SUBJECT | Certificate Subject Name | CR_SUBJECT | STRG | 0 | |||||
| SERIAL | Serial Number of Certificate (Dec) | CERTSERIAL | STRG | 0 | |||||
| STATUS | Revocation Status of the Certificate | CERTSTATUS | CHAR | 9 | CERTSTATUS | ||||
| STATUS_SOURCE | Source | CERTSTATUS_SOURCE | CHAR | 7 | CERTSTATUS_SOURCE | ||||
| STATUS_ISSUER_SH | Hash of Issuer Name for Certificate Status | CR_ISSUERHASH | RAW | 20 | |||||
| STATUS_ISSUER | Issuer of CRL | CR_ISSUER | STRG | 0 | |||||
| STATUS_VALIDFROM | Date from which the status is valid | STRUSTSTATUSVALIDFROM | DEC | 15 | TZNTSTMPS | ||||
| STATUS_VALIDTO | Date until which the status is valid | STRUSTSTATUSVALIDTO | DEC | 15 | TZNTSTMPS | ||||
| STATUS_SET_BY | User Name (With Change Document) | STRUSTSYUNAME | CHAR | 12 | SYCHAR12 | ||||
| STATUS_SET_AT | Date on which the status was set | STRUSTSTATUSSETAT | DEC | 15 | TZNTSTMPS | ||||
| CERT_VALIDTO | Date until which the certificate is valid | STRUSTCERTVALIDTO | DEC | 15 | TZNTSTMPS |
| Key field | Non-key field |
How do I retrieve data from SAP table STRUSTCRT using ABAP code
The following ABAP code Example will allow you to do a basic selection on STRUSTCRT to SELECT all data from the tableDATA: WA_STRUSTCRT TYPE STRUSTCRT.
SELECT SINGLE *
FROM STRUSTCRT
INTO CORRESPONDING FIELDS OF WA_STRUSTCRT
WHERE...
How to access SAP table STRUSTCRT
Within an ECC or HANA version of SAP you can also view further information about STRUSTCRT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects