ANLC

Transparent Table Application Table
77 Fields 5 CDS Views

Asset Value Fields

ANLC is an SAP database table in S/4HANA. Asset Value Fields. It contains 77 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
FAA_MIG_ANLC view left_outer Get ANLC for migration in ACDOCA and FAAT_DOC_IT
FAA_MIG_PREP view inner Get combinations of BUKRS/GJAHR for ANLC migration
FAA_RC5_ANLC_NB view inner Reconciliation ANLC Non Posting Areas (Base View) RC5
FAA_REC_ANLC_BASE view inner Reconciliation ANLC (Base View)
FAA_REC_ANLC_BRC5 view inner Reconciliation ANLC (Base View) RC5

Fields (77)

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 afabe AFABE_D Deprec. area
KEY zujhr DZUJHR Acquisition Year
KEY zucod DZUCOD Acquisition Code
afblpe AFBLPE Posted up To
afbanz AFBANZ No. of Posting Runs
xafar XAFAR Deprec. Error
ndabj NDABJ Expired UL
ndabp NDABP Expired UL Per.
andsj ANDSJ Exp.SDep.life
andsp ANDSP Exp.UL Per.Sdep
rstck RSTCK No. Units Dep.
kansw KANSW Cum.Acquis.Val.
kaufw KAUFW Cum.Reval.of RV
kinvz KINVZ Cum.Invst.Grant
knafa KNAFA Accm.Ord.Deprec
ksafa KSAFA Cum.Spec.Dep.
kaafa KAAFA Cum.Unplnd.Dep.
kmafa KMAFA Cum.Reserves
kzinw KZINW Cum. Interest
kaufn KAUFN Cum.Reval.O.Dep
kanza KANZA Cum.Down Paymts
kvost KVOST Cum. Input Tax
aufwp AUFWP Plnd.Rev.Rep.Vl
nafap NAFAP Plnd. Ord. Dep.
safap SAFAP Plnd.Spec. Dep.
aafap AAFAP Plan.Unplnd.Dep
mafap MAFAP Plnd.Trans.Res.
zinsp DZINSP Interest Plnd
aufnp AUFNP Revl.Cum.ODep
aufwb AUFWB Reval. Posted
nafag NAFAG Ord.Dep.Posted
safag SAFAG Pstd.Spec.Dep.
aafag AAFAG Pstd.Unpl.Dep.
mafag MAFAG Res.Posted
zinsg DZINSG Interest Posted
aufng AUFNG Pst.Rev.CumODep
answl ANSWL Ast.Val.Trans.
abgan ABGAN Retirement
ansaz ANSAZ Down Payments
aufwm AUFWM Man.Revaluation
invzm INVZM InvestmentGrant
nafam NAFAM Man.Ord. Dep.
safam SAFAM Man.Special Dep
aafam AAFAM Man.Unplnd.Dep.
mafam MAFAM Man.Trans.Res.
zinsm DZINSM Manual Interest
aufnm AUFNM ManRevl.CumODep
zusna DZUSNA W-up Ord.Dep.
zussa DZUSSA W-up Spec.Dep.
zusaa DZUSAA W-up Unplnd.Dep
zusma DZUSMA W-up Transf.Res
aufwv AUFWV Reval.Repl.Val
invzv INVZV InvestmentGrant
nafav NAFAV Ord. Dep.
safav SAFAV Special Depr.
aafav AAFAV Unplanned Dep.
mafav MAFAV Reserves Trans.
aufnv AUFNV Rev. Ord. Depr.
aufwl AUFWL Reval.Repl.Val
invzl INVZL InvestmentGrant
nafal NAFAL Ord. Dep.
safal SAFAL Spec. Dep.
aafal AAFAL Unplanned Dep.
mafal MAFAL Reserves Trans.
aufnl AUFNL Rev. Ord. Depr.
anupd ANUPD Change Type
ksans KSANS Cum.statistical APC
sansl SANSL Statist. acquis.val.
pstbeg PSTBEG FI-AA: Posting depreciation as of period xy
pstend PSTEND FI-AA: Posting depreciation up to period xy
pstcalc PSTCALC FI-AA: New calculation of depreciation during posting
pstper PSTPER FI-AA: Depreciation calculation from period X

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.

