SAP Table ANLCV stores Asset Reporting: ANLC Fields Plus Various Totalsdata

  

In this post, I will try and describe everything you need to know about the SAP anlcv table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for ANLCV what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from ANLCV....Right lets get started!


SAP ANLCV dictionary attributes

Object Name: ANLCV
Dictionary Type: Structure
Description: Asset Reporting: ANLC Fields Plus Various Totals


ANLCV field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
MANDTMANDTCLNT3(0) *ClientMANDTTEST
BUKRSBUKRSCHAR4(0) *Company CodeBUKRSBUKFBC_T001BUKRS
ANLN1ANLN1CHAR12(0) *Main Asset NumberANLN1AN1AA
ANLN2ANLN2CHAR4(0) *Asset SubnumberANLN2AN2AA
GJAHRGJAHRNUMC4(0) Fiscal YearGJAHRGJRFB
AFABEAFABE_DNUMC2(0) *Real depreciation areaAFABEAFBAB
ZUJHRDZUJHRNUMC4(0) Asset acquisition year (currently not used)GJAHRAB
ZUCODDZUCODNUMC4(0) Sub-classification of asset acquisitions(currently not used)AZCODAB
AFBLPEAFBLPENUMC3(0) Period in which last depreciation was postedPERAFAB
AFBANZAFBANZNUMC2(0) Number of depreciation posting runs in the periodNUM2AB
XAFARXAFARNUMC1(0) Indicator: Errors in depreciationXAFARABA
NDABJNDABJNUMC3(0) Expired useful life in years at start of the fiscal yearJARAFABA
NDABPNDABPNUMC3(0) Expired useful life in periods at start of fiscal yearPERAFABA
ANDSJANDSJNUMC3(0) Yrs Expired up to Fisc.Yr Start from Start of Spec.Dep.JARAFABA
ANDSPANDSPNUMC3(0) Expired useful life in periods during FY from SDep start datPERAFABA
RSTCKRSTCKDEC15(0) Number of units depreciated in unit-of-prod. depreciationPACK8ABA
KANSWKANSWCURR13(2) Cumulative acquisition and production costsANLKWERTAB
KAUFWKAUFWCURR13(2) Cumulative revaluation on the replacement valueANLKWERTAB
KINVZKINVZCURR13(2) Cumulative investment grantsANLKWERTAB
KNAFAKNAFACURR13(2) Accumulated ordinary depreciationANLKWERTAB
KSAFAKSAFACURR13(2) Cumulative special depreciationANLKWERTAB
KAAFAKAAFACURR13(2) Cumulative unplanned depreciationANLKWERTAB
KMAFAKMAFACURR13(2) Cumulative reserves transferANLKWERTAB
KZINWKZINWCURR13(2) Cumulative interestANLKWERTAB
KAUFNKAUFNCURR13(2) Cumulative revaluation of ordinary depreciationANLKWERTAB
KANZAKANZACURR13(2) Cumulative down paymentsANLKWERTAB
KVOSTKVOSTCURR13(2) Cumulative input taxANLKWERTAB
AUFWPAUFWPCURR13(2) Planned revaluation on replacement valueANLKWERTAB
NAFAPNAFAPCURR13(2) Planned ordinary depreciation for the yearANLKWERTAB
SAFAPSAFAPCURR13(2) Planned special depreciation for the yearANLKWERTAB
AAFAPAAFAPCURR13(2) Scheduled unplanned depreciation for the yearANLKWERTAB
MAFAPMAFAPCURR13(2) Planned transfer of reserves for the yearANLKWERTAB
ZINSPDZINSPCURR13(2) Interest planned for the yearANLKWERTAB
AUFNPAUFNPCURR13(2) Planned revaluation of accumulated ordinary depreciationANLKWERTAB
AUFWBAUFWBCURR13(2) Revaluation posted on replacement valueANLKWERTAB
NAFAGNAFAGCURR13(2) Ordinary depreciation posted in the current yearANLKWERTAB
SAFAGSAFAGCURR13(2) Special depreciation posted in the current fiscal yearANLKWERTAB
AAFAGAAFAGCURR13(2) Unplanned depreciation posted for the yearANLKWERTAB
MAFAGMAFAGCURR13(2) Acquisition value reducing depreciation posted for the yearANLKWERTAB
ZINSGDZINSGCURR13(2) Interest posted for the yearANLKWERTAB
AUFNGAUFNGCURR13(2) Posted revaluation of accumulated ordinary depreciationANLKWERTAB
ANSWLANSWLCURR13(2) Transactions for the year affecting asset valuesANLKWERTAB
ABGANABGANCURR13(2) Total retirements and retiring transfersANLKWERTAB
ANSAZANSAZCURR13(2) Down payments on assetANLKWERTAB
AUFWMAUFWMCURR13(2) Manual revaluation on replacement valueANLKWERTAB
INVZMINVZMCURR13(2) Investment grant for the yearANLKWERTAB
NAFAMNAFAMCURR13(2) Manually planned ordinary depreciation for the yearANLKWERTAB
SAFAMSAFAMCURR13(2) Manual special depreciation planned for the yearANLKWERTAB
AAFAMAAFAMCURR13(2) Manual unplanned depreciation for the yearANLKWERTAB
MAFAMMAFAMCURR13(2) Manual transfer of reserves for the yearANLKWERTAB
ZINSMDZINSMCURR13(2) Manual interest planned for the yearANLKWERTAB
AUFNMAUFNMCURR13(2) Manual revaluation of cumulative ordinary depreciationANLKWERTAB
ZUSNADZUSNACURR13(2) Write-up on ordinary depreciationANLKWERTAB
ZUSSADZUSSACURR13(2) Write-up on special depreciationANLKWERTAB
ZUSAADZUSAACURR13(2) Write-up on unplanned depreciationANLKWERTAB
ZUSMADZUSMACURR13(2) Write-up on transferred reservesANLKWERTAB
AUFWVAUFWVCURR13(2) Proportional cumulative revaluation on replacement valueANLKWERTAB
INVZVINVZVCURR13(2) Proportional cumulative investment grantsANLKWERTAB
NAFAVNAFAVCURR13(2) Proportional accumulated ordinary depreciationANLKWERTAB
SAFAVSAFAVCURR13(2) Proportional cumulative special depreciationANLKWERTAB
AAFAVAAFAVCURR13(2) Proportional cumulative unplanned depreciationANLKWERTAB
MAFAVMAFAVCURR13(2) Proportional cumulative transfer of reservesANLKWERTAB
AUFNVAUFNVCURR13(2) Proportional cum. revaluation on ordinary depreciationANLKWERTAB
AUFWLAUFWLCURR13(2) Proportional revaluation for the year on replacement valueANLKWERTAB
INVZLINVZLCURR13(2) Proportional investment grant for the yearANLKWERTAB
NAFALNAFALCURR13(2) Proportional ordinary depreciation for the yearANLKWERTAB
SAFALSAFALCURR13(2) Proportional special depreciation for the yearANLKWERTAB
AAFALAAFALCURR13(2) Proportional unplanned depreciation for the yearANLKWERTAB
MAFALMAFALCURR13(2) Proportional transfer of reserves for the yearANLKWERTAB
AUFNLAUFNLCURR13(2) Proportional revaluation of annual ordinary dep.ANLKWERTAB
ANUPDANUPDCHAR1(0) Indicator: Type of change to tableANUPDAA
KSANSKSANSCURR13(2) Cumulative statistical acquisition valueANLKWERT
SANSLSANSLCURR13(2) Statistical aquisition value of current yearANLKWERT
GJA_AUFWGJA_AUFWCURR13(2) Cumulative appreciation on replacement value for fiscal yearANLKWERTAB
GJE_AUFWGJE_AUFWCURR13(2) Appreciation on replacement value in current yearANLKWERTAB
GEB_AUFWTGGEB_AUFWTGCURR13(2) Posted planned and manual revaluation of replacement valueANLKWERTAW
GJA_KANSWGJA_KANSWCURR13(2) Asset acquisition value at fiscal year startANLKWERTAW
LFD_KANSWLFD_KANSWCURR13(2) Current asset acquisition valueANLKWERTAW
GJE_KANSWGJE_KANSWCURR13(2) Asset acquisition value at end of fiscal yearANLKWERTAW
GJA_BCHWRTGJA_BCHWRTCURR13(2) Asset book value at beginning of fiscal yearANLKWERTAW
LFD_BCHWRTLFD_BCHWRTCURR13(2) Current Book Value of AssetANLKWERTAW
GJE_BCHWRTGJE_BCHWRTCURR13(2) Asset net book value at end of fiscal yearANLKWERTAW
GJE_ZUSCHRGJE_ZUSCHRCURR13(2) Write-upANLKWERTAW
GJE_BWGWBGJE_BWGWBCURR13(2) Value adjustments on transactions, at FY endANLKWERTAW
GEB_ABSCHRGEB_ABSCHRCURR13(2) Depreciation posted (general)ANLKWERTAW
GEP_ABSCHRGEP_ABSCHRCURR13(2) Total depreciation plannedANLKWERTAW
NVG_ABSCHRNVG_ABSCHRCURR13(2) Ordinary depreciation: PastANLKWERTAW
RVG_ABSCHRRVG_ABSCHRCURR13(2) Remaining past depreciation (without ordinary depreciation)ANLKWERTAW
RGP_ABSCHRRGP_ABSCHRCURR13(2) Remaining depreciation planned (without ordinary dep.)ANLKWERTAW
GJE_INVZGJE_INVZCURR13(2) Investment grant at end of the yearANLKWERTAW
BEST_GJABEST_GJACURR13(2) Cumulative acquisition value at FY start (w/o inv.support)ANLKWERT
BEST_BEWBEST_BEWCURR13(2) Transactions affecting acquisition value (w/o inv. support)ANLKWERT
BEST_LFDBEST_LFDCURR13(2) Current acquisition value (without investment support)ANLKWERT
BEST_GJEBEST_GJECURR13(2) Acquisition value at fiscal year end (w/o inv.support)ANLKWERT
ANSW_GJAANSW_GJACURR13(2) Cumulative acquisition value at fiscal year startANLKWERT
ANSW_BEWANSW_BEWCURR13(2) Transactions on the acquisition valueANLKWERT
ANSW_LFDANSW_LFDCURR13(2) Current acquisition valueANLKWERT
ANSW_GJEANSW_GJECURR13(2) Acquisition value at fiscal year endANLKWERT
INV_GJAINV_GJACURR13(2) Cumulative investment support at fiscal year startANLKWERT
INV_BEWINV_BEWCURR13(2) Transactions on investment supportANLKWERT
INV_ANTINV_ANTCURR13(2) Proportional investment supportANLKWERT
INV_LFDINV_LFDCURR13(2) Current investment supportANLKWERT
INV_GJEINV_GJECURR13(2) Investment support at fiscal year endANLKWERT
AUFW_GJAAUFW_GJACURR13(2) Cumulative revaluation at fiscal year startANLKWERT
AUFW_GEPAUFW_GEPCURR13(2) Planned revaluationANLKWERT
AUFW_GEBAUFW_GEBCURR13(2) Revaluation postedANLKWERT
AUFW_ANTAUFW_ANTCURR13(2) Proportional revaluationANLKWERT
AUFW_LFDAUFW_LFDCURR13(2) Current revaluationANLKWERT
AUFW_GJEAUFW_GJECURR13(2) Revaluation at fiscal year endANLKWERT
AUFW_LFDPAUFW_LFDPCURR13(2) Revaluation for the current year (with planned values)ANLKWERT
AUFW_LFDGAUFW_LFDGCURR13(2) Revaluation from the current year (with posted values)ANLKWERT
RUECK_GJARUECK_GJACURR13(2) Cumulative reserves at fiscal year startANLKWERT
RUECK_GEPRUECK_GEPCURR13(2) Planned transfer of reservesANLKWERT
RUECK_GEBRUECK_GEBCURR13(2) Posted transfer of reservesANLKWERT
RUECK_ZUSRUECK_ZUSCURR13(2) Write-up to transferred reservesANLKWERT
RUECK_ANTRUECK_ANTCURR13(2) Proportional values from reservesANLKWERT
RUECK_LFDRUECK_LFDCURR13(2) Current reservesANLKWERT
RUECK_GJERUECK_GJECURR13(2) Transferred reserves at fiscal year endANLKWERT
RUECK_LFDPRUECK_LFDPCURR13(2) Transferred reserves from current year (w/planned values)ANLKWERT
RUECK_LFDGRUECK_LFDGCURR13(2) Transferred reserves from current year (w/posted values)ANLKWERT
NAFA_GJANAFA_GJACURR13(2) Accumulated ordinary depreciation at fiscal year startANLKWERT
NAFA_GEPNAFA_GEPCURR13(2) Planned ordinary depreciationANLKWERT
NAFA_GEBNAFA_GEBCURR13(2) Ordinary depreciation postedANLKWERT
NAFA_ZUSNAFA_ZUSCURR13(2) Write-up of ordinary depreciationANLKWERT
NAFA_ANTNAFA_ANTCURR13(2) Proportional ordinary depreciationANLKWERT
NAFA_LFDNAFA_LFDCURR13(2) Current ordinary depreciationANLKWERT
NAFA_GJENAFA_GJECURR13(2) Ordinary depreciation at fiscal year endANLKWERT
NAFA_LFDPNAFA_LFDPCURR13(2) Ordinary depreciation of the current year(w/ planned values)ANLKWERT
NAFA_LFDGNAFA_LFDGCURR13(2) Ordinary depreciation for current year (with posted values)ANLKWERT
RAFA_GJARAFA_GJACURR13(2) Cumulative remaining depreciation fiscal year startANLKWERT
RAFA_GEPRAFA_GEPCURR13(2) Planned remaining depreciationANLKWERT
RAFA_GEBRAFA_GEBCURR13(2) Remaining depreciation postedANLKWERT
RAFA_ZUSRAFA_ZUSCURR13(2) Write-up to remaining depreciationANLKWERT
RAFA_ANTRAFA_ANTCURR13(2) Proportional remaining depreciationANLKWERT
RAFA_LFDRAFA_LFDCURR13(2) Current remaining depreciationANLKWERT
RAFA_GJERAFA_GJECURR13(2) Remaining depreciation at fiscal year endANLKWERT
RAFA_LFDPRAFA_LFDPCURR13(2) Remaining depreciation for the current year (w/planned val.)ANLKWERT
RAFA_LFDGRAFA_LFDGCURR13(2) Remaining depreciation for current year (with posted values)ANLKWERT
AFA_GJAAFA_GJACURR13(2) Accumulated depreciation at fiscal year startANLKWERT
AFA_GEPAFA_GEPCURR13(2) Planned depreciationANLKWERT
AFA_GEBAFA_GEBCURR13(2) Depreciation postedANLKWERT
AFA_ZUSAFA_ZUSCURR13(2) Write-up to depreciationANLKWERT
AFA_ANTAFA_ANTCURR13(2) Proportional depreciationANLKWERT
AFA_LFDAFA_LFDCURR13(2) Current depreciationANLKWERT
AFA_GJEAFA_GJECURR13(2) Depreciation at fiscal year endANLKWERT
AFA_LFDPAFA_LFDPCURR13(2) Depreciation for the current year (with planned values)ANLKWERT
AFA_LFDGAFA_LFDGCURR13(2) Ordinary depreciation for current year (with posted values)ANLKWERT
SZINS_GJASZINS_GJACURR13(2) Cumulative interest at fiscal year startANLKWERT
SZINS_GEPSZINS_GEPCURR13(2) Interest plannedANLKWERT
SZINS_GEBSZINS_GEBCURR13(2) Interest postedANLKWERT
SZINS_LFDSZINS_LFDCURR13(2) Current interestANLKWERT
SZINS_GJESZINS_GJECURR13(2) Interest at fiscal year endANLKWERT
SZINS_LFDPSZINS_LFDCURR13(2) Current interestANLKWERT
SZINS_LFDGSZINS_LFDCURR13(2) Current interestANLKWERT
BACKL_GJABACKL_GJACURR13(2) Cumulative revaluation of ordinary depreciationANLKWERT
BACKL_GEPBACKL_GEPCURR13(2) Planned revaluation of accumulated ordinary depreciationANLKWERT
BACKL_GEBBACKL_GEBCURR13(2) Posted revaluation of accumulated ordinary depreciationANLKWERT
BACKL_LFDBACKL_LFDCURR13(2) Current cumulative revaluation of ordinary depreciationANLKWERT
BACKL_GJEBACKL_GJECURR13(2) Cum. revaluation of ord. depreciation at fiscal year endANLKWERT
BACKL_LFDGBACKL_LFDCURR13(2) Current cumulative revaluation of ordinary depreciationANLKWERT
BACKL_LFDPBACKL_LFDCURR13(2) Current cumulative revaluation of ordinary depreciationANLKWERT
BCHWRT_GJABCHWRT_GJACURR13(2) Book value at fiscal year startANLKWERT
BCHWRT_LFDBCHWRT_LFDCURR13(2) Current book valueANLKWERT
BCHWRT_GJEBCHWRT_GJECURR13(2) Book value at fiscal year endANLKWERT