/TMF/D_CCITMSTAT

Transparent Table Application Table
10 Fields 1 CDS Views

Fixed Asset Credit Amount Item Status

/TMF/D_CCITMSTAT is an SAP database table in S/4HANA. Fixed Asset Credit Amount Item Status. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_ImprtFxdAstCrdtAmtItemSts view from BASIC Basic for Import Fixed Assets Item Status

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY company_code BUKRS Company Code
KEY asset_class /TMF/DE_ASSET_CLASS Asset Class
KEY fiscal_year GJAHR Fiscal Year
KEY fiscal_period /TMF/DE_DEPREC_FISCAL_PERIOD Period
KEY asset_number ANLN1 Asset
KEY asset_subnumber ANLN2 Sub-number
quota_status /TMF/DE_ASSET_QUOTA_STATUS Quota Status
changed_by UNAME User Name
changed_on /TMF/DE_LOG_DATETIME Logging Date/Time

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.

-- Fixed Asset Credit Amount Item Status
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE /TMF/D_CCITMSTAT (
    CLIENT,           -- Client [MANDT]
    COMPANY_CODE,     -- Company Code [BUKRS]
    ASSET_CLASS,      -- Asset Class [/TMF/DE_ASSET_CLASS]
    FISCAL_YEAR,      -- Fiscal Year [GJAHR]
    FISCAL_PERIOD,    -- Period [/TMF/DE_DEPREC_FISCAL_PERIOD]
    ASSET_NUMBER,     -- Asset [ANLN1]
    ASSET_SUBNUMBER,  -- Sub-number [ANLN2]
    QUOTA_STATUS,     -- Quota Status [/TMF/DE_ASSET_QUOTA_STATUS]
    CHANGED_BY,       -- User Name [UNAME]
    CHANGED_ON,       -- Logging Date/Time [/TMF/DE_LOG_DATETIME]
    PRIMARY KEY (CLIENT, COMPANY_CODE, ASSET_CLASS, FISCAL_YEAR, FISCAL_PERIOD, ASSET_NUMBER, ASSET_SUBNUMBER)
);

Learn More