ANLZ SAP (Time-Dependent Asset Allocations) Table details

Dictionary Type: Table
Description: Time-Dependent Asset Allocations




ABAP Code to SELECT data from ANLZ
Related tables to ANLZ
Access table ANLZ




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
MANDTClient MANDTCLNT3Assigned to domainMANDT
BUKRSCompany Code BUKRSCHAR4T001BUKRSBUKC_T001
ANLN1Main Asset Number ANLN1CHAR12ANLHALPHAANLN1AN1
ANLN2Asset Subnumber ANLN2CHAR4ANLAALPHAANLN2AN2
BDATUDate validity ends BDATUDATS8DATUM
ADATUDate for beginning of validity ADATUDATS8DATUMADT
KOSTLCost Center KOSTLCHAR10Assigned to domainALPHAKOSTLKOS
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
GSBERBusiness Area GSBERCHAR4TGSBGSBERGSB
LSTARActivity Type LSTARCHAR6Assigned to domainLSTARLARLART_EMPTY
MSFAKMultiple-shift factor for multiple shift operation MSFAKDEC3(2) MSFAK
XSTILAsset shutdown XSTILCHAR1XFELD
STORTAsset location STORTCHAR10T499SAP_STAND
CAUFNInternal order CAUFNCHAR12AUFKALPHAAUFNR
PLAN1no longer used PLAN1CHAR12CHAR12
PLAN2No longer used PLAN2CHAR4CHAR4
RAUMNRoom RAUMNRCHAR8CHAR8
IAUFNMaintenance order IAUFNCHAR12AUFKALPHAAUFNR
IPROJOld: Project number : No longer used --> PS_POSNR PROJNCHAR16PROJN
TPLKZUnused field length 3 FILL03CHAR3CHAR03
TPLNRFunctional Location TPLNRCHAR30Assigned to domainTPLNRTPLNRIFLIFLM
ANUPDIndicator: Type of change to table ANUPDCHAR1ANUPD
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
IPSNRWBS element - maintenance project AM_IPSNRNUMC8PRPSABPSPPS_POSNR
KFZKZLicense plate no. of vehichle AM_KFZKZCHAR15AM_KFZKZ
PERNRPersonnel Number PERNR_DNUMC8PERNRPER
KOSTLVCost center responsible for asset KOSTLVCHAR10Assigned to domainALPHAKOSTL
FISTLFunds Center FISTLCHAR16Assigned to domainFISTLFIS
GEBERFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
FKBERFunctional Area FKBERCHAR16Assigned to domainFKBERFBE
GRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
GEBER2Fund for APC Account Assignments BP_GEBER2CHAR10Assigned to domainBP_GEBERFIC
FKBER2Functional Area for APC Account Assignments FKBER2CHAR16Assigned to domainFKBERFBE
GRANT_NBR2Grant for APC Account Assignments GM_GRANT_NBR2CHAR20ALPHAGM_GRANT_NBR
FISTL2Funds Center for APC Account Assignments FISTL2CHAR16Assigned to domainFISTLFIS
IMKEYInternal Key for Real Estate Object IMKEYCHAR8IMKEY
PS_PSP_PNR2WBS Element (Costs) PS_PSP_PNR2NUMC8Assigned to domainABPSPPS_POSNR
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
BUDGET_PD2Budget Period for APC Account Assignments FM_BUDGET_PERIOD2CHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
SEGMENTSegment for Segmental Reporting FB_SEGMENTCHAR10FAGL_SEGMALPHAFB_SEGMENT
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!