TECDET

Transparent Table Customizing Table
4 Fields 3 CDS Views

Service type text

TECDET is an SAP database table in S/4HANA. Service type text. It contains 4 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
/UCOM/I_MCM_TECDET view_entity from BASIC Basic View
I_UtilsServiceProviderRoleText view from BASIC Service Provider Role - Text
TECDE_CDS view left_outer

Fields (4)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY service SERCODE Service Type
KEY spras SPRAS Language
servicetext SERVICETEXT Service Type

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.

-- Service type text
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TECDET (
    MANDT,        -- Client [MANDT]
    SERVICE,      -- Service Type [SERCODE]
    SPRAS,        -- Language [SPRAS]
    SERVICETEXT,  -- Service Type [SERVICETEXT]
    PRIMARY KEY (MANDT, SERVICE, SPRAS)
);

Learn More