Overview
ANLB_D is a standard SAP S/4HANA table that stores I_FIXEDASSETTP I_FIXEDASSETDEPRAREATP data. There are total 48 fields in the ANLB_D table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table ANLB_D belongs to Fiori UI for Asset Accounting (FI-FIO-AA) module and is located in the package oData Services - FIAA Asset Master List (ODATA_AA_ASSET_MANAGE).
In addition, following links provide an overview of foreign key relationships, if any, that link ANLB_D to other SAP tables and standard CDS views available based on ANLB_D table in S/4HANA 2020.
Techincal Settings of ANLB_D
Below are technical details of the table ANLB_D
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of ANLB_D Fields
The following table gives you an overview of the fields available in ANLB_D
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|
| 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 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for ANLB_D
Other References