The CRMIDXSTA table in SAP ERP or S/4HANA stores CRM: Status Table for Indexing Documents data. There are total 12 fields in CRMIDXSTA table. The CRM: Status Table for Indexing Documents 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 CRMIDXSTA table. It is in Content Management in CRM (CRM_KNOWLEDGE) ABAP package and is part of the Content Management (CRM-BF-COM) module.
SAP CRMIDXSTA Table Fields
Following is the list of fields that are available in SAP CRMIDXSTA table. The primary key fields of the table are MANDT (Client), CATID (Index category identification), PHIO_ID (Physical document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| CATID | Index category identification | SRET_CATID | SRETIDCAT | CHAR (32) |
| PHIO_ID | Physical document | SDOK_PHID | CHAR (32) | |
| PH_CLASS | Physical document class | SDOK_PHCL | CHAR (10) | |
| LANGU | Language Key | SPRAS | LANG (1) | |
| ACTION | Type of action to be performed | SDOK_IDACT | CHAR (1) | |
| STATUS | Indexing/Deindexing Status | SDOK_STAT | CHAR (1) | |
| RCODE | Return code | SRET_RCODE | NUMC (4) | |
| ERROR_CNT | Number of failed attempts at (de)indexing | SDOK_ERCNT | INT1 (3) | |
| CREA_TIME | Creation time (UTC): Long representation | SDOK_LCTST | DEC (21) | |
| NBOFCOMPS | Number of components of a PHIO | SDOK_CNUMB | NUMC (10) | |
| SAPCP | SAP internal code page | SRET_SAPCP | NUMC (4) |
