ACMTST_DB_EMPL

Transparent Table Temporary Data
17 Fields 1 CDS Views

ACMTST: Employee (DB-Table)

ACMTST_DB_EMPL is an SAP database table in S/4HANA. ACMTST: Employee (DB-Table). It contains 17 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Acmtst_Ddl_Language view from Employee language

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY uuid ACMTST_ID ID
employee_id ACMTST_EMPLOYEE_ID Employee ID
first_name abap.char
last_name abap.char
login_name XUBNAME User
gender ACMTST_GENDER Gender
language SPRAS Language
phone_number abap.char
email_address abap.char
val_start_date abap.dats
val_end_date abap.dats
currency_code abap.cuky
salary_amount abap.curr
account_number abap.char
bank_id abap.char
bank_name 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.

-- ACMTST: Employee (DB-Table)
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACMTST_DB_EMPL (
    CLIENT,          -- Client [MANDT]
    UUID,            -- ID [ACMTST_ID]
    EMPLOYEE_ID,     -- Employee ID [ACMTST_EMPLOYEE_ID]
    FIRST_NAME,      -- abap.char
    LAST_NAME,       -- abap.char
    LOGIN_NAME,      -- User [XUBNAME]
    GENDER,          -- Gender [ACMTST_GENDER]
    LANGUAGE,        -- Language [SPRAS]
    PHONE_NUMBER,    -- abap.char
    EMAIL_ADDRESS,   -- abap.char
    VAL_START_DATE,  -- abap.dats
    VAL_END_DATE,    -- abap.dats
    CURRENCY_CODE,   -- abap.cuky
    SALARY_AMOUNT,   -- abap.curr
    ACCOUNT_NUMBER,  -- abap.char
    BANK_ID,         -- abap.char
    BANK_NAME,       -- abap.char
    PRIMARY KEY (CLIENT, UUID)
);

Learn More