Follow us on LinkedIn for your next SAP project

SAP Table ANLZ

Time-Dependent Asset Allocations

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.

ANLZ table fields

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

ANLZ foreign key relationships

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