FAAV_ANLP

56 Fields 1 CDS Views

Generated Table for View

FAAV_ANLP is an SAP database table in S/4HANA. Generated Table for View. It contains 56 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
Faa_Rec_Anlp_Base view inner Reconciliation ANLP (Base View)

Fields (56)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY gjahr GJAHR Fiscal Year
KEY peraf PERAF Deprec. Period
KEY afbnr AFBNR Seq. No. in Period
KEY anln1 ANLN1 Asset
KEY anln2 ANLN2 Sub-number
KEY afaber AFABER Deprec. Area
KEY zujhr DZUJHR Acquisition Year
KEY zucod DZUCOD Acquisition Code
aufwp AUFWP Plnd.Rev.Rep.Vl
aufwb AUFWB Reval. Posted
aufwz AUFWZ Rvl. to Be Pstd
nafap NAFAP Plnd. Ord. Dep.
nafag NAFAG Ord.Dep.Posted
nafaz NAFAZ Ord.Dep. TBP
safap SAFAP Plnd.Spec. Dep.
safag SAFAG Pstd.Spec.Dep.
safaz SAFAZ Spec. Dep. TBP
aafap AAFAP Plan.Unplnd.Dep
aafag AAFAG Pstd.Unpl.Dep.
aafaz AAFAZ Unpld.Dep. TBP
mafap MAFAP Plnd.Trans.Res.
mafag MAFAG Res.Posted
mafaz MAFAZ Trans.Res. TBP
zinsp DZINSP Interest Plnd
zinsg DZINSG Interest Posted
zinsz DZINZB Interest TBP
aufnp AUFNP Revl.Cum.ODep
aufng AUFNG Pst.Rev.CumODep
aufnz AUFNZ Rvl.tbp.Cum.Dep
answl ANSWL Ast.Val.Trans.
invzm INVZM InvestmentGrant
ktogr KTOGR Account Determ.
afasl AFASL Dep. key
kostl KOSTL Cost Center
gsber GSBER Business Area
caufn CAUFN Int. Order
xunul XUNULL Below-Zero Acct
anupd ANUPD Change Type
fkber FKBER Functional Area
belnr AFA_BLNR Document Number
lstar LSTAR Activity Type
geber BP_GEBER Fund
grant_nbr GM_GRANT_NBR Grant
geber2 BP_GEBER2 Fund
fkber2 FKBER2 Functional Area
grant_nbr2 GM_GRANT_NBR2 Grant
fistl2 FISTL2 Funds Center
imkey IMKEY Real Estate Key
ps_psp_pnr2 PS_PSP_PNR2 WBS Element
budget_pd FM_BUDGET_PERIOD Budget Period
budget_pd2 FM_BUDGET_PERIOD2 Budget Period
segment FB_SEGMENT Segment
prctr PRCTR Profit Center
fistl FISTL Funds Center

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.

-- Generated Table for View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FAAV_ANLP (
    MANDT,        -- Client [MANDT]
    BUKRS,        -- Company Code [BUKRS]
    GJAHR,        -- Fiscal Year [GJAHR]
    PERAF,        -- Deprec. Period [PERAF]
    AFBNR,        -- Seq. No. in Period [AFBNR]
    ANLN1,        -- Asset [ANLN1]
    ANLN2,        -- Sub-number [ANLN2]
    AFABER,       -- Deprec. Area [AFABER]
    ZUJHR,        -- Acquisition Year [DZUJHR]
    ZUCOD,        -- Acquisition Code [DZUCOD]
    AUFWP,        -- Plnd.Rev.Rep.Vl [AUFWP]
    AUFWB,        -- Reval. Posted [AUFWB]
    AUFWZ,        -- Rvl. to Be Pstd [AUFWZ]
    NAFAP,        -- Plnd. Ord. Dep. [NAFAP]
    NAFAG,        -- Ord.Dep.Posted [NAFAG]
    NAFAZ,        -- Ord.Dep. TBP [NAFAZ]
    SAFAP,        -- Plnd.Spec. Dep. [SAFAP]
    SAFAG,        -- Pstd.Spec.Dep. [SAFAG]
    SAFAZ,        -- Spec. Dep. TBP [SAFAZ]
    AAFAP,        -- Plan.Unplnd.Dep [AAFAP]
    AAFAG,        -- Pstd.Unpl.Dep. [AAFAG]
    AAFAZ,        -- Unpld.Dep. TBP [AAFAZ]
    MAFAP,        -- Plnd.Trans.Res. [MAFAP]
    MAFAG,        -- Res.Posted [MAFAG]
    MAFAZ,        -- Trans.Res. TBP [MAFAZ]
    ZINSP,        -- Interest Plnd [DZINSP]
    ZINSG,        -- Interest Posted [DZINSG]
    ZINSZ,        -- Interest TBP [DZINZB]
    AUFNP,        -- Revl.Cum.ODep [AUFNP]
    AUFNG,        -- Pst.Rev.CumODep [AUFNG]
    AUFNZ,        -- Rvl.tbp.Cum.Dep [AUFNZ]
    ANSWL,        -- Ast.Val.Trans. [ANSWL]
    INVZM,        -- InvestmentGrant [INVZM]
    KTOGR,        -- Account Determ. [KTOGR]
    AFASL,        -- Dep. key [AFASL]
    KOSTL,        -- Cost Center [KOSTL]
    GSBER,        -- Business Area [GSBER]
    CAUFN,        -- Int. Order [CAUFN]
    XUNUL,        -- Below-Zero Acct [XUNULL]
    ANUPD,        -- Change Type [ANUPD]
    FKBER,        -- Functional Area [FKBER]
    BELNR,        -- Document Number [AFA_BLNR]
    LSTAR,        -- Activity Type [LSTAR]
    GEBER,        -- Fund [BP_GEBER]
    GRANT_NBR,    -- Grant [GM_GRANT_NBR]
    GEBER2,       -- Fund [BP_GEBER2]
    FKBER2,       -- Functional Area [FKBER2]
    GRANT_NBR2,   -- Grant [GM_GRANT_NBR2]
    FISTL2,       -- Funds Center [FISTL2]
    IMKEY,        -- Real Estate Key [IMKEY]
    PS_PSP_PNR2,  -- WBS Element [PS_PSP_PNR2]
    BUDGET_PD,    -- Budget Period [FM_BUDGET_PERIOD]
    BUDGET_PD2,   -- Budget Period [FM_BUDGET_PERIOD2]
    SEGMENT,      -- Segment [FB_SEGMENT]
    PRCTR,        -- Profit Center [PRCTR]
    FISTL,        -- Funds Center [FISTL]
    PRIMARY KEY (MANDT, BUKRS, GJAHR, PERAF, AFBNR, ANLN1, ANLN2, AFABER, ZUJHR, ZUCOD)
);

Learn More