SMI_USR_EDCTN

Transparent Table Application Table
11 Fields 2 CDS Views

Education Table

SMI_USR_EDCTN is an SAP database table in S/4HANA. Education Table. It contains 11 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_Somi_Usr_Certification view from BASIC Certification Information of User From Data Provider
I_Somi_Usr_Education view from BASIC Education Information for User provided from Data Provider

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY edu_uuid SMI_UUID UUID
dataprovidername SMI_DATAPROVIDERNAME Data Provider Name
useridindataprovider SMI_USERIDINDATAPROVIDER User ID DataPrvdr
school SMI_SCHOOL School
schooltype SMI_SCHOOLTYPE Sch Type
fieldofstudy SMI_FIELDOFSTUDY Fld of Stdy
degree SMI_DEGREE User Qualification
startyear SMI_STARTYEAR Strt Yr
endyear SMI_ENDYEAR End Year
dummy_usr_edctn abap.char

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.

-- Education Table
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE SMI_USR_EDCTN (
    CLIENT,                -- Client [MANDT]
    EDU_UUID,              -- UUID [SMI_UUID]
    DATAPROVIDERNAME,      -- Data Provider Name [SMI_DATAPROVIDERNAME]
    USERIDINDATAPROVIDER,  -- User ID DataPrvdr [SMI_USERIDINDATAPROVIDER]
    SCHOOL,                -- School [SMI_SCHOOL]
    SCHOOLTYPE,            -- Sch Type [SMI_SCHOOLTYPE]
    FIELDOFSTUDY,          -- Fld of Stdy [SMI_FIELDOFSTUDY]
    DEGREE,                -- User Qualification [SMI_DEGREE]
    STARTYEAR,             -- Strt Yr [SMI_STARTYEAR]
    ENDYEAR,               -- End Year [SMI_ENDYEAR]
    DUMMY_USR_EDCTN,       -- abap.char
    PRIMARY KEY (CLIENT, EDU_UUID)
);

Learn More