ANEP

Transparent Table Application Table

Asset Line Items

ANEP is an SAP database table in S/4HANA. Asset Line Items. It contains 24 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
Faa_Anep view from Kompatibilitaets-View fuer Tabelle ANEP
FAA_MIG_ANEP view left_outer Join ANEP with ANEK plus add. Field AWKEY
Faa_Mig_AnEP_Movcat view from select ANEP by MOVCAT
Faa_Rc1_Anep view inner Parallel areas without leading area
Faa_Rc1_It_Base view from Mapping ANEP, ANEA to ANLC (Base View)

Fields (24)

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 lnran LNRAN Sequence Number
KEY afabe AFABE_D Deprec. area
KEY zujhr DZUJHR Acquisition Year
KEY zucod DZUCOD Acquisition Code
peraf PERAF Deprec. Period
belnr BELNR_D Document Number
buzei BUZEI Item
bzdat BZDAT Asset Val. Date
bwasl BWASL Trans. Type
xafar XAFAR Deprec. Error
anbtr ANBTR Amount Posted
nafab NAFAB O.Dep. on Trans
safab SAFAB S.Dep. on Trans
zinsb DZINSB Int. on Trans.
xantw XANTW Ind: Prop.Value
xawbt XAWBT Ind. diff.amt
lnsan LNSAN LineItemNo.Rev.
anupd ANUPD Change Type
augln AM_AUGLN Clearing Line Item

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 Line Items
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ANEP (
    MANDT,  -- Client [MANDT]
    BUKRS,  -- Company Code [BUKRS]
    ANLN1,  -- Asset [ANLN1]
    ANLN2,  -- Sub-number [ANLN2]
    GJAHR,  -- Fiscal Year [GJAHR]
    LNRAN,  -- Sequence Number [LNRAN]
    AFABE,  -- Deprec. area [AFABE_D]
    ZUJHR,  -- Acquisition Year [DZUJHR]
    ZUCOD,  -- Acquisition Code [DZUCOD]
    PERAF,  -- Deprec. Period [PERAF]
    BELNR,  -- Document Number [BELNR_D]
    BUZEI,  -- Item [BUZEI]
    BZDAT,  -- Asset Val. Date [BZDAT]
    BWASL,  -- Trans. Type [BWASL]
    XAFAR,  -- Deprec. Error [XAFAR]
    ANBTR,  -- Amount Posted [ANBTR]
    NAFAB,  -- O.Dep. on Trans [NAFAB]
    SAFAB,  -- S.Dep. on Trans [SAFAB]
    ZINSB,  -- Int. on Trans. [DZINSB]
    XANTW,  -- Ind: Prop.Value [XANTW]
    XAWBT,  -- Ind. diff.amt [XAWBT]
    LNSAN,  -- LineItemNo.Rev. [LNSAN]
    ANUPD,  -- Change Type [ANUPD]
    AUGLN,  -- Clearing Line Item [AM_AUGLN]
    PRIMARY KEY (MANDT, BUKRS, ANLN1, ANLN2, GJAHR, LNRAN, AFABE, ZUJHR, ZUCOD)
);