SAP ABAP Table RANLA (ANLA Structure with Update Indicator, as for Change Docs)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ IM-FA (Application Component) Capital Investments
     ⤷ AIS (Package) IM Deprec. Simulation Data - Inv.Prog., App.Reqs., Measures

Basic Data

Table Category	INTTAB	Structure
Structure	RANLA	Table Relationship Diagram
Short Description	ANLA Structure with Update Indicator, as for Change Docs

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	Asset Master Record Segment
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
4	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
5	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	*
6	ANLKL	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	ANKA
7	GEGST	☐	GEGST	GEGST	CHAR	8	0	Technical asset number
8	ANLAR	☐	ANLAR	CHAR5	CHAR	5	0	Asset types
9	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
11	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
12	AEDAT	☐	AEDAT_ANLA	DATUM	DATS	8	0	Changed on
13	XLOEV	☐	XLOEV	XFELD	CHAR	1	0	Indicator: Account marked for deletion?
14	XSPEB	☐	XSPEB_ANLA	XFELD	CHAR	1	0	Indicator: Asset Locked to Acquisition Postings
15	FELEI	☐	FELEI	FELEI	CHAR	4	0	Screen layout for Asset Accounting	*
16	KTOGR	☐	KTOGR	KTOGR	CHAR	8	0	Account determination	T095A
17	XOPVW	☐	OPVWA	XFELD	CHAR	1	0	Asset under construct. with line item settlement
18	ANLTP	☐	ANLTP	ANLTP	NUMC	1	0	Asset Category
19	ZUJHR	☐	DZUJAHR	GJAHR	NUMC	4	0	Fiscal year in which first acquisition was posted
20	ZUPER	☐	DZUPER	POPER	NUMC	3	0	Period in which first acquisition was posted
21	ZUGDT	☐	DZUGDAT	DATUM	DATS	8	0	Asset value date of the first posting
22	AKTIV	☐	AKTIVD	DATUM	DATS	8	0	Asset capitalization date
23	ABGDT	☐	ABGDAT	DATUM	DATS	8	0	Asset value date for the last retirement
24	DEAKT	☐	DEAKT	DATUM	DATS	8	0	Deactivation date
25	GPLAB	☐	GPLAB	DATUM	DATS	8	0	Planned retirement date
26	BSTDT	☐	BSTDT	DATUM	DATS	8	0	Asset purchase order date
27	ORD41	☐	ORD41	ORD4X	CHAR	4	0	Evaluation group 1	T087
28	ORD42	☐	ORD42	ORD4X	CHAR	4	0	Evaluation group 2	T087
29	ORD43	☐	ORD43	ORD4X	CHAR	4	0	Evaluation group 3	T087
30	ORD44	☐	ORD44	ORD4X	CHAR	4	0	Evaluation group 4	T087
31	ANLUE	☐	ANLUE	ANLUE	CHAR	12	0	Asset super number	T087U
32	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
33	ANEQK	☐	ANEQK	ANEQK	NUMC	1	0	Indicator: Historical management
34	ANEQS	☐	ANEQS	ANEQS	NUMC	1	0	Completeness indicator for the asset
35	LIFNR	☐	AM_LIFNR	LIFNR	CHAR	10	0	Account number of vendor (other key word)	LFA1
36	LAND1	☐	AM_LAND1	LAND1	CHAR	3	0	Asset's country of origin	T005
37	LIEFE	☐	LIEFE	TEXT30	CHAR	30	0	Name of asset supplier
38	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
39	EIGKZ	☐	EIGKZ	EIGKZ	CHAR	1	0	Property indicator	T097
40	AIBN1	☐	AIBN1	ANLN1	CHAR	12	0	Original asset that was transferred	*
41	AIBN2	☐	AIBN2	ANLN2	CHAR	4	0	Original asset that was transferred	*
42	AIBDT	☐	AIBDT	DATUM	DATS	8	0	Original acquisition date of AuC/ transferred asset
43	URJHR	☐	URJHR	GJAHR	NUMC	4	0	Fiscal year of original acquisition
44	URWRT	☐	URWRT	ANLKWERT	CURR	13	2	Original acquisition value
45	ANTEI	☐	ANTEI	PRZ32	DEC	5	2	In-house production percentage
46	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
47	EAUFN	☐	AM_AUFNR	AUFNR	CHAR	12	0	Investment Order	*
48	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
49	MENGE	☐	AM_MENGE	MENG13V	QUAN	13	3	Quantity
50	TYPBZ	☐	TYPBZ_ANLA	TYPBZ_ANLA	CHAR	15	0	Asset type name
51	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
52	INKEN	☐	INKEN	XFELD	CHAR	1	0	Inventory indicator
53	IVDAT	☐	IVDAT_ANLA	DATUM	DATS	8	0	Last inventory date
54	INVZU	☐	INVZU_ANLA	INVZU_ANLA	CHAR	15	0	Supplementary inventory specifications
55	VMGLI	☐	VMGLI	VMGLI	CHAR	4	0	Property classification key	T092
56	XVRMW	☐	XVRMW	XFELD	CHAR	1	0	Manual net worth tax value
57	WRTMA	☐	WRTMA	ANLKWERT	CURR	13	2	Manual net worth tax value
58	EHWRT	☐	EHWRT	ANLKWERT	CURR	13	2	Assessed value
59	AUFLA	☐	AUFLA_ANLA	DATUM	DATS	8	0	Date of conveyance
60	EHWZU	☐	EHWZU_ANLA	DATUM	DATS	8	0	Date of last notice of assessment
61	EHWNR	☐	EHWNR_ANLA	EHWNR_ANLA	CHAR	16	0	Tax number of the notice of assessment
62	GRUVO	☐	GRUVO_ANLA	DATUM	DATS	8	0	Land Register of
63	GREIN	☐	GREIN_ANLA	DATUM	DATS	8	0	Land register entry on
64	GRBND	☐	GRBND_ANLA	GRBND_ANLA	CHAR	5	0	Land register volume
65	GRBLT	☐	GRBLT_ANLA	GRBLT_ANLA	CHAR	5	0	Land register page
66	GRLFD	☐	GRLFD_ANLA	GRLFD_ANLA	CHAR	4	0	Land register entry: Sequence number
67	FLURK	☐	FLURK_ANLA	CHAR4	CHAR	4	0	Land register map number
68	FLURN	☐	FLURN_ANLA	CHAR10	CHAR	10	0	Plot number
69	FIAMT	☐	FIAMT	TEXT25	CHAR	25	0	Local tax office
70	STADT	☐	ORT01_ANLA	TEXT25	CHAR	25	0	Municipality
71	GRUND	☐	GRUND	GRUND	CHAR	3	0	Reason for manual valuation of net assets	T098
72	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
73	GRUFL	☐	GRUFL	MENG13	QUAN	13	3	Surface area
74	INVNR	☐	INVNR_ANLA	INVNR_ANLA	CHAR	25	0	Inventory number
75	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
76	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
77	TXT50	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
78	TXA50	☐	TXA50_MORE	TEXT50	CHAR	50	0	Additional asset description
79	XLTXID	☐	XLTXID	XFELD	CHAR	1	0	Indicator: Long text active
80	XVERID	☐	XVERID	XFELD	CHAR	1	0	Long text indicator:Property values
81	XTCHID	☐	XTCHID	XFELD	CHAR	1	0	Indicator: Technical view long text
82	XKALID	☐	XKALID	XFELD	CHAR	1	0	Indicator: Long text active
83	XHERID	☐	XHERID	XFELD	CHAR	1	0	Indicator: Long text for manufacturer/origin
84	XLEAID	☐	XLEAID	XFELD	CHAR	1	0	Indicator: Leasing data long text
85	LEAFI	☐	LEAFI	LIFNR	CHAR	10	0	Leasing company	LFA1
86	LVDAT	☐	LVDAT	DATUM	DATS	8	0	Leasing agreement date
87	LKDAT	☐	LKDAT	DATUM	DATS	8	0	Leasing agreement notice date
88	LEABG	☐	LEABG	DATUM	DATS	8	0	Lease start date
89	LEJAR	☐	LEJAR	JARAF	NUMC	3	0	Length of lease in years
90	LEPER	☐	LEPER	PERAF	NUMC	3	0	Length of lease in periods
91	LRYTH	☐	LRYTH	PERAF	NUMC	3	0	Lease payment cycle
92	LEGEB	☐	LEGEB	ANLKWERT	CURR	13	2	Periodic lease payment paid to leasing company/lessor
93	LBASW	☐	LBASW	ANLKWERT	CURR	13	2	Leasing base value as new
94	LKAUF	☐	LKAUF	ANLKWERT	CURR	13	2	Leased asset purchase price
95	LMZIN	☐	LMZIN	AFPROZ	DEC	7	4	Leasing monthly interest rate (Capital Lease)
96	LZINS	☐	LZINS	AFPROZ	DEC	7	4	Leasing interest rate (capital lease)
97	LTZBW	☐	LTZBW	DATUM	DATS	8	0	Posting date of the last lease payment
98	LKUZA	☐	LKUZA	ANLKWERT	CURR	13	2	Total of posted leasing payments
99	LKUZI	☐	LKUZI	ANLKWERT	CURR	13	2	Total leasing interest posted
100	LLAVB	☐	LLAVB	ANLKWERT	CURR	13	2	Total of long-term leasing liability
101	LEANZ	☐	LEANZ	DEC5	DEC	5	0	Number of lease payments
102	LVTNR	☐	LVTNR	CHAR15	CHAR	15	0	Leasing agreement number
103	LETXT	☐	LETXT	TEXT50	CHAR	50	0	Leasing data text
104	XAKTIV	☐	XAKTIV	XFELD	CHAR	1	0	Indicator: Capitalize fixed asset
105	ANUPD	☐	ANUPD	ANUPD	CHAR	1	0	Indicator: Type of change to table
106	LBLNR	☐	LBLNR	BELNR	CHAR	10	0	No. of last document with which posting to asset was made
107	XV0DT	☐	XV0DT	DATUM	DATS	8	0	Change date: View 0
108	XV0NM	☐	XV0NM	USNAM	CHAR	12	0	Name of person in charge, who changed View0
109	XV1DT	☐	XV1DT	DATUM	DATS	8	0	Change date: View 1
110	XV1NM	☐	XV1NM	USNAM	CHAR	12	0	Name of person in charge, who changed view 1
111	XV2DT	☐	XV2DT	DATUM	DATS	8	0	Change date: View 2
112	XV2NM	☐	XV2NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 2
113	XV3DT	☐	XV3DT	DATUM	DATS	8	0	Change date: View 3
114	XV3NM	☐	XV3NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 3
115	XV4DT	☐	XV4DT	DATUM	DATS	8	0	Change date: View 4
116	XV4NM	☐	XV4NM	USNAM	CHAR	12	0	Name of the person in charge, who changed view 4
117	XV5DT	☐	XV5DT	DATUM	DATS	8	0	Change date:View 5
118	XV5NM	☐	XV5NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 5
119	XV6DT	☐	XV6DT	DATUM	DATS	8	0	Change date:View 6
120	XV6NM	☐	XV6NM	USNAM	CHAR	12	0	Name of the person in charge who changed view 6
121	AIMMO	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
122	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	ONR00
123	LEART	☐	LEART	LEASART	CHAR	2	0	Leasing type	T083L
124	LVORS	☐	LVORS	XFELD	CHAR	1	0	Advance payments
125	GDLGRP	☐	GDLGRP	GDLGRP	CHAR	8	0	Evaluation group 5	T087G
126	POSNR	☐	AM_POSNR	PS_POSNR	NUMC	8	0	WBS element investment project	PRPS
127	XERWRT	☐	XERWRT	XFELD	CHAR	1	0	Indicator: Ignore memo value
128	XAFABCH	☐	XAFABCH	XFELD	CHAR	1	0	Asset acquired used
129	XANLGR	☐	XANLGR_1	XFELD	CHAR	1	0	Indicator: Asset is a group asset
130	MCOA1	☐	MCOA1	CHAR30	CHAR	30	0	Search term for matchcode search
131	XINVM	☐	IM_XINVM	XFELD	CHAR	1	0	Asset under Construction for Investment Measures
132	SERNR	☐	AM_SERNR	GERNR	CHAR	18	0	Serial number
133	UMWKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
134	LRVDAT	☐	AM_LRVDAT	DATUM	DATS	8	0	Date of last revaluation
135	ACT_CHANGE_PM	☐	AAPM_ACT_CHANGE_PM	AAPM_ACT	CHAR	1	0	Change Asset Master Record from Equipment Master
136	HAS_TDDP	☐	HAS_TDDP	BOOLE	CHAR	1	0	Asset Has Time-Dependent Valuation Parameters in ANLBZA
137	LAST_REORG_DATE	☐	FAA_LAST_REORG	DATUM	DATS	8	0	Date of Last Reorganization
138	.INCLUDE	☐				0	0	Structures for generating change document update programs
139	KZ	☐	CDCHNGIND	CDCHNGIND	CHAR	1	0	Change type (U, I, E, D)
140	.INCLUDE	☐				0	0	External currency field for ANLA change docs.
141	T001WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RANLA	ANLKL	ANKA	ANLKL
2	RANLA	ANLN1	ANLH	ANLN1
3	RANLA	ANLUE	T087U	ANLUE	REF	1	CN
4	RANLA	BUKRS	T001	BUKRS
5	RANLA	EIGKZ	T097	EIGKZ
6	RANLA	FEINS	T006	MSEHI
7	RANLA	GDLGRP	T087G	GDLGRP
8	RANLA	GRUND	T098	GRUND
9	RANLA	IZWEK	T087I	IZWEK
10	RANLA	KTOGR	T095A	KTOGR
11	RANLA	LAND1	T005	LAND1
12	RANLA	LEAFI	LFA1	LIFNR
13	RANLA	LEART	T083L	LEART
14	RANLA	LIFNR	LFA1	LIFNR
15	RANLA	MEINS	T006	MSEHI
16	RANLA	OBJNR	ONR00	OBJNR
17	RANLA	ORD41	T087	ORD4X
18	RANLA	ORD42	T087	ORD4X
19	RANLA	ORD43	T087	ORD4X
20	RANLA	ORD44	T087	ORD4X
21	RANLA	POSNR	PRPS	PSPNR
22	RANLA	SPRAS	T002	SPRAS
23	RANLA	UMWKZ	T087K	UMWKZ	REF	1	CN
24	RANLA	VBUND	T880	RCOMP
25	RANLA	VMGLI	T092	VMGLI
26	RANLA	ZUAWA	TZUN	ZUAWA

History

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