SAP table ANEP (Asset Line Items)
SAP table ANEP has 9 primary key fields being MANDT,BUKRS,ANLN1,ANLN2,GJAHR,LNRAN,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
T000
MANDT
BUKRS
Company Code
CHAR
4
0
T001
BUKRS
ANLN1
Main Asset Number
CHAR
12
0
ANLH
ANLN1
ANLN2
Asset Subnumber
CHAR
4
0
ANLA
ANLN2
GJAHR
Fiscal Year
NUMC
4
0
GJAHR
LNRAN
Sequence Number of Asset Line Items in Fiscal Year
NUMC
5
0
ANEK
LNRAN
AFABE
Real depreciation area
NUMC
2
0
ANLB
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
PERAF
Posting Period of Depreciation
NUMC
3
0
PERAF
Possible values
BELNR
Document Number of an Accounting Document
CHAR
10
0
BELNR_D
BUZEI
Number of Line Item Within Accounting Document
NUMC
3
0
BUZEI
BZDAT
Asset Value Date
DATS
8
0
BZDAT
BWASL
Asset Transaction Type
CHAR
3
0
TABW
BWASL
XAFAR
Indicator: Errors in Depreciation
NUMC
1
0
XAFAR
Possible values
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
ANBTR
Amount Posted
CURR
23
2
ANBTR
NAFAB
Ordinary Depreciation on Transactions
CURR
23
2
NAFAB
SAFAB
Special Depreciation on Transactions
CURR
23
2
SAFAB
ZINSB
Interest on Transaction
CURR
23
2
DZINSB
XANTW
Indicator: Proportional Values Posted Automatically
CHAR
1
0
XANTW
XAWBT
Indicator: Different posting amount entered
CHAR
1
0
XAWBT
LNSAN
Sequence Number of Reversed Asset Line Items
NUMC
5
0
LNSAN
ANUPD
Indicator: Type of change to table
CHAR
1
0
ANUPD
Possible values
No changes
D
Delete
I
Insert
U
Update
AUGLN
Current Number of the Clearing Asset Line Item
NUMC
5
0
ANEK
AM_AUGLN
ANEP foreign key relationships
Table
Field
Check Table
Check Field
0 ANEP
AFABE
ANLB
Depreciation terms
BUKRS
0 ANEP
AFABE
ANLB
Depreciation terms
ANLN1
0 ANEP
AFABE
ANLB
Depreciation terms
ANLN2
0 ANEP
AFABE
ANLB
Depreciation terms
AFABE
0 ANEP
AFABE
ANLB
Depreciation terms
BDATU
1 ANEP
ANLN1
ANLH
Main asset number
BUKRS
1 ANEP
ANLN1
ANLH
Main asset number
ANLN1
0 ANEP
ANLN2
ANLA
Asset Master Record Segment
BUKRS
0 ANEP
ANLN2
ANLA
Asset Master Record Segment
ANLN1
0 ANEP
ANLN2
ANLA
Asset Master Record Segment
ANLN2
1 ANEP
AUGLN
ANEK
Document Header Asset Posting
MANDT
1 ANEP
AUGLN
ANEK
Document Header Asset Posting
BUKRS
1 ANEP
AUGLN
ANEK
Document Header Asset Posting
ANLN1
1 ANEP
AUGLN
ANEK
Document Header Asset Posting
ANLN2
1 ANEP
AUGLN
ANEK
Document Header Asset Posting
GJAHR
1 ANEP
AUGLN
ANEK
Document Header Asset Posting
LNRAN
0 ANEP
BUKRS
T001
Company Codes
BUKRS
1 ANEP
BWASL
TABW
Asset transaction types
MANDT
0 ANEP
LNRAN
ANEK
Document Header Asset Posting
MANDT
0 ANEP
LNRAN
ANEK
Document Header Asset Posting
BUKRS
0 ANEP
LNRAN
ANEK
Document Header Asset Posting
ANLN1
0 ANEP
LNRAN
ANEK
Document Header Asset Posting
ANLN2
0 ANEP
LNRAN
ANEK
Document Header Asset Posting
GJAHR
0 ANEP
LNRAN
ANEK
Document Header Asset Posting
LNRAN
1 ANEP
MANDT
T000
Clients
MANDT