FAAD_TR_POST

Transparent Table Application Table
58 Fields 1 CDS Views

Draft table for entity R_FIXEDASSETPOSTINGTP

FAAD_TR_POST is an SAP database table in S/4HANA. Draft table for entity R_FIXEDASSETPOSTINGTP. It contains 58 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
C_FixedAssetSimlnPostingTP view_entity inner CONSUMPTION Simulation for Fixed Asset Posting

Fields (58)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY fixedassetpostinguuid faa_tr_post_uuid Posting UUID
KEY referencedocumentitem fins_awitem Ref. Doc. Item
assetaccttransclassfctn faa_movcat Trans.Type Cat.
referencedocumenttype awtyp Ref. procedure
logicalsystem awsys Logical System
referencedocumentcontext aworg Refer. Org.Unit
referencedocument awref Reference Doc.
companycode bukrs Company Code
masterfixedasset anln1 Asset
fixedasset anln2 Sub-number
assetclass anlkl Asset Class
documentdate bldat Document Date
postingdate budat Posting Date
assetvaluedate bzdat Asset Val. Date
assetoriginalvaluedate ubzdt Orig. Val. Dat
businesstransactiontype fins_custbttype Bus. Trans. Type
businesstransactioncategory fins_bttype Bus. Trans. Category
documentreferenceid xblnr1 Reference
accountingdocumentheadertext bktxt Doc.Header Text
exchangeratedate wwert_d Translatn Date
acqnamtintransactioncurrency faa_tr_post_amount Amount Posted
transactioncurrency waers Currency
quantityinbaseunit menge_d Quantity
baseunit meins Base Unit
debitcreditcode fis_shkzg Debit/Credit Code
fixedassetyearofacqncode faa_py_cy_code UI Control of Transaction Amounts (Current/Previous)
fixedassetretirementtype faa_tr_retirement_type Retirement Type
fxdastretirementrevenuetype faa_tr_retirement_revenue_type Determination of Revenue
astrtrmtamtintranscrcy faa_tr_retirement_amount Retirement Amount
fxdastretirementtranscrcy waers Currency
fxdastretirementcurrencyrole faa_tr_retirement_curtype Currency Type of Retirement
fxdastrtrmtquantityinbaseunit menge_d Quantity
fixedassetretirementbaseunit meins Base Unit
astrevenueamountintranscrcy faa_tr_retirement_revenue_amt Revenue Amount
fxdastrtrmtrevntranscrcy waers Currency
fxdastrtrmtrevncurrencyrole faa_tr_retirement_revn_curtype Currency Type of Revenue
fxdastretirementratioinpercent faa_tr_retirement_percentage Retirement Percentage
fxdastrevndetndeprarea faa_tr_retirement_revenue_area Depreciation Area for Determining NBV
fxdastrevalacqnamtinfc faa_tr_reval_apc_amount
fxdastrevalcyrdepramtinfc faa_tr_reval_cur_depr_amount
fxdastrevalpryrdepramtinfc faa_tr_reval_prev_depr_amount
fxdastrevalfuncnlcrcy waers Currency
fxdastrevalacqnamount faa_tr_reval_apc_amt_in_sc
fxdastrevalcyrdepramount faa_tr_reval_cr_depr_amt_in_sc
fxdastrevalpryrdepramount faa_tr_reval_pr_depr_amt_in_sc
fxdastrevalselectedcurrency faa_tr_reval_selected_currency
accountingdocumenttype blart Document Type
financialclosingstep fins_closingstep Closing Step
tradingpartner vbund Company ID
assignmentreference dzuonr Assignment
documentitemtext sgtxt Text
offsettingaccount gkont Offsetting Acct
ischanged faa_tr_post_changed Fixed Asset Posting: Change Indicator for Posting
fixedexchangerateisused xfixd_curv Fixed exch.rate
createdbyuser ernam Created By
creationdatetime timestamp Time Stamp
lastchangedatetime timestamp Time Stamp

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.

