FDT_ADMN_0000S

Transparent Table System Table (SAP only)
27 Fields 1 CDS Views

FDT: Central Administrative Data

FDT_ADMN_0000S is an SAP database table in S/4HANA. FDT: Central Administrative Data. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
cs4sic_hana_rules_framework_ci view inner Customer Analytic Functions (clnt indep)

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY id FDT_UUID Universal Unique ID
object_type FDT_OBJECT_TYPE Object Type
version FDT_VERSION Version
name FDT_NAME Name
application_id FDT_UUID Universal Unique ID
access_level FDT_ACCESS_LEVEL Access Level
cr_user SYUNAME User Name
cr_timestamp TIMESTAMP Time Stamp
ch_user SYUNAME User Name
ch_timestamp TIMESTAMP Time Stamp
deleted FDT_DELETED_OPTION Deleted Option
transported BOOLE_D TRUE
depl_timestamp TIMESTAMP Time Stamp
wtt_timestamp FDT_WTT_TIMESTAMP WriteToTransport Tim
osysid SYSYSID SAP System ID
osysclient MANDTDATA Client
obsolete BOOLE_D TRUE
local_object BOOLE_D TRUE
job_id FDT_JOB_UUID Job ID
tv_state FDT_TV_STATE Truncate Vers. State
tv_timestamp FDT_TV_TIMESTAMP Version Drop Date
tv_set_timestamp TIMESTAMP Time Stamp
p_tv_timestamp FDT_PHY_TV_TIMESTAMP Ph. Ver. Drop Date
p_tv_set_tmstmp TIMESTAMP Time Stamp
cr_release SAPRELEASE SAP Release
ch_release SAPRELEASE SAP Release
source_appl_id 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.

-- FDT: Central Administrative Data
-- Category TRANSPARENT · Delivery class S
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FDT_ADMN_0000S (
    ID,                -- Universal Unique ID [FDT_UUID]
    OBJECT_TYPE,       -- Object Type [FDT_OBJECT_TYPE]
    VERSION,           -- Version [FDT_VERSION]
    NAME,              -- Name [FDT_NAME]
    APPLICATION_ID,    -- Universal Unique ID [FDT_UUID]
    ACCESS_LEVEL,      -- Access Level [FDT_ACCESS_LEVEL]
    CR_USER,           -- User Name [SYUNAME]
    CR_TIMESTAMP,      -- Time Stamp [TIMESTAMP]
    CH_USER,           -- User Name [SYUNAME]
    CH_TIMESTAMP,      -- Time Stamp [TIMESTAMP]
    DELETED,           -- Deleted Option [FDT_DELETED_OPTION]
    TRANSPORTED,       -- TRUE [BOOLE_D]
    DEPL_TIMESTAMP,    -- Time Stamp [TIMESTAMP]
    WTT_TIMESTAMP,     -- WriteToTransport Tim [FDT_WTT_TIMESTAMP]
    OSYSID,            -- SAP System ID [SYSYSID]
    OSYSCLIENT,        -- Client [MANDTDATA]
    OBSOLETE,          -- TRUE [BOOLE_D]
    LOCAL_OBJECT,      -- TRUE [BOOLE_D]
    JOB_ID,            -- Job ID [FDT_JOB_UUID]
    TV_STATE,          -- Truncate Vers. State [FDT_TV_STATE]
    TV_TIMESTAMP,      -- Version Drop Date [FDT_TV_TIMESTAMP]
    TV_SET_TIMESTAMP,  -- Time Stamp [TIMESTAMP]
    P_TV_TIMESTAMP,    -- Ph. Ver. Drop Date [FDT_PHY_TV_TIMESTAMP]
    P_TV_SET_TMSTMP,   -- Time Stamp [TIMESTAMP]
    CR_RELEASE,        -- SAP Release [SAPRELEASE]
    CH_RELEASE,        -- SAP Release [SAPRELEASE]
    SOURCE_APPL_ID,    -- abap.char
    PRIMARY KEY (ID)
);

Learn More