/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