SAP AD01DLI Dynamic items (DI) Table data and field list

AD01DLI is a standard SAP Table which is used to store Dynamic items (DI) data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The AD01DLI table consists of various fields, each holding specific information or linking keys about Dynamic items (DI) data available in SAP. These include DLINR (Number of the Dynamic Item), OBJNR (Object number), POPER (Posting period), TWAER (Transaction Currency)... 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. .

AD01DLI table Technical Details:

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 AD01DLI table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the AD01DLI table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
DLINRNumber of the Dynamic Item AD01DLINRNUMC20AD01DLINR
OBJNRObject number J_OBJNRCHAR22ONR00J_OBJNRONR
POPERPosting period AD01PERIODNUMC7PERI7JAHRPER
TWAERTransaction Currency TWAERCUKY5TCURCWAERSFWS
MEINHUnit of Measure CO_MEINHUNIT3T006CUNITMEINS
MANUALCheckbox XFELDCHAR1XFELD
KSTARCost Element KSTARCHAR10CSKAALPHAKSTARKAT
KOSTLCost Center KOSTLCHAR10CSKSALPHAKOSTLKOS
LSTARActivity Type LSTARCHAR6CSLALSTARLARLART_EMPTY
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
STAGRStatistical key figure STAGRCHAR6TKA03STAGRSTA
FIPOSCommitment Item FIPOSCHAR14FMFPOFIPOSFIP
WRTTPValue Type CO_WRTTPCHAR2CO_WRTTP
VERSNVersion VERSNCHAR3TKVSALPHACOVERSIKVS
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
PRODUProduct number PRODNCHAR18MARAMATN1MATNR
FAKTFBilling form FAKTFCHAR2FAKTF
BEMOTAccounting Indicator BEMOTCHAR2TBMOTBEMOT
BELNRDocument Number CO_BELNRCHAR10Assigned to domainALPHACO_BELNRBLN
BUZEIPosting row CO_BUZEINUMC3BUZEI
ARBPLWork center ARBPLCHAR8ARBPLAGR
AWERKPlant of Work Center AD01AWERKCHAR4T001WWERKSH_T001W
PRZNRBusiness Process CO_PRZNRCHAR12CBPRALPHACO_PRZNRKWP
ASNUMActivity Number ASNUMCHAR18ASMDALPHAASNUMASN
PERNRPersonnel Number HR_PERNRNUMC8PERNRPER
Z_OBJNR2 0Assigned to domain
Z_PRS_OFFSHORE 0
Z_PRS_BILL_FLAG 0
Z_PRS_COUNTRYCountry Key LAND1CHAR3Assigned to domainLAND1LND
Z_PRS_CHARGELEVL 0
.INCLU--AP 0
/CBAD/ORIG_OBJNRCBAD Original Object Number /CBAD/ORIG_OBJNRCHAR22Assigned to domainJ_OBJNR
/CBAD/BILL_WBSCBAD WBS Element /CBAD/PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
.INCLU--AP 0
PRS_WORK_PERIODWork Period (Internal Representation) PRS_WORK_PERIODNUMC7PRSWPPRS_WORK_PERIOD
.INCLU--AP 0
GSBERBusiness Area GSBERCHAR4Assigned to domainGSBERGSB
PARGBTrading partner's business area PARGBCHAR4Assigned to domainGSBERGSB
PRCTRProfit Center PRCTRCHAR10Assigned to domainALPHAPRCTRPRCPRCTR_EMPTY
PPRCTRPartner Profit Center PPRCTRCHAR10Assigned to domainALPHAPRCTRPPC
.INCLU--AP 0
WTY_INDWarranty indicator WTYSC_WTY_INDICATORCHAR1WTYSC_WTY_INDICATOR
ORDERED_PRODProduct Name Entered CRMT_ORDERED_PROD_DBCHAR54CRM_ORDERED_PROD
CATEGORY_IDCategory ID COMT_CATEGORY_IDCHAR20COM_CATEGORY_IDCOM_CATEGORY_IDCOM_CAT_HIER
AWSYSLogical system of source document AWSYSCHAR10Assigned to domainALPHALOGSYS
SERV_AGENT_IDBusiness Partner Number BU_PARTNERCHAR10Assigned to domainALPHABU_PARTNERBPABUPA
REF_OBJECT_IDTransaction Number CRMT_OBJECT_ID_DBCHAR10ALPHACRM_OBJECT_ID
REF_OBJECT_ITEMItem Number in Document CRMT_ITEM_NONUMC10CRM_ITEM_NO
.INCLU--AP 0
CPD_DLIIDBilling ID for Commercial Project Management /CPD/PWS_BILLING_DLIIDNUMC10/CPD/PWS_BILLING_DLIID
.INCLU--AP 0
ORIG_OBJNRObject Number of Original Object DPICB_OBJNRCHAR22Assigned to domainJ_OBJNR
.INCLU--AP 0
FAREAFunctional Area FM_FAREACHAR16Assigned to domainFKBERFBE
RGRANT_NBRGrant GM_GRANT_NBRCHAR20ALPHAGM_GRANT_NBRGM_GRANT_NBRGRANTS_GENERIC
WBS_ELEMENTWBS Element PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
ORDERIDOrder Number AUFNRCHAR12Assigned to domainALPHAAUFNRANR
FUNDS_CTRFunds Center FISTLCHAR16Assigned to domainFISTLFIS
FUNDFund BP_GEBERCHAR10Assigned to domainBP_GEBERFIC
SPONSORED_PROGSponsored Program GM_SPONSORED_PROGCHAR20Assigned to domainGM_SPONSORED_PROGGM_SPONSORED_PROG
SPONSORED_CLASSSponsored Class GM_SPONSORED_CLASSCHAR20Assigned to domainGM_SPONSORED_CLASSGM_SPONSORED_CLASS
GL_SIRIDRecord number of the line item record GU_RECIDCHAR18OBJNROBN
REFDOCNRReference document number of an accounting document REFBELNRCHAR10ALPHABELNRBLN
REFDOCLNSix-digit number of the reference posting line REFBUZEI6NUMC6BUZEI6BUZ
SGTXTItem Text SGTXTCHAR50TEXT50
GM_VALUETYPEGM Value Type GM_VALUETYPECHAR2GM_VALUETYPEGMVALUETYPE
ASSETMAINOMain Asset Number BF_ANLN1CHAR12ALPHABF_ANLN1AN1
ASSETSUBNOAsset Subnumber BF_ANLN2CHAR4ALPHABF_ANLN2AN2
BUDGET_PDFM: Budget Period FM_BUDGET_PERIODCHAR10Assigned to domainFM_BUDGET_PERIODBUDPER
DLISRCDynamic Item Source AD01DLISRCCHAR4AD01SRCAD01DLISRC
PROFNRDynamic Item Processor Profile AD01PROFNRCHAR8AD01C_PROFAD01PROFNRAD0DIP_PROFILE
TIMESTMPTime created (Greenwich Meantime) RKE_HZSTMPDEC16RKE_TSTMP

Key field Non-key field



How do I retrieve data from SAP table AD01DLI using ABAP code

The following ABAP code Example will allow you to do a basic selection on AD01DLI to SELECT all data from the table
DATA: WA_AD01DLI TYPE AD01DLI.

SELECT SINGLE *
FROM AD01DLI
INTO CORRESPONDING FIELDS OF WA_AD01DLI
WHERE...

How to access SAP table AD01DLI

Within an ECC or HANA version of SAP you can also view further information about AD01DLI and the data within it using relevant transactions such as

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