1. Home
  2. Resources
  3. SAP Tables
  4. RANLA - ANLA Structure with Update Indicator, as for Change Docs

SAP Table RANLA

ANLA Structure with Update Indicator, as for Change Docs

RANLA (ANLA Structure with Update Indicator, as for Change Docs) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RANLA to other SAP tables.

Source: RANLA (ANLA Structure with Update Indicator, as for Change Docs)

RANLA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
BUKRS Company Code BUKRS T001 CHAR 4 0
ANLN1 Main Asset Number ANLN1 ANLH CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
ANLKL Asset Class ANLKL ANKA CHAR 8 0
GEGST Technical asset number GEGST CHAR 8 0
ANLAR Asset types ANLAR CHAR 5 0
ERNAM Name of Person who Created the Object ERNAM CHAR 12 0
ERDAT Date on Which Record Was Created ERDAT DATS 8 0
AENAM Name of Person Who Changed Object AENAM CHAR 12 0
AEDAT Changed on AEDAT_ANLA DATS 8 0
XLOEV Indicator: Account marked for deletion? XLOEV CHAR 1 0
X Yes
NULL No
XSPEB Indicator: Asset Locked to Acquisition Postings XSPEB_ANLA CHAR 1 0
X Yes
NULL No
FELEI Screen layout for Asset Accounting FELEI CHAR 4 0
KTOGR Account determination KTOGR T095A CHAR 8 0
XOPVW Asset under construct. with line item settlement OPVWA CHAR 1 0
X Yes
NULL No
ANLTP Asset Category ANLTP NUMC 1 0
0 Capitalized asset
1 Leased asset
2 Financial asset
ZUJHR Fiscal year in which first acquisition was posted DZUJAHR NUMC 4 0
ZUPER Period in which first acquisition was posted DZUPER NUMC 3 0
ZUGDT Asset value date of the first posting DZUGDAT DATS 8 0
AKTIV Asset capitalization date AKTIVD DATS 8 0
ABGDT Asset value date for the last retirement ABGDAT DATS 8 0
DEAKT Deactivation date DEAKT DATS 8 0
GPLAB Planned retirement date GPLAB DATS 8 0
BSTDT Asset purchase order date BSTDT DATS 8 0
ORD41 Evaluation group 1 ORD41 T087 CHAR 4 0
ORD42 Evaluation group 2 ORD42 T087 CHAR 4 0
ORD43 Evaluation group 3 ORD43 T087 CHAR 4 0
ORD44 Evaluation group 4 ORD44 T087 CHAR 4 0
ANLUE Asset super number ANLUE T087U CHAR 12 0
ZUAWA Key for sorting according to assignment numbers DZUAWA TZUN CHAR 3 0
ANEQK Indicator: Historical management ANEQK NUMC 1 0
0 Asset managed without history
1 Asset managed with history
ANEQS Completeness indicator for the asset ANEQS NUMC 1 0
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)
LIFNR Account number of vendor (other key word) AM_LIFNR LFA1 CHAR 10 0
LAND1 Asset's country of origin AM_LAND1 T005 CHAR 3 0
LIEFE Name of asset supplier LIEFE CHAR 30 0
HERST Manufacturer of asset HERST CHAR 30 0
EIGKZ Property indicator EIGKZ T097 CHAR 1 0
AIBN1 Original asset that was transferred AIBN1 CHAR 12 0
AIBN2 Original asset that was transferred AIBN2 CHAR 4 0
AIBDT Original acquisition date of AuC/ transferred asset AIBDT DATS 8 0
URJHR Fiscal year of original acquisition URJHR NUMC 4 0
URWRT Original acquisition value URWRT CURR 13 2
ANTEI In-house production percentage ANTEI DEC 5 2
PROJN Old: Project number : No longer used --> PS_POSNR PROJN CHAR 16 0
EAUFN Investment Order AM_AUFNR CHAR 12 0
MEINS Base Unit of Measure MEINS T006 UNIT 3 0
MENGE Quantity AM_MENGE QUAN 13 3
TYPBZ Asset type name TYPBZ_ANLA CHAR 15 0
IZWEK Reason for investment IZWEK T087I CHAR 2 0
INKEN Inventory indicator INKEN CHAR 1 0
X Yes
NULL No
IVDAT Last inventory date IVDAT_ANLA DATS 8 0
INVZU Supplementary inventory specifications INVZU_ANLA CHAR 15 0
VMGLI Property classification key VMGLI T092 CHAR 4 0
XVRMW Manual net worth tax value XVRMW CHAR 1 0
X Yes
NULL No
WRTMA Manual net worth tax value WRTMA CURR 13 2
EHWRT Assessed value EHWRT CURR 13 2
AUFLA Date of conveyance AUFLA_ANLA DATS 8 0
EHWZU Date of last notice of assessment EHWZU_ANLA DATS 8 0
EHWNR Tax number of the notice of assessment EHWNR_ANLA CHAR 16 0
GRUVO Land Register of GRUVO_ANLA DATS 8 0
GREIN Land register entry on GREIN_ANLA DATS 8 0
GRBND Land register volume GRBND_ANLA CHAR 5 0
GRBLT Land register page GRBLT_ANLA CHAR 5 0
GRLFD Land register entry: Sequence number GRLFD_ANLA CHAR 4 0
FLURK Land register map number FLURK_ANLA CHAR 4 0
FLURN Plot number FLURN_ANLA CHAR 10 0
FIAMT Local tax office FIAMT CHAR 25 0
STADT Municipality ORT01_ANLA CHAR 25 0
GRUND Reason for manual valuation of net assets GRUND T098 CHAR 3 0
FEINS Area unit FEINS T006 UNIT 3 0
GRUFL Surface area GRUFL QUAN 13 3
INVNR Inventory number INVNR_ANLA CHAR 25 0
VBUND Company ID of trading partner RASSC T880 CHAR 6 0
SPRAS Language Key SPRAS T002 LANG 1 0
TXT50 Asset description TXA50_ANLT CHAR 50 0
TXA50 Additional asset description TXA50_MORE CHAR 50 0
XLTXID Indicator: Long text active XLTXID CHAR 1 0
X Yes
NULL No
XVERID Long text indicator:Property values XVERID CHAR 1 0
X Yes
NULL No
XTCHID Indicator: Technical view long text XTCHID CHAR 1 0
X Yes
NULL No
XKALID Indicator: Long text active XKALID CHAR 1 0
X Yes
NULL No
XHERID Indicator: Long text for manufacturer/origin XHERID CHAR 1 0
X Yes
NULL No
XLEAID Indicator: Leasing data long text XLEAID CHAR 1 0
X Yes
NULL No
LEAFI Leasing company LEAFI LFA1 CHAR 10 0
LVDAT Leasing agreement date LVDAT DATS 8 0
LKDAT Leasing agreement notice date LKDAT DATS 8 0
LEABG Lease start date LEABG DATS 8 0
LEJAR Length of lease in years LEJAR NUMC 3 0
LEPER Length of lease in periods LEPER NUMC 3 0
0
LRYTH Lease payment cycle LRYTH NUMC 3 0
0
LEGEB Periodic lease payment paid to leasing company/lessor LEGEB CURR 13 2
LBASW Leasing base value as new LBASW CURR 13 2
LKAUF Leased asset purchase price LKAUF CURR 13 2
LMZIN Leasing monthly interest rate (Capital Lease) LMZIN DEC 7 4
LZINS Leasing interest rate (capital lease) LZINS DEC 7 4
LTZBW Posting date of the last lease payment LTZBW DATS 8 0
LKUZA Total of posted leasing payments LKUZA CURR 13 2
LKUZI Total leasing interest posted LKUZI CURR 13 2
LLAVB Total of long-term leasing liability LLAVB CURR 13 2
LEANZ Number of lease payments LEANZ DEC 5 0
LVTNR Leasing agreement number LVTNR CHAR 15 0
LETXT Leasing data text LETXT CHAR 50 0
XAKTIV Indicator: Capitalize fixed asset XAKTIV CHAR 1 0
X Yes
NULL No
ANUPD Indicator: Type of change to table ANUPD CHAR 1 0
D Delete
I Insert
U Update
NULL No changes
LBLNR No. of last document with which posting to asset was made LBLNR CHAR 10 0
XV0DT Change date: View 0 XV0DT DATS 8 0
XV0NM Name of person in charge, who changed View0 XV0NM CHAR 12 0
XV1DT Change date: View 1 XV1DT DATS 8 0
XV1NM Name of person in charge, who changed view 1 XV1NM CHAR 12 0
XV2DT Change date: View 2 XV2DT DATS 8 0
XV2NM Name of the person in charge, who changed view 2 XV2NM CHAR 12 0
XV3DT Change date: View 3 XV3DT DATS 8 0
XV3NM Name of the person in charge, who changed view 3 XV3NM CHAR 12 0
XV4DT Change date: View 4 XV4DT DATS 8 0
XV4NM Name of the person in charge, who changed view 4 XV4NM CHAR 12 0
XV5DT Change date:View 5 XV5DT DATS 8 0
XV5NM Name of the person in charge who changed view 5 XV5NM CHAR 12 0
XV6DT Change date:View 6 XV6DT DATS 8 0
XV6NM Name of the person in charge who changed view 6 XV6NM CHAR 12 0
AIMMO Indicator: real estate AIMMO NUMC 1 0
0 Other asset without real estate management
1 Real estate - property or buildings
OBJNR Object number J_OBJNR ONR00 CHAR 22 0
LEART Leasing type LEART T083L CHAR 2 0
LVORS Advance payments LVORS CHAR 1 0
X Yes
NULL No
GDLGRP Evaluation group 5 GDLGRP T087G CHAR 8 0
POSNR WBS element investment project AM_POSNR PRPS NUMC 8 0
XERWRT Indicator: Ignore memo value XERWRT CHAR 1 0
X Yes
NULL No
XAFABCH Asset acquired used XAFABCH CHAR 1 0
X Yes
NULL No
XANLGR Indicator: Asset is a group asset XANLGR_1 CHAR 1 0
X Yes
NULL No
MCOA1 Search term for matchcode search MCOA1 CHAR 30 0
XINVM Asset under Construction for Investment Measures IM_XINVM CHAR 1 0
X Yes
NULL No
SERNR Serial number AM_SERNR CHAR 18 0
UMWKZ Reason for environmental investment AM_UMWKZ T087K CHAR 5 0
LRVDAT Date of last revaluation AM_LRVDAT DATS 8 0
ACT_CHANGE_PM Change Asset Master Record from Equipment Master AAPM_ACT_CHANGE_PM CHAR 1 0
NULL No synchronization
1 Saving triggers a workflow
2 Direct synchronization after saving
3 Direct synchronization plus workflow
HAS_TDDP Asset Has Time-Dependent Valuation Parameters in ANLBZA HAS_TDDP CHAR 1 0
X TRUE
NULL FALSE
LAST_REORG_DATE Date of Last Reorganization FAA_LAST_REORG DATS 8 0
KZ Change Type (U, I, S, D) CDCHNGIND CHAR 1 0
U Update
I Insert
E Delete (Single Field Documentation)
D Delete
J Insert (Single Field Documentation)
T001WAERS Currency Key WAERS CUKY 5 0

