SAP ABAP Table ANLAV (Asset Reporting: ANLA Fields Plus Cost Center...)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ AA (Package) Application Development R/3 Assets: Master Data

Basic Data

Table Category	INTTAB	Structure
Structure	ANLAV	Table Relationship Diagram
Short Description	Asset Reporting: ANLA Fields Plus Cost Center...

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	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
3	ANLN1	☐	ANLN1	ANLN1	CHAR	12	0	Main Asset Number	ANLH
4	ANLN2	☐	ANLN2	ANLN2	CHAR	4	0	Asset Subnumber	ANLA
5	ANLKL	☐	ANLKL	ANLKL	CHAR	8	0	Asset Class	ANKA
6	GEGST	☐	GEGST	GEGST	CHAR	8	0	Technical asset number
7	ANEQK	☐	ANEQK	ANEQK	NUMC	1	0	Indicator: Historical management
8	ANEQS	☐	ANEQS	ANEQS	NUMC	1	0	Completeness indicator for the asset
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	T082A
16	KTOGR	☐	KTOGR	KTOGR	CHAR	8	0	Account determination	T095A
17	XOPVW	☐	XOPVW	XFELD	CHAR	1	0	Indicator: Open Item Management?
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	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
33	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
34	LIEFE	☐	LIEFE	TEXT30	CHAR	30	0	Name of asset supplier
35	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
36	EIGKZ	☐	EIGKZ	EIGKZ	CHAR	1	0	Property indicator	T097
37	AIBN1	☐	AIBN1	ANLN1	CHAR	12	0	Original asset that was transferred	ANLH
38	AIBN2	☐	AIBN2	ANLN2	CHAR	4	0	Original asset that was transferred	ANLA
39	AIBDT	☐	AIBDT	DATUM	DATS	8	0	Original acquisition date of AuC/ transferred asset
40	URJHR	☐	URJHR	GJAHR	NUMC	4	0	Fiscal year of original acquisition
41	URWRT	☐	URWRT	ANLKWERT	CURR	13	2	Original acquisition value
42	ANTEI	☐	ANTEI	PRZ32	DEC	5	2	In-house production percentage
43	PROJN	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
44	EAUFN	☐	EAUFN	AUFNR	CHAR	12	0	Investment order	AUFK
45	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
46	MENGE	☐	MENGE_D	MENG13	QUAN	13	3	Quantity
47	TYPBZ	☐	TYPBZ_ANLA	TYPBZ_ANLA	CHAR	15	0	Asset type name
48	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
49	INKEN	☐	INKEN	XFELD	CHAR	1	0	Inventory indicator
50	IVDAT	☐	IVDAT_ANLA	DATUM	DATS	8	0	Last inventory date
51	INVZU	☐	INVZU_ANLA	INVZU_ANLA	CHAR	15	0	Supplementary inventory specifications
52	VMGLI	☐	VMGLI	VMGLI	CHAR	4	0	Property classification key	T092
53	XVRMW	☐	XVRMW	XFELD	CHAR	1	0	Manual net worth tax value
54	WRTMA	☐	WRTMA	ANLKWERT	CURR	13	2	Manual net worth tax value
55	EHWRT	☐	EHWRT	ANLKWERT	CURR	13	2	Assessed value
56	AUFLA	☐	AUFLA_ANLA	DATUM	DATS	8	0	Date of conveyance
57	EHWZU	☐	EHWZU_ANLA	DATUM	DATS	8	0	Date of last notice of assessment
58	EHWNR	☐	EHWNR_ANLA	EHWNR_ANLA	CHAR	16	0	Tax number of the notice of assessment
59	GRUVO	☐	GRUVO_ANLA	DATUM	DATS	8	0	Land Register of
60	GREIN	☐	GREIN_ANLA	DATUM	DATS	8	0	Land register entry on
61	GRBND	☐	GRBND_ANLA	GRBND_ANLA	CHAR	5	0	Land register volume
62	GRBLT	☐	GRBLT_ANLA	GRBLT_ANLA	CHAR	5	0	Land register page
63	GRLFD	☐	GRLFD_ANLA	GRLFD_ANLA	CHAR	4	0	Land register entry: Sequence number
64	FLURK	☐	FLURK_ANLA	CHAR4	CHAR	4	0	Land register map number
65	FLURN	☐	FLURN_ANLA	CHAR10	CHAR	10	0	Plot number
66	FIAMT	☐	FIAMT	TEXT25	CHAR	25	0	Local tax office
67	STADT	☐	ORT01_ANLA	TEXT25	CHAR	25	0	Municipality
68	GRUND	☐	GRUND	GRUND	CHAR	3	0	Reason for manual valuation of net assets	T098
69	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
70	GRUFL	☐	GRUFL	MENG13	QUAN	13	3	Surface area
71	INVNR	☐	INVNR_ANLA	INVNR_ANLA	CHAR	25	0	Inventory number
72	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	T880
73	TXT50	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
74	TXA50	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
75	XLTXID	☐	XLTXID	XFELD	CHAR	1	0	Indicator: Long text active
76	XVERID	☐	XVERID	XFELD	CHAR	1	0	Long text indicator:Property values
77	XTCHID	☐	XTCHID	XFELD	CHAR	1	0	Indicator: Technical view long text
78	XKALID	☐	XKALID	XFELD	CHAR	1	0	Indicator: Long text active
79	XHERID	☐	XHERID	XFELD	CHAR	1	0	Indicator: Long text for manufacturer/origin
80	XLEAID	☐	XLEAID	XFELD	CHAR	1	0	Indicator: Leasing data long text
81	LEAFI	☐	LEAFI	LIFNR	CHAR	10	0	Leasing company	LFA1
82	LVDAT	☐	LVDAT	DATUM	DATS	8	0	Leasing agreement date
83	LKDAT	☐	LKDAT	DATUM	DATS	8	0	Leasing agreement notice date
84	LEABG	☐	LEABG	DATUM	DATS	8	0	Lease start date
85	LEJAR	☐	LEJAR	JARAF	NUMC	3	0	Length of lease in years
86	LEPER	☐	LEPER	PERAF	NUMC	3	0	Length of lease in periods
87	LRYTH	☐	LRYTH	PERAF	NUMC	3	0	Lease payment cycle
88	LEGEB	☐	LEGEB	ANLKWERT	CURR	13	2	Periodic lease payment paid to leasing company/lessor
89	LBASW	☐	LBASW	ANLKWERT	CURR	13	2	Leasing base value as new
90	LKAUF	☐	LKAUF	ANLKWERT	CURR	13	2	Leased asset purchase price
91	LZINS	☐	LZINS	AFPROZ	DEC	7	4	Leasing interest rate (capital lease)
92	LTZBW	☐	LTZBW	DATUM	DATS	8	0	Posting date of the last lease payment
93	LKUZA	☐	LKUZA	ANLKWERT	CURR	13	2	Total of posted leasing payments
94	LKUZI	☐	LKUZI	ANLKWERT	CURR	13	2	Total leasing interest posted
95	LLAVB	☐	LLAVB	ANLKWERT	CURR	13	2	Total of long-term leasing liability
96	LEANZ	☐	LEANZ	DEC5	DEC	5	0	Number of lease payments
97	LVTNR	☐	LVTNR	CHAR15	CHAR	15	0	Leasing agreement number
98	LETXT	☐	LETXT	TEXT50	CHAR	50	0	Leasing data text
99	AIMMO	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
100	OBJNR	☐	OBJNR	OBJNR	CHAR	18	0	Object number (forecast)
101	OBART	☐	IM_OBART	IM_OBART	CHAR	2	0	Allowed object types for cap. inv. programs
102	PSPHI	☐	PS_PSPHI	PS_PSPNR	NUMC	8	0	Current number of the appropriate project	PROJ
103	PRNAM	☐	IM_PRNAM	IM_PRNAM	CHAR	8	0	Investment program name	IMTP
104	PRPOS	☐	IM_POSNR	IM_POSNR	NUMC	8	0	Position number	IMPR
105	PRGJR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
106	IMAPO	☐	IMA_POSNR	IMA_POSNR	CHAR	12	0	Internal number for appropriation request	IMAK
107	IMAPE	☐	IMA_POSID	IMA_POSID	CHAR	24	0	Appropriation Request Number (Formatted for Coding Mask)
108	IMAVA	☐	IMA_VARNT	IMA_VARNT	CHAR	4	0	Variant of Appropriation Request
109	IMAGN	☐	IM_GNJHR	GJAHR	NUMC	4	0	Approval year of the investment program
110	LFDNR	☐	IM_LFDNR	NUMC3	NUMC	3	0	Sequence number
111	LFDHI	☐	IM_LFDHI	NUMC6	NUMC	6	0	Consecutive no. within hierarchy
112	LEART	☐	LEART	LEASART	CHAR	2	0	Leasing type	T083L
113	LVORS	☐	LVORS	XFELD	CHAR	1	0	Advance payments
114	GDLGRP	☐	GDLGRP	GDLGRP	CHAR	8	0	Evaluation group 5	T087G
115	POSNR	☐	AM_POSID	PS_POSID	CHAR	24	0	WBS element investment project
116	PSPID	☐	AM_PSPID	PS_PSPID	CHAR	24	0	Project definition
117	XERWRT	☐	XERWRT	XFELD	CHAR	1	0	Indicator: Ignore memo value
118	XAFABCH	☐	XAFABCH	XFELD	CHAR	1	0	Asset acquired used
119	XANLGR	☐	XANLGR	XFELD	CHAR	1	0	Indicator: asset class managed as group asset
120	XINVM	☐	IM_XINVM	XFELD	CHAR	1	0	Asset under Construction for Investment Measures
121	SERNR	☐	AM_SERNR	GERNR	CHAR	18	0	Serial number
122	UMWKZ	☐	AM_UMWKZ	AM_UMWKZ	CHAR	5	0	Reason for environmental investment	T087K
123	LRVDAT	☐	AM_LRVDAT	DATUM	DATS	8	0	Date of last revaluation
124	BDATU	☐	BDATU	DATUM	DATS	8	0	Date validity ends
125	ADATU	☐	ADATU	DATUM	DATS	8	0	Date for beginning of validity
126	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	CSKS
127	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
128	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
129	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type	CSLA
130	MSFAK	☐	MSFAK	MSFAK	DEC	3	2	Multiple-shift factor for multiple shift operation
131	XSTIL	☐	XSTIL	XFELD	CHAR	1	0	Asset shutdown
132	STORT	☐	STORT	AP_STAND	CHAR	10	0	Asset location	T499S
133	CAUFN	☐	CAUFN	AUFNR	CHAR	12	0	Internal order	AUFK
134	RAUMN	☐	RAUMNR	CHAR8	CHAR	8	0	Room
135	IAUFN	☐	IAUFN	AUFNR	CHAR	12	0	Maintenance order	AUFK
136	IPROJ	☐	PROJN	PROJN	CHAR	16	0	Old: Project number : No longer used --> PS_POSNR
137	TPLNR	☐	TPLNR	TPLNR	CHAR	30	0	Functional Location	IFLOT
138	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	TTXJ
139	IPSNR	☐	AM_IPSNR	PS_POSNR	NUMC	8	0	WBS element - maintenance project	PRPS
140	KTANSW	☐	KTANSW	SAKNR	CHAR	10	0	Bal. sheet account: Acquisition and production costs	SKA1
141	ERGSO	☐	AM_ERGSO	ERGSL	CHAR	10	0	AA: Balance sheet item (debit)
142	ERGHB	☐	AM_ERGHB	ERGSL	CHAR	10	0	FI-AA: Balance sheet item (credit)
143	KHINR	☐	KHINR	SETNR	CHAR	12	0	Standard Hierarchy Area
144	ANLN0	☐	ANLN0	ANLN1	CHAR	12	0	Reporting: Asset main number	ANLH
145	WRTTP	☐	AM_WRTTP	AM_WRTTP	CHAR	1	0	Asset-value type
146	KFZKZ	☐	AM_KFZKZ	AM_KFZKZ	CHAR	15	0	License plate no. of vehichle
147	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
148	KOSTLV	☐	KOSTLV	KOSTL	CHAR	10	0	Cost center responsible for asset	CSKS
149	ANLHTXT	☐	ANLHTXT	TEXT50	CHAR	50	0	Asset main number text
150	ADDRNUM	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
151	KTSAKAN	☐	FIAA_KTSAKAN	CHAR10	CHAR	10	0	APC balance sheet account in significant length
152	KTAUFW	☐	KTAUFW	SAKNR	CHAR	10	0	Reconciliation account: Revaluation	*
153	KTAUFAN	☐	FIAA_KTAUFAN	CHAR10	CHAR	10	0	Balance Sheet Account Revaluation to Significant Length
154	POSNR2	☐	AM_POSID2	PS_POSID	CHAR	24	0	WBS Element (Costs for Depreciation)
155	PSPID2	☐	AM_PSPID2	PS_PSPID	CHAR	24	0	Project Definition for Depreciation
156	HAS_TDDP	☐	HAS_TDDP	BOOLE	CHAR	1	0	Asset Has Time-Dependent Valuation Parameters in ANLBZA
157	LAST_REORG_DATE	☐	FAA_LAST_REORG	DATUM	DATS	8	0	Date of Last Reorganization
158	.INCLUDE	☐				0	0
159	.INCLUDE	☐				0	0	FISTL + GEBER + FKBER + ANLZACCOUNT
160	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
161	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
162	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
163	.INCLUDE	☐				0	0	Additional Account Assignment Objects in Asset Accounting
164	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
165	GEBER2	☐	BP_GEBER2	BP_GEBER	CHAR	10	0	Fund for APC Account Assignments	*
166	FKBER2	☐	FKBER2	FKBER	CHAR	16	0	Functional Area for APC Account Assignments	*
167	GRANT_NBR2	☐	GM_GRANT_NBR2	GM_GRANT_NBR	CHAR	20	0	Grant for APC Account Assignments
168	FISTL2	☐	FISTL2	FISTL	CHAR	16	0	Funds Center for APC Account Assignments	*
169	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
170	PS_PSP_PNR2	☐	PS_PSP_PNR2	PS_POSNR	NUMC	8	0	WBS Element (Costs)	*
171	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
172	BUDGET_PD2	☐	FM_BUDGET_PERIOD2	FM_BUDGET_PERIOD	CHAR	10	0	Budget Period for APC Account Assignments	*
173	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	FAGL_SEGM
174	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
175	.INCLUDE	☐				0	0
176	.INCLU--AP	☐				0	0	JV fields appended to ANLAV for reporting purposes
177	VNAME	☐	JV_NAME	JV_NAME	CHAR	6	0	Joint venture	*
178	EGRUP	☐	JV_EGROUP	JV_EGROUP	CHAR	3	0	Equity group	*
179	RECID	☐	JV_RECIND	JV_RECIND	CHAR	2	0	Recovery Indicator	*
180	ETYPE	☐	JV_ETYPE	JV_ETYPE	CHAR	3	0	Equity type	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ANLAV	AIBN1	ANLH	ANLN1
2	ANLAV	AIBN2	ANLA	ANLN2
3	ANLAV	ANLKL	ANKA	ANLKL
4	ANLAV	ANLN0	ANLH	ANLN1
5	ANLAV	ANLN1	ANLH	ANLN1	KEY	1	CN
6	ANLAV	ANLN2	ANLA	ANLN2		1	CN
7	ANLAV	ANLUE	T087U	ANLUE	REF	1	CN
8	ANLAV	BUKRS	T001	BUKRS
9	ANLAV	CAUFN	AUFK	AUFNR
10	ANLAV	EAUFN	AUFK	AUFNR
11	ANLAV	EIGKZ	T097	EIGKZ
12	ANLAV	FEINS	T006	MSEHI
13	ANLAV	FELEI	T082A	FELEI
14	ANLAV	GDLGRP	T087G	GDLGRP
15	ANLAV	GRUND	T098	GRUND
16	ANLAV	GSBER	TGSB	GSBER
17	ANLAV	IAUFN	AUFK	AUFNR
18	ANLAV	IMAPO	IMAK	POSNR
19	ANLAV	IPSNR	PRPS	PSPNR
20	ANLAV	IZWEK	T087I	IZWEK		1	CN
21	ANLAV	KOSTL	CSKS	KOSTL
22	ANLAV	KOSTLV	CSKS	KOSTL		1	CN
23	ANLAV	KTANSW	SKA1	SAKNR
24	ANLAV	KTOGR	T095A	KTOGR
25	ANLAV	LAND1	T005	LAND1
26	ANLAV	LEAFI	LFA1	LIFNR
27	ANLAV	LEART	T083L	LEART
28	ANLAV	LIFNR	LFA1	LIFNR
29	ANLAV	LSTAR	CSLA	LSTAR		1	CN
30	ANLAV	MEINS	T006	MSEHI
31	ANLAV	ORD41	T087	ORD4X		1	CN
32	ANLAV	ORD42	T087	ORD4X		1	CN
33	ANLAV	ORD43	T087	ORD4X		1	CN
34	ANLAV	ORD44	T087	ORD4X		1	CN
35	ANLAV	PRNAM	IMTP	PRNAM		1	CN
36	ANLAV	PRPOS	IMPR	POSNR		1	CN
37	ANLAV	PSPHI	PROJ	PSPNR		1	CN
38	ANLAV	SEGMENT	FAGL_SEGM	SEGMENT
39	ANLAV	STORT	T499S	STAND
40	ANLAV	TPLNR	IFLOT	TPLNR
41	ANLAV	TXJCD	TTXJ	TXJCD
42	ANLAV	UMWKZ	T087K	UMWKZ		1	CN
43	ANLAV	VBUND	T880	RCOMP
44	ANLAV	VMGLI	T092	VMGLI
45	ANLAV	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in