SAP AD01DLI Dynamic items (DI) Table
Overview
AD01DLI is a standard SAP S/4HANA table that stores Dynamic items (DI) data. There are total 70 fields in the AD01DLI table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AD01DLI belongs to Revenues and Earnings (PS-REV) module and is located in the package DI Processor (Resource-Related Billing/Sales Pricing) (AD01).
In addition, following links provide an overview of foreign key relationships, if any, that link AD01DLI to other SAP tables and standard CDS views available based on AD01DLI table in S/4HANA 2020.
Techincal Settings of AD01DLI
Below are technical details of the table AD01DLI
- Buffering switched on
- Single entries of table were buffered
- Storage type is Column Store
List of AD01DLI Fields
The following table gives you an overview of the fields available in AD01DLI
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| DLINR | Number of the Dynamic Item | AD01DLINR | NUMC | 20 | |
| OBJNR | Object number | J_OBJNR | ONR00 | CHAR | 22 |
| POPER | Posting period | AD01PERIOD | NUMC | 7 | |
| TWAER | Transaction Currency | TWAER | TCURC | CUKY | 5 |
| MEINH | Unit of Measure | CO_MEINH | T006 | UNIT | 3 |
| MANUAL | Checkbox | XFELD | CHAR | 1 | |
| KSTAR | Cost Element | KSTAR | CSKA | CHAR | 10 |
| KOSTL | Cost Center | KOSTL | CSKS | CHAR | 10 |
| LSTAR | Activity Type | LSTAR | CSLA | CHAR | 6 |
| MATNR | Material Number | MATNR | MARA | CHAR | 40 |
| STAGR | Statistical key figure | STAGR | TKA03 | CHAR | 6 |
| FIPOS | Commitment Item | FIPOS | FMFPO | CHAR | 14 |
| WRTTP | Value Type | CO_WRTTP | CHAR | 2 | |
| VERSN | Version | VERSN | TKVS | CHAR | 3 |
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 |
| PRODU | Product number | PRODN | MARA | CHAR | 40 |
| FAKTF | Billing form | FAKTF | CHAR | 2 | |
| BEMOT | Accounting Indicator | BEMOT | TBMOT | CHAR | 2 |
| BELNR | Document Number | CO_BELNR | * | CHAR | 10 |
| BUZEI | Posting Row | CO_BUZEI | NUMC | 3 | |
| DOCLN | Six-Character Posting Item for Ledger | DOCLN6 | CHAR | 6 | |
| ARBPL | Work center | ARBPL | CHAR | 8 | |
| AWERK | Plant of Work Center | AD01AWERK | T001W | CHAR | 4 |
| PRZNR | Business Process | CO_PRZNR | CBPR | CHAR | 12 |
| ASNUM | Activity Number | ASNUM | ASMD | CHAR | 18 |
| PERNR | Personnel Number | HR_PERNR | NUMC | 8 | |
| RSRCE | Resource | CO_RESSOURCE | * | CHAR | 10 |
| PRS_WORK_PERIOD | Work Period (Internal Representation) | PRS_WORK_PERIOD | NUMC | 7 | |
| GSBER | Business Area | GSBER | * | CHAR | 4 |
| PARGB | Trading partner's business area | PARGB | * | CHAR | 4 |
| PRCTR | Profit Center | PRCTR | CHAR | 10 | |
| PPRCTR | Partner Profit Center | PPRCTR | * | CHAR | 10 |
| WTY_IND | Warranty indicator | WTYSC_WTY_INDICATOR | CHAR | 1 | |
| ORDERED_PROD | Product Name Entered | CRMT_ORDERED_PROD_DB | CHAR | 54 | |
| CATEGORY_ID | Category ID | COMT_CATEGORY_ID | CHAR | 20 | |
| AWSYS | Logical system of source document | AWSYS | * | CHAR | 10 |
| SERV_AGENT_ID | Business Partner Number | BU_PARTNER | CHAR | 10 | |
| REF_OBJECT_ID | Transaction ID | CRMT_OBJECT_ID_DB | CHAR | 10 | |
| REF_OBJECT_ITEM | Item Number in Document | CRMT_ITEM_NO | NUMC | 10 | |
| CPD_DLIID | Billing ID for Commercial Project Management | /CPD/PWS_BILLING_DLIID | NUMC | 10 | |
| ORIG_OBJNR | Object Number of Original Object | DPICB_OBJNR | * | CHAR | 22 |
| FPLNR | Billing plan number / invoicing plan number | FPLNR | * | CHAR | 10 |
| FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | * | NUMC | 6 |
| BPCAT | Billing Plan Usage Category | SDBP_BPCAT | CHAR | 2 | |
| BILLINGPLANITEMUSAGE | Billing Plan Item Usage | SDBP_ITEM_USAGE | CHAR | 2 | |
| WBS_BILLING_ELEMENTS | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | * | NUMC | 8 |
| WORK_ITEM_ID | Work Item ID | /CPD/PFP_WORKITEM_ID | CHAR | 10 | |
| SERV_ORG | Service Organization | /CPD/PWS_WS_ORG_UNIT_ID | CHAR | 5 | |
| OVERTIMECAT | Overtime Category | CATS_OVERTIME_CATEGORY | * | CHAR | 4 |
| FAREA | Functional Area | FM_FAREA | * | CHAR | 16 |
| RGRANT_NBR | Grant | GM_GRANT_NBR | CHAR | 20 | |
| WBS_ELEMENT | WBS Element | PS_POSNR | * | NUMC | 8 |
| ORDERID | Order Number | AUFNR | * | CHAR | 12 |
| FUNDS_CTR | Funds Center | FISTL | * | CHAR | 16 |
| FUND | Fund | BP_GEBER | * | CHAR | 10 |
| SPONSORED_PROG | Sponsored Program | GM_SPONSORED_PROG | * | CHAR | 20 |
| SPONSORED_CLASS | Sponsored Class | GM_SPONSORED_CLASS | * | CHAR | 20 |
| GL_SIRID | Record number of the line item record | GU_RECID | CHAR | 18 | |
| REFDOCNR | Reference document number of an accounting document | REFBELNR | CHAR | 10 | |
| REFDOCLN | Six-Digit Number of the Reference Posting Line | REFBUZEI6 | NUMC | 6 | |
| SGTXT | Item Text | SGTXT | CHAR | 50 | |
| GM_VALUETYPE | GM Value Type | GM_VALUETYPE | CHAR | 2 | |
| ASSETMAINO | Main Asset Number | BF_ANLN1 | CHAR | 12 | |
| ASSETSUBNO | Asset Subnumber | BF_ANLN2 | CHAR | 4 | |
| BUDGET_PD | Budget Period | FM_BUDGET_PERIOD | * | CHAR | 10 |
| DLISRC | Dynamic Item Source | AD01DLISRC | AD01SRC | CHAR | 4 |
| PROFNR | Dynamic Item Processor Profile | AD01PROFNR | AD01C_PROF | CHAR | 8 |
| TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | DEC | 16 | |
| SOITEXT | Item Text | SGTXT | CHAR | 50 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AD01DLI
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AD01DLI | ASNUM | : | ASMD |
| AD01DLI | AWERK | : | T001W |
| AD01DLI | BEMOT | : | TBMOT |
| AD01DLI | DLISRC | 1: CN | AD01SRC |
| AD01DLI | FIPOS | : | FMFPO |
| AD01DLI | KOSTL | : | CSKS |
| AD01DLI | KSTAR | : | CSKA |
| AD01DLI | LSTAR | : | CSLA |
| AD01DLI | MANDT | 1: CN | T000 |
| AD01DLI | MATNR | 1: CN | MARA |
| AD01DLI | MEINH | 1: CN | T006 |
| AD01DLI | OBJNR | 1: CN | ONR00 |
| AD01DLI | PRODU | : | MARA |
| AD01DLI | PROFNR | 1: CN | AD01C_PROF |
| AD01DLI | PRZNR | : | CBPR |
| AD01DLI | STAGR | : | TKA03 |
| AD01DLI | TWAER | 1: CN | TCURC |
| AD01DLI | VERSN | : | TKVS |
| AD01DLI | WERKS | 1: CN | T001W |