SAP ANLP Asset Periodic Values Table data and field list

ANLP is a standard SAP Table which is used to store Asset Periodic Values data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The ANLP table consists of various fields, each holding specific information or linking keys about Asset Periodic Values data available in SAP. These include BUKRS (Company Code), GJAHR (Fiscal Year), PERAF (Depreciation calculation period), AFBNR (Sequence number of depreciation posting run in the period)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

ANLP table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP ANLP table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the ANLP table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
BUKRS	Company Code	BUKRS	CHAR	4	T001		BUKRS	BUK	C_T001
GJAHR	Fiscal Year	GJAHR	NUMC	4		GJAHR	GJAHR	GJR
PERAF	Depreciation calculation period	PERAF	NUMC	3			PERAF
AFBNR	Sequence number of depreciation posting run in the period	AFBNR	NUMC	2			NUM2
ANLN1	Main Asset Number	ANLN1	CHAR	12	ANLH	ALPHA	ANLN1	AN1
ANLN2	Asset Subnumber	ANLN2	CHAR	4	ANLA	ALPHA	ANLN2	AN2
AFABER	Depreciation area real or derived	AFABER	NUMC	2	T093		AFABE
ZUJHR	Asset acquisition year (currently not used)	DZUJHR	NUMC	4		GJAHR	GJAHR
ZUCOD	Sub-classification of asset acquisitions(currently not used)	DZUCOD	NUMC	4			AZCOD
AUFWP	Planned revaluation on replacement value	AUFWP	CURR	13(2)			ANLKWERT
AUFWB	Revaluation posted on replacement value	AUFWB	CURR	13(2)			ANLKWERT
AUFWZ	Revaluation on replacement value to be posted	AUFWZ	CURR	13(2)			ANLKWERT
NAFAP	Planned ordinary depreciation for the year	NAFAP	CURR	13(2)			ANLKWERT
NAFAG	Ordinary depreciation posted in the current year	NAFAG	CURR	13(2)			ANLKWERT
NAFAZ	Ordinary depreciation to be posted	NAFAZ	CURR	13(2)			ANLKWERT
SAFAP	Planned special depreciation for the year	SAFAP	CURR	13(2)			ANLKWERT
SAFAG	Special depreciation posted in the current fiscal year	SAFAG	CURR	13(2)			ANLKWERT
SAFAZ	Special depreciation to be posted	SAFAZ	CURR	13(2)			ANLKWERT
AAFAP	Scheduled unplanned depreciation for the year	AAFAP	CURR	13(2)			ANLKWERT
AAFAG	Unplanned depreciation posted for the year	AAFAG	CURR	13(2)			ANLKWERT
AAFAZ	Unplanned depreciation to be posted	AAFAZ	CURR	13(2)			ANLKWERT
MAFAP	Planned transfer of reserves for the year	MAFAP	CURR	13(2)			ANLKWERT
MAFAG	Acquisition value reducing depreciation posted for the year	MAFAG	CURR	13(2)			ANLKWERT
MAFAZ	Transferred reserves to be posted for the year	MAFAZ	CURR	13(2)			ANLKWERT
ZINSP	Interest planned for the year	DZINSP	CURR	13(2)			ANLKWERT
ZINSG	Interest posted for the year	DZINSG	CURR	13(2)			ANLKWERT
ZINSZ	Interest for the year to be posted	DZINZB	CURR	13(2)			ANLKWERT
AUFNP	Planned revaluation of accumulated ordinary depreciation	AUFNP	CURR	13(2)			ANLKWERT
AUFNG	Posted revaluation of accumulated ordinary depreciation	AUFNG	CURR	13(2)			ANLKWERT
AUFNZ	Revaluation to be posted on cum. ordinary depreciation	AUFNZ	CURR	13(2)			ANLKWERT
ANSWL	Transactions for the year affecting asset values	ANSWL	CURR	13(2)			ANLKWERT
INVZM	Investment grant for the year	INVZM	CURR	13(2)			ANLKWERT
KTOGR	Account determination	KTOGR	CHAR	8	T095A	ALPHA	KTOGR
AFASL	Depreciation key	AFASL	CHAR	4	T090NA		AFASL		SH_AFASL
KOSTL	Cost Center	KOSTL	CHAR	10	Assigned to domain	ALPHA	KOSTL	KOS
GSBER	Business Area	GSBER	CHAR	4	TGSB		GSBER	GSB
CAUFN	Internal order	CAUFN	CHAR	12	AUFK	ALPHA	AUFNR
XUNUL	Indicator: Post to below-zero account	XUNULL	CHAR	1			XFELD
ANUPD	Indicator: Type of change to table	ANUPD	CHAR	1			ANUPD
FKBER	Functional Area	FKBER	CHAR	16	Assigned to domain		FKBER	FBE
BELNR	Document number of a depreciation posting document	AFA_BLNR	CHAR	10		ALPHA	BELNR
LSTAR	Activity Type	LSTAR	CHAR	6	Assigned to domain		LSTAR	LAR	LART_EMPTY
GEBER	Fund	BP_GEBER	CHAR	10	Assigned to domain		BP_GEBER	FIC
GRANT_NBR	Grant	GM_GRANT_NBR	CHAR	20		ALPHA	GM_GRANT_NBR	GM_GRANT_NBR	GRANTS_GENERIC
GEBER2	Fund for APC Account Assignments	BP_GEBER2	CHAR	10	Assigned to domain		BP_GEBER	FIC
FKBER2	Functional Area for APC Account Assignments	FKBER2	CHAR	16	Assigned to domain		FKBER	FBE
GRANT_NBR2	Grant for APC Account Assignments	GM_GRANT_NBR2	CHAR	20		ALPHA	GM_GRANT_NBR
FISTL2	Funds Center for APC Account Assignments	FISTL2	CHAR	16	Assigned to domain		FISTL	FIS
IMKEY	Internal Key for Real Estate Object	IMKEY	CHAR	8			IMKEY
PS_PSP_PNR2	WBS Element (Costs)	PS_PSP_PNR2	NUMC	8	Assigned to domain	ABPSP	PS_POSNR
BUDGET_PD	FM: Budget Period	FM_BUDGET_PERIOD	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
BUDGET_PD2	Budget Period for APC Account Assignments	FM_BUDGET_PERIOD2	CHAR	10	Assigned to domain		FM_BUDGET_PERIOD	BUDPER
SEGMENT	Segment for Segmental Reporting	FB_SEGMENT	CHAR	10	FAGL_SEGM	ALPHA	FB_SEGMENT
PRCTR	Profit Center	PRCTR	CHAR	10	Assigned to domain	ALPHA	PRCTR	PRC	PRCTR_EMPTY
FISTL	Funds Center	FISTL	CHAR	16	Assigned to domain		FISTL	FIS

