SAP ABAP Table FAA_S_ROOT_DATA (Root Structure Fixed Asset BO (ANLA & ANLV & ANLU))

Hierarchy

☛ EA-FIN (Software Component) EA-FIN
   ⤷ FI-AA (Application Component) Asset Accounting
     ⤷ FAA_MDO (Package) Master Data Wrapper for FAA_TP_TC

Basic Data

Table Category	INTTAB	Structure
Structure	FAA_S_ROOT_DATA	Table Relationship Diagram
Short Description	Root Structure Fixed Asset BO (ANLA & ANLV & ANLU)

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

Foreign Keys

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

History

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