The CKLTEX table in SAP ERP or S/4HANA stores Generic store for extracts data. There are total 19 fields in CKLTEX table. The Generic store for extracts 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 CKLTEX table. It is in DDIC Objects for CM_Extract (K_CM_EXTRACT_DDIC) ABAP package and is part of the Cross-Application Components (CA) module.
SAP CKLTEX Table Fields
Following is the list of fields that are available in SAP CKLTEX table. The primary key fields of the table are MANDT (Client), RELID (Region in IMPORT/EXPORT Data Table), REPORT (ABAP Program Name), VRNT (ABAP: Name of variant (without program name)), HANDLE (Mgt. ID for repeated calls from the same program), LOG_GROUP (Logical group name), USERNAME (User name for user-specific storage), EXNAME (Extract Name), TYPE (Type (internal use)), DISVARIANT (Layout), SRTF2 (Next record counter in EXPORT/IMPORT data tables).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | * | CLNT (3) |
| RELID | Region in IMPORT/EXPORT Data Table | INDX_RELID | CHAR (2) | |
| REPORT | ABAP Program Name | REPID | CHAR (40) | |
| VRNT | ABAP: Name of variant (without program name) | VARIANT | * | CHAR (14) |
| HANDLE | Mgt. ID for repeated calls from the same program | SLIS_HANDL | CHAR (4) | |
| LOG_GROUP | Logical group name | SLIS_LOGGR | CHAR (4) | |
| USERNAME | User name for user-specific storage | SLIS_USER | CHAR (12) | |
| EXNAME | Extract Name | CK_EXTR | CHAR (12) | |
| TYPE | Type (internal use) | SLIS_TYPE | CHAR (1) | |
| DISVARIANT | Layout | SLIS_VARI | CHAR (12) | |
| SRTF2 | Next record counter in EXPORT/IMPORT data tables | INDX_SRTF2 | INT4 (10) | |
| TEXT | Extract Name | CK_EXBZ | CHAR (40) | |
| VERSION | Object version | VERSION | NUMC (6) | |
| ERFDAT | Display variant creation date | SLIS_ERDAT | DATS (8) | |
| ERFTIME | Display variant creation time | SLIS_ERTIM | TIMS (6) | |
| ERFNAME | Display variant creator | SLIS_ERNAM | CHAR (12) | |
| DATA | Information on MiniALV Extract | CK_EXDATA | CHAR (60) | |
| CLUSTR | Length field for user data in EXPORT/IMPORT tables | INDX_CLSTR | INT2 (5) | |
| CLUSTD | Data field for IMPORT/EXPORT database tables | INDX_CLUST | LRAW (2886) |
