SAP ABAP Table V_ANLSUM_5 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_ANLSUM_5   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 BUKRS BUKRS BUKRS CHAR 4   0   Company Code T093C
3 ANLN1 ANLN1 ANLN1 CHAR 12   0   Main Asset Number ANLH
4 ANLN2 ANLN2 ANLN2 CHAR 4   0   Asset Subnumber  
5 BDATU BDATU DATUM DATS 8   0   Date validity ends  
6 AFABE AFABE_D AFABE NUMC 2   0   Real depreciation area T093
7 GJAHR GJAHR GJAHR NUMC 4   0   Fiscal Year  
8 ANLKL ANLKL ANLKL CHAR 8   0   Asset Class ANKA
9 GEGST GEGST GEGST CHAR 8   0   Technical asset number  
10 ANLAR ANLAR CHAR5 CHAR 5   0   Asset types  
11 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
12 ERDAT ERDAT DATUM DATS 8   0   Date on which the record was created  
13 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
14 AEDAT AEDAT_ANLA DATUM DATS 8   0   Changed on  
15 XLOEV XLOEV XFELD CHAR 1   0   Indicator: Account marked for deletion?  
16 XSPEB XSPEB_ANLA XFELD CHAR 1   0   Indicator: Asset Locked to Acquisition Postings  
17 FELEI FELEI FELEI CHAR 4   0   Screen layout for Asset Accounting  
18 KTOGR KTOGR KTOGR CHAR 8   0   Account determination T095A
19 XOPVW OPVWA XFELD CHAR 1   0   Asset under construct. with line item settlement  
20 ANLTP ANLTP ANLTP NUMC 1   0   Asset Category  
21 ZUJHR DZUJAHR GJAHR NUMC 4   0   Fiscal year in which first acquisition was posted  
22 ZUPER DZUPER POPER NUMC 3   0   Period in which first acquisition was posted  
23 ZUGDT DZUGDAT DATUM DATS 8   0   Asset value date of the first posting  
24 AKTIV AKTIVD DATUM DATS 8   0   Asset capitalization date  
25 ABGDT ABGDAT DATUM DATS 8   0   Asset value date for the last retirement  
26 DEAKT DEAKT DATUM DATS 8   0   Deactivation date  
27 GPLAB GPLAB DATUM DATS 8   0   Planned retirement date  
28 BSTDT BSTDT DATUM DATS 8   0   Asset purchase order date  
29 ORD41 ORD41 ORD4X CHAR 4   0   Evaluation group 1 T087
30 ORD42 ORD42 ORD4X CHAR 4   0   Evaluation group 2 T087
31 ORD43 ORD43 ORD4X CHAR 4   0   Evaluation group 3 T087
32 ORD44 ORD44 ORD4X CHAR 4   0   Evaluation group 4 T087
33 ANLUE ANLUE ANLUE CHAR 12   0   Asset super number T087U
34 ZUAWA DZUAWA ZUAWA CHAR 3   0   Key for sorting according to assignment numbers TZUN
35 ANEQK ANEQK ANEQK NUMC 1   0   Indicator: Historical management  
36 ANEQS ANEQS ANEQS NUMC 1   0   Completeness indicator for the asset  
37 LIFNR AM_LIFNR LIFNR CHAR 10   0   Account number of vendor (other key word) LFA1
38 LAND1 AM_LAND1 LAND1 CHAR 3   0   Asset's country of origin T005
39 LIEFE LIEFE TEXT30 CHAR 30   0   Name of asset supplier  
40 HERST HERST TEXT30 CHAR 30   0   Manufacturer of asset  
41 EIGKZ EIGKZ EIGKZ CHAR 1   0   Property indicator T097
42 AIBN1 AIBN1 ANLN1 CHAR 12   0   Original asset that was transferred  
43 AIBN2 AIBN2 ANLN2 CHAR 4   0   Original asset that was transferred  
44 AIBDT AIBDT DATUM DATS 8   0   Original acquisition date of AuC/ transferred asset  
45 URJHR URJHR GJAHR NUMC 4   0   Fiscal year of original acquisition  
46 URWRT URWRT ANLKWERT CURR 13   2   Original acquisition value  
47 ANTEI ANTEI PRZ32 DEC 5   2   In-house production percentage  
48 PROJN PROJN PROJN CHAR 16   0   Old: Project number : No longer used --> PS_POSNR  
49 EAUFN AM_AUFNR AUFNR CHAR 12   0   Investment Order  
50 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
51 MENGE AM_MENGE MENG13V QUAN 13   3   Quantity  
52 TYPBZ TYPBZ_ANLA TYPBZ_ANLA CHAR 15   0   Asset type name  
53 IZWEK IZWEK IZWEK CHAR 2   0   Reason for investment T087I
54 INKEN INKEN XFELD CHAR 1   0   Inventory indicator  
55 IVDAT IVDAT_ANLA DATUM DATS 8   0   Last inventory date  
56 INVZU INVZU_ANLA INVZU_ANLA CHAR 15   0   Supplementary inventory specifications  
57 VMGLI VMGLI VMGLI CHAR 4   0   Property classification key T092
58 XVRMW XVRMW XFELD CHAR 1   0   Manual net worth tax value  
59 WRTMA WRTMA ANLKWERT CURR 13   2   Manual net worth tax value  
60 EHWRT EHWRT ANLKWERT CURR 13   2   Assessed value  
61 AUFLA AUFLA_ANLA DATUM DATS 8   0   Date of conveyance  
62 EHWZU EHWZU_ANLA DATUM DATS 8   0   Date of last notice of assessment  
63 EHWNR EHWNR_ANLA EHWNR_ANLA CHAR 16   0   Tax number of the notice of assessment  
64 GRUVO GRUVO_ANLA DATUM DATS 8   0   Land Register of  
65 GREIN GREIN_ANLA DATUM DATS 8   0   Land register entry on  
66 GRBND GRBND_ANLA GRBND_ANLA CHAR 5   0   Land register volume  
67 GRBLT GRBLT_ANLA GRBLT_ANLA CHAR 5   0   Land register page  
68 GRLFD GRLFD_ANLA GRLFD_ANLA CHAR 4   0   Land register entry: Sequence number  
69 FLURK FLURK_ANLA CHAR4 CHAR 4   0   Land register map number  
70 FLURN FLURN_ANLA CHAR10 CHAR 10   0   Plot number  
71 FIAMT FIAMT TEXT25 CHAR 25   0   Local tax office  
72 STADT ORT01_ANLA TEXT25 CHAR 25   0   Municipality  
73 GRUND GRUND GRUND CHAR 3   0   Reason for manual valuation of net assets T098
74 FEINS FEINS MEINS UNIT 3   0   Area unit T006
75 GRUFL GRUFL MENG13 QUAN 13   3   Surface area  
76 INVNR INVNR_ANLA INVNR_ANLA CHAR 25   0   Inventory number  
77 VBUND RASSC RCOMP CHAR 6   0   Company ID of trading partner T880
78 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
79 TXT50 TXA50_ANLT TEXT50 CHAR 50   0   Asset description  
80 TXA50 TXA50_MORE TEXT50 CHAR 50   0   Additional asset description  
81 XLTXID XLTXID XFELD CHAR 1   0   Indicator: Long text active  
82 XVERID XVERID XFELD CHAR 1   0   Long text indicator:Property values  
83 XTCHID XTCHID XFELD CHAR 1   0   Indicator: Technical view long text  
84 XKALID XKALID XFELD CHAR 1   0   Indicator: Long text active  
85 XHERID XHERID XFELD CHAR 1   0   Indicator: Long text for manufacturer/origin  
86 XLEAID XLEAID XFELD CHAR 1   0   Indicator: Leasing data long text  
87 LEAFI LEAFI LIFNR CHAR 10   0   Leasing company LFA1
88 LVDAT LVDAT DATUM DATS 8   0   Leasing agreement date  
89 LKDAT LKDAT DATUM DATS 8   0   Leasing agreement notice date  
90 LEABG LEABG DATUM DATS 8   0   Lease start date  
91 LEJAR LEJAR JARAF NUMC 3   0   Length of lease in years  
92 LEPER LEPER PERAF NUMC 3   0   Length of lease in periods  
93 LRYTH LRYTH PERAF NUMC 3   0   Lease payment cycle  
94 LEGEB LEGEB ANLKWERT CURR 13   2   Periodic lease payment paid to leasing company/lessor  
95 LBASW LBASW ANLKWERT CURR 13   2   Leasing base value as new  
96 LKAUF LKAUF ANLKWERT CURR 13   2   Leased asset purchase price  
97 LMZIN LMZIN AFPROZ DEC 7   4   Leasing monthly interest rate (Capital Lease)  
98 LZINS LZINS AFPROZ DEC 7   4   Leasing interest rate (capital lease)  
99 LTZBW LTZBW DATUM DATS 8   0   Posting date of the last lease payment  
100 LKUZA LKUZA ANLKWERT CURR 13   2   Total of posted leasing payments  
101 LKUZI LKUZI ANLKWERT CURR 13   2   Total leasing interest posted  
102 LLAVB LLAVB ANLKWERT CURR 13   2   Total of long-term leasing liability  
103 LEANZ LEANZ DEC5 DEC 5   0   Number of lease payments  
104 LVTNR LVTNR CHAR15 CHAR 15   0   Leasing agreement number  
105 LETXT LETXT TEXT50 CHAR 50   0   Leasing data text  
106 XAKTIV XAKTIV XFELD CHAR 1   0   Indicator: Capitalize fixed asset  
107 LBLNR LBLNR BELNR CHAR 10   0   No. of last document with which posting to asset was made  
108 XV0DT XV0DT DATUM DATS 8   0   Change date: View 0  
109 XV0NM XV0NM USNAM CHAR 12   0   Name of person in charge, who changed View0  
110 XV1DT XV1DT DATUM DATS 8   0   Change date: View 1  
111 XV1NM XV1NM USNAM CHAR 12   0   Name of person in charge, who changed view 1  
112 XV2DT XV2DT DATUM DATS 8   0   Change date: View 2  
113 XV2NM XV2NM USNAM CHAR 12   0   Name of the person in charge, who changed view 2  
114 XV3DT XV3DT DATUM DATS 8   0   Change date: View 3  
115 XV3NM XV3NM USNAM CHAR 12   0   Name of the person in charge, who changed view 3  
116 XV4DT XV4DT DATUM DATS 8   0   Change date: View 4  
117 XV4NM XV4NM USNAM CHAR 12   0   Name of the person in charge, who changed view 4  
118 XV5DT XV5DT DATUM DATS 8   0   Change date:View 5  
119 XV5NM XV5NM USNAM CHAR 12   0   Name of the person in charge who changed view 5  
120 XV6DT XV6DT DATUM DATS 8   0   Change date:View 6  
121 XV6NM XV6NM USNAM CHAR 12   0   Name of the person in charge who changed view 6  
122 AIMMO AIMMO AIMMO NUMC 1   0   Indicator: real estate  
123 OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number ONR00
124 LEART LEART LEASART CHAR 2   0   Leasing type T083L
125 LVORS LVORS XFELD CHAR 1   0   Advance payments  
126 GDLGRP GDLGRP GDLGRP CHAR 8   0   Evaluation group 5 T087G
127 POSNR AM_POSNR PS_POSNR NUMC 8   0   WBS element investment project PRPS
128 XERWRT XERWRT XFELD CHAR 1   0   Indicator: Ignore memo value  
129 XAFABCH XAFABCH XFELD CHAR 1   0   Asset acquired used  
130 XANLGR XANLGR_1 XFELD CHAR 1   0   Indicator: Asset is a group asset  
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 ADATU ADATU DATUM DATS 8   0   Date for beginning of validity  
136 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center  
137 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
138 GSBER GSBER GSBER CHAR 4   0   Business Area TGSB
139 LSTAR LSTAR LSTAR CHAR 6   0   Activity Type  
140 MSFAK MSFAK MSFAK DEC 3   2   Multiple-shift factor for multiple shift operation  
141 XSTIL XSTIL XFELD CHAR 1   0   Asset shutdown  
142 STORT STORT AP_STAND CHAR 10   0   Asset location T499S
143 CAUFN CAUFN AUFNR CHAR 12   0   Internal order AUFK
144 RAUMN RAUMNR CHAR8 CHAR 8   0   Room  
145 IAUFN IAUFN AUFNR CHAR 12   0   Maintenance order AUFK
146 IPROJ PROJN PROJN CHAR 16   0   Old: Project number : No longer used --> PS_POSNR  
147 TXJCD TXJCD TXJCD CHAR 15   0   Tax Jurisdiction TTXJ
148 IPSNR AM_IPSNR PS_POSNR NUMC 8   0   WBS element - maintenance project PRPS
149 KFZKZ AM_KFZKZ AM_KFZKZ CHAR 15   0   License plate no. of vehichle  
150 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
151 KOSTLV KOSTLV KOSTL CHAR 10   0   Cost center responsible for asset  
152 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location  
153 GEBER BP_GEBER BP_GEBER CHAR 10   0   Fund  
154 FKBER FKBER FKBER CHAR 16   0   Functional Area  
155 GRANT_NBR GM_GRANT_NBR GM_GRANT_NBR CHAR 20   0   Grant  
156 FISTL FISTL FISTL CHAR 16   0   Funds Center  
157 GEBER2 BP_GEBER2 BP_GEBER CHAR 10   0   Fund for APC Account Assignments  
158 FKBER2 FKBER2 FKBER CHAR 16   0   Functional Area for APC Account Assignments  
159 GRANT_NBR2 GM_GRANT_NBR2 GM_GRANT_NBR CHAR 20   0   Grant for APC Account Assignments  
160 FISTL2 FISTL2 FISTL CHAR 16   0   Funds Center for APC Account Assignments  
161 IMKEY IMKEY IMKEY CHAR 8   0   Internal Key for Real Estate Object  
162 PS_PSP_PNR2 PS_PSP_PNR2 PS_POSNR NUMC 8   0   WBS Element (Costs)  
163 FELEI_B FELEI FELEI CHAR 4   0   Screen layout for Asset Accounting T082A
164 XNEGA XNEGA XFELD CHAR 1   0   Indicator: Negative values allowed  
165 XGWGK XGWGK XGWGK NUMC 1   0   Low-value asset amount and quantity check  
166 XUNTA XUNTA XFELD CHAR 1   0   Indicator: Depreciate main asset number totally  
167 AFABG AFABG DATUM DATS 8   0   Depreciation calculation start date  
168 ZINBG DZINBG DATUM DATS 8   0   Start date for interest calculation  
169 SAFBG SAFBG DATUM DATS 8   0   Start date for special depreciation  
170 INVSL INVSL INVSL CHAR 2   0   Investment support key T085
171 AFASL AFASL AFASL CHAR 4   0   Depreciation key T090NA
172 NDJAR NDJAR JARAF NUMC 3   0   Planned useful life in years  
173 NDPER NDPER PERAF NUMC 3   0   Planned useful life in periods  
174 NAPRZ NAPRZ AFPROZ DEC 7   4   Ordinary depreciation percentage rate  
175 SAPRZ SAPRZ AFPROZ DEC 7   4   Special depreciation percentage rate  
176 WBIND WBIND WBIND CHAR 5   0   Index series for replacement values T094A
177 ALIND ALIND WBIND CHAR 5   0   Index series for replacement values by age T094A
178 APROP APROP DEC3_4 DEC 7   4   Variable depreciation portion  
179 UMJAR UMJAR GJAHR NUMC 4   0   Depreciation key for the changeover year  
180 NDURJ NDURJ JARAF NUMC 3   0   Original useful life in years  
181 NDURP NDURP PERAF NUMC 3   0   Original useful life in periods  
182 SCHRW SCHRW ANLKWERT CURR 13   2   Asset scrap value  
183 LGJAN LGJAN GJAHR NUMC 4   0   Last fiscal year for the annual values in Asset Acct.  
184 AUFWTG AUFWTG AUFWTG NUMC 2   0   Revaluation  
185 XAFBE XAFBE XFELD CHAR 1   0   Indicator: Depreciation area is deactivated  
186 ANLGR ANLGR ANLN1 CHAR 12   0   Group asset ANLH
187 ANLGR2 ANLGR2 ANLN2 CHAR 4   0   Subnumber of group asset ANLA
188 VYEAR VYEAR GJAHR NUMC 4   0   Acquisition year of the asset (manually changeable)  
189 VMNTH VMNTH POPER NUMC 3   0   Asset Accounting: Acquis. month (in depreciation area)  
190 INBDA INBDA DATUM DATS 8   0   Asset Accounting: Date of operating readiness  
191 ABGDAT_B ABGDAT_B DATUM DATS 8   0   Value date of last retirement for the depreciation area  
192 PERAF PERAF PERAF NUMC 3   0   Depreciation calculation period  
193 AFBNR AFBNR NUM2 NUMC 2   0   Sequence number of depreciation posting run in the period  
194 AUFWP AUFWP ANLKWERT CURR 13   2   Planned revaluation on replacement value  
195 AUFWB AUFWB ANLKWERT CURR 13   2   Revaluation posted on replacement value  
196 AUFWZ AUFWZ ANLKWERT CURR 13   2   Revaluation on replacement value to be posted  
197 NAFAP NAFAP ANLKWERT CURR 13   2   Planned ordinary depreciation for the year  
198 NAFAG NAFAG ANLKWERT CURR 13   2   Ordinary depreciation posted in the current year  
199 NAFAZ NAFAZ ANLKWERT CURR 13   2   Ordinary depreciation to be posted  
200 SAFAP SAFAP ANLKWERT CURR 13   2   Planned special depreciation for the year  
201 SAFAG SAFAG ANLKWERT CURR 13   2   Special depreciation posted in the current fiscal year  
202 SAFAZ SAFAZ ANLKWERT CURR 13   2   Special depreciation to be posted  
203 AAFAP AAFAP ANLKWERT CURR 13   2   Scheduled unplanned depreciation for the year  
204 AAFAG AAFAG ANLKWERT CURR 13   2   Unplanned depreciation posted for the year  
205 AAFAZ AAFAZ ANLKWERT CURR 13   2   Unplanned depreciation to be posted  
206 MAFAP MAFAP ANLKWERT CURR 13   2   Planned transfer of reserves for the year  
207 MAFAG MAFAG ANLKWERT CURR 13   2   Acquisition value reducing depreciation posted for the year  
208 MAFAZ MAFAZ ANLKWERT CURR 13   2   Transferred reserves to be posted for the year  
209 ZINSP DZINSP ANLKWERT CURR 13   2   Interest planned for the year  
210 ZINSG DZINSG ANLKWERT CURR 13   2   Interest posted for the year  
211 ZINSZ DZINZB ANLKWERT CURR 13   2   Interest for the year to be posted  
212 AUFNP AUFNP ANLKWERT CURR 13   2   Planned revaluation of accumulated ordinary depreciation  
213 AUFNG AUFNG ANLKWERT CURR 13   2   Posted revaluation of accumulated ordinary depreciation  
214 AUFNZ AUFNZ ANLKWERT CURR 13   2   Revaluation to be posted on cum. ordinary depreciation  
215 ANSWL ANSWL ANLKWERT CURR 13   2   Transactions for the year affecting asset values  
216 INVZM INVZM ANLKWERT CURR 13   2   Investment grant for the year  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 V_ANLSUM_5 AFABE T093 AFABER REF 1 CN
2 V_ANLSUM_5 AFASL T090NA AFASL REF 1 N
3 V_ANLSUM_5 ALIND T094A WBIND REF 1 CN
4 V_ANLSUM_5 ANLGR ANLH ANLN1 REF C CN
5 V_ANLSUM_5 ANLGR2 ANLA ANLN2 REF C CN
6 V_ANLSUM_5 ANLKL ANKA ANLKL REF 1 N
7 V_ANLSUM_5 ANLN1 ANLH ANLN1 KEY 1 1
8 V_ANLSUM_5 ANLUE T087U ANLUE REF 1 CN
9 V_ANLSUM_5 BUKRS T093C BUKRS KEY 1 N
10 V_ANLSUM_5 CAUFN AUFK AUFNR REF C CN
11 V_ANLSUM_5 EIGKZ T097 EIGKZ REF 1 CN
12 V_ANLSUM_5 FEINS T006 MSEHI REF 1 CN
13 V_ANLSUM_5 FELEI_B T082A FELEI REF 1 CN
14 V_ANLSUM_5 GDLGRP T087G GDLGRP REF C CN
15 V_ANLSUM_5 GRUND T098 GRUND REF 1 CN
16 V_ANLSUM_5 GSBER TGSB GSBER REF 1 CN
17 V_ANLSUM_5 IAUFN AUFK AUFNR REF C CN
18 V_ANLSUM_5 INVSL T085 INVSL REF C CN
19 V_ANLSUM_5 IPSNR PRPS PSPNR REF C CN
20 V_ANLSUM_5 IZWEK T087I IZWEK KEY 1 CN
21 V_ANLSUM_5 KTOGR T095A KTOGR REF 1 CN
22 V_ANLSUM_5 LAND1 T005 LAND1 REF 1 CN
23 V_ANLSUM_5 LEAFI LFA1 LIFNR REF 1 C
24 V_ANLSUM_5 LEART T083L LEART REF C CN
25 V_ANLSUM_5 LIFNR LFA1 LIFNR REF 1 C
26 V_ANLSUM_5 MEINS T006 MSEHI REF 1 CN
27 V_ANLSUM_5 OBJNR ONR00 OBJNR REF C C
28 V_ANLSUM_5 ORD41 T087 ORD4X REF 1 CN
29 V_ANLSUM_5 ORD42 T087 ORD4X REF 1 CN
30 V_ANLSUM_5 ORD43 T087 ORD4X REF 1 CN
31 V_ANLSUM_5 ORD44 T087 ORD4X REF 1 CN
32 V_ANLSUM_5 POSNR PRPS PSPNR REF C CN
33 V_ANLSUM_5 SPRAS T002 SPRAS REF 1 N
34 V_ANLSUM_5 STORT T499S STAND REF 1 CN
35 V_ANLSUM_5 TXJCD TTXJ TXJCD REF 1 CN
36 V_ANLSUM_5 UMWKZ T087K UMWKZ REF 1 CN
37 V_ANLSUM_5 VBUND T880 RCOMP REF 1 CN
38 V_ANLSUM_5 VMGLI T092 VMGLI REF 1 CN
39 V_ANLSUM_5 WBIND T094A WBIND REF 1 CN
40 V_ANLSUM_5 WERKS T001W WERKS REF 1 CN
41 V_ANLSUM_5 ZUAWA TZUN ZUAWA REF 1 N
History
Last changed by/on SAP  20130529 
SAP Release Created in