SAP ANLA_D I_FIXEDASSETTP I_FIXEDASSETTP Table

Overview

ANLA_D is a standard SAP S/4HANA table that stores I_FIXEDASSETTP I_FIXEDASSETTP data. There are total 68 fields in the ANLA_D table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table ANLA_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 ANLA_D to other SAP tables and standard CDS views available based on ANLA_D table in S/4HANA 2020.

Techincal Settings of ANLA_D

Below are technical details of the table ANLA_D

Buffering not allowed
No buffering
Storage type is Column Store

List of ANLA_D Fields

The following table gives you an overview of the fields available in ANLA_D

Field	Description	Data Element	Data Type	Length
MANDT	Client	MANDT	CLNT	3
DRAFTUUID	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
COMPANYCODEFOREDIT	Company Code	BUKRS	CHAR	4
MASTERFIXEDASSETFOREDIT	Main Asset Number	ANLN1	CHAR	12
FIXEDASSETFOREDIT	Asset Subnumber	ANLN2	CHAR	4
FIXEDASSETEXTERNALID	Asset Number	FIS_FIXEDASSET_EXT_ID	CHAR	17
ASSETCLASS	Asset Class	ANLKL	CHAR	8
ASSETSERIALNUMBER	Serial number	AM_SERNR	CHAR	18
QUANTITY	Quantity	AM_MENGE	QUAN	13
BASEUNIT	Base Unit of Measure	MEINS	UNIT	3
INVENTORY	Inventory Number	INVNR_ANLA	CHAR	25
FIXEDASSETDESCRIPTION	Asset Description	TXA50_ANLT	CHAR	50
ASSETADDITIONALDESCRIPTION	Additional Asset Description	TXA50_MORE	CHAR	50
CURRENCY	Currency Key	WAERS	CUKY	5
ORIGLACQNAMTINCOCODECRCY	Original Acquisition Value	URWRT	CURR	23
PARTNERCOMPANY	Company ID of Trading Partner	RASSC	CHAR	6
ASSETMANUFACTURERNAME	Manufacturer of Asset	HERST	CHAR	30
INHOUSEPRODNPERCENT	In-house production percentage	ANTEI	DEC	5
ASSETSUPPLIERNAME	Name of asset supplier	LIEFE	CHAR	30
INVENTORYNOTE	Supplementary Inventory Specifications	INVZU_ANLA	CHAR	15
GROUP1ASSETEVALUATIONKEY	Evaluation group 1	ORD41	CHAR	4
GROUP2ASSETEVALUATIONKEY	Evaluation Group 2	ORD42	CHAR	4
GROUP3ASSETEVALUATIONKEY	Evaluation Group 3	ORD43	CHAR	4
GROUP4ASSETEVALUATIONKEY	Evaluation group 4	ORD44	CHAR	4
GROUP5ASSETEVALUATIONKEY	Evaluation Group 5	GDLGRP	CHAR	8
MASTERFIXEDASSETDESCRIPTION	Main Asset Text	FIS_ANLHTXT	CHAR	50
ASSETACCOUNTDETERMINATION	Account Determination	KTOGR	CHAR	8
HASHISTORY	Indicator: Historical management	ANEQK	NUMC	1
ASSETCAPITALIZATIONDATE	Asset Capitalization Date	AKTIVD	DATS	8
FIRSTACQUISITIONFISCALYEAR	Fiscal Year in Which First Acquisition Was Posted	DZUJAHR	NUMC	4
FIRSTACQUISITIONFISCALPERIOD	Period in Which First Acquisition Was Posted	DZUPER	NUMC	3
ASSETDEACTIVATIONDATE	Deactivation Date	DEAKT	DATS	8
PLANNEDRETIREMENTDATE	Planned Retirement Date	GPLAB	DATS	8
FIXEDASSETORDERDATE	Asset Purchase Order Date	BSTDT	DATS	8
ORIGINALMASTERFIXEDASSET	Original Asset That Was Transferred	AIBN1	CHAR	12
ORIGINALFIXEDASSET	Original Asset That Was Transferred	AIBN2	CHAR	4
ORIGINALFIXEDASSETVALUEDATE	Original Acquisition Date of AuC/ Transferred Asset	AIBDT	DATS	8
FIXEDASSETGROUP	Asset Super Number	ANLUE	CHAR	12
INVESTMENTREASON	Reason for Investment	IZWEK	CHAR	2
ASSETISREALESTATE	Indicator: Real Estate	AIMMO	NUMC	1
AREASIZEUNIT	Area Unit	FEINS	UNIT	3
INVESTMENTORDER	Investment Order	AM_AUFNR	CHAR	12
INVESTMENTPROJECTWBSELEMENT	WBS element investment project	AM_POSNR	NUMC	8
INVENTORYISCOUNTED	Inventory Indicator	INKEN	CHAR	1
LASTINVENTORYDATE	Last Inventory Date	IVDAT_ANLA	DATS	8
ASSETSYNCHRONIZATIONRULE	Change Asset Master Record from Equipment Master	AAPM_ACT_CHANGE_PM	CHAR	1
ORIGINALACQUISITIONFISCALYEAR	Fiscal Year of Original Acquisition	URJHR	NUMC	4
ASSETTYPENAME	Asset Type Name	TYPBZ_ANLA	CHAR	15
SUPPLIER	Account number of vendor (other key word)	AM_LIFNR	CHAR	10
ASSETCOUNTRYOFORIGIN	Asset's Country of Origin	AM_LAND1	CHAR	3
NOTICEOFASSESSMENTTAXID	Tax Number of the Notice of Assessment	EHWNR_ANLA	CHAR	16
LASTASSESSMENTNOTICEDATE	Date of last notice of assessment	EHWZU_ANLA	DATS	8
ENVRNMTLINVESTMENTREASON	Reason for Environmental Investment	AM_UMWKZ	CHAR	5
ACQUISITIONVALUEDATE	Asset Value Date of the First Posting	DZUGDAT	DATS	8
CREATIONDATE	Date on which the record was created	ERDAT	DATS	8
CREATEDBYUSER	Name of Person who Created the Object	ERNAM	CHAR	12
LASTCHANGEDATE	Changed On	FIS_AEDAT_ANLA	DATS	8
LASTCHANGEDBYUSER	Name of person who changed object	AENAM	CHAR	12
ASSETSTATUSATPURCHASE	Asset Status at Purchase: New, Used or Unknown	FIS_ASSET_PURCHASED_NEW_OR_USD	CHAR	1
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 ANLA_D

SAP ANLA_D I_FIXEDASSETTP I_FIXEDASSETTP Table

Overview

Techincal Settings of ANLA_D

List of ANLA_D Fields

Foreign Key Relationships

Other References