CLMS_TENANT

Transparent Table Temporary Data
20 Fields 4 CDS Views

Tenant Information (Extension to T000)

CLMS_TENANT is an SAP database table in S/4HANA. Tenant Information (Extension to T000). It contains 20 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
APS_OM_TenantURL view from Tenant URL for Print Client
CLMS_V_TM_VTR_OBJ_STATUS view inner Multiplex status of objects of virtual transport
I_STJR_CONFIG view left_outer View of Technical Job Repository Config.
KSR_I_TM_DUMMY_TENANT_R view left_outer KSR: Tenant Dummy

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
tenant_id SLIC_SYSID System ID
tenant_url CLMS_TENANT_URL Tenant URL
tenant_role CLMS_TENANT_ROLE Tenant Role
business_type CLMS_BUSINESS_TYPE Business Type
tm_user XUBNAME User
tm_relevance CLMS_TM_RELEVANCE CLMS: Tenant Multiplexer Relevance
jr_user XUBNAME User
jr_relevance CLMS_JR_RELEVANCE Job Repository Rel.
business_sys_id CLMS_BUSINESS_SYS_ID Business Sys. ID
entitlement_tenant_id SLIC_SYSID System ID
entitlement_sub_account_id TEXT40 Name
entitlement_glo_account_id TEXT40 Name
tenant_api_url CLMS_TENANT_URL Tenant URL
tenant_adm_url CLMS_TENANT_URL Tenant URL
tenant_ui_url CLMS_TENANT_URL Tenant URL
tenant_readiness CLMS_TENANT_READINESS Tenant Ready
tenant_prov_adm_url CLMS_TENANT_URL Tenant URL
tenant_prov_api_url CLMS_TENANT_URL Tenant URL
tenant_zone_id CLMS_ZONE_ID Zone ID

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Tenant Information (Extension to T000)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CLMS_TENANT (
    CLIENT,                      -- Client [MANDT]
    TENANT_ID,                   -- System ID [SLIC_SYSID]
    TENANT_URL,                  -- Tenant URL [CLMS_TENANT_URL]
    TENANT_ROLE,                 -- Tenant Role [CLMS_TENANT_ROLE]
    BUSINESS_TYPE,               -- Business Type [CLMS_BUSINESS_TYPE]
    TM_USER,                     -- User [XUBNAME]
    TM_RELEVANCE,                -- CLMS: Tenant Multiplexer Relevance [CLMS_TM_RELEVANCE]
    JR_USER,                     -- User [XUBNAME]
    JR_RELEVANCE,                -- Job Repository Rel. [CLMS_JR_RELEVANCE]
    BUSINESS_SYS_ID,             -- Business Sys. ID [CLMS_BUSINESS_SYS_ID]
    ENTITLEMENT_TENANT_ID,       -- System ID [SLIC_SYSID]
    ENTITLEMENT_SUB_ACCOUNT_ID,  -- Name [TEXT40]
    ENTITLEMENT_GLO_ACCOUNT_ID,  -- Name [TEXT40]
    TENANT_API_URL,              -- Tenant URL [CLMS_TENANT_URL]
    TENANT_ADM_URL,              -- Tenant URL [CLMS_TENANT_URL]
    TENANT_UI_URL,               -- Tenant URL [CLMS_TENANT_URL]
    TENANT_READINESS,            -- Tenant Ready [CLMS_TENANT_READINESS]
    TENANT_PROV_ADM_URL,         -- Tenant URL [CLMS_TENANT_URL]
    TENANT_PROV_API_URL,         -- Tenant URL [CLMS_TENANT_URL]
    TENANT_ZONE_ID,              -- Zone ID [CLMS_ZONE_ID]
    PRIMARY KEY (CLIENT)
);

Learn More