RANLA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RANLA ANLKL RANLA MANDT ANKA Asset classes: general data MANDT
RANLA ANLKL RANLA ANLKL ANKA Asset classes: general data ANLKL
RANLA ANLN1 RANLA ANLN1 ANLH Main asset number ANLN1
RANLA ANLN1 RANLA BUKRS ANLH Main asset number BUKRS
RANLA ANLN1 RANLA MANDT ANLH Main asset number MANDT
RANLA ANLUE RANLA ANLUE T087U Asset group number / asset group ANLUE
RANLA ANLUE RANLA MANDT T087U Asset group number / asset group MANDT
RANLA BUKRS RANLA BUKRS T001 Company Codes BUKRS
RANLA BUKRS RANLA MANDT T001 Company Codes MANDT
RANLA EIGKZ RANLA EIGKZ T097 Property indicator EIGKZ
RANLA EIGKZ RANLA MANDT T097 Property indicator MANDT
RANLA FEINS RANLA FEINS T006 Units of Measurement MSEHI
RANLA FEINS RANLA MANDT T006 Units of Measurement MANDT
RANLA GDLGRP RANLA GDLGRP T087G Evaluation group 8 places GDLGRP
RANLA GDLGRP RANLA MANDT T087G Evaluation group 8 places MANDT
RANLA GRUND RANLA GRUND T098 Basis manual property evaluation GRUND
RANLA GRUND RANLA MANDT T098 Basis manual property evaluation MANDT
RANLA IZWEK RANLA IZWEK T087I Reason for investment IZWEK
RANLA IZWEK RANLA MANDT T087I Reason for investment MANDT
RANLA KTOGR RANLA MANDT T095A Account allocation MANDT
RANLA KTOGR RANLA KTOGR T095A Account allocation KTOGR
RANLA LAND1 RANLA MANDT T005 Countries MANDT
RANLA LAND1 RANLA LAND1 T005 Countries LAND1
RANLA LEAFI RANLA LEAFI LFA1 Vendor Master (General Section) LIFNR
RANLA LEAFI RANLA MANDT LFA1 Vendor Master (General Section) MANDT
RANLA LEART RANLA MANDT T083L Leasing types MANDT
RANLA LEART RANLA LEART T083L Leasing types LEART
RANLA LIFNR RANLA LIFNR LFA1 Vendor Master (General Section) LIFNR
RANLA LIFNR RANLA MANDT LFA1 Vendor Master (General Section) MANDT
RANLA MEINS RANLA MANDT T006 Units of Measurement MANDT
RANLA MEINS RANLA MEINS T006 Units of Measurement MSEHI
RANLA OBJNR RANLA OBJNR ONR00 General Object Number OBJNR
RANLA OBJNR RANLA MANDT ONR00 General Object Number MANDT
RANLA ORD41 RANLA ORD41 T087 Evaluation groups ORD4X
RANLA ORD41 RA01M ORD_1 T087 Evaluation groups ORDNR
RANLA ORD41 RANLA MANDT T087 Evaluation groups MANDT
RANLA ORD42 RA01M ORD_2 T087 Evaluation groups ORDNR
RANLA ORD42 RANLA MANDT T087 Evaluation groups MANDT
RANLA ORD42 RANLA ORD42 T087 Evaluation groups ORD4X
RANLA ORD43 RANLA ORD43 T087 Evaluation groups ORD4X
RANLA ORD43 RA01M ORD_3 T087 Evaluation groups ORDNR
RANLA ORD43 RANLA MANDT T087 Evaluation groups MANDT
RANLA ORD44 RANLA ORD44 T087 Evaluation groups ORD4X
RANLA ORD44 RA01M ORD_4 T087 Evaluation groups ORDNR
RANLA ORD44 RANLA MANDT T087 Evaluation groups MANDT
RANLA POSNR RANLA MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
RANLA POSNR RANLA POSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
RANLA SPRAS RANLA SPRAS T002 Language Keys (Component BC-I18) SPRAS
RANLA UMWKZ RANLA UMWKZ T087K Reason for investment protecting the environment UMWKZ
RANLA UMWKZ RANLA MANDT T087K Reason for investment protecting the environment MANDT
RANLA VBUND RANLA MANDT T880 Global Company Data (for KONS Ledger) MANDT
RANLA VBUND RANLA VBUND T880 Global Company Data (for KONS Ledger) RCOMP
RANLA VMGLI RANLA MANDT T092 Property classification key MANDT
RANLA VMGLI RANLA VMGLI T092 Property classification key VMGLI
RANLA ZUAWA RANLA ZUAWA TZUN Rules for 'Allocation' Field Layout ZUAWA