AD01WIP_DTL is a standard SAP table in SAP ECC (or) S/4HANA which stores WIP Details data. There are total 24 fields in AD01WIP_DTL table.This blog post provides key technical details of SAP table AD01WIP_DTL, including its availability across SAP S/4HANA versions and the list of CDS views for AD01WIP_DTL 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 AD01WIP_DTL Table Fields
The following is the list of fields that are available in SAP AD01WIP_DTL 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) |
| RA_VERSN | Results Analysis Version | VERSN_ABGR | VERSN_ABGR | TKKAP | CHAR (3) |
| BELNR | Document Number | CO_BELNR | CO_BELNR | CHAR (10) | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS | DEC (15) | |
| HWAER | Local Currency | HWAER | WAERS | * | CUKY (5) |
| KWAER | Controlling area currency | KWAER | WAERS | * | CUKY (5) |
| RV_WAERS | Currency code for WIP revenue | AD01REV_WAERS | WAERS | * | CUKY (5) |
| ABC_WTG | Already billed costs (transaction currency) | AD01ABC_WTG | WERTV8 | CURR (15) | |
| ABC_WOG | Already billed costs (company code currency) | AD01ABC_WOG | WERTV8 | CURR (15) | |
| ABC_WKG | Already billed costs (CO Area currency) | AD01ABC_WKG | WERTV8 | CURR (15) | |
| ABC_MEG | Already billed quantity | AD01ABC_MEG | MENGV8 | QUAN (15) | |
| NOC_WTG | Already rejected costs (transaction currency) | AD01NOC_WTG | WERTV8 | CURR (15) | |
| NOC_WOG | Already rejected costs (Company Code currency) | AD01NOC_WOG | WERTV8 | CURR (15) | |
| NOC_WKG | Already rejected costs (CO Area currency) | AD01NOC_WKG | WERTV8 | CURR (15) | |
| NOC_MEG | Already rejected quantity | AD01NOC_MEG | MENGV8 | QUAN (15) | |
| TBC_WTG | Not yet billed costs (WIP costs) (transaction currency) | AD01TBC_WTG | WERTV8 | CURR (15) | |
| TBC_WOG | Not yet billed costs (WIP costs) (Company Code currency) | AD01TBC_WOG | WERTV8 | CURR (15) | |
| TBC_WKG | Not yet billed costs (WIP costs) (CO Area currency) | AD01TBC_WKG | WERTV8 | CURR (15) | |
| TBC_MEG | Not yet billed quantity (WIP quantity) | AD01TBC_MEG | MENGV8 | QUAN (15) | |
| TBR_WTG | Revenue to be billed (revenue currency) | AD01REV_WTG | WERTV8 | CURR (15) | |
| TBR_WOG | Revenue to be billed (Company Code currency) | AD01REV_WOG | WERTV8 | CURR (15) | |
| TBR_WKG | Revenue to be billed (CO Area currency) | AD01REV_WKG | WERTV8 | CURR (15) | |
| FBUDA | Date on which services are rendered | FBUDA | DATUM | DATS (8) |
Availability
The SAP table AD01WIP_DTL 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 AD01WIP_DTL table
The following is the list of AD01WIP_DTL CDS views, which can also be used instead of AD01WIP_DTL table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| 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_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_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_MSTRPROJACTLCALMNTHCOSTQTY | CONSUMPTION | Commercial Proj Actual Cost Qty by Month |
| C_PROJECTWIPDETAIL | CONSUMPTION | WIP Detail View for projects |
| P_PROJECTWIPDETAIL1 | CONSUMPTION | WIP Detail view for projects |
