FAAT_DCTR

Transparent Table Temporary Data
7 Fields 1 CDS Views

Depreciation Trace : Header

FAAT_DCTR is an SAP database table in S/4HANA. Depreciation Trace : Header. It contains 7 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_DeprTraceHeader view from CONSUMPTION

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY comp_code BUKRS Company Code
KEY asset_no ANLN1 Asset
KEY asset_subno ANLN2 Sub-number
uname SYUNAME User Name
timestamp TIMESTAMP Time Stamp
b_external_data BOOLE_D TRUE

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.

-- Depreciation Trace : Header
-- Category TRANSPARENT · Delivery class L
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_DCTR (
    CLIENT,           -- abap.clnt
    COMP_CODE,        -- Company Code [BUKRS]
    ASSET_NO,         -- Asset [ANLN1]
    ASSET_SUBNO,      -- Sub-number [ANLN2]
    UNAME,            -- User Name [SYUNAME]
    TIMESTAMP,        -- Time Stamp [TIMESTAMP]
    B_EXTERNAL_DATA,  -- TRUE [BOOLE_D]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO)
);

Learn More