The ANLB_D table in SAP ERP or S/4HANA stores I_FIXEDASSETTP I_FIXEDASSETDEPRAREATP data. There are total 48 fields in ANLB_D table. The I_FIXEDASSETTP I_FIXEDASSETDEPRAREATP table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ANLB_D table. It is in oData Services – FIAA Asset Master List (ODATA_AA_ASSET_MANAGE) ABAP package and is part of the Fiori UI for Asset Accounting (FI-FIO-AA) module.
SAP ANLB_D Table Fields
Following is the list of fields that are available in SAP ANLB_D table. The primary key fields of the table are MANDT (Client), DRAFTUUID (UUID serving as key (parent key, root key)).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT (3) | |
| DRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| PARENTDRAFTUUID | UUID serving as key (parent key, root key) | /BOBF/UUID | RAW (16) | |
| COMPANYCODE | Company Code | BUKRS | CHAR (4) | |
| MASTERFIXEDASSET | Main Asset Number | ANLN1 | CHAR (12) | |
| FIXEDASSET | Asset Subnumber | ANLN2 | CHAR (4) | |
| ASSETDEPRECIATIONAREA | Real depreciation area | AFABE_D | NUMC (2) | |
| VALIDITYENDDATE | Date Validity Ends | BDATU | DATS (8) | |
| ASSETDEPRECIATIONAREANAME | Name of Depreciation Area | AFBTXT | CHAR (50) | |
| VALIDITYSTARTDATE | Date for Beginning of Validity | ADATU | DATS (8) | |
| PLANNEDUSEFULLIFEINYEARS | Planned Useful Life in Years | FIS_NDJAR | NUMC (3) | |
| PLANNEDUSEFULLIFEINPERIODS | Planned Useful Life in Periods | FIS_NDPER | NUMC (3) | |
| DEPRECIATIONSTARTDATE | Depreciation Calculation Start Date | AFABG | DATS (8) | |
| SPECIALDEPRSTARTDATE | Start date for special depreciation | SAFBG | DATS (8) | |
| INTERESTCALCSTARTDATE | Start Date for Interest Calculation | DZINBG | DATS (8) | |
| REPLACEMENTVALUEINDEXSERS | Index series for replacement values | WBIND | CHAR (5) | |
| RPLCMTVALUEAGINGINDEXSERS | Age-dependent Index Series | FIS_ALIND | CHAR (5) | |
| VARIABLEDEPRPERCENT | Variable depreciation portion | APROP | DEC (7) | |
| DEPRECIATIONAREACURRENCY | Currency Key | WAERS | CUKY (5) | |
| REPRESENTATIVELEDGER | Ledger in General Ledger Accounting | FINS_LEDGER | CHAR (2) | |
| SCRAPAMOUNTINCOCODECRCY | Asset scrap value | SCHRW | CURR (23) | |
| ORIGLASTUSEFULLIFEINYEARS | Original useful life in years | NDURJ | NUMC (3) | |
| GROUPMASTERFIXEDASSET | Group Asset | ANLGR | CHAR (12) | |
| ASSETOPGREADINESSDATE | Asset Accounting: Date of Operating Readiness | INBDA | DATS (8) | |
| NEGATIVEAMOUNTISALLOWED | Indicator: Negative Values Allowed | XNEGA | CHAR (1) | |
| DEPRECIATIONAREAISDACTVTD | Indicator: Depreciation area is deactivated | XAFBE | CHAR (1) | |
| ASSETREVALUATION | Revaluation Key | J_1AARVKEY | CHAR (4) | |
| INVESTMENTSUPPORTMEASURE | Investment Support Key | FAA_INVSL | CHAR (2) | |
| DEPRKEYCHANGEOVERYEAR | Changeover Year of Depreciation Key | FIS_UMJAR | NUMC (4) | |
| DEPRKEYCHANGEOVERPERIOD | Changeover Period of Depreciation Key | UMPER | NUMC (3) | |
| VINTAGEMONTH | Acquisition Month | FIS_VMNTH | NUMC (3) | |
| VINTAGEYEAR | Acquisition Year | FIS_VYEAR | NUMC (4) | |
| ORIGLASTUSEFULLIFEINPERDS | Original useful life in periods | NDURP | NUMC (3) | |
| GROUPFIXEDASSET | Subnumber of Group Asset | ANLGR2 | CHAR (4) | |
| CHARTOFDEPRECIATION | Chart of depreciaton for asset valuation | AFAPL | CHAR (4) | |
| DEPRECIATIONAREACURRENCYROLE | Currency Type | FINS_CURTYPE | CHAR (2) | |
| ACCOUNTINGPRINCIPLE | Accounting Principle | ACCOUNTING_PRINCIPLE | CHAR (4) | |
| VALUEREFERENCEDEPRECIATIONAREA | Adoption of Values from Depreciation Area | WRTAFB | NUMC (2) | |
| ISVALUEREFERENCEDEPRAREA | Boolean Variable (X = True, – = False, Space = Unknown) | BOOLEAN | CHAR (1) | |
| ISREALDEPRECIATIONAREA | Indicator: Store Real Depreciation Area | XSTORE | CHAR (1) | |
| ASSETACCTGLASTCLOSEDFISCALYEAR | Last Closed Fiscal Year | ABGJA | NUMC (4) | |
| DEPRECIATIONKEY | Depreciation key | AFASL | CHAR (4) | |
| HASACTIVEENTITY | Draft – Indicator – Has active document | SDRAFT_HAS_ACTIVE | CHAR (1) | |
| DRAFTENTITYCREATIONDATETIME | Draft Created On | SDRAFT_CREATED_AT | DEC (21) | |
| DRAFTENTITYLASTCHANGEDATETIME | Draft Last Changed On | SDRAFT_LAST_CHANGED_AT | DEC (21) | |
| DRAFTADMINISTRATIVEDATAUUID | Technical ID for the Administrative Data of a Draft Document | SDRAFT_ADMIN_UUID | RAW (16) | |
| DRAFTENTITYCONSISTENCYSTATUS | Draft Consistency Status | SDRAFT_CONSISTENCY_STATUS | CHAR (1) | |
| DRAFTENTITYOPERATIONCODE | Draft – Operation Code | SDRAFT_OPERATION_CODE | CHAR (1) |
