CTE_C_CONNECTION

Transparent Table Customizing Table
15 Fields 1 CDS Views

Connection information for Concur systems

CTE_C_CONNECTION is an SAP database table in S/4HANA. Connection information for Concur systems. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
CTE_CDS_SYSTEM view from CDS Help View for System Key

Fields (15)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY system_key CTE_SYSTEM_KEY_NUMBER System Key
rfc_connection RFCDEST Destination
concur_user_name CTE_CONCUR_USER_NAME User Name
token_expiration CTE_TOKEN_EXPIRATION_DATE Token Exp. Date
concur_def_langu CTE_CONCUR_DEFAULT_LANGU Default Language
concur_companyid CTE_CONCUR_COMPANY_ID Concur Company ID
concur_host_name CTE_URL Concur Host
concur_gateway_host_name CTE_GATEWAY_URL Gateway Host
middleware_active_ind CTE_MIDDLEWARE_ACTIVE_IND Middleware
partner_system_detail_id CTE_FND_MAP_SERVICE_ID Mapping Service ID
protect_ind CTE_SYSTEM_PROTECT_IND System protected
original_logical_system LOGSYS Logical system
original_system CTE_SAP_SYSTEM_IDENTIFIER SAP Sys. Ident.
is_rqa_test_sys CTE_BOOLEAN Boolean

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.

-- Connection information for Concur systems
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CTE_C_CONNECTION (
    CLIENT,                    -- Client [MANDT]
    SYSTEM_KEY,                -- System Key [CTE_SYSTEM_KEY_NUMBER]
    RFC_CONNECTION,            -- Destination [RFCDEST]
    CONCUR_USER_NAME,          -- User Name [CTE_CONCUR_USER_NAME]
    TOKEN_EXPIRATION,          -- Token Exp. Date [CTE_TOKEN_EXPIRATION_DATE]
    CONCUR_DEF_LANGU,          -- Default Language [CTE_CONCUR_DEFAULT_LANGU]
    CONCUR_COMPANYID,          -- Concur Company ID [CTE_CONCUR_COMPANY_ID]
    CONCUR_HOST_NAME,          -- Concur Host [CTE_URL]
    CONCUR_GATEWAY_HOST_NAME,  -- Gateway Host [CTE_GATEWAY_URL]
    MIDDLEWARE_ACTIVE_IND,     -- Middleware [CTE_MIDDLEWARE_ACTIVE_IND]
    PARTNER_SYSTEM_DETAIL_ID,  -- Mapping Service ID [CTE_FND_MAP_SERVICE_ID]
    PROTECT_IND,               -- System protected [CTE_SYSTEM_PROTECT_IND]
    ORIGINAL_LOGICAL_SYSTEM,   -- Logical system [LOGSYS]
    ORIGINAL_SYSTEM,           -- SAP Sys. Ident. [CTE_SAP_SYSTEM_IDENTIFIER]
    IS_RQA_TEST_SYS,           -- Boolean [CTE_BOOLEAN]
    PRIMARY KEY (CLIENT, SYSTEM_KEY)
);

Learn More