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
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
X Yes
NULL No
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
D Delete
I Insert
U Update
NULL No changes
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 MANDT ANLH Main asset number MANDT
ANLZ ANLN1 ANLZ BUKRS ANLH Main asset number BUKRS
ANLZ ANLN1 ANLZ ANLN1 ANLH Main asset number ANLN1
ANLZ ANLN2 ANLZ ANLN2 ANLA Asset Master Record Segment ANLN2
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 BUKRS ANLZ MANDT T001 Company Codes MANDT
ANLZ BUKRS ANLZ BUKRS T001 Company Codes BUKRS
ANLZ CAUFN ANLZ CAUFN AUFK Order master data AUFNR
ANLZ CAUFN ANLZ MANDT AUFK Order master data MANDT
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 IPSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
ANLZ IPSNR ANLZ MANDT PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
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