-- Draft table for entity R_FIXEDASSETPOSTINGTP
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAD_TR_POST (
    MANDT,                           -- Client [mandt]
    FIXEDASSETPOSTINGUUID,           -- Posting UUID [faa_tr_post_uuid]
    REFERENCEDOCUMENTITEM,           -- Ref. Doc. Item [fins_awitem]
    ASSETACCTTRANSCLASSFCTN,         -- Trans.Type Cat. [faa_movcat]
    REFERENCEDOCUMENTTYPE,           -- Ref. procedure [awtyp]
    LOGICALSYSTEM,                   -- Logical System [awsys]
    REFERENCEDOCUMENTCONTEXT,        -- Refer. Org.Unit [aworg]
    REFERENCEDOCUMENT,               -- Reference Doc. [awref]
    COMPANYCODE,                     -- Company Code [bukrs]
    MASTERFIXEDASSET,                -- Asset [anln1]
    FIXEDASSET,                      -- Sub-number [anln2]
    ASSETCLASS,                      -- Asset Class [anlkl]
    DOCUMENTDATE,                    -- Document Date [bldat]
    POSTINGDATE,                     -- Posting Date [budat]
    ASSETVALUEDATE,                  -- Asset Val. Date [bzdat]
    ASSETORIGINALVALUEDATE,          -- Orig. Val. Dat [ubzdt]
    BUSINESSTRANSACTIONTYPE,         -- Bus. Trans. Type [fins_custbttype]
    BUSINESSTRANSACTIONCATEGORY,     -- Bus. Trans. Category [fins_bttype]
    DOCUMENTREFERENCEID,             -- Reference [xblnr1]
    ACCOUNTINGDOCUMENTHEADERTEXT,    -- Doc.Header Text [bktxt]
    EXCHANGERATEDATE,                -- Translatn Date [wwert_d]
    ACQNAMTINTRANSACTIONCURRENCY,    -- Amount Posted [faa_tr_post_amount]
    TRANSACTIONCURRENCY,             -- Currency [waers]
    QUANTITYINBASEUNIT,              -- Quantity [menge_d]
    BASEUNIT,                        -- Base Unit [meins]
    DEBITCREDITCODE,                 -- Debit/Credit Code [fis_shkzg]
    FIXEDASSETYEAROFACQNCODE,        -- UI Control of Transaction Amounts (Current/Previous) [faa_py_cy_code]
    FIXEDASSETRETIREMENTTYPE,        -- Retirement Type [faa_tr_retirement_type]
    FXDASTRETIREMENTREVENUETYPE,     -- Determination of Revenue [faa_tr_retirement_revenue_type]
    ASTRTRMTAMTINTRANSCRCY,          -- Retirement Amount [faa_tr_retirement_amount]
    FXDASTRETIREMENTTRANSCRCY,       -- Currency [waers]
    FXDASTRETIREMENTCURRENCYROLE,    -- Currency Type of Retirement [faa_tr_retirement_curtype]
    FXDASTRTRMTQUANTITYINBASEUNIT,   -- Quantity [menge_d]
    FIXEDASSETRETIREMENTBASEUNIT,    -- Base Unit [meins]
    ASTREVENUEAMOUNTINTRANSCRCY,     -- Revenue Amount [faa_tr_retirement_revenue_amt]
    FXDASTRTRMTREVNTRANSCRCY,        -- Currency [waers]
    FXDASTRTRMTREVNCURRENCYROLE,     -- Currency Type of Revenue [faa_tr_retirement_revn_curtype]
    FXDASTRETIREMENTRATIOINPERCENT,  -- Retirement Percentage [faa_tr_retirement_percentage]
    FXDASTREVNDETNDEPRAREA,          -- Depreciation Area for Determining NBV [faa_tr_retirement_revenue_area]
    FXDASTREVALACQNAMTINFC,          -- faa_tr_reval_apc_amount
    FXDASTREVALCYRDEPRAMTINFC,       -- faa_tr_reval_cur_depr_amount
    FXDASTREVALPRYRDEPRAMTINFC,      -- faa_tr_reval_prev_depr_amount
    FXDASTREVALFUNCNLCRCY,           -- Currency [waers]
    FXDASTREVALACQNAMOUNT,           -- faa_tr_reval_apc_amt_in_sc
    FXDASTREVALCYRDEPRAMOUNT,        -- faa_tr_reval_cr_depr_amt_in_sc
    FXDASTREVALPRYRDEPRAMOUNT,       -- faa_tr_reval_pr_depr_amt_in_sc
    FXDASTREVALSELECTEDCURRENCY,     -- faa_tr_reval_selected_currency
    ACCOUNTINGDOCUMENTTYPE,          -- Document Type [blart]
    FINANCIALCLOSINGSTEP,            -- Closing Step [fins_closingstep]
    TRADINGPARTNER,                  -- Company ID [vbund]
    ASSIGNMENTREFERENCE,             -- Assignment [dzuonr]
    DOCUMENTITEMTEXT,                -- Text [sgtxt]
    OFFSETTINGACCOUNT,               -- Offsetting Acct [gkont]
    ISCHANGED,                       -- Fixed Asset Posting: Change Indicator for Posting [faa_tr_post_changed]
    FIXEDEXCHANGERATEISUSED,         -- Fixed exch.rate [xfixd_curv]
    CREATEDBYUSER,                   -- Created By [ernam]
    CREATIONDATETIME,                -- Time Stamp [timestamp]
    LASTCHANGEDATETIME,              -- Time Stamp [timestamp]
    PRIMARY KEY (MANDT, FIXEDASSETPOSTINGUUID, REFERENCEDOCUMENTITEM)
);

Learn More