SAP table ANLAV (Asset Reporting: ANLA Fields Plus Cost Center...)

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 ANLA ANLN2
ANLKL Asset Class CHAR 8 0 FAAV_ASSET_CLASS ANLKL
GEGST Technical Asset Number CHAR 8 0 GEGST
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)
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 T082A FELEI
KTOGR Account Determination CHAR 8 0 T095A KTOGR
XOPVW Indicator: Open Item Management? CHAR 1 0 XOPVW
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
LIFNR Account Number of Supplier CHAR 10 0 LFA1 LIFNR
LAND1 Country/Region Key CHAR 3 0 T005 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 ANLH AIBN1
AIBN2 Original Asset That Was Transferred CHAR 4 0 ANLA 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 AUFK EAUFN
MEINS Base Unit of Measure UNIT 3 0 T006 MEINS
MENGE Quantity QUAN 13 3 MENGE_D
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
TXT50 Asset Description CHAR 50 0 TXA50_ANLT
TXA50 Asset Description CHAR 50 0 TXA50_ANLT
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
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
AIMMO Indicator: Real Estate NUMC 1 0 AIMMO
0 Other asset without real estate management
1 Real estate - property or buildings
OBJNR Object number (forecast) CHAR 18 0 OBJNR
OBART Allowed object types for cap. inv. programs CHAR 2 0 IM_OBART
IQ Appropriation requests
OR Orders
PR WBS elements
PSPHI Current number of the appropriate project NUMC 8 0 PROJ PS_PSPHI
PRNAM Investment program name CHAR 8 0 IMTP IM_PRNAM
PRPOS Position number NUMC 8 0 IMPR IM_POSNR
PRGJR Fiscal Year NUMC 4 0 GJAHR
IMAPO Internal number for appropriation request CHAR 12 0 IMAK IMA_POSNR
IMAPE Appropriation Request Number (Formatted for Coding Mask) CHAR 24 0 IMA_POSID
IMAVA Variant of Appropriation Request CHAR 4 0 IMA_VARNT
IMAGN Approval year of the investment program NUMC 4 0 IM_GNJHR
LFDNR Sequence number NUMC 3 0 IM_LFDNR
LFDHI Consecutive no. within hierarchy NUMC 6 0 IM_LFDHI
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 of Investment Project CHAR 24 0 AM_POSID
PSPID Project Definition CHAR 24 0 AM_PSPID
XERWRT Indicator: Ignore memo value CHAR 1 0 XERWRT
XAFABCH Asset acquired used CHAR 1 0 XAFABCH
XANLGR Indicator: asset class managed as group asset CHAR 1 0 XANLGR
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
BDATU Date Validity Ends DATS 8 0 BDATU
ADATU Date for Beginning of Validity DATS 8 0 ADATU
KOSTL Cost Center CHAR 10 0 CSKS KOSTL
WERKS Plant CHAR 4 0 T001W WERKS_D
GSBER Business Area CHAR 4 0 TGSB GSBER
LSTAR Activity Type CHAR 6 0 CSLA LSTAR
MSFAK Multiple-Shift Factor for Multiple Shift Operation DEC 3 2 MSFAK
XSTIL Asset shutdown CHAR 1 0 XSTIL
STORT Asset location CHAR 10 0 T499S STORT
CAUFN Internal Order CHAR 12 0 AUFK CAUFN
RAUMN Room CHAR 8 0 RAUMNR
IAUFN Maintenance Order CHAR 12 0 AUFK IAUFN
IPROJ Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
TPLNR Functional Location CHAR 30 0 IFLOT TPLNR
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
IPSNR WBS Element - Maintenance Project NUMC 8 0 PRPS AM_IPSNR
KTANSW Bal. Sheet Account: Acquisition and Production Costs CHAR 10 0 SKA1 KTANSW
ERGSO AA: Balance Sheet Item (Debit) CHAR 10 0 AM_ERGSO
ERGHB FI-AA: Balance Sheet Item (Credit) CHAR 10 0 AM_ERGHB
KHINR Standard Hierarchy Area CHAR 12 0 KHINR
ANLN0 Reporting: Asset main number CHAR 12 0 ANLH ANLN0
WRTTP Asset-Value Type CHAR 1 0 AM_WRTTP
0 Actual values from asset
1 Plan values from cap.inv.program
2 Planned values from project
3 Planned values from order
4 Plan values from appropriation request
KFZKZ License Plate No. of Vehicle CHAR 15 0 AM_KFZKZ
PERNR Personnel Number NUMC 8 0 PERNR_D
KOSTLV Cost Center Responsible for Asset CHAR 10 0 CSKS KOSTLV
ANLHTXT Asset Main Number Text CHAR 50 0 ANLHTXT
ADDRNUM Address Number CHAR 10 0 AD_ADDRNUM
KTSAKAN APC Balance Sheet Account in Significant Length CHAR 10 0 FIAA_KTSAKAN
KTAUFW Reconciliation Account: Revaluation CHAR 10 0 KTAUFW
KTAUFAN Balance Sheet Account Revaluation to Significant Length CHAR 10 0 FIAA_KTAUFAN
POSNR2 WBS Element (Costs for Depreciation) CHAR 24 0 AM_POSID2
PSPID2 Project Definition for Depreciation CHAR 24 0 AM_PSPID2
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
DUMMY_FAA_MD_EEW_PS Custom Fields: Dummy for Use in Extension Includes CHAR 1 0 CFD_DUMMY
FISTL Funds Center CHAR 16 0 * FISTL
GEBER Fund CHAR 10 0 * BP_GEBER
FKBER Functional Area CHAR 16 0 * FKBER
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
GEBER2 Fund for APC Account Assignments CHAR 10 0 * BP_GEBER2
FKBER2 Functional Area for APC Account Assignments CHAR 16 0 * FKBER2
GRANT_NBR2 Grant for APC Account Assignments CHAR 20 0 * GM_GRANT_NBR2
FISTL2 Funds Center for APC Account Assignments CHAR 16 0 * FISTL2
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
PS_PSP_PNR2 WBS Element (Costs) NUMC 8 0 * PS_PSP_PNR2
BUDGET_PD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
BUDGET_PD2 Budget Period for APC Account Assignments CHAR 10 0 * FM_BUDGET_PERIOD2
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
PRCTR Profit Center CHAR 10 0 PRCTR
VNAME Joint venture CHAR 6 0 * JV_NAME
EGRUP Equity group CHAR 3 0 * JV_EGROUP
RECID Recovery Indicator CHAR 2 0 * JV_RECIND
ETYPE Equity type CHAR 3 0 * JV_ETYPE

