SAP table ANLCV (Asset Reporting: ANLC Fields Plus Various Totals)

SAP table ANLCV has 8 primary key fields being MANDT,BUKRS,ANLN1,ANLN2,GJAHR,AFABE,ZUJHR,ZUCOD.

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
BUKRS Company Code CHAR 4 0 BUKRS
ANLN1 Main Asset Number CHAR 12 0 ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLN2
GJAHR Fiscal Year NUMC 4 0 GJAHR
AFABE Real depreciation area NUMC 2 0 AFABE_D
ZUJHR Asset Acquisition Year (Currently Not Used) NUMC 4 0 DZUJHR
ZUCOD Sub-Classification of Asset Acquisitions(Currently Not Used) NUMC 4 0 DZUCOD
AFBLPE Period in Which Last Depreciation Was Posted NUMC 3 0 AFBLPE
AFBANZ Number of Depreciation Posting Runs in the Period NUMC 2 0 AFBANZ
XAFAR Indicator: Errors in Depreciation NUMC 1 0 XAFAR
0 No error occurred during depreciation calculation
1 Error occurred in depreciation calculation from previous yrs
2 Error occurred in depreciation calculation of current year
NDABJ Expired Useful Life in Years at Start of the Fiscal Year NUMC 3 0 NDABJ
NDABP Expired Useful Life in Periods at Start of Fiscal Year NUMC 3 0 NDABP
ANDSJ Yrs Expired up to Fisc.Yr Start from Start of Spec.Dep. NUMC 3 0 ANDSJ
ANDSP Expired Useful Life in Periods during FY from SDep Start Dat NUMC 3 0 ANDSP
RSTCK Number of Units Depreciated in Unit-of-Prod. Depreciation DEC 15 0 RSTCK
KANSW Cumulative Acquisition and Production Costs CURR 23 2 KANSW
KAUFW Cumulative Revaluation on the Replacement Value CURR 23 2 KAUFW
KINVZ Cumulative Investment Grants CURR 23 2 KINVZ
KNAFA Accumulated Ordinary Depreciation CURR 23 2 KNAFA
KSAFA Cumulative Special Depreciation CURR 23 2 KSAFA
KAAFA Cumulative Unplanned Depreciation CURR 23 2 KAAFA
KMAFA Cumulative Reserves Transfer CURR 23 2 KMAFA
KZINW Cumulative Interest CURR 23 2 KZINW
KAUFN Cumulative Revaluation of Ordinary Depreciation CURR 23 2 KAUFN
KANZA Cumulative Down Payments CURR 23 2 KANZA
KVOST Cumulative Input Tax CURR 23 2 KVOST
AUFWP Planned Revaluation on Replacement Value CURR 23 2 AUFWP
NAFAP Planned Ordinary Depreciation for the Year CURR 23 2 NAFAP
SAFAP Planned Special Depreciation for the Year CURR 23 2 SAFAP
AAFAP Scheduled Unplanned Depreciation for the Year CURR 23 2 AAFAP
MAFAP Planned Transfer of Reserves for the Year CURR 23 2 MAFAP
ZINSP Interest Planned for the Year CURR 23 2 DZINSP
AUFNP Planned Revaluation of Accumulated Ordinary Depreciation CURR 23 2 AUFNP
AUFWB Revaluation Posted on Replacement Value CURR 23 2 AUFWB
NAFAG Ordinary Depreciation Posted in the Current Year CURR 23 2 NAFAG
SAFAG Special Depreciation Posted in the Current Fiscal Year CURR 23 2 SAFAG
AAFAG Unplanned Depreciation Posted for the Year CURR 23 2 AAFAG
MAFAG Acquisition Value Reducing Depreciation Posted for the Year CURR 23 2 MAFAG
ZINSG Interest Posted for the Year CURR 23 2 DZINSG
AUFNG Posted Revaluation of Accumulated Ordinary Depreciation CURR 23 2 AUFNG
ANSWL Transactions for the Year Affecting Asset Values CURR 23 2 ANSWL
ABGAN Total Retirements and Retiring Transfers CURR 23 2 ABGAN
ANSAZ Down Payments on Asset CURR 23 2 ANSAZ
AUFWM Manual Revaluation on Replacement Value CURR 23 2 AUFWM
INVZM Investment Grant for the Year CURR 23 2 INVZM
NAFAM Manually Planned Ordinary Depreciation for the Year CURR 23 2 NAFAM
SAFAM Manual Special Depreciation Planned for the Year CURR 23 2 SAFAM
AAFAM Manual Unplanned Depreciation for the Year CURR 23 2 AAFAM
MAFAM Manual Transfer of Reserves for the Year CURR 23 2 MAFAM
ZINSM Manual Interest Planned for the Year CURR 23 2 DZINSM
AUFNM Manual Revaluation of Cumulative Ordinary Depreciation CURR 23 2 AUFNM
ZUSNA Write-up on Ordinary Depreciation CURR 23 2 DZUSNA
ZUSSA Write-up on Special Depreciation CURR 23 2 DZUSSA
ZUSAA Write-up on Unplanned Depreciation CURR 23 2 DZUSAA
ZUSMA Write-up on Transferred Reserves CURR 23 2 DZUSMA
AUFWV Proportional Cumulative Revaluation on Replacement Value CURR 23 2 AUFWV
INVZV Proportional Cumulative Investment Grants CURR 23 2 INVZV
NAFAV Proportional Accumulated Ordinary Depreciation CURR 23 2 NAFAV
SAFAV Proportional Cumulative Special Depreciation CURR 23 2 SAFAV
AAFAV Proportional Cumulative Unplanned Depreciation CURR 23 2 AAFAV
MAFAV Proportional Cumulative Transfer of Reserves CURR 23 2 MAFAV
AUFNV Proportional Accumul. Revaluation of Ordinary Depreciation CURR 23 2 AUFNV
AUFWL Proportional Revaluation for the Year on Replacement Value CURR 23 2 AUFWL
INVZL Proportional Investment Grant for the Year CURR 23 2 INVZL
NAFAL Proportional Ordinary Depreciation for the Year CURR 23 2 NAFAL
SAFAL Proportional Special Depreciation for the Year CURR 23 2 SAFAL
AAFAL Proportional Unplanned Depreciation for the Year CURR 23 2 AAFAL
MAFAL Proportional Transfer of Reserves for the Year CURR 23 2 MAFAL
AUFNL Proportional Revaluation of Annual Ordinary Depreciation CURR 23 2 AUFNL
ANUPD Indicator: Type of change to table CHAR 1 0 ANUPD
No changes
D Delete
I Insert
U Update
KSANS Cumulative statistical acquisition value CURR 23 2 KSANS
SANSL Statistical aquisition value of current year CURR 23 2 SANSL
GJA_AUFW Cumulative Appreciation on Replacement Value for Fiscal Year CURR 23 2 GJA_AUFW
GJE_AUFW Appreciation on Replacement Value in Current Year CURR 23 2 GJE_AUFW
GEB_AUFWTG Posted Planned and Manual Revaluation of Replacement Value CURR 23 2 GEB_AUFWTG
GJA_KANSW Asset Acquisition Value at Fiscal Year Start CURR 23 2 GJA_KANSW
LFD_KANSW Current asset acquisition value CURR 23 2 LFD_KANSW
GJE_KANSW Asset Acquisition Value at End of Fiscal Year CURR 23 2 GJE_KANSW
GJA_BCHWRT Asset Book Value at Beginning of Fiscal Year CURR 23 2 GJA_BCHWRT
LFD_BCHWRT Current Book Value of Asset CURR 23 2 LFD_BCHWRT
GJE_BCHWRT Asset Net Book Value at End of Fiscal Year CURR 23 2 GJE_BCHWRT
GJE_ZUSCHR Write-Ups CURR 23 2 GJE_ZUSCHR
GJE_BWGWB Value Adjustments on Transactions, at FY End CURR 23 2 GJE_BWGWB
GEB_ABSCHR Depreciation Posted (General) CURR 23 2 GEB_ABSCHR
GEP_ABSCHR Total Depreciation Planned CURR 23 2 GEP_ABSCHR
NVG_ABSCHR Ordinary depreciation: Past CURR 23 2 NVG_ABSCHR
RVG_ABSCHR Remaining past depreciation (without ordinary depreciation) CURR 23 2 RVG_ABSCHR
RGP_ABSCHR Remaining depreciation planned (without ordinary dep.) CURR 23 2 RGP_ABSCHR
GJE_INVZ Investment Grant at End of the Year CURR 23 2 GJE_INVZ
BEST_GJA Cumulative Acquisition Value at FY Start (w/o Inv.Support) CURR 23 2 BEST_GJA
BEST_BEW Transactions Affecting Acquisition Value (w/o Inv. Support) CURR 23 2 BEST_BEW
BEST_LFD Current Acquisition Value (Without Investment Support) CURR 23 2 BEST_LFD
BEST_GJE Acquisition Value at Fiscal Year End (w/o Inv.Support) CURR 23 2 BEST_GJE
ANSW_GJA Cumulative acquisition value at fiscal year start CURR 23 2 ANSW_GJA
ANSW_BEW Transactions on the acquisition value CURR 23 2 ANSW_BEW
ANSW_LFD Current Acquisition Value CURR 23 2 ANSW_LFD
ANSW_GJE Acquisition value at fiscal year end CURR 23 2 ANSW_GJE
INV_GJA Cumulative Investment Support at Fiscal Year Start CURR 23 2 INV_GJA
INV_BEW Transactions on Investment Support CURR 23 2 INV_BEW
INV_ANT Proportional Investment Support CURR 23 2 INV_ANT
INV_LFD Current Investment Support CURR 23 2 INV_LFD
INV_GJE Investment Support at Fiscal Year End CURR 23 2 INV_GJE
AUFW_GJA Cumulative revaluation at fiscal year start CURR 23 2 AUFW_GJA
AUFW_GEP Planned revaluation CURR 23 2 AUFW_GEP
AUFW_GEB Revaluation posted CURR 23 2 AUFW_GEB
AUFW_ANT Proportional revaluation CURR 23 2 AUFW_ANT
AUFW_LFD Current revaluation CURR 23 2 AUFW_LFD
AUFW_GJE Revaluation at fiscal year end CURR 23 2 AUFW_GJE
AUFW_LFDP Revaluation for the current year (with planned values) CURR 23 2 AUFW_LFDP
AUFW_LFDG Revaluation from the current year (with posted values) CURR 23 2 AUFW_LFDG
RUECK_GJA Cumulative reserves at fiscal year start CURR 23 2 RUECK_GJA
RUECK_GEP Planned transfer of reserves CURR 23 2 RUECK_GEP
RUECK_GEB Posted transfer of reserves CURR 23 2 RUECK_GEB
RUECK_ZUS Write-up to transferred reserves CURR 23 2 RUECK_ZUS
RUECK_ANT Proportional values from reserves CURR 23 2 RUECK_ANT
RUECK_LFD Current reserves CURR 23 2 RUECK_LFD
RUECK_GJE Transferred reserves at fiscal year end CURR 23 2 RUECK_GJE
RUECK_LFDP Transferred reserves from current year (w/planned values) CURR 23 2 RUECK_LFDP
RUECK_LFDG Transferred reserves from current year (w/posted values) CURR 23 2 RUECK_LFDG
NAFA_GJA Accumulated ordinary depreciation at fiscal year start CURR 23 2 NAFA_GJA
NAFA_GEP Planned ordinary depreciation CURR 23 2 NAFA_GEP
NAFA_GEB Ordinary depreciation posted CURR 23 2 NAFA_GEB
NAFA_ZUS Write-up of ordinary depreciation CURR 23 2 NAFA_ZUS
NAFA_ANT Proportional Ordinary Depreciation CURR 23 2 NAFA_ANT
NAFA_LFD Current ordinary depreciation CURR 23 2 NAFA_LFD
NAFA_GJE Ordinary depreciation at fiscal year end CURR 23 2 NAFA_GJE
NAFA_LFDP Ordinary depreciation of the current year(w/ planned values) CURR 23 2 NAFA_LFDP
NAFA_LFDG Ordinary depreciation for current year (with posted values) CURR 23 2 NAFA_LFDG
RAFA_GJA Cumulative remaining depreciation fiscal year start CURR 23 2 RAFA_GJA
RAFA_GEP Planned remaining depreciation CURR 23 2 RAFA_GEP
RAFA_GEB Remaining depreciation posted CURR 23 2 RAFA_GEB
RAFA_ZUS Write-up to remaining depreciation CURR 23 2 RAFA_ZUS
RAFA_ANT Proportional remaining depreciation CURR 23 2 RAFA_ANT
RAFA_LFD Current remaining depreciation CURR 23 2 RAFA_LFD
RAFA_GJE Remaining depreciation at fiscal year end CURR 23 2 RAFA_GJE
RAFA_LFDP Remaining depreciation for the current year (w/planned val.) CURR 23 2 RAFA_LFDP
RAFA_LFDG Remaining depreciation for current year (with posted values) CURR 23 2 RAFA_LFDG
AFA_GJA Accumulated depreciation at fiscal year start CURR 23 2 AFA_GJA
AFA_GEP Planned Depreciation CURR 23 2 AFA_GEP
AFA_GEB Depreciation Posted CURR 23 2 AFA_GEB
AFA_ZUS Write-up to Depreciation CURR 23 2 AFA_ZUS
AFA_ANT Proportional depreciation CURR 23 2 AFA_ANT
AFA_LFD Current depreciation CURR 23 2 AFA_LFD
AFA_GJE Depreciation at fiscal year end CURR 23 2 AFA_GJE
AFA_LFDP Depreciation for the Current Year (with Planned Values) CURR 23 2 AFA_LFDP
AFA_LFDG Ordinary Depreciation for Current Year (with Posted Values) CURR 23 2 AFA_LFDG
SZINS_GJA Cumulative interest at fiscal year start CURR 23 2 SZINS_GJA
SZINS_GEP Interest planned CURR 23 2 SZINS_GEP
SZINS_GEB Interest Posted CURR 23 2 SZINS_GEB
SZINS_LFD Current interest CURR 23 2 SZINS_LFD
SZINS_GJE Interest at fiscal year end CURR 23 2 SZINS_GJE
SZINS_LFDP Current interest CURR 23 2 SZINS_LFD
SZINS_LFDG Current interest CURR 23 2 SZINS_LFD
BACKL_GJA Cumulative revaluation of ordinary depreciation CURR 23 2 BACKL_GJA
BACKL_GEP Planned revaluation of accumulated ordinary depreciation CURR 23 2 BACKL_GEP
BACKL_GEB Posted revaluation of accumulated ordinary depreciation CURR 23 2 BACKL_GEB
BACKL_LFD Current cumulative revaluation of ordinary depreciation CURR 23 2 BACKL_LFD
BACKL_GJE Cum. revaluation of ord. depreciation at fiscal year end CURR 23 2 BACKL_GJE
BACKL_LFDG Current cumulative revaluation of ordinary depreciation CURR 23 2 BACKL_LFD
BACKL_LFDP Current cumulative revaluation of ordinary depreciation CURR 23 2 BACKL_LFD
BCHWRT_GJA Book Value at Fiscal Year Start CURR 23 2 BCHWRT_GJA
BCHWRT_LFD Curr.net book value CURR 23 2 BCHWRT_LFD
BCHWRT_GJE Book Value at Fiscal Year End CURR 23 2 BCHWRT_GJE