ANLP

Transparent Table Application Table
44 Fields 5 CDS Views

Anlagen-Periodenwerte

ANLP is an SAP database table in S/4HANA. Anlagen-Periodenwerte. It contains 44 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
Faa_Anlp view from Kompatibilitaets-View fuer Tabelle ANLP
faa_mig_anlp view left_outer ANLP with parallel currency areas
FAA_MIG_ANLP_AWORG view from BUILD AWORG on ANLP
faa_mig_anlp_main view inner Test ANLP
Faa_Rec_Anlp_Base view inner Reconciliation ANLP (Base View)

Fields (44)

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
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.

-- Anlagen-Periodenwerte
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE 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]
    FISTL,   -- Funds Center [fistl]
    PRIMARY KEY (MANDT, BUKRS, GJAHR, PERAF, AFBNR, ANLN1, ANLN2, AFABER, ZUJHR, ZUCOD)
);

Learn More