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'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 | T001 | BUKRS | |||||||||
| ANLN1 | 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 |
ANLH foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ANLH | BUKRS | T001 | Company Codes | BUKRS |
| 1 ANLH | FUNTN | ANLA | Asset Master Record Segment | BUKRS |
| 1 ANLH | FUNTN | ANLA | Asset Master Record Segment | ANLN1 |
| 1 ANLH | FUNTN | ANLA | Asset Master Record Segment | ANLN2 |