SAP table REEX_ASSET_X (Fixed Asset and Additional Fields (REEX_ASSET))

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
BUKRS Company Code CHAR 4 0 FAAV_COMP_CODE BUKRS
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 * ANLN2
ANLKL Asset Class CHAR 8 0 FAAV_ASSET_CLASS ANLKL
GEGST Technical Asset Number CHAR 8 0 GEGST
ANLAR Asset types CHAR 5 0 ANLAR
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 Indicator: Account Marked for Deletion? CHAR 1 0 XLOEV
XSPEB Indicator: Asset Locked to Acquisition Postings CHAR 1 0 XSPEB_ANLA
FELEI Screen Layout for Asset Accounting CHAR 4 0 * FELEI
KTOGR Account Determination CHAR 8 0 FAAV_ACCOUNT_DET KTOGR
XOPVW Asset under construct. with line item settlement CHAR 1 0 OPVWA
ANLTP Asset Category NUMC 1 0 ANLTP
0 Capitalized asset
1 Leased asset
2 Financial asset
ZUJHR Fiscal Year in Which First Acquisition Was Posted NUMC 4 0 DZUJAHR
ZUPER Period in Which First Acquisition Was Posted NUMC 3 0 DZUPER
ZUGDT Asset Value Date of the First Posting DATS 8 0 DZUGDAT
AKTIV Asset Capitalization Date DATS 8 0 AKTIVD
ABGDT Asset Value Date for the Last Retirement DATS 8 0 ABGDAT
DEAKT Deactivation Date DATS 8 0 DEAKT
GPLAB Planned Retirement Date DATS 8 0 GPLAB
BSTDT Asset Purchase Order Date DATS 8 0 BSTDT
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
ANLUE Asset Super Number CHAR 12 0 T087U ANLUE
ZUAWA Key for sorting according to assignment numbers CHAR 3 0 TZUN DZUAWA
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)
LIFNR Account number of vendor (other key word) CHAR 10 0 LFA1 AM_LIFNR
LAND1 Asset's Country/Region of Origin CHAR 3 0 T005 AM_LAND1
LIEFE Name of asset supplier CHAR 30 0 LIEFE
HERST Manufacturer of Asset CHAR 30 0 HERST
EIGKZ Property Indicator CHAR 1 0 T097 EIGKZ
AIBN1 Original Asset That Was Transferred CHAR 12 0 * AIBN1
AIBN2 Original Asset That Was Transferred CHAR 4 0 * AIBN2
AIBDT Original Acquisition Date of AuC/ Transferred Asset DATS 8 0 AIBDT
URJHR Fiscal Year of Original Acquisition NUMC 4 0 URJHR
URWRT Original Acquisition Value CURR 23 2 URWRT
ANTEI In-house production percentage DEC 5 2 ANTEI
PROJN Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
EAUFN Investment Order CHAR 12 0 * AM_AUFNR
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MENGE Quantity QUAN 13 3 AM_MENGE
TYPBZ Asset Type Name CHAR 15 0 TYPBZ_ANLA
IZWEK Reason for Investment CHAR 2 0 T087I IZWEK
INKEN Inventory Indicator CHAR 1 0 INKEN
IVDAT Last Inventory Date DATS 8 0 IVDAT_ANLA
INVZU Supplementary Inventory Specifications CHAR 15 0 INVZU_ANLA
VMGLI Property classification key CHAR 4 0 T092 VMGLI
XVRMW Manual net worth tax value CHAR 1 0 XVRMW
WRTMA Manual net worth tax value CURR 23 2 WRTMA
EHWRT Assessed Value CURR 23 2 EHWRT
AUFLA Date of conveyance DATS 8 0 AUFLA_ANLA
EHWZU Date of last notice of assessment DATS 8 0 EHWZU_ANLA
EHWNR Tax Number of the Notice of Assessment CHAR 16 0 EHWNR_ANLA
GRUVO Land Register of DATS 8 0 GRUVO_ANLA
GREIN Land Register Entry on DATS 8 0 GREIN_ANLA
GRBND Land Register Volume CHAR 5 0 GRBND_ANLA
GRBLT Land Register Page CHAR 5 0 GRBLT_ANLA
GRLFD Land Register Entry: Sequence Number CHAR 4 0 GRLFD_ANLA
FLURK Land Register Map Number CHAR 4 0 FLURK_ANLA
FLURN Plot Number CHAR 10 0 FLURN_ANLA
FIAMT Local Tax Office CHAR 25 0 FIAMT
STADT Municipality CHAR 25 0 ORT01_ANLA
GRUND Reason for Manual Valuation of Net Assets CHAR 3 0 T098 GRUND
FEINS Area Unit UNIT 3 0 T006 FEINS
GRUFL Surface Area QUAN 13 3 GRUFL
INVNR Inventory Number CHAR 25 0 INVNR_ANLA
VBUND Company ID of Trading Partner CHAR 6 0 T880 RASSC
SPRAS Language Key LANG 1 0 T002 SPRAS
TXT50 Asset Description CHAR 50 0 TXA50_ANLT
TXA50 Additional Asset Description CHAR 50 0 TXA50_MORE
XLTXID Indicator: Long Text Active CHAR 1 0 XLTXID
XVERID Long text indicator:Property values CHAR 1 0 XVERID
XTCHID Indicator: Technical View Long Text CHAR 1 0 XTCHID
XKALID Indicator: Long Text Active CHAR 1 0 XKALID
XHERID Indicator: Long text for manufacturer/origin CHAR 1 0 XHERID
XLEAID Indicator: Leasing Data Long Text CHAR 1 0 XLEAID
LEAFI Leasing company CHAR 10 0 LFA1 LEAFI
LVDAT Leasing agreement date DATS 8 0 LVDAT
LKDAT Leasing agreement notice date DATS 8 0 LKDAT
LEABG Lease start date DATS 8 0 LEABG
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
LEGEB Periodic lease payment paid to leasing company/lessor CURR 23 2 LEGEB
LBASW Leasing base value as new CURR 23 2 LBASW
LKAUF Leased asset purchase price CURR 23 2 LKAUF
LMZIN Leasing monthly interest rate (Capital Lease) DEC 7 4 LMZIN
LZINS Leasing Interest Rate (Capital Lease) DEC 7 4 LZINS
LTZBW Posting date of the last lease payment DATS 8 0 LTZBW
LKUZA Total of posted leasing payments CURR 23 2 LKUZA
LKUZI Total leasing interest posted CURR 23 2 LKUZI
LLAVB Total of long-term leasing liability CURR 23 2 LLAVB
LEANZ Number of Lease Payments DEC 5 0 LEANZ
LVTNR Leasing agreement number CHAR 15 0 LVTNR
LETXT Leasing data text CHAR 50 0 LETXT
XAKTIV Indicator: Capitalize Fixed Asset CHAR 1 0 XAKTIV
ANUPD Indicator: Type of change to table CHAR 1 0 ANUPD
No changes
D Delete
I Insert
U Update
LBLNR No. of Last Document with Which Posting to Asset Was Made CHAR 10 0 LBLNR
XV0DT Change date: View 0 DATS 8 0 XV0DT
XV0NM Name of person in charge, who changed View0 CHAR 12 0 XV0NM
XV1DT Change date: View 1 DATS 8 0 XV1DT
XV1NM Name of person in charge, who changed view 1 CHAR 12 0 XV1NM
XV2DT Change date: View 2 DATS 8 0 XV2DT
XV2NM Name of the person in charge, who changed view 2 CHAR 12 0 XV2NM
XV3DT Change date: View 3 DATS 8 0 XV3DT
XV3NM Name of the person in charge, who changed view 3 CHAR 12 0 XV3NM
XV4DT Change date: View 4 DATS 8 0 XV4DT
XV4NM Name of the person in charge, who changed view 4 CHAR 12 0 XV4NM
XV5DT Change date:View 5 DATS 8 0 XV5DT
XV5NM Name of the person in charge who changed view 5 CHAR 12 0 XV5NM
XV6DT Change date:View 6 DATS 8 0 XV6DT
XV6NM Name of the person in charge who changed view 6 CHAR 12 0 XV6NM
AIMMO Indicator: Real Estate NUMC 1 0 AIMMO
0 Other asset without real estate management
1 Real estate - property or buildings
OBJNR Object number CHAR 22 0 ONR00 J_OBJNR
LEART Leasing type CHAR 2 0 T083L LEART
LVORS Advance payments CHAR 1 0 LVORS
GDLGRP Evaluation Group 5 CHAR 8 0 T087G GDLGRP
POSNR WBS element investment project NUMC 8 0 PRPS AM_POSNR
XERWRT Indicator: Ignore memo value CHAR 1 0 XERWRT
XAFABCH Asset acquired used CHAR 1 0 XAFABCH
XANLGR Indicator: Asset is a group asset CHAR 1 0 XANLGR_1
MCOA1 Search Term for Matchcode Search CHAR 30 0 MCOA1
XINVM Asset under Construction for Investment Measures CHAR 1 0 IM_XINVM
SERNR Serial number CHAR 18 0 AM_SERNR
UMWKZ Reason for Environmental Investment CHAR 5 0 T087K AM_UMWKZ
LRVDAT Date of Last Revaluation DATS 8 0 AM_LRVDAT
ACT_CHANGE_PM Change Asset Master Record from Equipment Master CHAR 1 0 AAPM_ACT_CHANGE_PM
HAS_TDDP Asset Has Time-Dependent Valuation Parameters in ANLBZA CHAR 1 0 HAS_TDDP
LAST_REORG_DATE Date of Last Reorganization DATS 8 0 FAA_LAST_REORG
LDT_DATE Legacy Data Transfer Date DATS 8 0 FAA_LDT_DATE
LDT_SEQNO Legacy Data Transfer - sequence number NUMC 5 0 FAA_LDT_SEQNO
SDM_STATUS Silent Data Migration Status CHAR 2 0 FAA_SDM_STATUS
not processed
01 ANLA transfered
11 TECH_LEDGER: Currency Conversion finished
12 TECH_LEDGER: Retirement Indicator Enrichment done
13 TECH_LEDGER: Currency Adjustment finished
18 TECH_LEDGER: Processing finished, no migration
19 TECH_LEDGER: Processing finished, migrated to ACDOCA
20 Derived Areas exist and migration is required
21 Derived Areas entries waiting for AFABN to be posted
22 Derived Areas completely migrated
DUMMY_FAA_ASSET_INCL_EEW_PS Data Element for Extension Include: Asset Worklist CHAR 1 0 FAA_ASSET_INCL_EEW
INTERNAL_CODE Internal code CHAR 10 0 /ATL/INTERNAL_CODE
APPROVAL_NUMBER Approval document number CHAR 15 0 /ATL/APPROVAL_NUMBER
APPROVAL_VERSION Approval version CHAR 3 0 /ATL/APPROVAL_VERSION
BOGUS_ANLN1 bogus asset number CHAR 12 0 /ATL/BOGUS_ANLN1
ASSET_VERSION Asset version CHAR 3 0 /ATL/ASSET_VERSION
TXK20 Short Text for Asset Class Name CHAR 20 0 TXT20_ANKT
TXK50 Asset class description CHAR 50 0 TXT50_ANKT

