Monday, May 27, 2024

SAP Table ANLH – Main asset number

ANLH is a standard SAP table in SAP ERP (or) S/4HANA which stores Main asset number data. There are total 8 fields in ANLH table.This blog post provides key technical details of SAP table ANLH, including its availability across SAP S/4HANA versions and the list of CDS views for ANLH table in SAP.

SAP HANA Table Type Column Store
Buffering Permission Buffering not allowed
Buffering Type No buffering
Package Asset Accounting (AB)
Technical Component Basic Functions (FI-AA-AA)

SAP ANLH Table Fields

The following is the list of fields that are available in SAP ANLH table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type
MANDT Client MANDT MANDT * CLNT (3)
BUKRS Company Code BUKRS BUKRS T001 CHAR (4)
ANLN1 Main Asset Number ANLN1 ANLN1 CHAR (12)
LUNTN Last Subnumber Assigned to this Main Number LUNTN ANLN2_4 CHAR (4)
LANEP Last Line Item Number Assigned LANEP LNRAN * NUMC (5)
ANUPD Indicator: Type of change to table ANUPD ANUPD CHAR (1)
FUNTN First Subnumber Assigned FUNTN ANLN2 ANLA CHAR (4)
ANLHTXT Asset Main Number Text ANLHTXT TEXT50 CHAR (50)

Availability

The SAP table ANLH is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Available?
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for ANLH table

The following is the list of ANLH CDS views, which can also be used instead of ANLH table based on your business requirements.

CDS View CDS View Type Description
I_MASTERFIXEDASSET BASIC Master Fixed Asset
I_MATLDOCFIXEDASSETVH BASIC Invtry Management Fixed Assets
I_FIXEDASSETDEPRAREATP COMPOSITE Transactional View Fixed Asset Depreciation Areas
I_MASTERFIXEDASSETSTDVH COMPOSITE Master Fixed Asset
P_AUDIT_AT_ASSETHISTORYSHEET COMPOSITE Austrian Audit Asset History Sheet
P_AUDIT_AT_ASSETTRANSACTION COMPOSITE Austrian Audit Asset Transaction
C_DARTFIXEDASSETSCHEDULE CONSUMPTION Schedule of Fixed Assets
C_FIXEDASSETBALANCE CONSUMPTION Asset Balances
C_FIXEDASSETDEPRAREAMAINTAIN CONSUMPTION Consumption View of Fixed Asset Change – Depreciation Area
C_FIXEDASSETDEPRECIATIONLIST CONSUMPTION Depreciation Lists
C_FIXEDASSETHISTORYSHEET CONSUMPTION Asset History Sheet
C_FIXEDASSETINVMTSUPPMSRMNTN CONSUMPTION Consumption View of Fixed Asset Change – Invmt Supp Measure
C_FIXEDASSETMAINTAIN CONSUMPTION Consumption View of Fixed Asset Change – Fixed Asset Data
C_FIXEDASSETOVWFXDASTVH CONSUMPTION Master Fixed Asset Value Help
C_FIXEDASSETTRANSACTION CONSUMPTION Asset Transactions
C_FIXEDASSETVALUEHELP CONSUMPTION Value Help for fixed asset
C_FXDASTDEPRAREACURRENTMNTN CONSUMPTION Cons. View of Fixed Asset Edit – Depr. Area by Current Date
C_GLACCOUNTLINEITEMIMPACT CONSUMPTION GL Accounting Impact
C_OBJPGTECHNICALOBJECT CONSUMPTION Technical Object
C_PURCHASEORDERITEMACCTMNTR CONSUMPTION Purchase Order Items by Account Assignment
C_RO_STRPFXDASTCHARTVALUEQRY CONSUMPTION RO Asset Chart: Values and Trans. – Qry
C_STRPFXDASTACQUISITIONFORMQRY CONSUMPTION Fixed Asset Acquisition Form Query
C_STRPFXDASTLOCTRANSFERFORMQRY CONSUMPTION Fixed Asset Location Transfer Form Query
C_STRPFXDASTRETIREMENTFORMQRY CONSUMPTION Fixed Asset Retirement Form Query
C_TRACKTOOLUSAGETP CONSUMPTION Track Tool Usage