AD01WIP_REV is a standard SAP table in SAP ECC (or) S/4HANA which stores WIP Details data. There are total 16 fields in AD01WIP_REV table.This blog post provides key technical details of SAP table AD01WIP_REV, including its availability across SAP S/4HANA versions and the list of CDS views for AD01WIP_REV 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_REV Table Fields
The following is the list of fields that are available in SAP AD01WIP_REV 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) |
| REV_KSTAR | Cost Element | KSTAR | KSTAR | CHAR (10) | |
| BELNR | Document Number | CO_BELNR | CO_BELNR | CHAR (10) | |
| REV_MATNR | Material Number | MATNR | MATNR | CHAR (40) | |
| REV_WTG | Revenue to be billed (revenue currency) | AD01REV_WTG | WERTV8 | CURR (15) | |
| REV_WOG | Revenue to be billed (Company Code currency) | AD01REV_WOG | WERTV8 | CURR (15) | |
| REV_WKG | Revenue to be billed (CO Area currency) | AD01REV_WKG | WERTV8 | CURR (15) | |
| 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 Key | WAERS | WAERS | CUKY (5) | |
| OBJNR | Object number | J_OBJNR | J_OBJNR | CHAR (22) | |
| RA_OBJNR | Object number | J_OBJNR | J_OBJNR | CHAR (22) | |
| RA_ABGSL | Results Analysis Key | ABGR_SCHL | ABGR_SCHL | CHAR (6) |
Availability
The SAP table AD01WIP_REV 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_REV table
The following is the list of AD01WIP_REV CDS views, which can also be used instead of AD01WIP_REV table based on your business requirements.
| CDS View | CDS View Type | Description |
|---|---|---|
| P_PROJECTWIPREVDETLBASIC | BASIC | Project WIP with revenue from DIP |
| P_WIPREVDETAILBASIC | BASIC | WIP revenue details from DIP data |
