SAP ABAP Table FAA_S_DB_ASSET_DATA (Time-Independent Asset Master Data (ANLA))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-AA-AA (Application Component) Basic Functions
     ⤷ FAA_DB (Package) Database Access to Asset Tables

Basic Data

Table Category	INTTAB	Structure
Structure	FAA_S_DB_ASSET_DATA	Table Relationship Diagram
Short Description	Time-Independent Asset Master Data (ANLA)

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	ASSET_ID	☐	FAA_ASSET_ID	SYSUUID_C	CHAR	32	0	GUID That Uniquely Identifies an Asset
2	.INCLUDE	☐				0	0	Time-Dependent Asset Master Data
3	.INCLUDE	☐				0	0	General Data for Asset
4	.INCLUDE	☐				0	0	Key Fields for an Asset ID
5	.INCLUDE	☐				0	0	Key Fields for Identifying Main Asset Number
6	ORGUNIT	☐	FAA_ORG_CA	BUKRS	CHAR	4	0	Leading Organizational Unit for Asset Accounting	*
7	ASSET	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	*
8	SUBNUMBER	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
9	.INCLUDE	☐				0	0	Key of Asset Class
10	ASSETCLASS	☐	BF_ANLKL	BF_ANLKL	CHAR	8	0	Asset class	*
11	DESCRIPT	☐	BF_TXA50	TEXT50	CHAR	50	0	Asset Description
12	DESCRIPT2	☐	TXA50_MORE	TEXT50	CHAR	50	0	Additional asset description
13	SERIAL_NO	☐	BF_AM_SERNR	BF_GERNR	CHAR	18	0	Serial number
14	INVENT_NO	☐	BF_INVNR_ANLA	BF_INVNR_ANLA	CHAR	25	0	Inventory number
15	.INCLUDE	☐				0	0	Information Relevant for Posting on Asset
16	ACCT_DETRM	☐	BF_KTOGR	KTOGR	CHAR	8	0	Account determination	*
17	QUANTITY	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
18	BASE_UOM	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
19	CAP_DATE	☐	BF_AKTIVD	DATUM	DATS	8	0	Asset capitalization date
20	DEACT_DATE	☐	BF_DEAKT	DATUM	DATS	8	0	Deactivation date
21	INITIAL_ACQ	☐	BF_ZUGDAT	DATUM	DATS	8	0	Asset value date of the first posting
22	INITIAL_ACQ_YR	☐	BF_ZUJAHR	GJAHR	NUMC	4	0	Fiscal year in which first acquisition was posted
23	INITIAL_ACQ_PRD	☐	BF_ZUPER	POPER	NUMC	3	0	Period in which first acquisition was posted
24	PLRET_DATE	☐	BF_GPLAB	DATUM	DATS	8	0	Planned retirement date
25	LAST_RET_DATE	☐	ABGDAT	DATUM	DATS	8	0	Asset value date for the last retirement
26	PO_DATE	☐	BF_BSTDT	DATUM	DATS	8	0	Asset purchase order date
27	CAP_KEY	☐	ABGR_SCHL	ABGR_SCHL	CHAR	6	0	Results Analysis Key	*
28	LAST_REV_DATE	☐	AM_LRVDAT	DATUM	DATS	8	0	Date of last revaluation
29	.INCLUDE	☐				0	0	Allocations
30	EVALGROUP1	☐	BF_ORD41	BF_ORD4X	CHAR	4	0	Evaluation Group 1
31	EVALGROUP2	☐	BF_ORD42	BF_ORD4X	CHAR	4	0	Evaluation Group 2
32	EVALGROUP3	☐	BF_ORD43	BF_ORD4X	CHAR	4	0	Evaluation Group 3
33	EVALGROUP4	☐	BF_ORD44	BF_ORD4X	CHAR	4	0	Evaluation Group 4
34	EVALGROUP5	☐	BF_GDLGRP	BF_GDLGRP	CHAR	8	0	Sort Key 5
35	INV_REASON	☐	BF_IZWEK	BF_IZWEK	CHAR	2	0	Reason for investment
36	ENVIR_INVEST	☐	BF_AM_UMWKZ	BF_AM_UMWKZ	CHAR	5	0	Reason for environmental investment
37	ASSETSUPNO	☐	BF_ANLUE	BF_ANLUE	CHAR	12	0	Asset super number
38	.INCLUDE	☐				0	0	Entries on Origin of Asset
39	VENDOR_NO	☐	BF_AM_LIFNR	LIFNR	CHAR	10	0	Account number of vendor (other key word)	LFA1
40	VENDOR	☐	BF_LIEFE	TEXT30	CHAR	30	0	Name of asset supplier
41	MANUFACTURER	☐	BF_HERST	TEXT30	CHAR	30	0	Manufacturer of asset
42	PURCH_NEW	☐	XNEU_AM	XFELD	CHAR	1	0	Indicator: Asset purchased new
43	TRADE_ID	☐	BF_RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
44	COUNTRY	☐	BF_AM_LAND1	LAND1	CHAR	3	0	Asset's country of origin	T005
45	TYPE_NAME	☐	BF_TYPBZ_ANLA	BF_TYPBZ_ANLA	CHAR	15	0	Asset type name
46	ORIG_ASSET	☐	BF_AIBN1	BF_ANLN1	CHAR	12	0	Original asset that was transferred
47	ORIG_ASSET_SUBNO	☐	BF_AIBN2	BF_ANLN2	CHAR	4	0	Original asset that was transferred
48	ORIG_ACQ_DATE	☐	BF_AIBDT	DATUM	DATS	8	0	Original acquisition date of AuC/ transferred asset
49	ORIG_ACQ_YR	☐	BF_URJHR	GJAHR	NUMC	4	0	Fiscal year of original acquisition
50	ORIG_VALUE	☐	BF_URWRT	BAPICURR	DEC	23	4	Original acquisition value
51	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
52	INHOUSE_PROD_PRC	☐	BF_ANTEI	BF_PRZ32	DEC	5	2	In-house production percentage
53	.INCLUDE	☐				0	0	Account Assignment for Investment
54	INVEST_ORD	☐	BF_AM_AUFNR	AUFNR	CHAR	12	0	Investment Order	AUFK
55	WBS_ELEM	☐	PS_POSNR	PS_POSNR	NUMC	8	0	WBS Element	PRPS
56	.INCLUDE	☐				0	0	Entries for Inventory
57	INVNTRY_DATE	☐	BF_IVDAT_ANLA	DATUM	DATS	8	0	Last inventory date
58	INVNTRY_NOTE	☐	BF_INVZU_ANLA	BF_INVZU_ANLA	CHAR	15	0	Supplementary inventory specifications
59	.INCLU-_LS	☐				0	0	Leasing
60	COMPANY_LS	☐	BF_LEAFI	LIFNR	CHAR	10	0	Leasing company	*
61	AGRMNT_NO_LS	☐	BF_LVTNR	CHAR15	CHAR	15	0	Leasing agreement number
62	AGRMNTDATE_LS	☐	BF_LVDAT	DATUM	DATS	8	0	Leasing agreement date
63	NOTICEDATE_LS	☐	BF_LKDAT	DATUM	DATS	8	0	Leasing agreement notice date
64	START_DATE_LS	☐	BF_LEABG	DATUM	DATS	8	0	Lease start date
65	LNGTH_YRS_LS	☐	BF_LEJAR	BF_JARAF	NUMC	3	0	Length of lease in years
66	LNGTH_PRDS_LS	☐	BF_LEPER	BF_PERAF	NUMC	3	0	Length of lease in periods
67	TYPE_LS	☐	BF_LEART	BF_LEASART	CHAR	2	0	Leasing type
68	BASE_VALUE_LS	☐	LBASW	ANLKWERT	CURR	13	2	Leasing base value as new
69	PURCHPRICE_LS	☐	LKAUF	ANLKWERT	CURR	13	2	Leased asset purchase price
70	TEXT_LS	☐	BF_LETXT	TEXT50	CHAR	50	0	Leasing data text
71	NO_PAYMNTS_LS	☐	BF_LEANZ	DEC5	DEC	5	0	Number of lease payments
72	CYCLE_LS	☐	BF_LRYTH	BF_PERAF	NUMC	3	0	Lease payment cycle
73	IN_ADVANCE_LS	☐	BF_LVORS	BF_XFELD	CHAR	1	0	Advance payments
74	PAYMENT_LS	☐	LEGEB	ANLKWERT	CURR	13	2	Periodic lease payment paid to leasing company/lessor
75	INTEREST_LS	☐	BF_LZINS	BF_AFPROZ	DEC	7	4	Leasing interest rate (capital lease)
76	VALUE_LS	☐	LBARW	ANLKWERT	CURR	13	2	Present value of lease
77	CURRENCY_LS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
78	.INCLU-_NW	☐				0	0	Net Worth Valuation
79	CLASS_KEY_NW	☐	BF_VMGLI	BF_VMGLI	CHAR	4	0	Property classification key
80	PROP_IND_NW	☐	BF_EIGKZ	BF_EIGKZ	CHAR	1	0	Property indicator
81	MAN_PV_REASON_NW	☐	BF_GRUND	BF_GRUND	CHAR	3	0	Reason for manual valuation of net assets
82	MAN_PROP_VAL_NW	☐	WRTMA	ANLKWERT	CURR	13	2	Manual net worth tax value
83	CURRENCY_NW	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
84	HAS_MAN_PV_NW	☐	BF_XVRMW	BF_XFELD	CHAR	1	0	Manual net worth tax value
85	.INCLU-_RE	☐				0	0	Real Estate Data
86	TAX_OFFICE_RE	☐	BF_FIAMT	TEXT25	CHAR	25	0	Local tax office
87	TAX_NO_RE	☐	BF_EHWNR_ANLA	BF_EHWNR_ANLA	CHAR	16	0	Tax number of the notice of assessment
88	ASSMNT_NTCDT_RE	☐	BF_EHWZU_ANLA	DATUM	DATS	8	0	Date of last notice of assessment
89	MUNICIPALITY_RE	☐	BF_ORT01_ANLA	TEXT25	CHAR	25	0	Municipality
90	LNDREG_DT_RE	☐	BF_GRUVO_ANLA	DATUM	DATS	8	0	Land Register of
91	LNDREG_ENTRDT_RE	☐	BF_GREIN_ANLA	DATUM	DATS	8	0	Land register entry on
92	LNDREG_VOL_RE	☐	BF_GRBND_ANLA	BF_GRBND_ANLA	CHAR	5	0	Land register volume
93	LNDREG_PG_RE	☐	BF_GRBLT_ANLA	BF_GRBLT_ANLA	CHAR	5	0	Land register page
94	LNDREG_NO_RE	☐	BF_GRLFD_ANLA	BF_GRLFD_ANLA	CHAR	4	0	Land register entry: Sequence number
95	LNDREG_MAPNO_RE	☐	BF_FLURK_ANLA	CHAR4	CHAR	4	0	Land register map number
96	LNDREG_PLOTNO_RE	☐	BF_FLURN_ANLA	CHAR10	CHAR	10	0	Plot number
97	CONVEYANCE_DT_RE	☐	BF_AUFLA_ANLA	DATUM	DATS	8	0	Date of conveyance
98	AREA_RE	☐	BF_GRUFL	MENG13	QUAN	13	3	Surface area
99	AREA_UOM_RE	☐	BF_FEINS	MEINS	UNIT	3	0	Area unit	*
100	.INCLUDE	☐				0	0	Status Fields of Asset
101	COMPLETENESS	☐	ANEQS	ANEQS	NUMC	1	0	Completeness indicator for the asset
102	HISTORY	☐	XHIST_AM	XFELD	CHAR	1	0	Asset is managed historically
103	IS_GROUP_ASSET	☐	XANLGR_1	XFELD	CHAR	1	0	Indicator: Asset is a group asset
104	IS_INVSTMNT_MSR	☐	IM_XINVM	XFELD	CHAR	1	0	Asset under Construction for Investment Measures
105	LINE_ITEM_SETTL	☐	OPVWA	XFELD	CHAR	1	0	Asset under construct. with line item settlement
106	IGNORE_MEMVAL	☐	XERWRT	XFELD	CHAR	1	0	Indicator: Ignore memo value
107	PLND_FOR_DELETN	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
108	LOCKED_FOR_PSTNG	☐	XSPEB_ANLA	XFELD	CHAR	1	0	Indicator: Asset Locked to Acquisition Postings
109	IS_REAL_ESTATE	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
110	INCL_IN_INV_LIST	☐	BF_INKEN	BF_XFELD	CHAR	1	0	Inventory indicator
111	HAS_TDDP	☐	HAS_TDDP	BOOLE	CHAR	1	0	Asset Has Time-Dependent Valuation Parameters in ANLBZA
112	.INCLUDE	☐				0	0	Log Data for Asset Master Record
113	.INCLUDE	☐				0	0	Log Data for Asset Changes
114	CREATION_DATE	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
115	CREATED_BY	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
116	CHANGE_DATE	☐	AEDAT_ANLA	DATUM	DATS	8	0	Changed on
117	CHANGED_BY	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
118	SCR_LAYOUT_CRTN	☐	FELEI	FELEI	CHAR	4	0	Screen layout for Asset Accounting	*
119	.INCLU-0	☐				0	0	Log Data on the Asset Views Used
120	CHANGE_VIEW0	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
121	VIEW_USED_BY0	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
122	.INCLU-1	☐				0	0	Log Data on the Asset Views Used
123	CHANGE_VIEW1	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
124	VIEW_USED_BY1	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
125	.INCLU-2	☐				0	0	Log Data on the Asset Views Used
126	CHANGE_VIEW2	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
127	VIEW_USED_BY2	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
128	.INCLU-3	☐				0	0	Log Data on the Asset Views Used
129	CHANGE_VIEW3	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
130	VIEW_USED_BY3	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
131	.INCLU-4	☐				0	0	Log Data on the Asset Views Used
132	CHANGE_VIEW4	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
133	VIEW_USED_BY4	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
134	.INCLU-5	☐				0	0	Log Data on the Asset Views Used
135	CHANGE_VIEW5	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
136	VIEW_USED_BY5	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
137	.INCLU-6	☐				0	0	Log Data on the Asset Views Used
138	CHANGE_VIEW6	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
139	VIEW_USED_BY6	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAA_S_DB_ASSET_DATA	COUNTRY	T005	LAND1
2	FAA_S_DB_ASSET_DATA	CURRENCY	TCURC	WAERS
3	FAA_S_DB_ASSET_DATA	CURRENCY_NW	TCURC	WAERS
4	FAA_S_DB_ASSET_DATA	INVEST_ORD	AUFK	AUFNR
5	FAA_S_DB_ASSET_DATA	TRADE_ID	T880	RCOMP
6	FAA_S_DB_ASSET_DATA	VENDOR_NO	LFA1	LIFNR
7	FAA_S_DB_ASSET_DATA	WBS_ELEM	PRPS	PSPNR

History

Last changed by/on	SAP	20130529
SAP Release Created in	500