CLMS_TENANT

Transparent Table Temporary Data
20 Fields 3 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. 3 CDS views read from this table.

CDS Views using this table (3)

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
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