FAAT_TR_SIMDOC

Transparent Table Application Table
91 Fields 1 CDS Views

Fixed Asset Posting: Simulation Posting Document

FAAT_TR_SIMDOC is an SAP database table in S/4HANA. Fixed Asset Posting: Simulation Posting Document. It contains 91 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FixedAssetSimulationPosting view_entity from BASIC Simulation for Fixed Asset Posting

Fields (91)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY posting_uuid FAA_TR_POST_UUID Posting UUID
KEY awitem FINS_AWITEM Ref. Doc. Item
KEY comp_code BUKRS Company Code
KEY ledger FINS_LEDGER Ledger
KEY fisc_year GJAHR Fiscal Year
KEY depr_area AFABER Deprec. Area
KEY slalittype FIS_SLALITTYPE Line Item Type
KEY subta FINS_SUBTA Sub Transaction
KEY posnr POSNR_ACC Position
awtyp AWTYP Ref. procedure
awsys AWSYS Logical System
awref AWREF Reference Doc.
aworg AWORG Refer. Org.Unit
vorgn VORGN Transact. Type
racct RACCT Account Number
budat BUDAT Posting Date
bldat BLDAT Document Date
bzdat BZDAT Asset Val. Date
poper POPER Posting Period
drcrk SHKZG Debit/Credit
koart KOART Account type
quantity MENGE_D Quantity
base_unit MEINS Base Unit
depr_period PERAF Deprec. Period
movcat FAA_MOVCAT Trans.Type Cat.
anlkl ANLKL Asset Class
ktogr KTOGR Account Determ.
panl1 PANL1 Partner Asset
panl2 PANL2 Partner Sub-No.
glvor GLVOR Bus.transaction
awitgrp FINS_AWITGRP Ref. Item Group
buzei BUZEI Item
xreversing FINS_XREVERSING Is Reversing
xreversed FINS_XREVERSED Is Reversed
xsettling FINS_XSETTLING Is Settling
xsettled FINS_XSETTLED Is Settled
prec_awtyp FINS_PREC_AWTYP PrecRefTransact
prec_aworg FINS_PREC_AWORG PrecRefOrgUnit
prec_awref FINS_PREC_AWREF PrecRefDocument
prec_subta FINS_PREC_SUBTA Prec. Sub Transactn
awtyp_rev AWTYP_REV ReversalRefTran
awref_rev AWREF_REV Reversal Ref.
aworg_rev AWORG_REV Reversal Org.
subta_rev FINS_SUBTA_REV Reversal Sub Trans
ref_doc_nr XBLNR1 Reference
item_text SGTXT Text
trading_partner VBUND Company ID
alloc_nmbr DZUONR Assignment
offset_account GKONT Offsetting Acct
kunnr KUNNR Customer
lifnr LIFNR Supplier
fkber FKBER Functional Area
kokrs KOKRS CO Area
kostl KOSTL Cost Center
lstar LSTAR Activity Type
aufnr AUFNR Order
prctr PRCTR Profit Center
segment FB_SEGMENT Segment
fund BP_GEBER Fund
grant_id GM_GRANT_NBR Grant
pprctr PPRCTR Partner PC
posting_type BUHBKT Ind.: G/L Acct.
rtcur FINS_CURRT Bal. Transac. Crcy
rwcur FINS_CURRW Transaction Currency
rhcur FINS_CURRH CompanyCode Currency
rkcur FINS_CURRK Global Currency
rfccur FINS_CURRFC Functional Currency
rocur FINS_CURR1 Free Defined Crcy 1
rvcur FINS_CURR2 Free Defined Crcy 2
rbcur FINS_CURR3 Free Defined Crcy 3
rccur FINS_CURR4 Free Defined Crcy 4
rdcur FINS_CURR5 Free Defined Crcy 5
recur FINS_CURR6 Free Defined Crcy 6
rfcur FINS_CURR7 Free Defined Crcy 7
rgcur FINS_CURR8 Free Defined Crcy 8
rco_ocur FINS_CO_OCUR CO Object Currency
rgm_ocur GM_GRANT_CURRENCY Grant Currency
tsl FINS_VTCUR12 Amnt in Bal Tr Crcy
wsl FINS_VWCUR12 Amnt in Trans. Crcy
hsl FINS_VHCUR12 Amnt in Comp Cd Crcy
ksl FINS_VKCUR12 Amnt in Global Crcy
osl FINS_VOCUR12 Amount in Currency 1
vsl FINS_VVCUR12 Amount in Currency 2
bsl FINS_VBCUR12 Amount in Currency 3
csl FINS_VCCUR12 Amount in Currency 4
dsl FINS_VDCUR12 Amount in Currency 5
esl FINS_VECUR12 Amount in Currency 6
fsl FINS_VFCUR12 Amount in Currency 7
gsl FINS_VGCUR12 Amount in Currency 8
fcsl FINS_VFCCUR12 Amount in FunctCrcy

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 Posting: Simulation Posting Document
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_TR_SIMDOC (
    CLIENT,           -- Client [MANDT]
    POSTING_UUID,     -- Posting UUID [FAA_TR_POST_UUID]
    AWITEM,           -- Ref. Doc. Item [FINS_AWITEM]
    COMP_CODE,        -- Company Code [BUKRS]
    LEDGER,           -- Ledger [FINS_LEDGER]
    FISC_YEAR,        -- Fiscal Year [GJAHR]
    DEPR_AREA,        -- Deprec. Area [AFABER]
    SLALITTYPE,       -- Line Item Type [FIS_SLALITTYPE]
    SUBTA,            -- Sub Transaction [FINS_SUBTA]
    POSNR,            -- Position [POSNR_ACC]
    AWTYP,            -- Ref. procedure [AWTYP]
    AWSYS,            -- Logical System [AWSYS]
    AWREF,            -- Reference Doc. [AWREF]
    AWORG,            -- Refer. Org.Unit [AWORG]
    VORGN,            -- Transact. Type [VORGN]
    RACCT,            -- Account Number [RACCT]
    BUDAT,            -- Posting Date [BUDAT]
    BLDAT,            -- Document Date [BLDAT]
    BZDAT,            -- Asset Val. Date [BZDAT]
    POPER,            -- Posting Period [POPER]
    DRCRK,            -- Debit/Credit [SHKZG]
    KOART,            -- Account type [KOART]
    QUANTITY,         -- Quantity [MENGE_D]
    BASE_UNIT,        -- Base Unit [MEINS]
    DEPR_PERIOD,      -- Deprec. Period [PERAF]
    MOVCAT,           -- Trans.Type Cat. [FAA_MOVCAT]
    ANLKL,            -- Asset Class [ANLKL]
    KTOGR,            -- Account Determ. [KTOGR]
    PANL1,            -- Partner Asset [PANL1]
    PANL2,            -- Partner Sub-No. [PANL2]
    GLVOR,            -- Bus.transaction [GLVOR]
    AWITGRP,          -- Ref. Item Group [FINS_AWITGRP]
    BUZEI,            -- Item [BUZEI]
    XREVERSING,       -- Is Reversing [FINS_XREVERSING]
    XREVERSED,        -- Is Reversed [FINS_XREVERSED]
    XSETTLING,        -- Is Settling [FINS_XSETTLING]
    XSETTLED,         -- Is Settled [FINS_XSETTLED]
    PREC_AWTYP,       -- PrecRefTransact [FINS_PREC_AWTYP]
    PREC_AWORG,       -- PrecRefOrgUnit [FINS_PREC_AWORG]
    PREC_AWREF,       -- PrecRefDocument [FINS_PREC_AWREF]
    PREC_SUBTA,       -- Prec. Sub Transactn [FINS_PREC_SUBTA]
    AWTYP_REV,        -- ReversalRefTran [AWTYP_REV]
    AWREF_REV,        -- Reversal Ref. [AWREF_REV]
    AWORG_REV,        -- Reversal Org. [AWORG_REV]
    SUBTA_REV,        -- Reversal Sub Trans [FINS_SUBTA_REV]
    REF_DOC_NR,       -- Reference [XBLNR1]
    ITEM_TEXT,        -- Text [SGTXT]
    TRADING_PARTNER,  -- Company ID [VBUND]
    ALLOC_NMBR,       -- Assignment [DZUONR]
    OFFSET_ACCOUNT,   -- Offsetting Acct [GKONT]
    KUNNR,            -- Customer [KUNNR]
    LIFNR,            -- Supplier [LIFNR]
    FKBER,            -- Functional Area [FKBER]
    KOKRS,            -- CO Area [KOKRS]
    KOSTL,            -- Cost Center [KOSTL]
    LSTAR,            -- Activity Type [LSTAR]
    AUFNR,            -- Order [AUFNR]
    PRCTR,            -- Profit Center [PRCTR]
    SEGMENT,          -- Segment [FB_SEGMENT]
    FUND,             -- Fund [BP_GEBER]
    GRANT_ID,         -- Grant [GM_GRANT_NBR]
    PPRCTR,           -- Partner PC [PPRCTR]
    POSTING_TYPE,     -- Ind.: G/L Acct. [BUHBKT]
    RTCUR,            -- Bal. Transac. Crcy [FINS_CURRT]
    RWCUR,            -- Transaction Currency [FINS_CURRW]
    RHCUR,            -- CompanyCode Currency [FINS_CURRH]
    RKCUR,            -- Global Currency [FINS_CURRK]
    RFCCUR,           -- Functional Currency [FINS_CURRFC]
    ROCUR,            -- Free Defined Crcy 1 [FINS_CURR1]
    RVCUR,            -- Free Defined Crcy 2 [FINS_CURR2]
    RBCUR,            -- Free Defined Crcy 3 [FINS_CURR3]
    RCCUR,            -- Free Defined Crcy 4 [FINS_CURR4]
    RDCUR,            -- Free Defined Crcy 5 [FINS_CURR5]
    RECUR,            -- Free Defined Crcy 6 [FINS_CURR6]
    RFCUR,            -- Free Defined Crcy 7 [FINS_CURR7]
    RGCUR,            -- Free Defined Crcy 8 [FINS_CURR8]
    RCO_OCUR,         -- CO Object Currency [FINS_CO_OCUR]
    RGM_OCUR,         -- Grant Currency [GM_GRANT_CURRENCY]
    TSL,              -- Amnt in Bal Tr Crcy [FINS_VTCUR12]
    WSL,              -- Amnt in Trans. Crcy [FINS_VWCUR12]
    HSL,              -- Amnt in Comp Cd Crcy [FINS_VHCUR12]
    KSL,              -- Amnt in Global Crcy [FINS_VKCUR12]
    OSL,              -- Amount in Currency 1 [FINS_VOCUR12]
    VSL,              -- Amount in Currency 2 [FINS_VVCUR12]
    BSL,              -- Amount in Currency 3 [FINS_VBCUR12]
    CSL,              -- Amount in Currency 4 [FINS_VCCUR12]
    DSL,              -- Amount in Currency 5 [FINS_VDCUR12]
    ESL,              -- Amount in Currency 6 [FINS_VECUR12]
    FSL,              -- Amount in Currency 7 [FINS_VFCUR12]
    GSL,              -- Amount in Currency 8 [FINS_VGCUR12]
    FCSL,             -- Amount in FunctCrcy [FINS_VFCCUR12]
    PRIMARY KEY (CLIENT, POSTING_UUID, AWITEM, COMP_CODE, LEDGER, FISC_YEAR, DEPR_AREA, SLALITTYPE, SUBTA, POSNR)
);

Learn More