ANLB

Transparent Table Application Table
50 Fields 17 CDS Views

Abschreibungsparameter

ANLB is an SAP database table in S/4HANA. Abschreibungsparameter. It contains 50 fields. 17 CDS views read from this table.

CDS Views using this table (17)

ViewTypeJoinVDMDescription
Faa_Anlsum1_Per view inner V_ANLSUM_1-View - mit Periode
faa_md_ld_mig view inner Migration View for New Ledger
FAA_MD_QUANTITY_MIG view inner Migration View for Quantity totals
FAA_MD_VAL_MIG view inner Migration View for New Valuation
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_Rc1_Tt_Base view inner Reconciliation Totals vs ANEP, ANEA (Base View)
FAA_REC_ANLC_BASE view inner Reconciliation ANLC (Base View)
Faa_Sil_Anlb_All view from Bewertungsbereiche zu relevanten Anlagen bereitstellen
faa_sil_Anlb_Deakt view from Erwartetes Deaktivierungsdatum des Zielber. beim Rücksetzen
faa_sil_Anlb_Deakt view inner Erwartetes Deaktivierungsdatum des Zielber. beim Rücksetzen
FAA_UPA_MIG_MD_LD_MIG view_entity inner Migration View for New Ledger
FAA_UPA_MIG_MD_VAL_MIG view_entity inner Migration View for New Valuation
Faa_V_Anlsum_1 view inner Kompatibilitaets-View fuer View V_ANLSUM_1
Faa_V_Anlsum_2 view inner Kompatibilitaets-View fuer View V_ANLSUM_2
Faa_V_Anlsum_5 view inner Kompatibilitaets-View fuer View V_ANLSUM_5
P_FixedAssetDeprArea view from BASIC Fixed Asset Depreciation Area

Fields (50)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY bukrs bukrs Company Code
KEY anln1 anln1 Asset
KEY anln2 anln2 Sub-number
KEY afabe afabe_d Deprec. area
KEY bdatu bdatu Valid To
adatu adatu Valid From
ernam ernam Created By
erdat erdat Created On
aenam aenam Changed By
aedat aedat_anla Changed On
xloev xloev Deletion Flag
xspeb xspeb Posting Block
felei felei Screen Layout
xnega xnega Negative Val.Allowed
xgwgk xgwgk LVA Check
xunta xunta Dep per MainNo.
afabg afabg Dep. Start Date
zinbg dzinbg Int.Calc. Start
safbg safbg Spec.dep.start
invsl invsl Invest.Support
afasl afasl Dep. key
ndjar ndjar Useful Life
ndper ndper Periods
naprz naprz Ord.Dep Perc.Rate
saprz saprz Spec.Dep.Perc.
wbind wbind Index series
alind alind Aging Index
aprop aprop Var.dep.portion
umjar umjar Changeover year
ndurj ndurj Original Life
ndurp ndurp Periods
schrw schrw Scrap value
lgjan lgjan Last Fiscal Yr.
perfy perfy Period Scaling
anupd anupd Change Type
aufwtg aufwtg Revaluation
xafbe xafbe Area Deact.
anlgr anlgr Group Asset
anlgr2 anlgr2 Subnumber
vyear vyear Acquisition Yr
vmnth vmnth Acquis. Month
inbda inbda Operating Readiness
abgdat_b abgdat_b Last retmt. on
deakt_b deakt_b Deact.Date
j_1aarvkey j_1aarvkey Revaluation Key
j_1aaltdat j_1aaltdat Last rev. date
j_1aaltidx j_1aaltidx Last index used
schrw_proz schrw_proz Scrap Value %
umper umper Changeover Prd

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.

-- Abschreibungsparameter
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ANLB (
    MANDT,       -- Client [mandt]
    BUKRS,       -- Company Code [bukrs]
    ANLN1,       -- Asset [anln1]
    ANLN2,       -- Sub-number [anln2]
    AFABE,       -- Deprec. area [afabe_d]
    BDATU,       -- Valid To [bdatu]
    ADATU,       -- Valid From [adatu]
    ERNAM,       -- Created By [ernam]
    ERDAT,       -- Created On [erdat]
    AENAM,       -- Changed By [aenam]
    AEDAT,       -- Changed On [aedat_anla]
    XLOEV,       -- Deletion Flag [xloev]
    XSPEB,       -- Posting Block [xspeb]
    FELEI,       -- Screen Layout [felei]
    XNEGA,       -- Negative Val.Allowed [xnega]
    XGWGK,       -- LVA Check [xgwgk]
    XUNTA,       -- Dep per MainNo. [xunta]
    AFABG,       -- Dep. Start Date [afabg]
    ZINBG,       -- Int.Calc. Start [dzinbg]
    SAFBG,       -- Spec.dep.start [safbg]
    INVSL,       -- Invest.Support [invsl]
    AFASL,       -- Dep. key [afasl]
    NDJAR,       -- Useful Life [ndjar]
    NDPER,       -- Periods [ndper]
    NAPRZ,       -- Ord.Dep Perc.Rate [naprz]
    SAPRZ,       -- Spec.Dep.Perc. [saprz]
    WBIND,       -- Index series [wbind]
    ALIND,       -- Aging Index [alind]
    APROP,       -- Var.dep.portion [aprop]
    UMJAR,       -- Changeover year [umjar]
    NDURJ,       -- Original Life [ndurj]
    NDURP,       -- Periods [ndurp]
    SCHRW,       -- Scrap value [schrw]
    LGJAN,       -- Last Fiscal Yr. [lgjan]
    PERFY,       -- Period Scaling [perfy]
    ANUPD,       -- Change Type [anupd]
    AUFWTG,      -- Revaluation [aufwtg]
    XAFBE,       -- Area Deact. [xafbe]
    ANLGR,       -- Group Asset [anlgr]
    ANLGR2,      -- Subnumber [anlgr2]
    VYEAR,       -- Acquisition Yr [vyear]
    VMNTH,       -- Acquis. Month [vmnth]
    INBDA,       -- Operating Readiness [inbda]
    ABGDAT_B,    -- Last retmt. on [abgdat_b]
    DEAKT_B,     -- Deact.Date [deakt_b]
    J_1AARVKEY,  -- Revaluation Key [j_1aarvkey]
    J_1AALTDAT,  -- Last rev. date [j_1aaltdat]
    J_1AALTIDX,  -- Last index used [j_1aaltidx]
    SCHRW_PROZ,  -- Scrap Value % [schrw_proz]
    UMPER,       -- Changeover Prd [umper]
    PRIMARY KEY (MANDT, BUKRS, ANLN1, ANLN2, AFABE, BDATU)
);

Learn More