FAAT_DOC_IT

73 Fields 25 CDS Views

FAAT_DOC_IT is an SAP database table in S/4HANA. It contains 73 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 (73)

KeyField CDS FieldsUsed in Views
KEY afabe afabe,AssetDepreciationArea 15
KEY anlkl anlkl,AssetClass,s_anlkl 8
KEY anln1 anln1,MasterFixedAsset 15
KEY anln2 anln2,FixedAsset 15
KEY aworg aworg,ReferenceDocumentContext 14
KEY awref awref,ReferenceDocument 13
KEY awsys awsys,LogicalSystem 14
KEY awtyp awtyp 7
KEY bukrs bukrs,CompanyCode 14
KEY drcrk DebitCreditCode,drcrk 13
KEY gjahr FiscalYear,gjahr 16
KEY movcat AssetAcctTransClassfctn,movcat,s_movcat 12
KEY poper FiscalPeriod,poper,poperg,poperx,s_poper 11
KEY slalittype slalittype 7
KEY subta subta,TransactionSubitem 14
afabe_fi_doc afabe_fi_doc 2
anlgr anlgr,GroupMasterFixedAsset 2
anlgr2 anlgr2,GroupFixedAsset 2
awitem awitem,ReferenceDocumentItem,s_awitem 6
aworg_rev aworg_rev,ReversalReferenceDocumentCntxt,s_aworg_rev 6
awref_rev awref_rev,ReversalReferenceDocument,s_awref_rev 6
awtyp_rev awtyp_rev,s_awtyp_rev 5
bldat bldat,DocumentDate,s_bldat 5
bsl AmountInFreeDefinedCurrency3,bsl 8
budat budat,PostingDate,s_budat 6
bwasl AssetTransactionType,bwasl,s_bwasl 6
bzdat AssetValueDate,bzdat,s_bzdat 6
csl AmountInFreeDefinedCurrency4,csl 8
dsl AmountInFreeDefinedCurrency5,dsl 8
esl AmountInFreeDefinedCurrency6,esl 8
fsl AmountInFreeDefinedCurrency7,fsl 8
gsl AmountInFreeDefinedCurrency8,gsl 7
has_fi_doc has_fi_doc 2
hsl AmountInCompanyCodeCurrency,hsl,s_hsl 13
ksl AmountInGlobalCurrency,ksl,s_ksl 13
ktogr ktogr,s_ktogr 5
ldgrp ldgrp 1
mig_source mig_source,s_mig_source 5
obart obart,s_obart 4
objid objid,s_objid 4
osl AmountInFreeDefinedCurrency1,osl,s_osl 13
panl1 panl1,PartnerMasterFixedAsset,s_panl1 6
panl2 panl2,PartnerFixedAsset,s_panl2 6
prec_aworg prec_aworg,s_prec_aworg 5
prec_awref prec_awref,s_prec_awref 5
prec_awtyp prec_awtyp,s_prec_awtyp 5
prec_subta prec_subta,s_prec_subta 5
prozs_pn prozs_pn,s_prozs_pn 4
rbcur FreeDefinedCurrency3,rbcur 8
rccur FreeDefinedCurrency4,rccur 8
rdcur FreeDefinedCurrency5,rdcur 8
recid JointVentureCostRecoveryCode,recid,s_recid 6
recur FreeDefinedCurrency6,recur 8
rfcur FreeDefinedCurrency7,rfcur 8
rgcur FreeDefinedCurrency8,rgcur 8
rhcur CompanyCodeCurrency,rhcur,s_rhcur 12
rkcur GlobalCurrency,rkcur,s_rkcur 12
rldnr Ledger 1
rocur FreeDefinedCurrency1,rocur,s_rocur 13
rvcur FreeDefinedCurrency2,rvcur,s_rvcur 11
sdm_status sdm_status 5
sgtxt DocumentItemText,s_sgtxt,sgtxt 5
subta_rev s_subta_rev,subta_rev 5
ubzdt_pn s_ubzdt_pn,ubzdt_pn 4
vorgn GLBusinessTransactionType,s_vorgn,vorgn 6
vsl AmountInFreeDefinedCurrency2,s_vsl,vsl 11
xmanpropval_pn s_xmanpropval_pn,xmanpropval_pn 4
xreversed IsReversed,s_xreversed,xreversed 6
xreversing IsReversal,s_xreversing,xreversing 6
xsettled s_xsettled,xsettled 5
xsettling s_xsettling,xsettling 5
xvabg_pn s_xvabg_pn,xvabg_pn 4
zuonr AssignmentReference,s_zuonr,zuonr 5

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAT_DOC_IT (
    AFABE,
    ANLKL,
    ANLN1,
    ANLN2,
    AWORG,
    AWREF,
    AWSYS,
    AWTYP,
    BUKRS,
    DRCRK,
    GJAHR,
    MOVCAT,
    POPER,
    SLALITTYPE,
    SUBTA,
    AFABE_FI_DOC,
    ANLGR,
    ANLGR2,
    AWITEM,
    AWORG_REV,
    AWREF_REV,
    AWTYP_REV,
    BLDAT,
    BSL,
    BUDAT,
    BWASL,
    BZDAT,
    CSL,
    DSL,
    ESL,
    FSL,
    GSL,
    HAS_FI_DOC,
    HSL,
    KSL,
    KTOGR,
    LDGRP,
    MIG_SOURCE,
    OBART,
    OBJID,
    OSL,
    PANL1,
    PANL2,
    PREC_AWORG,
    PREC_AWREF,
    PREC_AWTYP,
    PREC_SUBTA,
    PROZS_PN,
    RBCUR,
    RCCUR,
    RDCUR,
    RECID,
    RECUR,
    RFCUR,
    RGCUR,
    RHCUR,
    RKCUR,
    RLDNR,
    ROCUR,
    RVCUR,
    SDM_STATUS,
    SGTXT,
    SUBTA_REV,
    UBZDT_PN,
    VORGN,
    VSL,
    XMANPROPVAL_PN,
    XREVERSED,
    XREVERSING,
    XSETTLED,
    XSETTLING,
    XVABG_PN,
    ZUONR,
    PRIMARY KEY (AFABE, ANLKL, ANLN1, ANLN2, AWORG, AWREF, AWSYS, AWTYP, BUKRS, DRCRK, GJAHR, MOVCAT, POPER, SLALITTYPE, SUBTA)
);

Learn More