The AD01WIP_DTL table in SAP ERP or S/4HANA stores WIP Details data. There are total 24 fields in AD01WIP_DTL table. The WIP Details table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of AD01WIP_DTL table. It is in DI Processor (Resource-Related Billing/Sales Pricing) (AD01) ABAP package and is part of the Revenues and Earnings (PS-REV) module.
SAP AD01WIP_DTL Table Fields
Following is the list of fields that are available in SAP AD01WIP_DTL table. The primary key fields of the table are MANDT (Client), DLINR (Number of the Dynamic Item), RA_VERSN (Results Analysis Version), BELNR (Document Number).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| DLINR | Number of the Dynamic Item | AD01DLINR | AD01DLI | NUMC (20) |
| RA_VERSN | Results Analysis Version | VERSN_ABGR | TKKAP | CHAR (3) |
| BELNR | Document Number | CO_BELNR | CHAR (10) | |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | DEC (15) | |
| HWAER | Local Currency | HWAER | * | CUKY (5) |
| KWAER | Controlling area currency | KWAER | * | CUKY (5) |
| RV_WAERS | Currency code for WIP revenue | AD01REV_WAERS | * | CUKY (5) |
| ABC_WTG | Already billed costs (transaction currency) | AD01ABC_WTG | CURR (15) | |
| ABC_WOG | Already billed costs (company code currency) | AD01ABC_WOG | CURR (15) | |
| ABC_WKG | Already billed costs (CO Area currency) | AD01ABC_WKG | CURR (15) | |
| ABC_MEG | Already billed quantity | AD01ABC_MEG | QUAN (15) | |
| NOC_WTG | Already rejected costs (transaction currency) | AD01NOC_WTG | CURR (15) | |
| NOC_WOG | Already rejected costs (Company Code currency) | AD01NOC_WOG | CURR (15) | |
| NOC_WKG | Already rejected costs (CO Area currency) | AD01NOC_WKG | CURR (15) | |
| NOC_MEG | Already rejected quantity | AD01NOC_MEG | QUAN (15) | |
| TBC_WTG | Not yet billed costs (WIP costs) (transaction currency) | AD01TBC_WTG | CURR (15) | |
| TBC_WOG | Not yet billed costs (WIP costs) (Company Code currency) | AD01TBC_WOG | CURR (15) | |
| TBC_WKG | Not yet billed costs (WIP costs) (CO Area currency) | AD01TBC_WKG | CURR (15) | |
| TBC_MEG | Not yet billed quantity (WIP quantity) | AD01TBC_MEG | QUAN (15) | |
| TBR_WTG | Revenue to be billed (revenue currency) | AD01REV_WTG | CURR (15) | |
| TBR_WOG | Revenue to be billed (Company Code currency) | AD01REV_WOG | CURR (15) | |
| TBR_WKG | Revenue to be billed (CO Area currency) | AD01REV_WKG | CURR (15) | |
| FBUDA | Date on which services are rendered | FBUDA | DATS (8) |
