SAP Table

ANKA Asset classes: general data

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

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

/ Fields

ANKA columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 MANDT
KeyANLKL 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
ANEQS Completeness indicator for the asset NUMC 1 0 ANEQS
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
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
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
/ Relationships

ANKA foreign keys.

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