AD01DLISF is a standard SAP table in SAP ECC (or) S/4HANA which stores DI Flow: Totals Flow data. There are total 16 fields in AD01DLISF table.This blog post provides key technical details of SAP table AD01DLISF, including its availability across SAP S/4HANA versions and the list of CDS views for AD01DLISF 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 AD01DLISF Table Fields
The following is the list of fields that are available in SAP AD01DLISF 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) | |
| 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) | |
| NO_WTGBTR | Sum never | AD01NOWRT | WERTV8 | CURR (15) | |
| NO_WOGBTR | Sum never | AD01NOWRT | WERTV8 | CURR (15) | |
| NO_WKGBTR | Sum never | AD01NOWRT | WERTV8 | CURR (15) | |
| NO_MEGBTR | Quantity never | AD01NOMNG | MENGV8 | QUAN (15) | |
| RV_WTGBTR1 | Simulation subtotal | AD01RVWRT | WERTV8 | CURR (15) | |
| RV_WTGBTR2 | Simulation subtotal | AD01RVWRT | WERTV8 | CURR (15) | |
| RV_WTGBTR3 | Simulation subtotal | AD01RVWRT | WERTV8 | CURR (15) | |
| RV_WTGBTR4 | Simulation subtotal | AD01RVWRT | WERTV8 | CURR (15) | |
| RV_WAERS | Currency Key | WAERS | WAERS | TCURC | CUKY (5) |
Availability
The SAP table AD01DLISF 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 AD01DLISF table
The following is the list of AD01DLISF CDS views, which can also be used instead of AD01DLISF table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| I_RRBDYNAMICITEMTOTALFLOW | BASIC | Total Flow of Dynamic Item |
| I_WORKINPROCESSDETAIL | BASIC | Detail WIP from DIP data |
| 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 |
| I_ALERTWORKINPROGRESS | COMPOSITE | Master Project Alert for High Risk |
| 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_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_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_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_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_PROJECTWIPDETAILBASIC | COMPOSITE | WIP Detail for WBS elements |
| C_ENGMNTPROJBILLGANDRBLSQRY | CONSUMPTION | Engagement Project Billing And Receivables Query |
| C_MSTRPROJACTLCALMNTHCOSTQTY | CONSUMPTION | Commercial Proj Actual Cost Qty by Month |
| C_PROJECTWIPDETAIL | CONSUMPTION | WIP Detail View for projects |
| C_RRBWRITTENOFFDYNAMICITEM | CONSUMPTION | Written Off Dynamic Item |
| P_PROJECTWIPDETAIL1 | CONSUMPTION | WIP Detail view for projects |
| P_RRBWRITTENOFFDYNAMICITEM | CONSUMPTION | CDS private view for Written Off Dynamic Items |
| P_RRBWRITTENOFFDYNAMICITEM01 | CONSUMPTION | CDS written off view for journal entry item |
