ANLA

Transparent Table Application Table
145 Fields 31 CDS Views

Asset Master Record Segment

ANLA is an SAP database table in S/4HANA. Asset Master Record Segment. It contains 145 fields. 31 CDS views read from this table.

CDS Views using this table (31)

ViewTypeJoinVDMDescription
E_FixedAssetWorklist view from EXTENSION Extension View for Fixed Asset Worklist
ESH_N_ASSET_ANLA view from Asset Master Record Segment
Faa_Anlsum1_Per view from V_ANLSUM_1-View - mit Periode
FAA_DOC_IT_BCF view inner Carry forward for statistical items
FAA_M_AANLA view from Selection view for matchcode ID AANL-A
FAA_MD_MIG view from Migration View for New Master Data
FAA_MD_QUANTITY_MIG view from Migration View for Quantity totals
FAA_MD_ROOT_MIG view from Migration View for New Master Data Root
FAA_MIG_ANEP view inner Join ANEP with ANEK plus add. Field AWKEY
FAA_MIG_ANLC view inner Get ANLC for migration in ACDOCA and FAAT_DOC_IT
faa_mig_anlp view left_outer ANLP with parallel currency areas
faa_mig_anlp view inner ANLP with parallel currency areas
faa_mig_anlp_main view inner Test ANLP
Faa_Rec_Anea_Base view inner Reconciliation ANEA (base Version)
Faa_Rec_Anlp1_Sum view inner Reconciliation ANLP vs ANLC (Result Set)
Faa_Sil_Anla_Relevant view inner Relevante Anlagen für Rücksetzen selektieren
faa_sil_Anlb_Deakt view inner Erwartetes Deaktivierungsdatum des Zielber. beim Rücksetzen
FAA_SIL_DEPR view inner Intern: Abschreibungen verdichtet auf DEPR_PERIOD & SLALITTYPE-Ebene
FAA_SIL_ITEMS view inner Intern: Bewegungen verdichtet auf AWREF & SLALITTYPE-Ebene
FAA_UPA_MIG_BAL_OLD01 view_entity inner Balance cube for old asset 01
FAA_UPA_MIG_MD_MIG view_entity from Migration View for New Master Data
FAA_UPA_MIG_MD_ROOT_MIG view_entity from Migration View for New Master Data Root
Faa_V_Anlab view from Kompatibilitaets-View fuer View V_ANLAB
Faa_V_Anlsum_1 view from Kompatibilitaets-View fuer View V_ANLSUM_1
Faa_V_Anlsum_2 view from Kompatibilitaets-View fuer View V_ANLSUM_2
Faa_V_Anlsum_5 view from Kompatibilitaets-View fuer View V_ANLSUM_5
FINOC_RULE_FA_EXAMPLE view inner Organizational Change: Custom Rule FA
Finsv_Drf_FixedAsset view from Fixed Asset for Data Replication
P_FixedAsset view from BASIC
P_FixedAssetCountryData view from BASIC
P_FixedAssetForLedger view from BASIC

