SAP Table

ANLH Main asset number

SAP table ANLH is part of the Asset Accounting (FI-AA) module. It stores master data for main asset numbers, which are used to uniquely identify and organize fixed assets within a company code. This table contains essential fields such as the asset main number, asset class, and associated company code, helping manage and track fixed asset details. ANLH acts as a key reference for linking detailed asset transactions and other related tables in the SAP system.

SAP table ANLH has 3 primary key fields being MANDT,BUKRS,ANLN1.

If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.

/ Fields

ANLH columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 * MANDT
KeyBUKRS Company Code CHAR 4 0 T001 BUKRS
KeyANLN1 Main Asset Number CHAR 12 0 ANLN1
LUNTN Last Subnumber Assigned to this Main Number CHAR 4 0 LUNTN
LANEP Last Line Item Number Assigned NUMC 5 0 * LANEP
ANUPD Indicator: Type of change to table CHAR 1 0 ANUPD
FUNTN First Subnumber Assigned CHAR 4 0 ANLA FUNTN
ANLHTXT Asset Main Number Text CHAR 50 0 ANLHTXT
/ Relationships

ANLH foreign keys.

Table Field Check Table Description Check Field
ANLH BUKRS T001 Company Codes BUKRS
ANLH FUNTN ANLA Asset Master Record Segment BUKRS
ANLH FUNTN ANLA Asset Master Record Segment ANLN1
ANLH FUNTN ANLA Asset Master Record Segment ANLN2