ANLAV foreign key relationships

Table Field Check Table Check Field
0 ANLAV AIBN1 ANLH Main asset number BUKRS
0 ANLAV AIBN1 ANLH Main asset number ANLN1
1 ANLAV AIBN2 ANLA Asset Master Record Segment BUKRS
1 ANLAV AIBN2 ANLA Asset Master Record Segment ANLN1
1 ANLAV AIBN2 ANLA Asset Master Record Segment ANLN2
0 ANLAV ANLKL FAAV_ASSET_CLASS Generated Table for View MANDT
1 ANLAV ANLN0 ANLH Main asset number BUKRS
1 ANLAV ANLN0 ANLH Main asset number ANLN1
0 ANLAV ANLN1 ANLH Main asset number BUKRS
0 ANLAV ANLN1 ANLH Main asset number ANLN1
1 ANLAV ANLN2 ANLA Asset Master Record Segment BUKRS
1 ANLAV ANLN2 ANLA Asset Master Record Segment ANLN1
1 ANLAV ANLN2 ANLA Asset Master Record Segment ANLN2
0 ANLAV ANLUE T087U Asset group number / asset group MANDT
0 ANLAV ANLUE T087U Asset group number / asset group ANLUE
1 ANLAV CAUFN AUFK Order master data AUFNR
0 ANLAV EAUFN AUFK Order master data AUFNR
1 ANLAV EIGKZ T097 Property indicator MANDT
1 ANLAV EIGKZ T097 Property indicator EIGKZ
0 ANLAV FEINS T006 Units of Measurement MANDT
1 ANLAV FELEI T082A Field string asset master record maintenance MANDT
1 ANLAV FELEI T082A Field string asset master record maintenance FEGTB
0 ANLAV GDLGRP T087G Evaluation group 8 places MANDT
1 ANLAV GRUND T098 Basis manual property evaluation MANDT
0 ANLAV GSBER TGSB Business Areas MANDT
0 ANLAV GSBER TGSB Business Areas GSBER
1 ANLAV IAUFN AUFK Order master data AUFNR
0 ANLAV IMAPO IMAK Appropriation requests - general data MANDT
0 ANLAV IMAPO IMAK Appropriation requests - general data POSNR
1 ANLAV IPSNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 ANLAV IPSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 ANLAV IZWEK T087I Reason for investment MANDT
0 ANLAV IZWEK T087I Reason for investment IZWEK
1 ANLAV KOSTL CSKS Cost Center Master Record MANDT
1 ANLAV KOSTL CSKS Cost Center Master Record KOKRS
1 ANLAV KOSTL CSKS Cost Center Master Record KOSTL
1 ANLAV KOSTL CSKS Cost Center Master Record DATBI
0 ANLAV KOSTLV CSKS Cost Center Master Record MANDT
0 ANLAV KOSTLV CSKS Cost Center Master Record KOKRS
0 ANLAV KOSTLV CSKS Cost Center Master Record DATBI
1 ANLAV KTANSW SKA1 G/L Account Master (Chart of Accounts) MANDT
1 ANLAV KTANSW SKA1 G/L Account Master (Chart of Accounts) KTOPL
1 ANLAV KTANSW SKA1 G/L Account Master (Chart of Accounts) SAKNR
0 ANLAV KTOGR T095A Account allocation MANDT
0 ANLAV KTOGR T095A Account allocation KTOGR
1 ANLAV LAND1 T005 Countries MANDT
1 ANLAV LAND1 T005 Countries LAND1
0 ANLAV LEAFI LFA1 Supplier Master (General Section) MANDT
0 ANLAV LEAFI LFA1 Supplier Master (General Section) LIFNR
1 ANLAV LEART T083L Leasing types MANDT
1 ANLAV LEART T083L Leasing types LEART
0 ANLAV LIFNR LFA1 Supplier Master (General Section) MANDT
0 ANLAV LIFNR LFA1 Supplier Master (General Section) LIFNR
1 ANLAV LSTAR CSLA Activity master MANDT
1 ANLAV LSTAR CSLA Activity master KOKRS
1 ANLAV LSTAR CSLA Activity master DATBI
0 ANLAV MEINS T006 Units of Measurement MANDT
0 ANLAV MEINS T006 Units of Measurement MSEHI
1 ANLAV ORD41 T087 Evaluation groups MANDT
1 ANLAV ORD41 T087 Evaluation groups ORDNR
1 ANLAV ORD41 T087 Evaluation groups ORD4X
0 ANLAV ORD42 T087 Evaluation groups MANDT
0 ANLAV ORD42 T087 Evaluation groups ORDNR
0 ANLAV ORD42 T087 Evaluation groups ORD4X
1 ANLAV ORD43 T087 Evaluation groups MANDT
1 ANLAV ORD43 T087 Evaluation groups ORDNR
1 ANLAV ORD43 T087 Evaluation groups ORD4X
0 ANLAV ORD44 T087 Evaluation groups MANDT
0 ANLAV ORD44 T087 Evaluation groups ORDNR
0 ANLAV ORD44 T087 Evaluation groups ORD4X
1 ANLAV PRNAM IMTP Investment programs MANDT
1 ANLAV PRNAM IMTP Investment programs GJAHR
0 ANLAV PRPOS IMPR Investment Program Positions MANDT
0 ANLAV PRPOS IMPR Investment Program Positions POSNR
1 ANLAV PSPHI PROJ Project definition MANDT
1 ANLAV PSPHI PROJ Project definition PSPNR
0 ANLAV SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 ANLAV STORT T499S Location MANDT
1 ANLAV STORT T499S Location WERKS
0 ANLAV TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 ANLAV TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 ANLAV UMWKZ T087K Reason for investment protecting the environment MANDT
0 ANLAV VBUND T880 Global Company Data (for KONS Ledger) MANDT
0 ANLAV VBUND T880 Global Company Data (for KONS Ledger) RCOMP
1 ANLAV VMGLI T092 Property classification key MANDT
0 ANLAV WERKS T001W Plants/Branches MANDT
0 ANLAV WERKS T001W Plants/Branches WERKS