REEX_ASSET_X foreign key relationships

Table Field Check Table Check Field
0 REEX_ASSET_X ANLKL FAAV_ASSET_CLASS Generated Table for View MANDT
1 REEX_ASSET_X ANLN1 ANLH Main asset number BUKRS
1 REEX_ASSET_X ANLN1 ANLH Main asset number ANLN1
0 REEX_ASSET_X ANLUE T087U Asset group number / asset group MANDT
0 REEX_ASSET_X ANLUE T087U Asset group number / asset group ANLUE
1 REEX_ASSET_X EIGKZ T097 Property indicator MANDT
1 REEX_ASSET_X EIGKZ T097 Property indicator EIGKZ
0 REEX_ASSET_X FEINS T006 Units of Measurement MANDT
1 REEX_ASSET_X GDLGRP T087G Evaluation group 8 places MANDT
0 REEX_ASSET_X GRUND T098 Basis manual property evaluation MANDT
1 REEX_ASSET_X IZWEK T087I Reason for investment MANDT
1 REEX_ASSET_X IZWEK T087I Reason for investment IZWEK
0 REEX_ASSET_X KTOGR FAAV_ACCOUNT_DET Generated Table for View MANDT
1 REEX_ASSET_X LAND1 T005 Countries MANDT
1 REEX_ASSET_X LAND1 T005 Countries LAND1
0 REEX_ASSET_X LEAFI LFA1 Supplier Master (General Section) MANDT
0 REEX_ASSET_X LEAFI LFA1 Supplier Master (General Section) LIFNR
1 REEX_ASSET_X LEART T083L Leasing types MANDT
1 REEX_ASSET_X LEART T083L Leasing types LEART
0 REEX_ASSET_X LIFNR LFA1 Supplier Master (General Section) MANDT
0 REEX_ASSET_X LIFNR LFA1 Supplier Master (General Section) LIFNR
1 REEX_ASSET_X MEINS T006 Units of Measurement MANDT
1 REEX_ASSET_X MEINS T006 Units of Measurement MSEHI
0 REEX_ASSET_X OBJNR ONR00 General Object Number MANDT
1 REEX_ASSET_X ORD41 T087 Evaluation groups MANDT
1 REEX_ASSET_X ORD41 T087 Evaluation groups ORDNR
1 REEX_ASSET_X ORD41 T087 Evaluation groups ORD4X
0 REEX_ASSET_X ORD42 T087 Evaluation groups MANDT
0 REEX_ASSET_X ORD42 T087 Evaluation groups ORDNR
0 REEX_ASSET_X ORD42 T087 Evaluation groups ORD4X
1 REEX_ASSET_X ORD43 T087 Evaluation groups MANDT
1 REEX_ASSET_X ORD43 T087 Evaluation groups ORDNR
1 REEX_ASSET_X ORD43 T087 Evaluation groups ORD4X
0 REEX_ASSET_X ORD44 T087 Evaluation groups MANDT
0 REEX_ASSET_X ORD44 T087 Evaluation groups ORDNR
0 REEX_ASSET_X ORD44 T087 Evaluation groups ORD4X
1 REEX_ASSET_X POSNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 REEX_ASSET_X POSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 REEX_ASSET_X UMWKZ T087K Reason for investment protecting the environment MANDT
1 REEX_ASSET_X VBUND T880 Global Company Data (for KONS Ledger) MANDT
1 REEX_ASSET_X VBUND T880 Global Company Data (for KONS Ledger) RCOMP
0 REEX_ASSET_X VMGLI T092 Property classification key MANDT