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 First Name
last_name abap.char Last Name
login_name xubname User
gender acmtst_gender Gender
language spras Language
phone_number abap.char Phone Number
email_address abap.char E-Mail Address
val_start_date abap.dats Start date of Validity
val_end_date abap.dats End date of Validity
currency_code abap.cuky Currency Code
salary_amount abap.curr Yearly Salary
account_number abap.char Account Number
bank_id abap.char Bank ID
bank_name abap.char Name of a bank

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,      -- First Name [abap.char]
    LAST_NAME,       -- Last Name [abap.char]
    LOGIN_NAME,      -- User [xubname]
    GENDER,          -- Gender [acmtst_gender]
    LANGUAGE,        -- Language [spras]
    PHONE_NUMBER,    -- Phone Number [abap.char]
    EMAIL_ADDRESS,   -- E-Mail Address [abap.char]
    VAL_START_DATE,  -- Start date of Validity [abap.dats]
    VAL_END_DATE,    -- End date of Validity [abap.dats]
    CURRENCY_CODE,   -- Currency Code [abap.cuky]
    SALARY_AMOUNT,   -- Yearly Salary [abap.curr]
    ACCOUNT_NUMBER,  -- Account Number [abap.char]
    BANK_ID,         -- Bank ID [abap.char]
    BANK_NAME,       -- Name of a bank [abap.char]
    PRIMARY KEY (CLIENT, UUID)
);

Learn More