AD01DLI is a standard SAP table in SAP ECC (or) S/4HANA which stores Dynamic items (DI) data. There are total 70 fields in AD01DLI table.This blog post provides key technical details of SAP table AD01DLI, including its availability across SAP S/4HANA versions and the list of CDS views for AD01DLI table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering switched on |
| Buffering Type | Single entries of table were buffered |
| Package | DI Processor (Resource-Related Billing/Sales Pricing) (AD01) |
| Technical Component | Revenues and Earnings (PS-REV) |
SAP AD01DLI Table Fields
The following is the list of fields that are available in SAP AD01DLI table. The key fields of the table are highlighted in color.
| Field | Description | Data Element | Domain | Check Table | Data Type |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | MANDT | T000 | CLNT (3) |
| DLINR | Number of the Dynamic Item | AD01DLINR | AD01DLINR | NUMC (20) | |
| OBJNR | Object number | J_OBJNR | J_OBJNR | ONR00 | CHAR (22) |
| POPER | Posting period | AD01PERIOD | JAHRPER | NUMC (7) | |
| TWAER | Transaction Currency | TWAER | WAERS | TCURC | CUKY (5) |
| MEINH | Unit of Measure | CO_MEINH | MEINS | T006 | UNIT (3) |
| MANUAL | Checkbox | XFELD | XFELD | CHAR (1) | |
| KSTAR | Cost Element | KSTAR | KSTAR | CSKA | CHAR (10) |
| KOSTL | Cost Center | KOSTL | KOSTL | CSKS | CHAR (10) |
| LSTAR | Activity Type | LSTAR | LSTAR | CSLA | CHAR (6) |
| MATNR | Material Number | MATNR | MATNR | MARA | CHAR (40) |
| STAGR | Statistical key figure | STAGR | STAGR | TKA03 | CHAR (6) |
| FIPOS | Commitment Item | FIPOS | FIPOS | FMFPO | CHAR (14) |
| WRTTP | Value Type | CO_WRTTP | CO_WRTTP | CHAR (2) | |
| VERSN | Version | VERSN | COVERSI | TKVS | CHAR (3) |
| WERKS | Plant | WERKS_D | WERKS | T001W | CHAR (4) |
| PRODU | Product number | PRODN | MATNR | MARA | CHAR (40) |
| FAKTF | Billing form | FAKTF | FAKTF | CHAR (2) | |
| BEMOT | Accounting Indicator | BEMOT | BEMOT | TBMOT | CHAR (2) |
| BELNR | Document Number | CO_BELNR | CO_BELNR | * | CHAR (10) |
| BUZEI | Posting Row | CO_BUZEI | BUZEI | NUMC (3) | |
| DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | DOCLN6 | CHAR (6) | |
| ARBPL | Work center | ARBPL | ARBPL | CHAR (8) | |
| AWERK | Plant of Work Center | AD01AWERK | WERKS | T001W | CHAR (4) |
| PRZNR | Business Process | CO_PRZNR | CO_PRZNR | CBPR | CHAR (12) |
| ASNUM | Activity Number | ASNUM | ASNUM | ASMD | CHAR (18) |
| PERNR | Personnel Number | HR_PERNR | PERNR | NUMC (8) | |
| RSRCE | Resource | CO_RESSOURCE | CO_RESSOURCE | * | CHAR (10) |
| PRS_WORK_PERIOD | Work Period (Internal Representation) | PRS_WORK_PERIOD | PRS_WORK_PERIOD | NUMC (7) | |
| GSBER | Business Area | GSBER | GSBER | * | CHAR (4) |
| PARGB | Trading partner’s business area | PARGB | GSBER | * | CHAR (4) |
| PRCTR | Profit Center | PRCTR | PRCTR | CHAR (10) | |
| PPRCTR | Partner Profit Center | PPRCTR | PRCTR | * | CHAR (10) |
| WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | WTYSC_WTY_INDICATOR | CHAR (1) | |
| ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD_DB | CRM_ORDERED_PROD | CHAR (54) | |
| CATEGORY_ID | Category ID | COMT_CATEGORY_ID | COM_CATEGORY_ID | CHAR (20) | |
| AWSYS | Logical system of source document | AWSYS | LOGSYS | * | CHAR (10) |
| SERV_AGENT_ID | Business Partner Number | BU_PARTNER | BU_PARTNER | CHAR (10) | |
| REF_OBJECT_ID | Transaction ID | CRMT_OBJECT_ID_DB | CRM_OBJECT_ID | CHAR (10) | |
| REF_OBJECT_ITEM | Item Number in Document | CRMT_ITEM_NO | CRM_ITEM_NO | NUMC (10) | |
| CPD_DLIID | Billing ID for Commercial Project Management | /CPD/PWS_BILLING_DLIID | /CPD/PWS_BILLING_DLIID | NUMC (10) | |
| ORIG_OBJNR | Object Number of Original Object | DPICB_OBJNR | J_OBJNR | * | CHAR (22) |
| FPLNR | Billing plan number / invoicing plan number | FPLNR | FPLNR | * | CHAR (10) |
| FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | FPLTR | * | NUMC (6) |
| BPCAT | Billing Plan Usage Category | SDBP_BPCAT | SDBP_BPCAT | CHAR (2) | |
| BILLINGPLANITEMUSAGE | Billing Plan Item Usage | SDBP_ITEM_USAGE | SDBP_ITEM_USAGE | CHAR (2) | |
| WBS_BILLING_ELEMENTS | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PS_POSNR | * | NUMC (8) |
| WORK_ITEM_ID | Work Item ID | /CPD/PFP_WORKITEM_ID | /CPD/PFP_WORKITEM_ID | CHAR (10) | |
| SERV_ORG | Service Organization | /CPD/PWS_WS_ORG_UNIT_ID | /CPD/PWS_WS_ORG_UNIT_ID | CHAR (5) | |
| OVERTIMECAT | Overtime Category | CATS_OVERTIME_CATEGORY | CATS_OVERTIME_CATEGORY | * | CHAR (4) |
| FAREA | Functional Area | FM_FAREA | FKBER | * | CHAR (16) |
| RGRANT_NBR | Grant | GM_GRANT_NBR | GM_GRANT_NBR | CHAR (20) | |
| WBS_ELEMENT | WBS Element | PS_POSNR | PS_POSNR | * | NUMC (8) |
| ORDERID | Order Number | AUFNR | AUFNR | * | CHAR (12) |
| FUNDS_CTR | Funds Center | FISTL | FISTL | * | CHAR (16) |
| FUND | Fund | BP_GEBER | BP_GEBER | * | CHAR (10) |
| SPONSORED_PROG | Sponsored Program | GM_SPONSORED_PROG | GM_SPONSORED_PROG | * | CHAR (20) |
| SPONSORED_CLASS | Sponsored Class | GM_SPONSORED_CLASS | GM_SPONSORED_CLASS | * | CHAR (20) |
| GL_SIRID | Record number of the line item record | GU_RECID | OBJNR | CHAR (18) | |
| REFDOCNR | Reference document number of an accounting document | REFBELNR | BELNR | CHAR (10) | |
| REFDOCLN | Six-Digit Number of the Reference Posting Line | REFBUZEI6 | BUZEI6 | NUMC (6) | |
| SGTXT | Item Text | SGTXT | TEXT50 | CHAR (50) | |
| GM_VALUETYPE | GM Value Type | GM_VALUETYPE | GM_VALUETYPE | CHAR (2) | |
| ASSETMAINO | Main Asset Number | BF_ANLN1 | BF_ANLN1 | CHAR (12) | |
| ASSETSUBNO | Asset Subnumber | BF_ANLN2 | BF_ANLN2 | CHAR (4) | |
| BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | FM_BUDGET_PERIOD | * | CHAR (10) |
| DLISRC | Dynamic Item Source | AD01DLISRC | AD01DLISRC | AD01SRC | CHAR (4) |
| PROFNR | Dynamic Item Processor Profile | AD01PROFNR | AD01PROFNR | AD01C_PROF | CHAR (8) |
| TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | RKE_TSTMP | DEC (16) | |
| SOITEXT | Item Text | SGTXT | TEXT50 | CHAR (50) |
Availability
The SAP table AD01DLI is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.
| SAP S/4HANA Version | Available? |
|---|---|
| 1909 | Yes |
| 2020 | Yes |
| 2021 | Yes |
| 2022 | Yes |
| 2023 | Yes |
CDS Views for AD01DLI table
The following is the list of AD01DLI CDS views, which can also be used instead of AD01DLI table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_BPBAPSTATUS | BASIC | BP BAP Status |
| I_BPFPSTATUS | BASIC | Bp Fp Status |
| I_BPRRBSTATUS | BASIC | Status of Resource Related Billing |
| I_COMBAPOPENBILLINGPLAN | BASIC | Billing as Planned Open Billing Plan |
| I_COMFPOPENBILLINGPLAN | BASIC | FP Open Billing Plan |
| I_RRBCOSTDYNAMICITEM | BASIC | Cost Data for Dynamic Items |
| I_RRBDYNAMICITEM | BASIC | RRB Dynamic Items |
| I_RRBDYNAMICITEMFLOW | BASIC | Dynamic Item Flow |
| I_RRBDYNAMICITEMTOTALFLOW | BASIC | Total Flow of Dynamic Item |
| I_WORKINPROCESSDETAIL | BASIC | Detail WIP from DIP data |
| P_BPAD01DLI | BASIC | Unique Dynamic items |
| P_BPBAPDATA | BASIC | BillAsPlanned Billing Plan Data |
| P_BPBAPSTATUS | BASIC | BillAsPlanned Billing Plan Data |
| P_BPFPDATA | BASIC | Fixed Plan Billing Plan Data |
| P_BPFPDYNITEM | BASIC | Dynamic Item for Billing Plan |
| P_BPFPSTATUS | BASIC | Fixed Plan Billing Plan Status |
| P_BPRRBDATA | BASIC | Resource Related Billing Data |
| P_BPRRBDYNITEM | BASIC | Dynamic Item for RRB |
| P_BPRRBSTATUS | BASIC | RRB Billing Status |
| P_COMBAPOPENBILLINGPLAN | BASIC | BAP Open Billing Plan |
| P_COMFPOPENBILLINGPLAN | BASIC | Fixed Plan Open Billing Plan |
| P_PROJECTWIPREVDETLBASIC | BASIC | Project WIP with revenue from DIP |
| P_WIPDETAILBASIC | BASIC | Detail WIP from DIP data |
| P_WIPDETAILBASIC1 | BASIC | Detail WIP from DIP data |
| P_WIPREVDETAILBASIC | BASIC | WIP revenue details from DIP data |
| I_ALERTOVERDUEBILLINGEVENTS | COMPOSITE | Overdue Billing Events |
| I_ALERTWORKINPROGRESS | COMPOSITE | Master Project Alert for High Risk |
| I_BILLINGPLANDATA | COMPOSITE | Basic View for CPM Billing Plan Data |
| I_BPALLDATA | COMPOSITE | All Billing Plan Data |
| I_BPCPMDATA | COMPOSITE | CPM Billing Plan Data |
| I_BPMASTERPROJECT | COMPOSITE | Master Project Billing Plans |
| I_DUEDAYSBILLPLAN | COMPOSITE | Billing Plan Due Days |
| I_ENGMNTPROJBILLGANDRBLSCUBE | COMPOSITE | Billg and Rbls of Engmnt Project – Cube |
| I_HIERCOSTERP | COMPOSITE | Hierarchical Cost status: ERP scenario |
| I_HIERCOSTSTATUSACTUAL | COMPOSITE | Fetch Actuals for Hierarchical Cost stauts report |
| I_MASTERPROJECTACTUALSKPI | COMPOSITE | Get Actuals KPI for master project |
| I_MASTERPROJECTBILLINGPLANCUBE | COMPOSITE | Master Project Billing Plan Cube |
| I_MAXDUEBILLPLAN | COMPOSITE | Maximum Due for Bill Plan |
| I_MPUNBILLEDREVENU | COMPOSITE | Master Project Unbilled Revenu |
| I_MSTRPROJACTLCALMNTHCOSTQTY | COMPOSITE | Commercial Proj Actual Cost Qty by Month |
| I_MSTRPROJACTLCOSTQTY | COMPOSITE | Commercial Project Actual Input Cost Qty |
| I_MSTRPROJBILLGDUEDTE | COMPOSITE | Get billing due date for a project |
| I_MSTRPROJCOSTQTY | COMPOSITE | Commercial Project Actual Cost and Qty |
| I_MSTRPROJCOSTQTYWTHTOTCOST | COMPOSITE | Commercial Project Actual Cost Status |
| I_MSTRPROJKPIERP | COMPOSITE | KPI for ERP scenario |
| I_MSTRPROJWORKINPROGRESS | COMPOSITE | Master Project Work in Progress |
| I_PROJECTWIPDETAIL | COMPOSITE | WIP Detail view for projects |
| P_BPCPMDATA | COMPOSITE | CPM Billing Plan Data |
| P_ENGMNTPROJBILLGANDRBLS | COMPOSITE | Billing Receivables – UNION of Sales, Billing, Acc Doc |
| P_ENGMNTPROJBILLGANDRBLSANLYS | COMPOSITE | Billing Receivables – Analysis View w/ Time Intervals |
| P_ERPACTUALWIP | COMPOSITE | ERP acenario Actuals and WIP |
| P_MASTERPROJECTACTUALS | COMPOSITE | Union of total actuals and actuals till month |
| P_MPBILLPLAN | COMPOSITE | Master Project Billing Plan |
| P_MSTRPROJACTLCOSTQTY | COMPOSITE | Actuals for Master Project |
| P_MSTRPROJACTUALWIP | COMPOSITE | Master Project Actuals with WIP |
| P_MSTRPROJACTUALWIPCOST | COMPOSITE | Actual cost with work in progress |
| P_MSTRPROJKPIERP | COMPOSITE | Plan and actual cost: ERP scenario |
| P_MSTRPROJPLANACTUAL | COMPOSITE | Master Project Plan Actual |
| P_MSTRPROJPLANCOST | COMPOSITE | Plan Cost |
| P_MSTRPROJWIP | COMPOSITE | Master Project WIP |
| P_MSTRPROJWIPCNTROBJ | COMPOSITE | WIP at Controlling object |
| P_MSTRPROJWIPINPROJCRCY | COMPOSITE | Master Proj WIP in Project Currency |
| P_MSTRPROJWSBILLINGDUEDATE | COMPOSITE | Get PWS billing due date for a project |
| P_OPENBILLINGPLAN | COMPOSITE | All Open Billing Plan |
| P_PROJECTWIPDETAILBASIC | COMPOSITE | WIP Detail for WBS elements |
| C_ENGMNTPROJBILLGANDRBLSQRY | CONSUMPTION | Engagement Project Billing And Receivables Query |
| C_MASTERPROJECTBILLINGPLAN | CONSUMPTION | Master Project Billing Plans |
| C_MSTRPROJACTLCALMNTHCOSTQTY | CONSUMPTION | Commercial Proj Actual Cost Qty by Month |
| C_MSTRPROJKEYDATES | CONSUMPTION | Get Master Project Key Dates |
| C_PROJECTWIPDETAIL | CONSUMPTION | WIP Detail View for projects |
| C_RRBDYNAMICITEMFLOW | CONSUMPTION | Dynamic Item Flow With Characteristics |
| C_RRBSALESPRICINGDYNAMICITEM | CONSUMPTION | Resource Related Billing Dynamic Items |
| C_RRBWRITTENOFFDYNAMICITEM | CONSUMPTION | Written Off Dynamic Item |
| P_PROJECTWIPDETAIL1 | CONSUMPTION | WIP Detail view for projects |
| P_RRBDYNAMICITEMFLOW00 | CONSUMPTION | Dynamic Item Flow With Characteristics Helper View 1 |
| P_RRBDYNAMICITEMFLOW01 | CONSUMPTION | Dynamic Item Flow With Characteristics Helper View 1 |
| P_RRBDYNAMICITEMFLOW02 | CONSUMPTION | Dynamic Item Flow With Characteristics Helper View 2 |
| P_RRBSALESPRICINGDYNAMICITEM | CONSUMPTION | CDS private View for Resource Related Billing Dynamic Items |
| P_RRBSALESPRICINGDYNAMICITEM01 | CONSUMPTION | CDS version view for journal entry item |
| P_RRBWRITTENOFFDYNAMICITEM | CONSUMPTION | CDS private view for Written Off Dynamic Items |
| P_RRBWRITTENOFFDYNAMICITEM01 | CONSUMPTION | CDS written off view for journal entry item |
