Thursday, July 25, 2024

SAP Table AD01WIP_REV – WIP Details

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