Key field

Non-key field

< ANLN2_RANG - Range for ANLN2 ANLP_KEY - ANLP Key Fields >

How do I retrieve data from SAP table ANLP using ABAP code

The following ABAP code Example will allow you to do a basic selection on ANLP to SELECT all data from the table
DATA: WA_ANLP TYPE ANLP.

SELECT SINGLE *
FROM ANLP
INTO CORRESPONDING FIELDS OF WA_ANLP
WHERE...

How to access SAP table ANLP

Within an ECC or HANA version of SAP you can also view further information about ANLP and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).

Related SAP tables and the relationships to ANLP

    ANLA0 - Intro. Table Logical Database ADA
        ANLAV - Asset Reporting: ANLA Fields Plus Cost Center...
    ANLK - Asset Origin by Cost Element
    ANLP - Asset Periodic Values
    ANEK - Document Header Asset Posting
        ANEPV - Asset Line Items (ANEP + ANEA + ANEK)
    GLOFAAASSETD - Country-Specific Asset Master Records
    GLOFAATMD - Time-Depend. Country-Specific Asset Master Records
    ANLAV_ADDR - Address Data for Asset on the Report Date
    ANLT - Asset Texts
    ANLV - Insurance Data
    ANLZ - Time-Dependent Asset Allocations
    ANLB - Depreciation Terms
        ANLCV - Asset Reporting: ANLC Fields, Extended