SAP AD01WIP_DTL WIP Details Table
Overview
AD01WIP_DTL is a standard SAP S/4HANA table that stores WIP Details data. There are total 24 fields in the AD01WIP_DTL table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table AD01WIP_DTL belongs to Revenues and Earnings (PS-REV) module and is located in the package DI Processor (Resource-Related Billing/Sales Pricing) (AD01).
In addition, following links provide an overview of foreign key relationships, if any, that link AD01WIP_DTL to other SAP tables and standard CDS views available based on AD01WIP_DTL table in S/4HANA 2020.
Techincal Settings of AD01WIP_DTL
Below are technical details of the table AD01WIP_DTL
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of AD01WIP_DTL Fields
The following table gives you an overview of the fields available in AD01WIP_DTL
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| 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 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for AD01WIP_DTL
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| AD01WIP_DTL | DLINR | : | AD01DLI |
| AD01WIP_DTL | MANDT | 1: CN | T000 |
| AD01WIP_DTL | RA_VERSN | : | TKKAP |