SAP ABAP Table U_22697 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_22697	Table Relationship Diagram
Short Description	Generated Table for View

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	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
3	ANLKL	☑	ANLKL	ANLKL	CHAR	8	0	Asset Class
4	TXK20	☐	TXT20_ANKT	TEXT20	CHAR	20	0	Short Text for Asset Class Name
5	TXK50	☐	TXT50_ANKT	TEXT50	CHAR	50	0	Asset class description
6	TXT50	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
7	TXA50	☐	TXA50_ANLT	TEXT50	CHAR	50	0	Asset description
8	XLTXID	☐	XLTXID	XFELD	CHAR	1	0	Indicator: Long text active
9	SUNART	☐	VVSUNART	VVSUNART	CHAR	8	0	Main usage type	TIV36
10	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
11	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
12	AENAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	AEDAT	☐	AEDAT_ANLA	DATUM	DATS	8	0	Changed on
14	XLOEV	☐	XLOEV_ANKA	XFELD	CHAR	1	0	Ind.: Asseet class marked for deletion
15	XSPEA	☐	XSPEA_ANKA	XFELD	CHAR	1	0	Indicator: Asset class is blocked
16	XOPVW	☐	OPVWA	XFELD	CHAR	1	0	Asset under construct. with line item settlement
17	NUMKR	☐	NUMKR	CHAR2	CHAR	2	0	Number range
18	KTOGR	☐	KTOGR	KTOGR	CHAR	8	0	Account determination	T095A
19	ANKAR	☐	ANKAR	TDFORMNEW	CHAR	16	0	Layout set name for asset history
20	FELEI	☐	FELEI	FELEI	CHAR	4	0	Screen layout for Asset Accounting	T082A
21	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
22	ZUAWA	☐	DZUAWA	ZUAWA	CHAR	3	0	Key for sorting according to assignment numbers	TZUN
23	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	TGSB
24	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
25	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center
26	LSTAR	☐	LSTAR	LSTAR	CHAR	6	0	Activity Type
27	ANEQK	☐	ANEQK	ANEQK	NUMC	1	0	Indicator: Historical management
28	ANEQS	☐	ANEQS	ANEQS	NUMC	1	0	Completeness indicator for the asset
29	MACKZ	☐	MACKZ	MACKZ	CHAR	1	0	Matchcode indicator
30	LAND1	☐	AM_LAND1	LAND1	CHAR	3	0	Asset's country of origin	T005
31	LIFNR	☐	AM_LIFNR	LIFNR	CHAR	10	0	Account number of vendor (other key word)	LFA1
32	LIEFE	☐	LIEFE	TEXT30	CHAR	30	0	Name of asset supplier
33	ANLUE	☐	ANLUE	ANLUE	CHAR	12	0	Asset super number	T087U
34	EIGKZ	☐	EIGKZ	EIGKZ	CHAR	1	0	Property indicator	T097
35	VMGLI	☐	VMGLI	VMGLI	CHAR	4	0	Property classification key	T092
36	XVRMW	☐	XVRMW	XFELD	CHAR	1	0	Manual net worth tax value
37	INVSL	☐	INVSL	INVSL	CHAR	2	0	Investment support key
38	ORD41	☐	ORD41	ORD4X	CHAR	4	0	Evaluation group 1	T087
39	ORD42	☐	ORD42	ORD4X	CHAR	4	0	Evaluation group 2	T087
40	ORD43	☐	ORD43	ORD4X	CHAR	4	0	Evaluation group 3	T087
41	ORD44	☐	ORD44	ORD4X	CHAR	4	0	Evaluation group 4	T087
42	IZWEK	☐	IZWEK	IZWEK	CHAR	2	0	Reason for investment	T087I
43	HERST	☐	HERST	TEXT30	CHAR	30	0	Manufacturer of asset
44	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
45	FEINS	☐	FEINS	MEINS	UNIT	3	0	Area unit	T006
46	INKEN	☐	INKEN	XFELD	CHAR	1	0	Inventory indicator
47	FIAMT	☐	FIAMT	TEXT25	CHAR	25	0	Local tax office
48	STADT	☐	ORT01_ANLA	TEXT25	CHAR	25	0	Municipality
49	ANLTP	☐	ANLTP	ANLTP	NUMC	1	0	Asset Category
50	XUNTV	☐	XUNTV	XFELD	CHAR	1	0	External/internal asset subnumber assignment
51	XAKTIV	☐	XAKTIV	XFELD	CHAR	1	0	Indicator: Capitalize fixed asset
52	LEAFI	☐	LEAFI	LIFNR	CHAR	10	0	Leasing company
53	LEJAR	☐	LEJAR	JARAF	NUMC	3	0	Length of lease in years
54	LEPER	☐	LEPER	PERAF	NUMC	3	0	Length of lease in periods
55	LRYTH	☐	LRYTH	PERAF	NUMC	3	0	Lease payment cycle
56	LMZIN	☐	LMZIN	AFPROZ	DEC	7	4	Leasing monthly interest rate (Capital Lease)
57	LEANZ	☐	LEANZ	DEC5	DEC	5	0	Number of lease payments
58	LETXT	☐	LETXT	TEXT50	CHAR	50	0	Leasing data text
59	AIMMO	☐	AIMMO	AIMMO	NUMC	1	0	Indicator: real estate
60	GDLGRP	☐	GDLGRP	GDLGRP	CHAR	8	0	Evaluation group 5	T087G
61	XERWRT	☐	XERWRT	XFELD	CHAR	1	0	Indicator: Ignore memo value
62	XANLGR	☐	XANLGR	XFELD	CHAR	1	0	Indicator: asset class managed as group asset
63	XINVM	☐	IM_XINVM	XFELD	CHAR	1	0	Asset under Construction for Investment Measures

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_22697	ANLUE	T087U	ANLUE	REF	1	CN
2	U_22697	EIGKZ	T097	EIGKZ	REF	1	CN
3	U_22697	FEINS	T006	MSEHI	REF	1	CN
4	U_22697	FELEI	T082A	FELEI	REF	1	N
5	U_22697	GDLGRP	T087G	GDLGRP	REF	C	CN
6	U_22697	GSBER	TGSB	GSBER	REF	1	CN
7	U_22697	IZWEK	T087I	IZWEK	KEY	1	CN
8	U_22697	KTOGR	T095A	KTOGR	REF	1	N
9	U_22697	LAND1	T005	LAND1	REF	1	CN
10	U_22697	LIFNR	LFA1	LIFNR	REF	1	CN
11	U_22697	MEINS	T006	MSEHI	REF	1	CN
12	U_22697	ORD41	T087	ORD4X	REF	1	CN
13	U_22697	ORD42	T087	ORD4X	REF	1	CN
14	U_22697	ORD43	T087	ORD4X	REF	1	CN
15	U_22697	ORD44	T087	ORD4X	REF	1	CN
16	U_22697	SPRAS	T002	SPRAS	KEY	1	N
17	U_22697	SUNART	TIV36	SUNART	KEY	1	CN
18	U_22697	VMGLI	T092	VMGLI	REF	1	CN
19	U_22697	WERKS	T001W	WERKS	REF	1	CN
20	U_22697	ZUAWA	TZUN	ZUAWA	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in