SMI_USR_WORKEXP

Transparent Table Application Table
12 Fields 1 CDS Views

Work Experience Table

SMI_USR_WORKEXP is an SAP database table in S/4HANA. Work Experience Table. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_Somi_Usr_Workexp view from BASIC Work Experience of User Information from Data Provider

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY work_uuid smi_uuid UUID
dataprovidername smi_dataprovidername Data Provider Name
useridindataprovider smi_useridindataprovider User ID DataPrvdr
company smi_company Company Name
companyid smi_companyid Company ID
work_title smi_title Title
companysize smi_companysize Company Size
work_startdate smi_startdate Strt Dt
work_enddate smi_enddate End Date
work_industry smi_industry Industry Name
iscurrentcompany smi_iscurrentcompany Cur Comp

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.

-- Work Experience Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SMI_USR_WORKEXP (
    CLIENT,                -- Client [mandt]
    WORK_UUID,             -- UUID [smi_uuid]
    DATAPROVIDERNAME,      -- Data Provider Name [smi_dataprovidername]
    USERIDINDATAPROVIDER,  -- User ID DataPrvdr [smi_useridindataprovider]
    COMPANY,               -- Company Name [smi_company]
    COMPANYID,             -- Company ID [smi_companyid]
    WORK_TITLE,            -- Title [smi_title]
    COMPANYSIZE,           -- Company Size [smi_companysize]
    WORK_STARTDATE,        -- Strt Dt [smi_startdate]
    WORK_ENDDATE,          -- End Date [smi_enddate]
    WORK_INDUSTRY,         -- Industry Name [smi_industry]
    ISCURRENTCOMPANY,      -- Cur Comp [smi_iscurrentcompany]
    PRIMARY KEY (CLIENT, WORK_UUID)
);

Learn More