Fields (145)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY bukrs BUKRS Company Code
KEY anln1 ANLN1 Asset
KEY anln2 ANLN2 Sub-number
anlkl ANLKL Asset Class
gegst GEGST Tech.Asset
anlar ANLAR Asset Type
ernam ERNAM Created By
erdat ERDAT Created On
aenam AENAM Changed By
aedat AEDAT_ANLA Changed On
xloev XLOEV Deletion Flag
xspeb XSPEB_ANLA Acq. lock
felei FELEI Screen Layout
ktogr KTOGR Account Determ.
xopvw OPVWA LineItem settl.
anltp ANLTP Asset Category
zujhr DZUJAHR Acquisition Yr
zuper DZUPER First Acq. Per.
zugdt DZUGDAT First Acq. on
aktiv AKTIVD Capitalized On
abgdt ABGDAT Last Retirement
deakt DEAKT Deact.Date
gplab GPLAB Pl. Retir. On
bstdt BSTDT Ordered On
ord41 ORD41 Eval.group 1
ord42 ORD42 Eval. Group 2
ord43 ORD43 Eval. Group 3
ord44 ORD44 Eval.group 4
anlue ANLUE Asset Super No.
zuawa DZUAWA Sort key
aneqk ANEQK Manage Historically
aneqs ANEQS Complete.
lifnr AM_LIFNR Vendor
land1 AM_LAND1 Origin C/R
liefe LIEFE Supplier Name
herst HERST Manufacturer
eigkz EIGKZ Property Indic.
aibn1 AIBN1 Original Asset
aibn2 AIBN2 Asset Sub-No. AuC
aibdt AIBDT Acq.Orig.Ast.On
urjhr URJHR Org. Acq. Year
urwrt URWRT Original Value
antei ANTEI In-H.Prod.Perc.
projn PROJN not in use
eaufn AM_AUFNR Inv. Order
meins MEINS Base Unit
menge AM_MENGE Quantity
typbz TYPBZ_ANLA Type Name
izwek IZWEK Invest. Reason
inken INKEN Inventory Ind.
ivdat IVDAT_ANLA Last Inventory
invzu INVZU_ANLA Inventory Note
vmgli VMGLI Prop.classif.
xvrmw XVRMW Man.net wrth vl
wrtma WRTMA Man.valuation
ehwrt EHWRT Assessed Val
aufla AUFLA_ANLA Conveyance
ehwzu EHWZU_ANLA Notice on
ehwnr EHWNR_ANLA Assmt Tax No.
gruvo GRUVO_ANLA Land Regist. of
grein GREIN_ANLA Entry by
grbnd GRBND_ANLA Lnd Reg. Volume
grblt GRBLT_ANLA Land Reg. Page
grlfd GRLFD_ANLA LandRegEntSeqNo
flurk FLURK_ANLA Ld.Reg.Map.No
flurn FLURN_ANLA Plot No.
fiamt FIAMT Tax Office
stadt ORT01_ANLA Municipality
grund GRUND Reason
feins FEINS Area Unit
grufl GRUFL Area
invnr INVNR_ANLA Inventory No.
vbund RASSC Trading Partner
spras SPRAS Language
txt50 TXA50_ANLT Description
txa50 TXA50_MORE Description (2)
xltxid XLTXID Longtext Exists
xverid XVERID Longtext exists
xtchid XTCHID Techn.Long Text
xkalid XKALID C-Acc.Long Text
xherid XHERID Longtext exists
xleaid XLEAID Longtext Exists
leafi LEAFI Lessor
lvdat LVDAT Agreement Date
lkdat LKDAT Notice date
leabg LEABG Leas.start date
lejar LEJAR Lease Length
leper LEPER Periods
lryth LRYTH Cycle
legeb LEGEB Lease payment
lbasw LBASW Base val.as new
lkauf LKAUF Purch.price
lmzin LMZIN Mnthly int.rate
lzins LZINS Annl Int. Rate
ltzbw LTZBW Last Posting
lkuza LKUZA Posted payments
lkuzi LKUZI Interest posted
llavb LLAVB Leas.liab.
leanz LEANZ No.leas.paymnts
lvtnr LVTNR Agreement no.
letxt LETXT Suppl. text
xaktiv XAKTIV Set Capit. Date
anupd ANUPD Change Type
lblnr LBLNR Last Doc. No.
xv0dt XV0DT Maintain dt.V0
xv0nm XV0NM V0 changed by
xv1dt XV1DT Maintain dt.V1
xv1nm XV1NM V1 changed by
xv2dt XV2DT Maintain dt.V2
xv2nm XV2NM V2 chnged by
xv3dt XV3DT Maintain dt. V3
xv3nm XV3NM V3 changed by
xv4dt XV4DT Mainain dt.V4
xv4nm XV4NM V4 changed by
xv5dt XV5DT Mainain dt. V5
xv5nm XV5NM V5 changed by
xv6dt XV6DT Mainain dt. V6
xv6nm XV6NM V6 changed by
aimmo AIMMO Connection to SAP Real Estate Management
objnr J_OBJNR Object number
leart LEART Type
lvors LVORS Advance pay.
gdlgrp GDLGRP Eval. Group 5
posnr AM_POSNR WBS Element
xerwrt XERWRT Do not take memo value into account
xafabch XAFABCH Used indicator
xanlgr XANLGR_1 Group Asset
mcoa1 MCOA1 Description
xinvm IM_XINVM Inv. Measure
sernr AM_SERNR Serial number
umwkz AM_UMWKZ Envir. Invest.
lrvdat AM_LRVDAT Last Reval.
act_change_pm AAPM_ACT_CHANGE_PM Change asset
has_tddp HAS_TDDP Time-Dependent
last_reorg_date FAA_LAST_REORG Reorganization Date
ldt_date FAA_LDT_DATE Transfer Date
ldt_seqno FAA_LDT_SEQNO Sequence Number
sdm_status FAA_SDM_STATUS SDM Status
dummy_faa_asset_incl_eew_ps FAA_ASSET_INCL_EEW Data Element for Extension Include: Asset Worklist
internal_code /ATL/INTERNAL_CODE Internal code
approval_number /ATL/APPROVAL_NUMBER Approval document #
approval_version /ATL/APPROVAL_VERSION Approval version
bogus_anln1 /ATL/BOGUS_ANLN1 inv. asset #
asset_version /ATL/ASSET_VERSION Asset version

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 Master Record Segment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ANLA (
    MANDT,                        -- Client [MANDT]
    BUKRS,                        -- Company Code [BUKRS]
    ANLN1,                        -- Asset [ANLN1]
    ANLN2,                        -- Sub-number [ANLN2]
    ANLKL,                        -- Asset Class [ANLKL]
    GEGST,                        -- Tech.Asset [GEGST]
    ANLAR,                        -- Asset Type [ANLAR]
    ERNAM,                        -- Created By [ERNAM]
    ERDAT,                        -- Created On [ERDAT]
    AENAM,                        -- Changed By [AENAM]
    AEDAT,                        -- Changed On [AEDAT_ANLA]
    XLOEV,                        -- Deletion Flag [XLOEV]
    XSPEB,                        -- Acq. lock [XSPEB_ANLA]
    FELEI,                        -- Screen Layout [FELEI]
    KTOGR,                        -- Account Determ. [KTOGR]
    XOPVW,                        -- LineItem settl. [OPVWA]
    ANLTP,                        -- Asset Category [ANLTP]
    ZUJHR,                        -- Acquisition Yr [DZUJAHR]
    ZUPER,                        -- First Acq. Per. [DZUPER]
    ZUGDT,                        -- First Acq. on [DZUGDAT]
    AKTIV,                        -- Capitalized On [AKTIVD]
    ABGDT,                        -- Last Retirement [ABGDAT]
    DEAKT,                        -- Deact.Date [DEAKT]
    GPLAB,                        -- Pl. Retir. On [GPLAB]
    BSTDT,                        -- Ordered On [BSTDT]
    ORD41,                        -- Eval.group 1 [ORD41]
    ORD42,                        -- Eval. Group 2 [ORD42]
    ORD43,                        -- Eval. Group 3 [ORD43]
    ORD44,                        -- Eval.group 4 [ORD44]
    ANLUE,                        -- Asset Super No. [ANLUE]
    ZUAWA,                        -- Sort key [DZUAWA]
    ANEQK,                        -- Manage Historically [ANEQK]
    ANEQS,                        -- Complete. [ANEQS]
    LIFNR,                        -- Vendor [AM_LIFNR]
    LAND1,                        -- Origin C/R [AM_LAND1]
    LIEFE,                        -- Supplier Name [LIEFE]
    HERST,                        -- Manufacturer [HERST]
    EIGKZ,                        -- Property Indic. [EIGKZ]
    AIBN1,                        -- Original Asset [AIBN1]
    AIBN2,                        -- Asset Sub-No. AuC [AIBN2]
    AIBDT,                        -- Acq.Orig.Ast.On [AIBDT]
    URJHR,                        -- Org. Acq. Year [URJHR]
    URWRT,                        -- Original Value [URWRT]
    ANTEI,                        -- In-H.Prod.Perc. [ANTEI]
    PROJN,                        -- not in use [PROJN]
    EAUFN,                        -- Inv. Order [AM_AUFNR]
    MEINS,                        -- Base Unit [MEINS]
    MENGE,                        -- Quantity [AM_MENGE]
    TYPBZ,                        -- Type Name [TYPBZ_ANLA]
    IZWEK,                        -- Invest. Reason [IZWEK]
    INKEN,                        -- Inventory Ind. [INKEN]
    IVDAT,                        -- Last Inventory [IVDAT_ANLA]
    INVZU,                        -- Inventory Note [INVZU_ANLA]
    VMGLI,                        -- Prop.classif. [VMGLI]
    XVRMW,                        -- Man.net wrth vl [XVRMW]
    WRTMA,                        -- Man.valuation [WRTMA]
    EHWRT,                        -- Assessed Val [EHWRT]
    AUFLA,                        -- Conveyance [AUFLA_ANLA]
    EHWZU,                        -- Notice on [EHWZU_ANLA]
    EHWNR,                        -- Assmt Tax No. [EHWNR_ANLA]
    GRUVO,                        -- Land Regist. of [GRUVO_ANLA]
    GREIN,                        -- Entry by [GREIN_ANLA]
    GRBND,                        -- Lnd Reg. Volume [GRBND_ANLA]
    GRBLT,                        -- Land Reg. Page [GRBLT_ANLA]
    GRLFD,                        -- LandRegEntSeqNo [GRLFD_ANLA]
    FLURK,                        -- Ld.Reg.Map.No [FLURK_ANLA]
    FLURN,                        -- Plot No. [FLURN_ANLA]
    FIAMT,                        -- Tax Office [FIAMT]
    STADT,                        -- Municipality [ORT01_ANLA]
    GRUND,                        -- Reason [GRUND]
    FEINS,                        -- Area Unit [FEINS]
    GRUFL,                        -- Area [GRUFL]
    INVNR,                        -- Inventory No. [INVNR_ANLA]
    VBUND,                        -- Trading Partner [RASSC]
    SPRAS,                        -- Language [SPRAS]
    TXT50,                        -- Description [TXA50_ANLT]
    TXA50,                        -- Description (2) [TXA50_MORE]
    XLTXID,                       -- Longtext Exists [XLTXID]
    XVERID,                       -- Longtext exists [XVERID]
    XTCHID,                       -- Techn.Long Text [XTCHID]
    XKALID,                       -- C-Acc.Long Text [XKALID]
    XHERID,                       -- Longtext exists [XHERID]
    XLEAID,                       -- Longtext Exists [XLEAID]
    LEAFI,                        -- Lessor [LEAFI]
    LVDAT,                        -- Agreement Date [LVDAT]
    LKDAT,                        -- Notice date [LKDAT]
    LEABG,                        -- Leas.start date [LEABG]
    LEJAR,                        -- Lease Length [LEJAR]
    LEPER,                        -- Periods [LEPER]
    LRYTH,                        -- Cycle [LRYTH]
    LEGEB,                        -- Lease payment [LEGEB]
    LBASW,                        -- Base val.as new [LBASW]
    LKAUF,                        -- Purch.price [LKAUF]
    LMZIN,                        -- Mnthly int.rate [LMZIN]
    LZINS,                        -- Annl Int. Rate [LZINS]
    LTZBW,                        -- Last Posting [LTZBW]
    LKUZA,                        -- Posted payments [LKUZA]
    LKUZI,                        -- Interest posted [LKUZI]
    LLAVB,                        -- Leas.liab. [LLAVB]
    LEANZ,                        -- No.leas.paymnts [LEANZ]
    LVTNR,                        -- Agreement no. [LVTNR]
    LETXT,                        -- Suppl. text [LETXT]
    XAKTIV,                       -- Set Capit. Date [XAKTIV]
    ANUPD,                        -- Change Type [ANUPD]
    LBLNR,                        -- Last Doc. No. [LBLNR]
    XV0DT,                        -- Maintain dt.V0 [XV0DT]
    XV0NM,                        -- V0 changed by [XV0NM]
    XV1DT,                        -- Maintain dt.V1 [XV1DT]
    XV1NM,                        -- V1 changed by [XV1NM]
    XV2DT,                        -- Maintain dt.V2 [XV2DT]
    XV2NM,                        -- V2 chnged by [XV2NM]
    XV3DT,                        -- Maintain dt. V3 [XV3DT]
    XV3NM,                        -- V3 changed by [XV3NM]
    XV4DT,                        -- Mainain dt.V4 [XV4DT]
    XV4NM,                        -- V4 changed by [XV4NM]
    XV5DT,                        -- Mainain dt. V5 [XV5DT]
    XV5NM,                        -- V5 changed by [XV5NM]
    XV6DT,                        -- Mainain dt. V6 [XV6DT]
    XV6NM,                        -- V6 changed by [XV6NM]
    AIMMO,                        -- Connection to SAP Real Estate Management [AIMMO]
    OBJNR,                        -- Object number [J_OBJNR]
    LEART,                        -- Type [LEART]
    LVORS,                        -- Advance pay. [LVORS]
    GDLGRP,                       -- Eval. Group 5 [GDLGRP]
    POSNR,                        -- WBS Element [AM_POSNR]
    XERWRT,                       -- Do not take memo value into account [XERWRT]
    XAFABCH,                      -- Used indicator [XAFABCH]
    XANLGR,                       -- Group Asset [XANLGR_1]
    MCOA1,                        -- Description [MCOA1]
    XINVM,                        -- Inv. Measure [IM_XINVM]
    SERNR,                        -- Serial number [AM_SERNR]
    UMWKZ,                        -- Envir. Invest. [AM_UMWKZ]
    LRVDAT,                       -- Last Reval. [AM_LRVDAT]
    ACT_CHANGE_PM,                -- Change asset [AAPM_ACT_CHANGE_PM]
    HAS_TDDP,                     -- Time-Dependent [HAS_TDDP]
    LAST_REORG_DATE,              -- Reorganization Date [FAA_LAST_REORG]
    LDT_DATE,                     -- Transfer Date [FAA_LDT_DATE]
    LDT_SEQNO,                    -- Sequence Number [FAA_LDT_SEQNO]
    SDM_STATUS,                   -- SDM Status [FAA_SDM_STATUS]
    DUMMY_FAA_ASSET_INCL_EEW_PS,  -- Data Element for Extension Include: Asset Worklist [FAA_ASSET_INCL_EEW]
    INTERNAL_CODE,                -- Internal code [/ATL/INTERNAL_CODE]
    APPROVAL_NUMBER,              -- Approval document # [/ATL/APPROVAL_NUMBER]
    APPROVAL_VERSION,             -- Approval version [/ATL/APPROVAL_VERSION]
    BOGUS_ANLN1,                  -- inv. asset # [/ATL/BOGUS_ANLN1]
    ASSET_VERSION,                -- Asset version [/ATL/ASSET_VERSION]
    PRIMARY KEY (MANDT, BUKRS, ANLN1, ANLN2)
);

Learn More