-- Asset Value Fields
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ANLC (
    MANDT,    -- Client [MANDT]
    BUKRS,    -- Company Code [BUKRS]
    ANLN1,    -- Asset [ANLN1]
    ANLN2,    -- Sub-number [ANLN2]
    GJAHR,    -- Fiscal Year [GJAHR]
    AFABE,    -- Deprec. area [AFABE_D]
    ZUJHR,    -- Acquisition Year [DZUJHR]
    ZUCOD,    -- Acquisition Code [DZUCOD]
    AFBLPE,   -- Posted up To [AFBLPE]
    AFBANZ,   -- No. of Posting Runs [AFBANZ]
    XAFAR,    -- Deprec. Error [XAFAR]
    NDABJ,    -- Expired UL [NDABJ]
    NDABP,    -- Expired UL Per. [NDABP]
    ANDSJ,    -- Exp.SDep.life [ANDSJ]
    ANDSP,    -- Exp.UL Per.Sdep [ANDSP]
    RSTCK,    -- No. Units Dep. [RSTCK]
    KANSW,    -- Cum.Acquis.Val. [KANSW]
    KAUFW,    -- Cum.Reval.of RV [KAUFW]
    KINVZ,    -- Cum.Invst.Grant [KINVZ]
    KNAFA,    -- Accm.Ord.Deprec [KNAFA]
    KSAFA,    -- Cum.Spec.Dep. [KSAFA]
    KAAFA,    -- Cum.Unplnd.Dep. [KAAFA]
    KMAFA,    -- Cum.Reserves [KMAFA]
    KZINW,    -- Cum. Interest [KZINW]
    KAUFN,    -- Cum.Reval.O.Dep [KAUFN]
    KANZA,    -- Cum.Down Paymts [KANZA]
    KVOST,    -- Cum. Input Tax [KVOST]
    AUFWP,    -- Plnd.Rev.Rep.Vl [AUFWP]
    NAFAP,    -- Plnd. Ord. Dep. [NAFAP]
    SAFAP,    -- Plnd.Spec. Dep. [SAFAP]
    AAFAP,    -- Plan.Unplnd.Dep [AAFAP]
    MAFAP,    -- Plnd.Trans.Res. [MAFAP]
    ZINSP,    -- Interest Plnd [DZINSP]
    AUFNP,    -- Revl.Cum.ODep [AUFNP]
    AUFWB,    -- Reval. Posted [AUFWB]
    NAFAG,    -- Ord.Dep.Posted [NAFAG]
    SAFAG,    -- Pstd.Spec.Dep. [SAFAG]
    AAFAG,    -- Pstd.Unpl.Dep. [AAFAG]
    MAFAG,    -- Res.Posted [MAFAG]
    ZINSG,    -- Interest Posted [DZINSG]
    AUFNG,    -- Pst.Rev.CumODep [AUFNG]
    ANSWL,    -- Ast.Val.Trans. [ANSWL]
    ABGAN,    -- Retirement [ABGAN]
    ANSAZ,    -- Down Payments [ANSAZ]
    AUFWM,    -- Man.Revaluation [AUFWM]
    INVZM,    -- InvestmentGrant [INVZM]
    NAFAM,    -- Man.Ord. Dep. [NAFAM]
    SAFAM,    -- Man.Special Dep [SAFAM]
    AAFAM,    -- Man.Unplnd.Dep. [AAFAM]
    MAFAM,    -- Man.Trans.Res. [MAFAM]
    ZINSM,    -- Manual Interest [DZINSM]
    AUFNM,    -- ManRevl.CumODep [AUFNM]
    ZUSNA,    -- W-up Ord.Dep. [DZUSNA]
    ZUSSA,    -- W-up Spec.Dep. [DZUSSA]
    ZUSAA,    -- W-up Unplnd.Dep [DZUSAA]
    ZUSMA,    -- W-up Transf.Res [DZUSMA]
    AUFWV,    -- Reval.Repl.Val [AUFWV]
    INVZV,    -- InvestmentGrant [INVZV]
    NAFAV,    -- Ord. Dep. [NAFAV]
    SAFAV,    -- Special Depr. [SAFAV]
    AAFAV,    -- Unplanned Dep. [AAFAV]
    MAFAV,    -- Reserves Trans. [MAFAV]
    AUFNV,    -- Rev. Ord. Depr. [AUFNV]
    AUFWL,    -- Reval.Repl.Val [AUFWL]
    INVZL,    -- InvestmentGrant [INVZL]
    NAFAL,    -- Ord. Dep. [NAFAL]
    SAFAL,    -- Spec. Dep. [SAFAL]
    AAFAL,    -- Unplanned Dep. [AAFAL]
    MAFAL,    -- Reserves Trans. [MAFAL]
    AUFNL,    -- Rev. Ord. Depr. [AUFNL]
    ANUPD,    -- Change Type [ANUPD]
    KSANS,    -- Cum.statistical APC [KSANS]
    SANSL,    -- Statist. acquis.val. [SANSL]
    PSTBEG,   -- FI-AA: Posting depreciation as of period xy [PSTBEG]
    PSTEND,   -- FI-AA: Posting depreciation up to period xy [PSTEND]
    PSTCALC,  -- FI-AA: New calculation of depreciation during posting [PSTCALC]
    PSTPER,   -- FI-AA: Depreciation calculation from period X [PSTPER]
    PRIMARY KEY (MANDT, BUKRS, ANLN1, ANLN2, GJAHR, AFABE, ZUJHR, ZUCOD)
);

Learn More