ANLZ SAP (Time-Dependent Asset Allocations) Table details
Dictionary Type: Table
Description: Time-Dependent Asset Allocations
Description: Time-Dependent Asset Allocations
Table field list including key, data, relationships and ABAP select examples
ANLZ is a standard SAP Table which is used to store Time-Dependent Asset Allocations data and is available within R/3 SAP systems depending on the version and release level.
The ANLZ table consists of various fields, each holding specific information or linking keys about Time-Dependent Asset Allocations data available in SAP. These include BUKRS (Company Code), ANLN1 (Main Asset Number), ANLN2 (Asset Subnumber), BDATU (Date validity ends).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP ANLZ table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
ANLN1 | Main Asset Number | ANLN1 | CHAR | 12 | ANLH | ALPHA | ANLN1 | AN1 | |
ANLN2 | Asset Subnumber | ANLN2 | CHAR | 4 | ANLA | ALPHA | ANLN2 | AN2 | |
BDATU | Date validity ends | BDATU | DATS | 8 | DATUM | ||||
ADATU | Date for beginning of validity | ADATU | DATS | 8 | DATUM | ADT | |||
KOSTL | Cost Center | KOSTL | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | KOS | |
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
GSBER | Business Area | GSBER | CHAR | 4 | TGSB | GSBER | GSB | ||
LSTAR | Activity Type | LSTAR | CHAR | 6 | Assigned to domain | LSTAR | LAR | LART_EMPTY | |
MSFAK | Multiple-shift factor for multiple shift operation | MSFAK | DEC | 3(2) | MSFAK | ||||
XSTIL | Asset shutdown | XSTIL | CHAR | 1 | XFELD | ||||
STORT | Asset location | STORT | CHAR | 10 | T499S | AP_STAND | |||
CAUFN | Internal order | CAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
PLAN1 | no longer used | PLAN1 | CHAR | 12 | CHAR12 | ||||
PLAN2 | No longer used | PLAN2 | CHAR | 4 | CHAR4 | ||||
RAUMN | Room | RAUMNR | CHAR | 8 | CHAR8 | ||||
IAUFN | Maintenance order | IAUFN | CHAR | 12 | AUFK | ALPHA | AUFNR | ||
IPROJ | Old: Project number : No longer used --> PS_POSNR | PROJN | CHAR | 16 | PROJN | ||||
TPLKZ | Unused field length 3 | FILL03 | CHAR | 3 | CHAR03 | ||||
TPLNR | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
ANUPD | Indicator: Type of change to table | ANUPD | CHAR | 1 | ANUPD | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
IPSNR | WBS element - maintenance project | AM_IPSNR | NUMC | 8 | PRPS | ABPSP | PS_POSNR | ||
KFZKZ | License plate no. of vehichle | AM_KFZKZ | CHAR | 15 | AM_KFZKZ | ||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | PERNR | PER | |||
KOSTLV | Cost center responsible for asset | KOSTLV | CHAR | 10 | Assigned to domain | ALPHA | KOSTL | ||
FISTL | Funds Center | FISTL | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
GEBER | Fund | BP_GEBER | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FKBER | Functional Area | FKBER | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
GRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | ALPHA | GM_GRANT_NBR | GM_GRANT_NBR | GRANTS_GENERIC | |
GEBER2 | Fund for APC Account Assignments | BP_GEBER2 | CHAR | 10 | Assigned to domain | BP_GEBER | FIC | ||
FKBER2 | Functional Area for APC Account Assignments | FKBER2 | CHAR | 16 | Assigned to domain | FKBER | FBE | ||
GRANT_NBR2 | Grant for APC Account Assignments | GM_GRANT_NBR2 | CHAR | 20 | ALPHA | GM_GRANT_NBR | |||
FISTL2 | Funds Center for APC Account Assignments | FISTL2 | CHAR | 16 | Assigned to domain | FISTL | FIS | ||
IMKEY | Internal Key for Real Estate Object | IMKEY | CHAR | 8 | IMKEY | ||||
PS_PSP_PNR2 | WBS Element (Costs) | PS_PSP_PNR2 | NUMC | 8 | Assigned to domain | ABPSP | PS_POSNR | ||
BUDGET_PD | FM: Budget Period | FM_BUDGET_PERIOD | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
BUDGET_PD2 | Budget Period for APC Account Assignments | FM_BUDGET_PERIOD2 | CHAR | 10 | Assigned to domain | FM_BUDGET_PERIOD | BUDPER | ||
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | CHAR | 10 | FAGL_SEGM | ALPHA | FB_SEGMENT | ||
PRCTR | Profit Center | PRCTR | CHAR | 10 | Assigned to domain | ALPHA | PRCTR | PRC | PRCTR_EMPTY |
Key field | Non-key field |
How do I retrieve data from SAP table ANLZ using ABAP code
The following ABAP code Example will allow you to do a basic selection on ANLZ to SELECT all data from the tableDATA: WA_ANLZ TYPE ANLZ.
SELECT SINGLE *
FROM ANLZ
INTO CORRESPONDING FIELDS OF WA_ANLZ
WHERE...
How to access SAP table ANLZ
Within an ECC or HANA version of SAP you can also view further information about ANLZ and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects