ANLZ (Time-Dependent Asset Allocations) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link ANLZ to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||
|
ANLN1
Main Asset Number
|
ANLN1 | ANLH |
CHAR
|
12 | 0 | |||||||||||
|
ANLN2
Asset Subnumber
|
ANLN2 | ANLA |
CHAR
|
4 | 0 | |||||||||||
|
BDATU
Date validity ends
|
BDATU |
DATS
|
8 | 0 | ||||||||||||
|
ADATU
Date for beginning of validity
|
ADATU |
DATS
|
8 | 0 | ||||||||||||
|
KOSTL
Cost Center
|
KOSTL |
CHAR
|
10 | 0 | ||||||||||||
|
WERKS
Plant
|
WERKS_D | T001W |
CHAR
|
4 | 0 | |||||||||||
|
GSBER
Business Area
|
GSBER | TGSB |
CHAR
|
4 | 0 | |||||||||||
|
LSTAR
Activity Type
|
LSTAR |
CHAR
|
6 | 0 | ||||||||||||
|
MSFAK
Multiple-shift factor for multiple shift operation
|
MSFAK |
DEC
|
3 | 2 | ||||||||||||
|
XSTIL
Asset shutdown
|
XSTIL |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
STORT
Asset location
|
STORT | T499S |
CHAR
|
10 | 0 | |||||||||||
|
CAUFN
Internal order
|
CAUFN | AUFK |
CHAR
|
12 | 0 | |||||||||||
|
PLAN1
no longer used
|
PLAN1 |
CHAR
|
12 | 0 | ||||||||||||
|
PLAN2
No longer used
|
PLAN2 |
CHAR
|
4 | 0 | ||||||||||||
|
RAUMN
Room
|
RAUMNR |
CHAR
|
8 | 0 | ||||||||||||
|
IAUFN
Maintenance order
|
IAUFN | AUFK |
CHAR
|
12 | 0 | |||||||||||
|
IPROJ
Old: Project number : No longer used --> PS_POSNR
|
PROJN |
CHAR
|
16 | 0 | ||||||||||||
|
TPLKZ
Unused field length 3
|
FILL03 |
CHAR
|
3 | 0 | ||||||||||||
|
TPLNR
Functional Location
|
TPLNR |
CHAR
|
30 | 0 | ||||||||||||
|
ANUPD
Indicator: Type of change to table
|
ANUPD |
CHAR
|
1 | 0 | ||||||||||||
|
||||||||||||||||
|
TXJCD
Tax Jurisdiction
|
TXJCD | TTXJ |
CHAR
|
15 | 0 | |||||||||||
|
IPSNR
WBS element - maintenance project
|
AM_IPSNR | PRPS |
NUMC
|
8 | 0 | |||||||||||
|
KFZKZ
License plate no. of vehichle
|
AM_KFZKZ |
CHAR
|
15 | 0 | ||||||||||||
|
PERNR
Personnel Number
|
PERNR_D |
NUMC
|
8 | 0 | ||||||||||||
|
KOSTLV
Cost center responsible for asset
|
KOSTLV |
CHAR
|
10 | 0 | ||||||||||||
|
FISTL
Funds Center
|
FISTL |
CHAR
|
16 | 0 | ||||||||||||
|
GEBER
Fund
|
BP_GEBER |
CHAR
|
10 | 0 | ||||||||||||
|
FKBER
Functional Area
|
FKBER |
CHAR
|
16 | 0 | ||||||||||||
|
GRANT_NBR
Grant
|
GM_GRANT_NBR |
CHAR
|
20 | 0 | ||||||||||||
|
GEBER2
Fund for APC Account Assignments
|
BP_GEBER2 |
CHAR
|
10 | 0 | ||||||||||||
|
FKBER2
Functional Area for APC Account Assignments
|
FKBER2 |
CHAR
|
16 | 0 | ||||||||||||
|
GRANT_NBR2
Grant for APC Account Assignments
|
GM_GRANT_NBR2 |
CHAR
|
20 | 0 | ||||||||||||
|
FISTL2
Funds Center for APC Account Assignments
|
FISTL2 |
CHAR
|
16 | 0 | ||||||||||||
|
IMKEY
Internal Key for Real Estate Object
|
IMKEY |
CHAR
|
8 | 0 | ||||||||||||
|
PS_PSP_PNR2
WBS Element (Costs)
|
PS_PSP_PNR2 |
NUMC
|
8 | 0 | ||||||||||||
|
BUDGET_PD
FM: Budget Period
|
FM_BUDGET_PERIOD |
CHAR
|
10 | 0 | ||||||||||||
|
BUDGET_PD2
Budget Period for APC Account Assignments
|
FM_BUDGET_PERIOD2 |
CHAR
|
10 | 0 | ||||||||||||
|
SEGMENT
Segment for Segmental Reporting
|
FB_SEGMENT | FAGL_SEGM |
CHAR
|
10 | 0 | |||||||||||
|
PRCTR
Profit Center
|
PRCTR |
CHAR
|
10 | 0 | ||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ANLZ | ANLN1 | ANLZ | ANLN1 |
ANLH
Main asset number
|
ANLN1 |
| ANLZ | ANLN1 | ANLZ | MANDT |
ANLH
Main asset number
|
MANDT |
| ANLZ | ANLN1 | ANLZ | BUKRS |
ANLH
Main asset number
|
BUKRS |
| ANLZ | ANLN2 | ANLZ | MANDT |
ANLA
Asset Master Record Segment
|
MANDT |
| ANLZ | ANLN2 | ANLZ | BUKRS |
ANLA
Asset Master Record Segment
|
BUKRS |
| ANLZ | ANLN2 | ANLZ | ANLN1 |
ANLA
Asset Master Record Segment
|
ANLN1 |
| ANLZ | ANLN2 | ANLZ | ANLN2 |
ANLA
Asset Master Record Segment
|
ANLN2 |
| ANLZ | BUKRS | ANLZ | BUKRS |
T001
Company Codes
|
BUKRS |
| ANLZ | BUKRS | ANLZ | MANDT |
T001
Company Codes
|
MANDT |
| ANLZ | CAUFN | ANLZ | MANDT |
AUFK
Order master data
|
MANDT |
| ANLZ | CAUFN | ANLZ | CAUFN |
AUFK
Order master data
|
AUFNR |
| ANLZ | GSBER | ANLZ | MANDT |
TGSB
Business Areas
|
MANDT |
| ANLZ | GSBER | ANLZ | GSBER |
TGSB
Business Areas
|
GSBER |
| ANLZ | IAUFN | ANLZ | MANDT |
AUFK
Order master data
|
MANDT |
| ANLZ | IAUFN | ANLZ | IAUFN |
AUFK
Order master data
|
AUFNR |
| ANLZ | IPSNR | ANLZ | MANDT |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
MANDT |
| ANLZ | IPSNR | ANLZ | IPSNR |
PRPS
WBS (Work Breakdown Structure) Element Master Data
|
PSPNR |
| ANLZ | SEGMENT | SYST | MANDT |
FAGL_SEGM
Master Data for Segments
|
MANDT |
| ANLZ | SEGMENT | ANLZ | SEGMENT |
FAGL_SEGM
Master Data for Segments
|
SEGMENT |
| ANLZ | STORT | ANLZ | MANDT |
T499S
Location
|
MANDT |
| ANLZ | STORT | ANLZ | WERKS |
T499S
Location
|
WERKS |
| ANLZ | STORT | ANLZ | STORT |
T499S
Location
|
STAND |
| ANLZ | TXJCD | ANLZ | MANDT |
TTXJ
Check Table for Tax Jurisdiction
|
MANDT |
| ANLZ | TXJCD | RA02S | KALSM |
TTXJ
Check Table for Tax Jurisdiction
|
KALSM |
| ANLZ | TXJCD | ANLZ | TXJCD |
TTXJ
Check Table for Tax Jurisdiction
|
TXJCD |
| ANLZ | WERKS | ANLZ | MANDT |
T001W
Plants/Branches
|
MANDT |
| ANLZ | WERKS | ANLZ | WERKS |
T001W
Plants/Branches
|
WERKS |