The CLMS_TENANT table in SAP ERP or S/4HANA stores Tenant Information (Extension to T000) data. There are total 14 fields in CLMS_TENANT table. The Tenant Information (Extension to T000) 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 CLMS_TENANT table. It is in Cloud Management Services: Tenant Information (SCLMS_TENANT) ABAP package and is part of the Cloud Management Services (BC-SRV-APS-CLM) module.
SAP CLMS_TENANT Table Fields
Following is the list of fields that are available in SAP CLMS_TENANT table. The primary key fields of the table are CLIENT (Client).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| TENANT_URL | CLMS: Tenant URL | CLMS_TENANT_URL | CHAR (255) | |
| TENANT_ROLE | CLMS: Tenant Role | CLMS_TENANT_ROLE | CHAR (2) | |
| BUSINESS_TYPE | CLMS: Tenant Business Type | CLMS_BUSINESS_TYPE | CHAR (20) | |
| TM_USER | User Name in User Master Record | XUBNAME | CHAR (12) | |
| TM_RELEVANCE | CLMS: Tenant Multiplexer Relevance | CLMS_TM_RELEVANCE | CHAR (1) | |
| JR_USER | User Name in User Master Record | XUBNAME | CHAR (12) | |
| JR_RELEVANCE | CLMS: Job Repository Relevance | CLMS_JR_RELEVANCE | CHAR (1) | |
| ENTITLEMENT_SUB_ACCOUNT_ID | Text, 40 Characters Long | TEXT40 | CHAR (40) | |
| ENTITLEMENT_GLO_ACCOUNT_ID | Text, 40 Characters Long | TEXT40 | CHAR (40) | |
| TENANT_API_URL | CLMS: Tenant URL | CLMS_TENANT_URL | CHAR (255) | |
| TENANT_ADM_URL | CLMS: Tenant URL | CLMS_TENANT_URL | CHAR (255) | |
| TENANT_UI_URL | CLMS: Tenant URL | CLMS_TENANT_URL | CHAR (255) | |
| TENANT_READINESS | CLMS: Tenant Readiness | CLMS_TENANT_READINESS | CHAR (1) |
