FAAT_DOC_IT

Transparent Table Application Table
89 Fields 25 CDS Views

Statistical Line Item in Asset Accounting

FAAT_DOC_IT is an SAP database table in S/4HANA. Statistical Line Item in Asset Accounting. It contains 89 fields. 25 CDS views read from this table.

CDS Views using this table (25)

ViewTypeJoinVDMDescription
FAA_ACDOCA_DOCIT view_entity union_all Union over ACDOCA and FAAT_DOC_IT
Faa_Anea1 view union_all Intern: Verdichten auf SLALITTYPE-Ebene
Faa_Anep1 view union_all Intern: Verdichten auf SLALITTYPE-Ebene
Faa_Anlc1_P_Stat view from Periodisches Verdichten auf SLALITTYPE
Faa_Anlc1_Stat view from Intern: Verdichten auf SLALITTYPE-Ebene
FAA_CompDrvdAreaDocit01 view from Compare Derived Area DOC_IT 01
FAA_CompDrvdAreaSplitNum view from Compare Derived Area Split Number
FAA_DOC_IT_BCF view from Carry forward for statistical items
FAA_SDM_BALANCE02 view from Asset line items
FAA_SDM_DOCIT_CP02 view from Compare splitting number of line items
FAA_SDM_DOCIT_CP03 view from KFC DOC_IT aggregation
FAA_SDM_DOCIT_CP03 view union KFC DOC_IT aggregation
FAA_SDM_DOCIT_CP111 view from Compare from DOC_IT to ACDOCA
FAA_SDM_DOCIT_CP130 view from DOC_IT projection
FAA_SDM_DOCIT_CP130 view union DOC_IT projection
FAA_UPA_MIG_BAL_DOC view_entity union_all Asset documents
FAA_UPA_MIG_BAL_ODOC view_entity union_all Old asset documents
FAA_UPA_MIG_DA_DOCIT_CMPR01 view_entity from Compare DOC_IT for derived area layer 1
FAA_UPA_MIG_DA_DOCIT_SPLT view_entity from Split DOC_IT-DRCRK for derived area
FAA_UPA_MIG_DA_KFC_DOCIT01 view_entity from Aggregate DOC_IT for derived area 01
FAA_UPA_MIG_DI_BALANCE02 view_entity from DOC_IT line items
FAA_UPA_MIG_DI_BALANCE02 view_entity union_all DOC_IT line items
FAA_UPA_MIG_DI_DOCIT_SPLT view_entity from Split DOC_IT-DRCRK
FAA_UPA_MIG_DI_KFC_DOCIT01 view_entity from Aggregate DOC_IT for tech ledger 01
I_FxdAstStatisticalLineItem view from BASIC Statistical Line Items of Fixed Asset

Fields (89)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY anln1 ANLN1 Asset
KEY anln2 ANLN2 Sub-number
KEY gjahr GJAHR Fiscal Year
KEY awtyp AWTYP Ref. procedure
KEY awref AWREF Reference Doc.
KEY aworg AWORG Refer. Org.Unit
KEY awsys AWSYS Logical System
KEY subta FINS_SUBTA Sub Transaction
KEY afabe AFABE_D Deprec. area
KEY slalittype SLALITTYPE SLALineItemType
KEY drcrk SHKZG Debit/Credit
awitem FINS_AWITEM Ref. Doc. Item
ldgrp FAGL_LDGRP Ledger Group
rldnr FINS_LEDGER Ledger
vorgn VORGN Transact. Type
budat BUDAT Posting Date
bzdat BZDAT Asset Val. Date
poper POPER Posting Period
bwasl BWASL Trans. Type
movcat FAA_MOVCAT Trans.Type Cat.
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
rhcur FINS_CURRH CompanyCode Currency
rkcur FINS_CURRK Global 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
has_fi_doc FAA_HAS_FI_DOC FI Doc. Exists
afabe_fi_doc FAA_AFABE_FI_DOC FI Depreciation Area
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
anlkl ANLKL Asset Class
ktogr KTOGR Account Determ.
panl1 PANL1 Partner Asset
panl2 PANL2 Partner Sub-No.
anlgr ANLGR Group Asset
anlgr2 ANLGR2 Subnumber
mig_source FINS_ACDOC_MIG_SOURCE Migr. Source
recid JV_RECIND Recovery Ind.
bldat BLDAT Document Date
cpudt CPUDT Entered On
cputm CPUTM Entered at
usnam UNAME User Name
tcode TCODE Transaction Code
sgtxt SGTXT Text
xblnr XBLNR1 Reference
zuonr DZUONR Assignment
obart A_OBART Forwarding obj. type
objid A_OBJID Forwarding object nr
trava_pn TRANSVAR Transfer var.
ldgrpspec_pn XLDGRPSPEC LDGRP-Specific
afabespec_pn XAFABESPEC Area-Specific
anln2_pn ANLN2_PN Asset Subnumber
bwasl_pn BWASL Trans. Type
bzdat_pn BZDAT_PN Asset Val. Date
ubzdt_pn UBZDT Orig. Val. Dat
xvabg_pn XVABG Compl.Retiremnt
anbtr_pn ANBTR Amount Posted
prozs_pn PROZS Percentage Rate
xmanpropval_pn XMANPROPVAL Man. Proport. Values
sdm_curr_conv_src FAA_SDM_CURR_CONV_SRC SDM Curr.Conv.Source
sdm_curr_adjust FAA_SDM_CURR_ADJUST SDM Curr.Conv.Adjust
sdm_xvabg_set FAA_SDM_XVABG_SET SDM: XVABG Was Set
sdm_status FAA_SDM_STATUS SDM Status

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.

