SAP table ANKA (Asset classes: general data)

SAP table ANKA has 2 primary key fields being MANDT,ANLKL.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
ANLKL Asset Class CHAR 8 0 ANLKL
ERNAM Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ERDAT Date on which the record was created DATS 8 0 ERDAT
AENAM Name of Person Who Changed Object CHAR 12 0 AENAM
AEDAT Changed On DATS 8 0 AEDAT_ANLA
XLOEV Ind.: Asseet class marked for deletion CHAR 1 0 XLOEV_ANKA
XSPEA Indicator: Asset class is blocked CHAR 1 0 XSPEA_ANKA
XOPVW Asset under construct. with line item settlement CHAR 1 0 OPVWA
NUMKR Number Range CHAR 2 0 NUMKR
KTOGR Account Determination CHAR 8 0 T095A KTOGR
ANKAR Layout set name for asset history CHAR 16 0 ANKAR
FELEI Screen Layout for Asset Accounting CHAR 4 0 T082A FELEI
BEGRU Authorization Group CHAR 4 0 BEGRU
ZUAWA Key for sorting according to assignment numbers CHAR 3 0 TZUN DZUAWA
GSBER Business Area CHAR 4 0 TGSB GSBER
WERKS Plant CHAR 4 0 T001W WERKS_D
KOSTL Cost Center CHAR 10 0 KOSTL
LSTAR Activity Type CHAR 6 0 LSTAR
ANEQK Indicator: Historical management NUMC 1 0 ANEQK
0 Asset managed without history
1 Asset managed with history
ANEQS Completeness indicator for the asset NUMC 1 0 ANEQS
0 Asset is complete
1 Asset is incomplete, but can be posted
2 Asset is incomplete and cannot be posted (dep., retmt)
3 Asset is incomplete (cst ctr, int.order, activ.type missing)
4 Asset is incomplete (investment account assignment missing)
MACKZ Matchcode indicator CHAR 1 0 MACKZ
LAND1 Asset's Country/Region of Origin CHAR 3 0 T005 AM_LAND1
LIFNR Account number of vendor (other key word) CHAR 10 0 LFA1 AM_LIFNR
LIEFE Name of asset supplier CHAR 30 0 LIEFE
ANLUE Asset Super Number CHAR 12 0 T087U ANLUE
EIGKZ Property Indicator CHAR 1 0 T097 EIGKZ
VMGLI Property classification key CHAR 4 0 T092 VMGLI
XVRMW Manual net worth tax value CHAR 1 0 XVRMW
INVSL Investment Support Key CHAR 2 0 INVSL
ORD41 Evaluation group 1 CHAR 4 0 T087 ORD41
ORD42 Evaluation Group 2 CHAR 4 0 T087 ORD42
ORD43 Evaluation Group 3 CHAR 4 0 T087 ORD43
ORD44 Evaluation group 4 CHAR 4 0 T087 ORD44
IZWEK Reason for Investment CHAR 2 0 T087I IZWEK
HERST Manufacturer of Asset CHAR 30 0 HERST
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
FEINS Area Unit UNIT 3 0 T006 FEINS
INKEN Inventory Indicator CHAR 1 0 INKEN
FIAMT Local Tax Office CHAR 25 0 FIAMT
STADT Municipality CHAR 25 0 ORT01_ANLA
ANLTP Asset Category NUMC 1 0 ANLTP
0 Capitalized asset
1 Leased asset
2 Financial asset
XUNTV External/internal asset subnumber assignment CHAR 1 0 XUNTV
XAKTIV Indicator: Capitalize Fixed Asset CHAR 1 0 XAKTIV
LEAFI Leasing company CHAR 10 0 LEAFI
LEJAR Length of Lease in Years NUMC 3 0 LEJAR
LEPER Length of lease in periods NUMC 3 0 LEPER
LRYTH Lease payment cycle NUMC 3 0 LRYTH
LMZIN Leasing monthly interest rate (Capital Lease) DEC 7 4 LMZIN
LEANZ Number of Lease Payments DEC 5 0 LEANZ
LETXT Leasing data text CHAR 50 0 LETXT
AIMMO Indicator: Real Estate NUMC 1 0 AIMMO
0 Other asset without real estate management
1 Real estate - property or buildings
GDLGRP Evaluation Group 5 CHAR 8 0 T087G GDLGRP
XERWRT Indicator: Ignore memo value CHAR 1 0 XERWRT
XANLGR Indicator: asset class managed as group asset CHAR 1 0 XANLGR
XINVM Asset under Construction for Investment Measures CHAR 1 0 IM_XINVM
LEART Leasing type CHAR 2 0 T083L LEART
ABGSL Capitalization Key for Investment Measure CHAR 6 0 TKKAA IM_ABGR_SL

ANKA foreign key relationships

Table Field Check Table Check Field
0 ANKA ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders MANDT
0 ANKA ABGSL TKKAA Check Table for Results Analysis Key of RA for Orders ABGSL
1 ANKA ANLUE T087U Asset group number / asset group MANDT
1 ANKA ANLUE T087U Asset group number / asset group ANLUE
0 ANKA EIGKZ T097 Property indicator MANDT
0 ANKA EIGKZ T097 Property indicator EIGKZ
1 ANKA FEINS T006 Units of Measurement MANDT
0 ANKA FELEI T082A Field string asset master record maintenance MANDT
0 ANKA FELEI T082A Field string asset master record maintenance FEGTB
1 ANKA GDLGRP T087G Evaluation group 8 places MANDT
0 ANKA GSBER TGSB Business Areas MANDT
0 ANKA GSBER TGSB Business Areas GSBER
1 ANKA IZWEK T087I Reason for investment MANDT
1 ANKA IZWEK T087I Reason for investment IZWEK
0 ANKA KTOGR T095A Account allocation MANDT
0 ANKA KTOGR T095A Account allocation KTOGR
1 ANKA LAND1 T005 Countries MANDT
1 ANKA LAND1 T005 Countries LAND1
0 ANKA LEART T083L Leasing types MANDT
0 ANKA LEART T083L Leasing types LEART
1 ANKA LIFNR LFA1 Supplier Master (General Section) MANDT
1 ANKA LIFNR LFA1 Supplier Master (General Section) LIFNR
0 ANKA MEINS T006 Units of Measurement MANDT
0 ANKA MEINS T006 Units of Measurement MSEHI
1 ANKA ORD41 T087 Evaluation groups MANDT
1 ANKA ORD41 T087 Evaluation groups ORDNR
1 ANKA ORD41 T087 Evaluation groups ORD4X
0 ANKA ORD42 T087 Evaluation groups MANDT
0 ANKA ORD42 T087 Evaluation groups ORDNR
0 ANKA ORD42 T087 Evaluation groups ORD4X
1 ANKA ORD43 T087 Evaluation groups MANDT
1 ANKA ORD43 T087 Evaluation groups ORDNR
1 ANKA ORD43 T087 Evaluation groups ORD4X
0 ANKA ORD44 T087 Evaluation groups MANDT
0 ANKA ORD44 T087 Evaluation groups ORDNR
0 ANKA ORD44 T087 Evaluation groups ORD4X
1 ANKA VMGLI T092 Property classification key MANDT
0 ANKA WERKS T001W Plants/Branches MANDT
0 ANKA WERKS T001W Plants/Branches WERKS