SAP table ANLZ (Time-Dependent Asset Allocations)

SAP table ANLZ has 5 primary key fields being MANDT,BUKRS,ANLN1,ANLN2,BDATU.

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 FAAV_COMP_CODE BUKRS
ANLN1 Main Asset Number CHAR 12 0 ANLH ANLN1
ANLN2 Asset Subnumber CHAR 4 0 ANLA ANLN2
BDATU Date Validity Ends DATS 8 0 BDATU
ADATU Date for Beginning of Validity DATS 8 0 ADATU
KOSTL Cost Center CHAR 10 0 KOSTL
WERKS Plant CHAR 4 0 T001W WERKS_D
GSBER Business Area CHAR 4 0 TGSB GSBER
LSTAR Activity Type CHAR 6 0 LSTAR
MSFAK Multiple-Shift Factor for Multiple Shift Operation DEC 3 2 MSFAK
XSTIL Asset shutdown CHAR 1 0 XSTIL
STORT Asset location CHAR 10 0 T499S STORT
CAUFN Internal Order CHAR 12 0 AUFK CAUFN
PLAN1 No Longer Used CHAR 12 0 PLAN1
PLAN2 No longer used CHAR 4 0 PLAN2
RAUMN Room CHAR 8 0 RAUMNR
IAUFN Maintenance Order CHAR 12 0 AUFK IAUFN
IPROJ Old: Project number : No longer used --> PS_POSNR CHAR 16 0 PROJN
TPLKZ Unused Field Length 3 CHAR 3 0 FILL03
TPLNR Functional Location CHAR 30 0 TPLNR
ANUPD Indicator: Type of change to table CHAR 1 0 ANUPD
No changes
D Delete
I Insert
U Update
TXJCD Tax Jurisdiction CHAR 15 0 TTXJ TXJCD
IPSNR WBS Element - Maintenance Project NUMC 8 0 PRPS AM_IPSNR
KFZKZ License Plate No. of Vehicle CHAR 15 0 AM_KFZKZ
PERNR Personnel Number NUMC 8 0 PERNR_D
KOSTLV Cost Center Responsible for Asset CHAR 10 0 KOSTLV
FISTL Funds Center CHAR 16 0 * FISTL
GEBER Fund CHAR 10 0 * BP_GEBER
FKBER Functional Area CHAR 16 0 * FKBER
GRANT_NBR Grant CHAR 20 0 GM_GRANT_NBR
GEBER2 Fund for APC Account Assignments CHAR 10 0 * BP_GEBER2
FKBER2 Functional Area for APC Account Assignments CHAR 16 0 * FKBER2
GRANT_NBR2 Grant for APC Account Assignments CHAR 20 0 * GM_GRANT_NBR2
FISTL2 Funds Center for APC Account Assignments CHAR 16 0 * FISTL2
IMKEY Internal Key for Real Estate Object CHAR 8 0 IMKEY
PS_PSP_PNR2 WBS Element (Costs) NUMC 8 0 * PS_PSP_PNR2
BUDGET_PD Budget Period CHAR 10 0 * FM_BUDGET_PERIOD
BUDGET_PD2 Budget Period for APC Account Assignments CHAR 10 0 * FM_BUDGET_PERIOD2
SEGMENT Segment for Segmental Reporting CHAR 10 0 FAGL_SEGM FB_SEGMENT
PRCTR Profit Center CHAR 10 0 PRCTR

ANLZ foreign key relationships

Table Field Check Table Check Field
0 ANLZ ANLN1 ANLH Main asset number BUKRS
0 ANLZ ANLN1 ANLH Main asset number ANLN1
1 ANLZ ANLN2 ANLA Asset Master Record Segment BUKRS
1 ANLZ ANLN2 ANLA Asset Master Record Segment ANLN1
1 ANLZ ANLN2 ANLA Asset Master Record Segment ANLN2
0 ANLZ CAUFN AUFK Order master data AUFNR
1 ANLZ GSBER TGSB Business Areas MANDT
1 ANLZ GSBER TGSB Business Areas GSBER
0 ANLZ IAUFN AUFK Order master data AUFNR
1 ANLZ IPSNR PRPS WBS (Work Breakdown Structure) Element Master Data MANDT
1 ANLZ IPSNR PRPS WBS (Work Breakdown Structure) Element Master Data PSPNR
0 ANLZ SEGMENT FAGL_SEGM Master Data for Segments SEGMENT
1 ANLZ STORT T499S Location MANDT
1 ANLZ STORT T499S Location WERKS
0 ANLZ TXJCD TTXJ Check Table for Tax Jurisdiction MANDT
0 ANLZ TXJCD TTXJ Check Table for Tax Jurisdiction KALSM
1 ANLZ WERKS T001W Plants/Branches MANDT
1 ANLZ WERKS T001W Plants/Branches WERKS