-- Statistical Line Item in Asset Accounting
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_DOC_IT (
    MANDT,              -- Client [MANDT]
    BUKRS,              -- Company Code [BUKRS]
    ANLN1,              -- Asset [ANLN1]
    ANLN2,              -- Sub-number [ANLN2]
    GJAHR,              -- Fiscal Year [GJAHR]
    AWTYP,              -- Ref. procedure [AWTYP]
    AWREF,              -- Reference Doc. [AWREF]
    AWORG,              -- Refer. Org.Unit [AWORG]
    AWSYS,              -- Logical System [AWSYS]
    SUBTA,              -- Sub Transaction [FINS_SUBTA]
    AFABE,              -- Deprec. area [AFABE_D]
    SLALITTYPE,         -- SLALineItemType [SLALITTYPE]
    DRCRK,              -- Debit/Credit [SHKZG]
    AWITEM,             -- Ref. Doc. Item [FINS_AWITEM]
    LDGRP,              -- Ledger Group [FAGL_LDGRP]
    RLDNR,              -- Ledger [FINS_LEDGER]
    VORGN,              -- Transact. Type [VORGN]
    BUDAT,              -- Posting Date [BUDAT]
    BZDAT,              -- Asset Val. Date [BZDAT]
    POPER,              -- Posting Period [POPER]
    BWASL,              -- Trans. Type [BWASL]
    MOVCAT,             -- Trans.Type Cat. [FAA_MOVCAT]
    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]
    RHCUR,              -- CompanyCode Currency [FINS_CURRH]
    RKCUR,              -- Global Currency [FINS_CURRK]
    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]
    HAS_FI_DOC,         -- FI Doc. Exists [FAA_HAS_FI_DOC]
    AFABE_FI_DOC,       -- FI Depreciation Area [FAA_AFABE_FI_DOC]
    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]
    ANLKL,              -- Asset Class [ANLKL]
    KTOGR,              -- Account Determ. [KTOGR]
    PANL1,              -- Partner Asset [PANL1]
    PANL2,              -- Partner Sub-No. [PANL2]
    ANLGR,              -- Group Asset [ANLGR]
    ANLGR2,             -- Subnumber [ANLGR2]
    MIG_SOURCE,         -- Migr. Source [FINS_ACDOC_MIG_SOURCE]
    RECID,              -- Recovery Ind. [JV_RECIND]
    BLDAT,              -- Document Date [BLDAT]
    CPUDT,              -- Entered On [CPUDT]
    CPUTM,              -- Entered at [CPUTM]
    USNAM,              -- User Name [UNAME]
    TCODE,              -- Transaction Code [TCODE]
    SGTXT,              -- Text [SGTXT]
    XBLNR,              -- Reference [XBLNR1]
    ZUONR,              -- Assignment [DZUONR]
    OBART,              -- Forwarding obj. type [A_OBART]
    OBJID,              -- Forwarding object nr [A_OBJID]
    TRAVA_PN,           -- Transfer var. [TRANSVAR]
    LDGRPSPEC_PN,       -- LDGRP-Specific [XLDGRPSPEC]
    AFABESPEC_PN,       -- Area-Specific [XAFABESPEC]
    ANLN2_PN,           -- Asset Subnumber [ANLN2_PN]
    BWASL_PN,           -- Trans. Type [BWASL]
    BZDAT_PN,           -- Asset Val. Date [BZDAT_PN]
    UBZDT_PN,           -- Orig. Val. Dat [UBZDT]
    XVABG_PN,           -- Compl.Retiremnt [XVABG]
    ANBTR_PN,           -- Amount Posted [ANBTR]
    PROZS_PN,           -- Percentage Rate [PROZS]
    XMANPROPVAL_PN,     -- Man. Proport. Values [XMANPROPVAL]
    SDM_CURR_CONV_SRC,  -- SDM Curr.Conv.Source [FAA_SDM_CURR_CONV_SRC]
    SDM_CURR_ADJUST,    -- SDM Curr.Conv.Adjust [FAA_SDM_CURR_ADJUST]
    SDM_XVABG_SET,      -- SDM: XVABG Was Set [FAA_SDM_XVABG_SET]
    SDM_STATUS,         -- SDM Status [FAA_SDM_STATUS]
    PRIMARY KEY (MANDT, BUKRS, ANLN1, ANLN2, GJAHR, AWTYP, AWREF, AWORG, AWSYS, SUBTA, AFABE, SLALITTYPE, DRCRK)
);

Learn More