SAP table ANLP (Asset Periodic Values)

SAP table ANLP has 10 primary key fields being MANDT,BUKRS,GJAHR,PERAF,AFBNR,ANLN1,ANLN2,AFABER,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 FAAV_COMP_CODE BUKRS
GJAHR Fiscal Year NUMC 4 0 GJAHR
PERAF Posting Period of Depreciation NUMC 3 0 PERAF
0
AFBNR Sequence Number of Depreciation Posting Run in the Period NUMC 2 0 AFBNR
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLA ANLN2
AFABER Depreciation Area Real or Derived NUMC 2 0 FAAV_DEPR_AREA AFABER
ZUJHR Asset Acquisition Year (Currently Not Used) NUMC 4 0 DZUJHR
ZUCOD Sub-Classification of Asset Acquisitions(Currently Not Used) NUMC 4 0 DZUCOD
AUFWP Planned Revaluation on Replacement Value CURR 23 2 AUFWP
AUFWB Revaluation Posted on Replacement Value CURR 23 2 AUFWB
AUFWZ Revaluation on Replacement Value to Be Posted CURR 23 2 AUFWZ
NAFAP Planned Ordinary Depreciation for the Year CURR 23 2 NAFAP
NAFAG Ordinary Depreciation Posted in the Current Year CURR 23 2 NAFAG
NAFAZ Ordinary Depreciation to Be Posted CURR 23 2 NAFAZ
SAFAP Planned Special Depreciation for the Year CURR 23 2 SAFAP
SAFAG Special Depreciation Posted in the Current Fiscal Year CURR 23 2 SAFAG
SAFAZ Special Depreciation to Be Posted CURR 23 2 SAFAZ
AAFAP Scheduled Unplanned Depreciation for the Year CURR 23 2 AAFAP
AAFAG Unplanned Depreciation Posted for the Year CURR 23 2 AAFAG
AAFAZ Unplanned Depreciation to Be Posted CURR 23 2 AAFAZ
MAFAP Planned Transfer of Reserves for the Year CURR 23 2 MAFAP
MAFAG Acquisition Value Reducing Depreciation Posted for the Year CURR 23 2 MAFAG
MAFAZ Transferred Reserves to Be Posted for the Year CURR 23 2 MAFAZ
ZINSP Interest Planned for the Year CURR 23 2 DZINSP
ZINSG Interest Posted for the Year CURR 23 2 DZINSG
ZINSZ Interest for the Year to Be Posted CURR 23 2 DZINZB
AUFNP Planned Revaluation of Accumulated Ordinary Depreciation CURR 23 2 AUFNP
AUFNG Posted Revaluation of Accumulated Ordinary Depreciation CURR 23 2 AUFNG
AUFNZ Revaluation to Be Posted on Cum. Ordinary Depreciation CURR 23 2 AUFNZ
ANSWL Transactions for the Year Affecting Asset Values CURR 23 2 ANSWL
INVZM Investment Grant for the Year CURR 23 2 INVZM
KTOGR Account Determination CHAR 8 0 T095A KTOGR
AFASL Depreciation key CHAR 4 0 T090NA AFASL
KOSTL Cost Center CHAR 10 0 KOSTL
GSBER Business Area CHAR 4 0 TGSB GSBER
CAUFN Internal Order CHAR 12 0 AUFK CAUFN
XUNUL Indicator: Post to Below-Zero Account CHAR 1 0 XUNULL
ANUPD Indicator: Type of change to table CHAR 1 0 ANUPD
No changes
D Delete
I Insert
U Update
FKBER Functional Area CHAR 16 0 FKBER
BELNR Document number of a depreciation posting document CHAR 10 0 AFA_BLNR
LSTAR Activity Type CHAR 6 0 LSTAR
GEBER Fund CHAR 10 0 * BP_GEBER
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
FISTL Funds Center CHAR 16 0 FISTL

ANLP foreign key relationships

Table Field Check Table Check Field
0 ANLP AFABER FAAV_DEPR_AREA Generated Table for View DEPR_AREA
1 ANLP AFASL T090NA Depreciation Keys MANDT
1 ANLP AFASL T090NA Depreciation Keys AFAPL
1 ANLP AFASL T090NA Depreciation Keys AFASL
0 ANLP ANLN1 ANLH Main asset number BUKRS
0 ANLP ANLN1 ANLH Main asset number ANLN1
1 ANLP ANLN2 ANLA Asset Master Record Segment BUKRS
1 ANLP ANLN2 ANLA Asset Master Record Segment ANLN1
1 ANLP ANLN2 ANLA Asset Master Record Segment ANLN2
0 ANLP CAUFN AUFK Order master data AUFNR
1 ANLP GSBER TGSB Business Areas MANDT
1 ANLP GSBER TGSB Business Areas GSBER
0 ANLP KTOGR T095A Account allocation MANDT
0 ANLP KTOGR T095A Account allocation KTOGR
1 ANLP SEGMENT FAGL_SEGM Master Data for Segments SEGMENT