AD01DLIEF is a standard SAP table in SAP ECC (or) S/4HANA which stores DI flow: Individual flow data. There are total 21 fields in AD01DLIEF table.This blog post provides key technical details of SAP table AD01DLIEF, including its availability across SAP S/4HANA versions and the list of CDS views for AD01DLIEF table in SAP.
| SAP HANA Table Type | Column Store |
|---|---|
| Buffering Permission | Buffering not allowed |
| Buffering Type | No buffering |
| Package | DI Processor (Resource-Related Billing/Sales Pricing) (AD01) |
| Technical Component | Revenues and Earnings (PS-REV) |
SAP AD01DLIEF Table Fields
The following is the list of fields that are available in SAP AD01DLIEF 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 | AD01DLI | NUMC (20) |
| DLIUS | Usage of the DI profile | AD01USAGE | AD01USAGE | NUMC (2) | |
| VBELN | Sales Document | VBELN_VA | VBELN | CHAR (10) | |
| VBPOS | Sales Document Item | POSNR_VA | POSNR | NUMC (6) | |
| IN_WTGBTR | Amount referenced for invoicing | EB_FKWRT | WERTV8 | CURR (15) | |
| IN_WOGBTR | Amount referenced for invoicing | EB_FKWRT | WERTV8 | CURR (15) | |
| IN_WKGBTR | Amount referenced for invoicing | EB_FKWRT | WERTV8 | CURR (15) | |
| IN_MEGBTR | Quantity billed | EB_FKMNG | MENGV8 | QUAN (15) | |
| TO_WTGBTR | Amount referenced for invoicing | EB_FKWRT | WERTV8 | CURR (15) | |
| TO_WOGBTR | Amount referenced for invoicing | EB_FKWRT | WERTV8 | CURR (15) | |
| TO_WKGBTR | Amount referenced for invoicing | EB_FKWRT | WERTV8 | CURR (15) | |
| TO_MEGBTR | Quantity billed | EB_FKMNG | MENGV8 | QUAN (15) | |
| AUMOT | Apportionment reason | AUMOT | AD01COSTYP | CHAR (2) | |
| BEMOT | Accounting Indicator | BEMOT | BEMOT | CHAR (2) | |
| RETRO | Checkbox | XFELD | XFELD | CHAR (1) | |
| DOPEN | Indicator: DOPEN Status in Single Flow | AD01DOPENSIGN | AD01DOPENSIGN | CHAR (1) | |
| TO_DATE | To Date | AD01BTODAT | DATUM | DATS (8) | |
| TIMESTMP | Time created (Greenwich Meantime) | RKE_HZSTMP | RKE_TSTMP | DEC (16) | |
| FKDAT_ACTIVE | Billing Date is Updated in Document Flow | AD01FKDAT_ACTIVE | XFIELD | CHAR (1) | |
| FKDAT | Billing Date | FKDAT | DATUM | DATS (8) |
Availability
The SAP table AD01DLIEF 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 AD01DLIEF table
The following is the list of AD01DLIEF CDS views, which can also be used instead of AD01DLIEF 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_RRBDYNAMICITEMFLOW | BASIC | Dynamic Item Flow |
| P_BPBAPSTATUS | BASIC | BillAsPlanned 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 |
| 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_ENGMNTPROJBILLGANDRBLSCUBE | COMPOSITE | Billg and Rbls of Engmnt Project – Cube |
| I_MASTERPROJECTBILLINGPLANCUBE | COMPOSITE | Master Project Billing Plan Cube |
| I_MSTRPROJBILLGDUEDTE | COMPOSITE | Get billing due date for a project |
| 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_MSTRPROJWSBILLINGDUEDATE | COMPOSITE | Get PWS billing due date for a project |
| C_ENGMNTPROJBILLGANDRBLSQRY | CONSUMPTION | Engagement Project Billing And Receivables Query |
| C_MASTERPROJECTBILLINGPLAN | CONSUMPTION | Master Project Billing Plans |
| C_MSTRPROJKEYDATES | CONSUMPTION | Get Master Project Key Dates |
| C_RRBDYNAMICITEMFLOW | CONSUMPTION | Dynamic Item Flow With Characteristics |
| 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 |
