FAAT_MD_TDD

Transparent Table Application Table
32 Fields 4 CDS Views

Fixed Asset Master: Time Dependent Data

FAAT_MD_TDD is an SAP database table in S/4HANA. Fixed Asset Master: Time Dependent Data. It contains 32 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
E_FixedAssetAssgmt view from EXTENSION Extension View for FAA Master TDD Data
FAA_ASSETASSIGNMENTS4 view from Unit Test View for Asset Assignment
FAA_ES_ASSET_MD_TDD view from Fixed Asset Time Dependent Data (current intervall) for Enterprise Search
P_FixedAssetAssgmt view union_all BASIC

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY comp_code BUKRS Company Code
KEY asset_no ANLN1 Asset
KEY asset_subno ANLN2 Sub-number
KEY valid_to_date BDATU Valid To
valid_from_date ADATU Valid From
business_area GSBER Business Area
cost_center KOSTL Cost Center
activity_type LSTAR Activity Type
internal_order CAUFN Int. Order
fund BP_GEBER Fund
grant_id GM_GRANT_NBR Grant
functional_area FKBER Functional Area
funds_center FISTL Funds Center
wbs_element FAA_MD_WBSELEMENT WBS Internal ID
tax_jurisdiction TXJCD Tax Jur.
real_estate_key IMKEY Real Estate Key
segment FB_SEGMENT Segment
profit_center PRCTR Profit Center
budget_period FM_BUDGET_PERIOD Budget Period
responsible_cost_center KOSTLV Resp. Cost Ctr
room RAUMNR Room
plant WERKS_D Plant
location STORT Location
car_license_plate AM_KFZKZ License Plate Number
personnel_number PERNR_D Personnel No.
business_place BUPLA Business place
awtyp AWTYP Ref. procedure
awsys AWSYS Logical System
awref AWREF Reference Doc.
aworg AWORG Refer. Org.Unit
dummy_faa_md_tdd_eew_ps CFD_DUMMY Dummy

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 Master: Time Dependent Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_MD_TDD (
    CLIENT,                   -- Client [MANDT]
    COMP_CODE,                -- Company Code [BUKRS]
    ASSET_NO,                 -- Asset [ANLN1]
    ASSET_SUBNO,              -- Sub-number [ANLN2]
    VALID_TO_DATE,            -- Valid To [BDATU]
    VALID_FROM_DATE,          -- Valid From [ADATU]
    BUSINESS_AREA,            -- Business Area [GSBER]
    COST_CENTER,              -- Cost Center [KOSTL]
    ACTIVITY_TYPE,            -- Activity Type [LSTAR]
    INTERNAL_ORDER,           -- Int. Order [CAUFN]
    FUND,                     -- Fund [BP_GEBER]
    GRANT_ID,                 -- Grant [GM_GRANT_NBR]
    FUNCTIONAL_AREA,          -- Functional Area [FKBER]
    FUNDS_CENTER,             -- Funds Center [FISTL]
    WBS_ELEMENT,              -- WBS Internal ID [FAA_MD_WBSELEMENT]
    TAX_JURISDICTION,         -- Tax Jur. [TXJCD]
    REAL_ESTATE_KEY,          -- Real Estate Key [IMKEY]
    SEGMENT,                  -- Segment [FB_SEGMENT]
    PROFIT_CENTER,            -- Profit Center [PRCTR]
    BUDGET_PERIOD,            -- Budget Period [FM_BUDGET_PERIOD]
    RESPONSIBLE_COST_CENTER,  -- Resp. Cost Ctr [KOSTLV]
    ROOM,                     -- Room [RAUMNR]
    PLANT,                    -- Plant [WERKS_D]
    LOCATION,                 -- Location [STORT]
    CAR_LICENSE_PLATE,        -- License Plate Number [AM_KFZKZ]
    PERSONNEL_NUMBER,         -- Personnel No. [PERNR_D]
    BUSINESS_PLACE,           -- Business place [BUPLA]
    AWTYP,                    -- Ref. procedure [AWTYP]
    AWSYS,                    -- Logical System [AWSYS]
    AWREF,                    -- Reference Doc. [AWREF]
    AWORG,                    -- Refer. Org.Unit [AWORG]
    DUMMY_FAA_MD_TDD_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, COMP_CODE, ASSET_NO, ASSET_SUBNO, VALID_TO_DATE)
);

Learn More